distal-attribute
distal-attribute
distal-attribute
distal-attribute

Failed to count rows and more

davidind posted 1 year ago in General
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 posted 1 year ago
InnoDB tables do not report the exact row count. Please see the documentation on mysql.com for details.
davidind posted 1 year ago
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 posted 1 year ago
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.
davidind posted 1 year ago
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 posted 1 year ago
There is another complaint about huge RAM usage here. Please starr that issue.

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