mysql question
Cameron Simpson
cs at zip.com.au
Thu Dec 4 00:54:08 UTC 2008
On 03Dec2008 07:06, ann kok <oiyankok at yahoo.ca> wrote:
| Can I know what is the meaning of the position?
It is how many transactions are in the binlog.
You can look in
| Why there is nothing in the "Binlog_Ignore_DB"
Because you're not ignoring any DBs in the replication?
| mysql> show master status;
| +-------------------+----------+---------------+------------------+
| | File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
| +-------------------+----------+---------------+------------------+
| | mysqld-bin.000006 | 183219 | dbname,dbname | |
| +-------------------+----------+---------------+------------------+
Isn't this decribed in the MySQL doco?
http://dev.mysql.com/doc/refman/5.0/en/replication.html
http://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-log.html
Did you look there first?
--
Cameron Simpson <cs at zip.com.au> DoD#743
http://www.cskk.ezoshosting.com/cs/
The problem is, every time something goes wrong, the paperwork is found
in order... - Walker on NASA
More information about the fedora-list
mailing list