Jump to content

Table locking and other tables


Recommended Posts

Posted

Hello

Does a table locking affect the other tables in general?

I mean when a table is lock does mysq serv the rest of the users that are not asking something from that table?

Thank you

Posted

Table locking is not as bad as it sounds, People can still use / write / read on those tables.
Putting on low-priority-updates in the my.cnf will help the issue alot.

Locked tables can increase speeds on the other tables to read/write, This is not a major issue as I see it, See if you had a BIG table you can also chage this to use BDB just for that one table.

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...