471,336 Members | 1,230 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,336 software developers and data experts.

strange behavior with phpmyadmin and innodb tables

Hello,

I recently converted all my existing MyISAM tables to InnoDB tables
through phpmyadmin. I noticed some strange behavior whenever I would
refresh the screen, as phpmyadmin would report different numbers for the
cardinality of the primary key (i.e. one minute it would say cardinality
388, then 244 on refresh, then something else), and it would report
different values for the number of rows when mousing over the table
names on the left menubar. This behavior only seems to exist on tables
with a "larger" number of rows, and by larger I only mean ~100 or more
rows (tables with fewer rows always report the correct number of rows).

Whenever I do a SELECT *, I get the correct number of rows returned, so
I know they are actually there.

Has anyone ever experienced this or does anyone know what is up? Thanks.
Jul 17 '05 #1
2 3286
Marcus,
Has anyone ever experienced this or does anyone know what is up? Thanks.


I have a database with 45,000 rows. This seems to happen to me all the
time with that one. It seems odd because sometimes with the cardinality
being different the number of rows returned in the select are
different quite a bit of the time.

Mike
Jul 17 '05 #2
Marcus (Ju********@aol.com) decided we needed to hear...
Hello,

I recently converted all my existing MyISAM tables to InnoDB tables
through phpmyadmin. I noticed some strange behavior whenever I would
refresh the screen, as phpmyadmin would report different numbers for the
cardinality of the primary key (i.e. one minute it would say cardinality
388, then 244 on refresh, then something else), and it would report
different values for the number of rows when mousing over the table
names on the left menubar. This behavior only seems to exist on tables
with a "larger" number of rows, and by larger I only mean ~100 or more
rows (tables with fewer rows always report the correct number of rows).

Whenever I do a SELECT *, I get the correct number of rows returned, so
I know they are actually there.

Has anyone ever experienced this or does anyone know what is up? Thanks.

This happens because row count is only an estimate for InnoDB tables
due to the storage format. For MyISAM on the other hand, MySQL
maintains an exact row count.
--
Dave <da**@REMOVEbundook.com>
(Remove REMOVE for email address)
Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

30 posts views Thread by Darren Gates | last post: by
3 posts views Thread by Andy Tran | last post: by
3 posts views Thread by Reuben Pearse | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.