View Single Post
  #2  
Old 05-07-2007, 06:38 AM
Renne Renne is offline
OSP Addicts
 
Join Date: Aug 2006
Posts: 99
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 17
Renne is on a distinguished road
Default Re: locking problems......

If using MyISAM tables and never delete anything from them, INSERTS will automatically run in parallel to queries.

If you need to delete something from time to time, try to do it in big bunches and run OPTIMIZE afterwards.

MyISAM always locks the whole table. If you want to have row locks, ALTER the table to an InnoDB table. Also, tune your application by using the optimal isolation level then. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - locking problems......
View Single Post
  #2  
Old 05-07-2007, 06:38 AM
Renne Renne is offline
OSP Addicts
 
Join Date: Aug 2006
Posts: 99
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 17
Renne is on a distinguished road
Default Re: locking problems......

If using MyISAM tables and never delete anything from them, INSERTS will automatically run in parallel to queries.

If you need to delete something from time to time, try to do it in big bunches and run OPTIMIZE afterwards.

MyISAM always locks the whole table. If you want to have row locks, ALTER the table to an InnoDB table. Also, tune your application by using the optimal isolation level then. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote