MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Cardinality Problem
Posted by: Rick James
Date: November 28, 2014 06:56PM

Perhaps you would benefit from upgrading to 5.6 to get "persistent statistics":
http://dev.mysql.com/doc/refman/5.6/en/innodb-persistent-stats.html

Meanwhile, let's see
SHOW CREATE TABLE
SHOW TABLE STATUS
EXPLAIN SELECT ... -- preferably twice, once for each cardinality.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Cardinality Problem
1599
Katja Kahl
November 26, 2014 06:53AM
Re: Cardinality Problem
758
Peter Brawley
November 26, 2014 12:03PM
Re: Cardinality Problem
713
Katja Kahl
November 27, 2014 03:08AM
Re: Cardinality Problem
678
Rick James
November 28, 2014 06:56PM


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.