PDA

View Full Version : MySQL Locking - Server Hang


jackiehms79
04-17-2003, 03:24 AM
Hi,

I am using:

1. PHP 4.3.1
2. MySQL 4.0.12
3. Apache 1.3.27
4. vBulletin Version 2.3.0

The Problem Is:

My servers load seems to be jumped abnormally until sometimes it hang. When I check on the processlist of mysql :

mysql>show processlist;

It shows there is more than 10 locking process on the same database.

How to set time out for database locking? or do you have any other suggestions?

Thanks

raf
04-17-2003, 04:04 PM
Not quite sure about the problem.

Normally, if you use php, there an automatic unlock at the end of the script. Maybe try Explicitely unlocking.
http://www.linux.ie/pipermail/webdev/2000-October/000656.html
If you use the commandline you can use "UNLOCK TABLES"

did you check at mysql.com ?