Re: table access slows to a crawl
If you have a MyISAM table (which is non-transactional) you may try to use the ANALYZE statement. If this doesn't help, try OPTIMIZE. This rebuilds the whole table and all indexes. This takes a long time to run, but defragments the table.
It is also possible that your growing table needs more space in the key cache than available. Try to increase its size then.
Regards
Ingo
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
2190
August 14, 2006 12:39PM
Re: table access slows to a crawl
1415
August 22, 2006 12:52PM
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.