View Full Version : InnoDB rows

09-20-2006, 10:49 AM
How can you tell how many rows are in an innodb table? I tried running a count(*) on it and it told me 467,535 but phpMyAdmin lists 802,759 and varies the cardinality of a unique field from 450k - 1.2million so is there any reliable way to tell how many rows there are?

09-20-2006, 02:39 PM
i never had any reason to distrust the returned value from a
SELECT COUNT(*) FROM tablename
for any storage-engine, so i'd rather trust that statistic then whatever phpmyadmin throws at you.

why do you think this value would be incorrect for that innodb-table? just the phpmyadmin stats?

09-20-2006, 02:45 PM
Yeah - just phpMyAdmin - with myIsam its usually fairly reliable. I guess that would explain why it timed out when I tried to look at pages that went beyond the actual number of rows

09-20-2006, 05:47 PM
phpmyadmin sure has it's flaws + it's ugly. (i try to never use it...)
i'd trust what the commandline, MySQL Query Browser or query-tab gives you.

09-20-2006, 05:52 PM
I like phpMyAdmin - less typing. Ok its not that pretty but it does its job