ERROR [HY000] [MySQL][ODBC 8.0(w) Driver][mysqld-5.7.32-log]MySQL client ran out of memory

[Anonymous]

Refresh data through, and gateway is deployed on a server, connnected mysql database through ODBC.

It signs such an error when I refresh data:

ERROR [HY000] [MySQL][ODBC 8.0(w) Driver][mysqld-5.7.32-log]MySQL client ran out of memory

 do you guys know how to solve it? Thanks.

[amitchandak · Accepted solution]

@Anonymous ,

1. Make sure you have installed 64 bit odbc driver.

2. Try to use MySQL using the latest .net driver -https://dev.mysql.com/downloads/connector/net/

3. Increase memory Management cache in Data Load under -> file -> options and settings -> options

make it 8-10 GB and try