Hello there,
i got an application that from time to time shows a white page for some time before actually loading the page.
A look at MySQLs revealed that a lot of SELECTs were locked, and there were also a number of UPDATE statements with the state locked.
The strange thing is that i couldnt make out a singe Statement that could have caused the lock, all UPDATE / INSERT statements were in the state LOCKED, none was running, no DELETEs where run at that time.
How can i determine which process is causing the other processes to wait?
MySQL Version is MySQL 4.0.18, query Cache is active.
I am thinking about trying to have UPDATEs run LOW_PRIORITY but the Mysql manual doesnt clearly show if this would cause UPDATEs to wait for SELECTs to finish Or if they would run concurrently, i dont care much about the SELECTs containing the other Processes UPDATEd Data.
Having the UPDATEs wait for the SELECT would cause just the same Problem.
Is it possible one of the joins containing that table which is copying to tmp table is causing the lock?
Maybe i should better change the MyISAM Table to a InnoDB or BDB?
I attached the Process list, i removed all queries that are not on the table that i have locking issues with.
The Table in question is called "galerie"
any opinions would be highly appreciated.
cheers
Jens
