search

webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.16k stars 318 forks source link

'mysql client ran out of memory'. #1319

Open atulwy opened 9 years ago

atulwy commented 9 years ago

Original issue 1319 created by webyog on 2010-04-15T09:19:39.000Z:

ticket 9333/9251:

Oser repots getting this error 'mysql client ran out of memory' whne using Data Sync to an empty table.

MySQL documentation has no proper description on how the client code (libmysql) allocates memory and if it is possible to control this somehow. The error is only listed on this page: http://dev.mysql.com/doc/refman/5.1/en/error-messages-client.html

.. and a short hint here: http://dev.mysql.com/doc/refman/5.1/en/out-of-memory.html: " ... use the mysql_use_result() C API function to retrieve the result set, which places less of a load on the client (but more on the server)"

Obivously syncing to an empty table will create large BULK inserts (but should not exceed 32M)

atulwy commented 9 years ago

Comment #1 originally posted by webyog on 2010-04-15T09:30:38.000Z:

correct: User reports ...

atulwy commented 9 years ago

Comment #2 originally posted by webyog on 2010-09-18T19:08:33.000Z:

First release after 8.61 (8.62?) will add a '-r' parameter option to SJA what may be used in situations where a huge table is synced to an empty table.

So this is in principle fixed, but not yet released nor documented.

atulwy commented 9 years ago

Comment #3 originally posted by webyog on 2011-07-30T14:43:34.000Z:

It is now both released and documented. But visibility of this option in wizard would be better!