phpMyAdmin showing negative total records for a da

问题:

When I check my database, it's showing negative records for a table (e.g. -200,000), other tables' records are static.

When I view the table and go back to the summary, it changes randomly to -198,000, or -220,000... It's just not static.

What could be happening?

回答1:

This is an old question but one that I ran into and this post was the first thing to show up on google so I thought I would put the right answer up.

You'll notice that all of the "negative mysql records" questions are with large tables or databases. This isn't a negative sign its ~, which means approximately. It's basically saying that there's around that many records. As far as I can tell, it shows up once any table gets more than 20,000 records in it in phpMyAdmin. This is also why the askers numbers keep fluctuating, it's not exact.

回答2:

as Eric Strom already mention that, it is correct which is that sign mean estimated total row by phpMyAdmin. you can always get a rid of that ~ sign or get exact value of its total row by clicking this number. here it is on my own table example :

and after click that number that started with ~ sign, you will get total row exactly after being re-calculated.

回答3:

go to phpmyadmin

1. select the problematic table
2. choose "operations" from the tabs on the top
3. look under the "table maintainance" block what options you have. I would simply click them all by order, let each operation finish, and see if problem remains. Each operation has a help button next to it to explain what it does. (My bet is that FLUSH should fix your problem).

回答4:

If FLUSH didn't solve your problem, try to de-fragment your table, This variations in numbers of table-rows usually occurs when table contains billions of rows.

There will be always some limitations in PHP-Myadmin.

And same time you can also fire a query "select count(id) from tableName" to get the exact number of rows.