Hello,

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?

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.

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue

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.

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

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue

Yes it appears that some tables are in MYIsam and some in Innodb. Anyway to convert them to Innodb?

run

ALTER TABLE tablename ENGINE=InnoDB

on them

_________________
Paid support
How to ask for help
1. Give details of your problem
2. Post any errors
3. Post relevant logs.
4. Don't hide details i.e. your domain, it just makes things harder
5. Be polite or you'll be eaten by a grue