HomeMYSQL

MySQL client ran out of memory

MySQL client ran out of memory
Like Tweet Pin it Share Share Email

Error Message :

Open Database Connectivity (ODBC) error occurred. state: ‘HY000’. Native Error Code: 2008. [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.5-10.1.22-MariaDB]MySQL client ran out of memory

This error is caused due to large number of rows that are stored in client machine memory. If you are reading data from MYSQL and not performing any seek operation, then you can disable Caching and free up the memory.

Control Panel > Administrative Tools > ODBC   (64 big ODBC client)

C:\Windows\SysWOW64\odbcad32.exe   (32 bit ODBC client)

Open your DSN Name  > Configure > Details > Cursor / Results  and check  “Don’t cache results of forward-only cursors.

 

Comments (0)

Leave a Reply

Your email address will not be published. Required fields are marked *