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

Failed to count rows and more

User, date Message
Written by davidind
1 year 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
1 year ago
4986 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
1 year 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
1 year ago
593 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
1 year 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
1 year ago
4986 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.