Re: Sudden drop in performance on MyISAM DB
These indexes don't show up in the SHOW CREATE TABLE in your original post, so the explain output of that query is probably not correct either (which means that our suggestions are not relevant)?
If you could provide the SHOW CREATE TABLE and EXPLAIN for the actual problematic queries run on the actual tables it will be much easier to suggest changes...
Hope this helps,
Jørgen Løland
Software Engineer, MySQL, Oracle
jorgenloland.blogspot.com
Subject
Views
Written By
Posted
2622
October 15, 2012 07:46AM
1055
October 16, 2012 06:29AM
974
October 16, 2012 07:56AM
862
October 17, 2012 01:29AM
886
October 16, 2012 07:40PM
842
October 17, 2012 01:19AM
816
October 17, 2012 01:47AM
Re: Sudden drop in performance on MyISAM DB
924
October 17, 2012 03:21AM
971
October 17, 2012 04:28AM
898
October 17, 2012 10:38AM
880
October 17, 2012 09:41PM
837
October 18, 2012 12:34PM
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.