October 10, 2010 in Classic self-hosted technical help
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?
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.
This topic is now archived and is closed to further replies.
Started Wednesday at 11:08 PM
Started 1 hour ago
Started 16 hours ago