Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » mysql process/thread id?
mysql process/thread id? [message #3052] Wed, 07 May 2008 17:17
zedude is currently offline zedude
Messages: 4
Registered: May 2008
Junior Member
I was doing "mysqldump debug" to review the locks in MySQL, and found the following:

13258871email Locked - write Highest priority write lock
13258871contact Locked - write Concurrent insert lock
13258907email Waiting - write Highest priority write lock
13258907address Locked - write Concurrent insert lock

It seems for pid 13258871, there are actually two threads running. Is this normal? Same thing for pid 13258907.

Thanks
Report message to a moderator
[Message index]

Read Message
Previous Topic:Sphinx - only for string based search?
Next Topic:Database Server Hardware
Goto Forum:

  

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

Current Time: Thu Jul 9 23:12:15 EDT 2009

Total time taken to generate the page: 0.02273 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

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.