MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: What's the cause of table locking other than insert/update/delete?
Posted by: He Ha
Date: February 18, 2011 06:38PM

Figured out now. My table has lots of TEXT field type and I do not run OPTIMIZE for a while so, the each insert/update/delete cause longer time than usual. After optimized, the query run faster and make the locking time less. It's work like a charm now. :)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
What's the cause of table locking other than insert/update/delete?
3536
He Ha
February 17, 2011 08:08AM
Re: What's the cause of table locking other than insert/update/delete?
1641
He Ha
February 17, 2011 07:54PM
Re: What's the cause of table locking other than insert/update/delete?
1415
He Ha
February 18, 2011 06:38PM


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.