Database administration with MySQL


Tips

MyISAM

Lock Tables

On myisam tables, if you are having issues with too many locked tables (show processlist), you can do the following to improve reading from uncommitted inserts:

 show variables like 'tx%'; and you see 'REPEATABLE-READ'
 set global transaction isolation level read uncommitted;

This improves reading but it assumes that your application will not be using the data from another part concurrently.

Advertisement