ASTRAPI Posted October 10, 2010 Posted October 10, 2010 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
Gary. Posted October 10, 2010 Posted October 10, 2010 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.