Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007
    Posts
    239

    MySQL memory problem

    Hi Guys,

    We have recently recompiled Apache and now we are receiving MySQL errors on some of our sites. The errors are only displayed sometimes (not on every single load of the page).

    We have been advised that the problem may be due to MySQL running out of memory - is this correct?

    I have tried changing the 'memory_limit' in php.ini to 100MB but still this does not change anything. Here is the error we are receiving:

    Code:
    Warning: mysql_list_tables() [function.mysql-list-tables]: Unable to save MySQL query result in /home/username/public_html/includes/tables.php on line 16
    Thank you in advance.

  2. #2
    Join Date
    Mar 2007
    Posts
    239
    Now im getting the following error in phpMyadmin too:

    Code:
    Out of memory (Needed 1042840 bytes)

  3. #3
    Join Date
    Nov 2005
    Location
    Palma de Mallorca, Spain
    Posts
    259
    That seems PHP errors, not MySQL, and seems to me as you need to increase your memory_limit on this file: /etc/php.ini

    memory_limit = 8M ; Maximum amount of memory a script may consume (8MB)

    Change that for 16M, 32M or whatever you need and that server can afford

    Regards,

    Juan

  4. #4
    Join Date
    May 2008
    Location
    Sweden
    Posts
    152
    It seems like, you dnt have enough RAM.

Posting Permissions

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