Knowledgebase

Portal Home > Knowledgebase > Articles Database > MySQL memory problem


MySQL memory problem




Posted by Zaggs, 05-15-2008, 03:55 PM
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: Thank you in advance.
Posted by Zaggs, 05-15-2008, 04:03 PM
Now im getting the following error in phpMyadmin too:
Posted by juangake, 05-16-2008, 10:33 AM
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
Posted by helpyoulinux, 05-16-2008, 12:00 PM
It seems like, you dnt have enough RAM.


Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read
Help with rkhunter & chkrootkit? (Views: 584)
Liquidweb network problem ? (Views: 592)
Problems when installing memcache (Views: 553)
EU reseller - server must be in the EU (Views: 642)
Apache 2.2 or 2.4 (Views: 598)