Mysql Issues
I have been having frequent issues with mysql. I only have a couple of wordpress and drupal sites and it seems that mysql just shuts down and I have to restart my server to get it working. Wordpress just says "cannot establish database connection" but everything gets back to normal after restarting.
I looked into error log and it just has bunch of "table needs repair errors."
Any ideas?
5 Replies
If you're using apache search the forums for MaxClients there's a ton of threads on it. If you are using MyISAM try converting to InnoDB. Also check your system logs (probably /var/log/messages or /var/log/syslog) for out of memory errors.
@obs:
I suspect your node is running out of memory then the kernel is killing off MySQL. Also it sounds like you're using MyISAM tables which aren't crash safe.
If you're using apache search the forums for MaxClients there's a ton of threads on it. If you are using MyISAM try converting to InnoDB. Also check your system logs (probably /var/log/messages or /var/log/syslog) for out of memory errors.
I dont know much about MyISAM or INNODB but I did import my databases from a server running mysql 5.0.6. My current version is 5.5. Could that be an issue? I will look into those error logs and report back.
Thanks.
@obs:
If by import you meant you generated a sql dump then no that won't be a problem, though you probably do have MyISAM since that was the default engine in 5.0
Yes it appears that some tables are in MYIsam and some in Innodb. Anyway to convert them to Innodb?