MySQL Forums
Forum List  »  MyISAM

Rebuilding Index
Posted by: Charles Siu
Date: December 11, 2012 10:26PM

Currently the performance of MySQL is low. After checking the structure of some tables via phpMyAdmin, I found that the cardinality of some indexes are strange. Sometime the cardinality is 0, and sometime the cardinality is simply the same as the number of rows. After I repair/optimize the tables, the cardinality return back to what I expect and the queries are returned faster than before.

I would like to know if there any way to identify the tables with such issue? Then I will do optimize table for those tables only.

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Rebuilding Index
3886
December 11, 2012 10:26PM
1900
December 20, 2012 02:48PM


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.