Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I just converted a MyISAM table to InnoDB with around 1.4 million rows. When I converted it to InnoDB, it now shows -1.4 million rows. The table still works as expected, but why does it shows negative in the rows column?

share|improve this question
Where do you see the numbers? – Pacerier Apr 9 '15 at 14:45
up vote 5 down vote accepted

If you look closely, you'll notice it's not a negative sign, it's a tilde, which means "approximately".

InnoDB tables do not store the exact count of rows in the table, so you are being shown approximately how many rows are in the table.

If you use the COUNT(*) function you can retrieve the exact number of rows.

share|improve this answer
Wow how did you manage to answer the question with such limited information? – Pacerier Apr 9 '15 at 14:45

I think that could be a bug of phpmyadmin ...

What version are you using?

If you do a SELECT COUNT(*) FROM table from MySQL command prompt, what number is displayed?

share|improve this answer
The correct number is shown. I am using MySQL 5.0.91 and phpMyAdmin 3.3.8. – James Simpson Dec 21 '10 at 21:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.