MySQL Forums :: MyISAM :: Rebuilding Index

Advanced Search

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 2738 Charles Siu 12/11/2012 10:26PM
Re: Rebuilding Index 1286 Rick James 12/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.