MySQL Performance: MySQL => slave sql thread always at 2 seconds

Members

Help

Home

Home » Performance » MySQL » slave sql thread always at 2 seconds

Show: Today's Messages :: Show Polls :: Message Navigator

slave sql thread always at 2 seconds [message #3648]

Thu, 23 October 2008 03:47

mancdaz
Messages: 5
Registered: March 2008

Junior Member

How come the slave sql thread always shows a time of not less than 2:

30884 system user NULL Connect 2 Has read all relay log; waiting for the slave I/O thread to update it NULL

?
Daz

Report message to a moderator

Previous Topic:	odd replication lag situation
Next Topic:	One to many -- Select 3 subitems for every item.

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 10 04:21:34 EDT 2009

Total time taken to generate the page: 0.02854 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.