MySQL configuration that allows for locking many tables?

Posted by Floyd Bonne on Stack Overflow See other posts from Stack Overflow or by Floyd Bonne
Published on 2010-05-03T10:56:53Z Indexed on 2010/05/03 12:58 UTC
Read the original article Hit count: 380

Filed under:
|

I need to do a MySQLDump on a DB with ~700 tables and when I try with my current configuration, I get an error:

mysqldump: Got error: 1016: Can't open file: './my_db/content_node_field_instance.frm' (errno: 24) when using LOCK TABLES

Searching around I've found that this happens because it tries to lock all tables and fails because they are "too many". I know I can try lock-tables=no and get a dump, but this way my DB might be in an inconsistent state.

So, does anyone know what is the MySQL configuration setting I need to change in order to be able to do the locking I need? I'm running 5.1.37-1ubuntu5.1 with MyISAM.

Thanks!

© Stack Overflow or respective owner

Related posts about mysqldump

Related posts about mysql