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]

Reply via email to