Bug #27557 we can't recover more than 252,983 records
Submitted: 30 Mar 2007 23:22 Modified: 30 Apr 2007 6:58
Reporter: GIovanni M Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.2.10 OS:
Assigned to: CPU Architecture:Any
Tags: memory load

[30 Mar 2007 23:22] GIovanni M
mysql query browser 1.2.10 show me the next message when i try to recover more than 252,983 records using next statement:

"The memory load of the system is extremly high. This is likely because of the current result being very large. In order to keep the system responsive record set retrieval  has been stopped."

The whole table has more than 330,000 records (small from others)

How to repeat:
select acc,name from _accs;

(_accs has above 330,000 records)

Suggested fix:
implement a virtual memory usage.
[31 Mar 2007 6:58] Valeriy Kravchuk
Thank you for a problem report. Please, send the results of SHOW CREATE TABLE and SHOW TABLE STATUS for yourt problematic table, and SHOW VARIABLES results from QB.
[1 May 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".