ASTRAPI Posted October 10, 2010 Share 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 Link to comment Share on other sites More sharing options...
Gary. Posted October 10, 2010 Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.