Re: More ways to debug mysql slowness..?

David Taveras wrote: Hello, We have a BSD box with the following installed: mysql-client-5.0.77 multithreaded SQL database (client) mysql-server-5.0.77 multithreaded SQL database (server) p5-DBD-mysql-4.010 MySQL drivers for the Perl DBI php5-mysql-5.2.8mysql database access extensions for

Re: lock wait timeout try restrating transaction

Hello Manasi, Manasi Save wrote: Hi All, Can anyone provide me any input on in what all senerios one can get this error. I have innodb tables, I am updating one table but I am getting error lock wait timeout try restarting transaction. Also the parameter innodb_lock_wait_timeout is set to 50 de

Downloading old version of MySQL ?

Hi all, I'm trying to drag a database through the upgrade process from 5.0.32 but I keep running into small cross-version compatibility issues. At present my live database is running 5.0.32 and is large enough that it would take too long (read days) to perform an upgrade on, and drives an importa