MySQL Forums
Forum List  »  MyISAM

Re: Query Locking Problem
Posted by: Neil Edgar
Date: January 24, 2006 10:43AM

I think I might have stumbed on the problem: Host #2 has been running longer and has deleted events older than 30 days. This delete creates free blocks in the database. Inserts are not concurrent until all free blocks have been used up.

I guess I have two choices: run an OPTIMIZE TABLE as part of the maintenance delete or change the storage engine (to Inno??) to allow concurrent inserts and selects.

Options: ReplyQuote


Subject
Views
Written By
Posted
2916
January 24, 2006 09:14AM
Re: Query Locking Problem
1817
January 24, 2006 10:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.