Failed to count rows and more

[expired user #7025]'s profile image [expired user #7025] posted 11 years ago in General Permalink
Hello,

HeidiSQL does not count correctly the rows of tables, much to update (f5) does not give the correct result.

Another problem I have is that after making a large query increases RAM consumption and the end is not released.

Greetings!
ansgar's profile image ansgar posted 11 years ago Permalink
InnoDB tables do not report the exact row count. Please see the documentation on mysql.com for details.
[expired user #7025]'s profile image [expired user #7025] posted 11 years ago Permalink
Thanks ansgar, I meant that I have always worked with phpmyadmin and if it correctly.

And is there any way to release the RAM after completing a large query?
kalvaro's profile image kalvaro posted 11 years ago Permalink
Counting rows in a large database can be an expensive operation that can take a lot of time to complete. That's why HeidiSQL does not even attempt to do it; it simply shows the estimation provided by the server.

If phpMyAdmin really does it I'd say it's a bug rather than a feature. But, most likely, you're now working against a local server where table engine defaults to InnoDB. If your tables are MyISAM, then the row count should be exact.
[expired user #7025]'s profile image [expired user #7025] posted 11 years ago Permalink
Thanks for your comment kalvaro. This happens to work locally and remotely, and no matter how big the table, I'm talking about a table with 1000 rows, and has no count exact rows. And if I use InnoDB. I have not really tested MyISAM ... Thanks for the help.

The other theme of the RAM is there any solution?
ansgar's profile image ansgar posted 11 years ago Permalink
There is another complaint about huge RAM usage here. Please starr that issue.

Please login to leave a reply, or register at first.