I'm currently on a shared hosted account with a Drupal install. I have access to a custom php.ini file, so I was able to increase the amount of memory available to PHP, however I am constantly getting mysql memory errors in watchdog. I'll copy a few below. Does anyone have any idea if it's possible to increase MySQL memory in a hosted account? Or do I have other options? I have even got my host to move me to a new MySQL server (in case the other one was just getting abused) but I'm still having this problem. Anyone got any thoughts?
mysql_query() [function.mysql-query]: Unable to save result set in /home/******/public_html/includes/database.mysql.inc on line 153.
Invalid argument supplied for foreach() in /home/******/public_html/sites/all/modules/calendar/calendar.module on line 1204.
Got error 12 from storage engine query: SELECT data, created, headers, expire FROM cache_views WHERE cid = 'views_tables:en' in /home/******/public_html/includes/database.mysql.inc on line 172.
mysql_query() [function.mysql-query]: Unable to save result set in /home/******/public_html/includes/database.mysql.inc on line 153.
Comments
No thoughts? :(
No thoughts? :(
a possible answer
Hi there,
i had to up my php value to 200m for the first time i ran everything. I have a number of modules installed including. Imagecache recommends at least 100 or 150m (I forgot the exact number), in order to process images.
I would set it high the first time through to see if everything is resolved. then you can taper it down. Or start low and keep increasing and restarting the server until it goes through.
Chris
http://SocialNicheGuru.com
Delivering inSITE(TM), we empower you to deliver the right product and the right message to the right NICHE at the right time across all product, marketing, and sales channels.
permissions
Those watchdog errors look more like file system write permission problems.