Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    8

    Unanswered: MySQL Out of Memory Error

    Hi,

    Does Anybody help me out in configuring/tuning my MySQL Server.

    Here are the details of our physical server:
    Microsoft Windows Server 2003
    32 bit

    Intel Xeon 3.0GHz
    RAM 32GB

    We are using MySQL Server 5.0
    Currently we are running 20 servlets and each instance averages 15000 kb.
    We are using inodb tables
    We have hundreds of users and Everytime the mysqld-nt process reaches 1,000,000k memory usagem, it crashes. The MySQL service automatically stopped. We are also encountering Unable to create new thread error.

    I know I posted this thread several times but until now there were still no clear answers for me. Need some help here..

  2. #2
    Join Date
    Feb 2010
    Posts
    3
    The out of memory error means that mysql does not have enough memory to store the entire query result: You might have encountered below mentioned error message -

    "mysql: Out of memory at line 42, 'malloc.c'
    mysql: needed 8136 byte (8k), memory in use: 12481367 bytes (12189k)
    ERROR 2008: MySQL client ran out of memory
    "

    In order to resolve this issue first check the query if it is correct. Is it reasonable that it should return so many rows? If not, correct the query and try again. Otherwise you need to invoke quick option to resolve the issue. This option will not cache each query result, rather print each row as it is received. If the issue still persists then the only way to resolve the issue is by using MySQL Repair software, which will repair the MySQL database and retain its cache value.

    I hope this will help you out.

    All the best!

  3. #3
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Without the actual log message it is difficult to pinpoint where your problem lies. For instance, are you using memory resident tables? Could this be affecting the servers memory usage.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •