Hi,
I have done a show processlist\G right after I start slave.
*************************** 1. row ***************************
Id: 1
User: martin
Host: localhost:1110
db: NULL
Command: Query
Time: 0
State: NULL
Info: show processlist
*************************** 2. row ***************************
Id: 2
User: system user
Host:
db: NULL
Command: Connect
Time: 7
State: Waiting for master to send event
Info: NULL
*************************** 3. row ***************************
Id: 3
User: system user
Host:
db: NULL
Command: Connect
Time: 7
State: Has read all relay log; waiting for the I/O slave thread to update
it
Info: NULL
3 rows in set (0.02 sec)
After I do some update in master, show processlist\G gives me:
*************************** 1. row ***************************
Id: 1
User: martin
Host: localhost:1110
db: NULL
Command: Query
Time: 0
State: NULL
Info: show processlist
*************************** 2. row ***************************
Id: 2
User: system user
Host:
db: NULL
Command: Connect
Time: 323
State: Waiting for master to send event
Info: NULL
*************************** 3. row ***************************
Id: 3
User: system user
Host:
db: NULL
Command: Connect
Time: 7
State: Has read all relay log; waiting for the I/O slave thread to update
it
Info: NULL
The time for id 2 and 3 are very differnet.
Liying
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
