Another strange lock problem? [message #12214] |
Thu, 31 July 2003 12:01 |
ctbk
Messages: 142 Registered: April 2002 Location: Milan, Italy
Karma: 0
|
Senior Member |
|
|
In a hour in wich our forum is quite full, I tried deleting an account via the manager pages. Result: blank page in the admin panel and stuck forum.
Right after that, mysqladmin processlist showed a lot of queries waiting for tables to unlock.
Restarted mysql and the forum is OK, but the user I tried to delete is still there. Tried 2 times in a row with identical result, I decided to wait the night or the early morning to disable the forum and try to delete the user.
~
~
:wq
|
|
|
Re: Another strange lock problem? [message #12216 is a reply to message #12214] |
Thu, 31 July 2003 12:18 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Which MySQL are you using, it does sound like it is not releasing locks, however the code does have lock releases in all the appropriate places.
FUDforum Core Developer
|
|
|
|
Re: Another strange lock problem? [message #12219 is a reply to message #12218] |
Thu, 31 July 2003 12:57 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Strange, I am using the same version and not having such problems. Are you using persistent connections? Do you have a short mysql timeout set in php or mysql?
FUDforum Core Developer
|
|
|
Re: Another strange lock problem? [message #12220 is a reply to message #12219] |
Thu, 31 July 2003 13:09 |
ctbk
Messages: 142 Registered: April 2002 Location: Milan, Italy
Karma: 0
|
Senior Member |
|
|
I've persistent connections turned on, and I haven't modified anything regarding mysql timeouts, I'm using debian defaults.
(in fact I didn't find any setting about timeouts neither in /etc/php4/apache/php.ini nor in /etc/mysql/*)
~
~
:wq
|
|
|
|
Re: Another strange lock problem? [message #12224 is a reply to message #12223] |
Thu, 31 July 2003 15:59 |
ctbk
Messages: 142 Registered: April 2002 Location: Milan, Italy
Karma: 0
|
Senior Member |
|
|
Variables with "time" in the name:
wait_timeout 28800
timezone CEST
slow_launch_time 2
slave_net_timeout 3600
net_write_timeout 60
net_read_timeout 30
long_query_time 10
interactive_timeout 28800
innodb_lock_wait_timeout 50
flush_time 0
delayed_insert_timeout 300
connect_timeout 5
~
~
:wq
|
|
|
|
Re: Another strange lock problem? [message #12253 is a reply to message #12228] |
Thu, 31 July 2003 22:51 |
ctbk
Messages: 142 Registered: April 2002 Location: Milan, Italy
Karma: 0
|
Senior Member |
|
|
I was hoping to be able to keep on using them, they make a big difference in performances. Anyway, I'll try to switch them off, to see if some of those problem will go away.
~
~
:wq
|
|
|
Re: Another strange lock problem? [message #12254 is a reply to message #12253] |
Thu, 31 July 2003 22:55 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Really? I actually have seen only a very negligible benefit from using MySQL with persistent connections.
FUDforum Core Developer
|
|
|