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]