Mysql database taking too much memory.

[George]

Sometimes database taking too much memory and such behavior of database dies or crashes the server which caused due to corrupted MySQL database. Try to do the following:

1) Kill the mysql server

/etc/rc.d/init.d/mysql stop

2) Repair all MySQL databases:

myisamchk -r /var/lib/mysql/*/*.MYI

or if you already new the database name which causing the problem then repair it by using following command.

root@server [/var/lib/mysql]#mysqlcheck -r -o database name

3) Start mysql again:

/etc/rc.d/init.d/mysql start

[Lazlo90]

Nice tip, I luckily haven't had that problem yet but I'll be sure to refer to this thread if my MySQL goes haywire!

Another thing that I think is worth mentioning is that if the database still uses a lot of memory after doing that then a possible reason might be that your website is having a heavy amount of traffic at that moment, at that point you might want to check if it's legit traffic or someone trying to crash your server.

[Shane Phillips]

If someone is, make sure you report the same to your service provider immediately and begin the firewall customization.

Regards,

Shane Phillips

[php_rules]

Another tip if your database is doing the same queries a lot is to cache your pages and only re-run the queries when the content changes - that way you only perform one set of queries and generate static pages then re-generate the pages when a change is made to the database - It took me a long time to learn this, but it was one of the best things I have learned.