MySQL Forums
Forum List  »  MyISAM

Re: Slow UPDATE's on a large table
Posted by: Rick James
Date: June 27, 2010 02:57PM

Sounds like a missing or inadequate INDEX. Plz show us the UPDATE.

Also, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]

You could try
ANALYZE TABLE
to get it to recompute the statistics.

LOCK/UNLOCK around a single statement (such as an UPDATE that modifies 1000 rows) has no impact. LOCK/UNLOCK around a sequence of statements (in MyISAM tables) could improve speed _some_, but at the expense of locking out other queries.

Options: ReplyQuote


Subject
Views
Written By
Posted
14894
June 24, 2010 10:11PM
Re: Slow UPDATE's on a large table
6337
June 27, 2010 02:57PM
5510
June 27, 2010 09:16PM
5680
June 27, 2010 09:47PM
4305
June 27, 2010 10:36PM
4226
June 27, 2010 11:52PM
3974
June 28, 2010 08:38PM
4130
July 04, 2010 08:28PM


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.