var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
MySQL memory problem
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:
Thank you in advance.
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
Now im getting the following error in phpMyadmin too:
Out of memory (Needed 1042840 bytes)
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
It seems like, you dnt have enough RAM.