MySQL Bugs: #70632: Workbench Error Code 2008: MySQL Client ran out of memory

Bug #70632	Workbench Error Code 2008: MySQL Client ran out of memory
Submitted:	16 Oct 2013 9:00	Modified:	16 Oct 2013 11:30
Reporter:	Mark Rouse	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S5 (Performance)
Version:	6.0.7.11215	OS:	Windows (7 64-bit)
Assigned to:		CPU Architecture:	Any

Description:

Error Code: 2008 MySQL client ran out of memory appears when I try to return 30 fields and 1.1m records.  Yes, I need to return all of these 1.1m records.

System Info

Already connected to MySQL server
Already connected to MySQL server
MySQL Workbench Community (GPL) for Windows version 6.0.7  revision 11215
Configuration Directory: C:\Users\921524\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.0 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7 Enterprise Edition Service Pack 1 (build 7601), 32-bit
CPU: 4x Intel(R) Core(TM) i3-2120 CPU @ 3.30GHz, 3.3 GiB RAM
Active video adapter Radmin Mirror Driver V3
Installed video RAM: 0 MB
Current video mode: 1920 x 1200 x 4294967296 colors
Used bit depth: 32
Driver version: 3.0.0.0
Installed display drivers: NULL
Current user language: English (United Kingdom)

How to repeat:
Try returning all records and field from a large table.

You have probably reached the memory allocation limit of a 32 bit application. WB is not available as 64 bit (not for Windows at least). Also note that the situation as regards memory allocation for a 32 bit application is actually worse on 64 bit Windows than on 32 bit Windows.

There are only few GUI clients that has an option for 64 bit.  I am only aware of SQLyog, actually.

Peter
(not a MySQL/Oracler person)

Besides you claim that your Windows is 64 bit.  But the OS information returned by WB logs says 32 bit.

Is it you or WB who is inconsistent? Maybe WB return 32 bit as it runs in the 32-bit subsystem ('syswow64')?

My server is 64-bit as is the OS MySQL Server sits on on but Workbench is 32-bit and is installed on a separate PC from my server which is 32-bit.

Is there anything else that I can do other than use another GUI?

If the client is running on a 32 bit system, I doubt that another GUI will make much difference. But you may try a few others, of course. 

(Peter - and still not an official MySQL/Oracle person)

Are there any plans to release a 64-bit version of Workbench?

Thank you for the bug report. Duplicate with http://bugs.mysql.com/bug.php?id=65728 .