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

Failed to count rows and more

User, date Message
Written by davidind
10 months ago
Category: General
3 posts since Wed, 19 Jun 13
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!
Written by ansgar
10 months ago
4793 posts since Fri, 07 Apr 06
InnoDB tables do not report the exact row count. Please see the documentation on mysql.com for details.
Written by davidind
10 months ago
3 posts since Wed, 19 Jun 13
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?
Written by kalvaro
10 months ago
563 posts since Thu, 29 Nov 07
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.
Written by davidind
10 months ago
3 posts since Wed, 19 Jun 13
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?
Written by ansgar
10 months ago
4793 posts since Fri, 07 Apr 06
There is another complaint about huge RAM usage here. Please starr that issue.
 

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