MySql stops suddenly

[AgusDiaz]

Hi every body!

I'm novice in this forum. I have been using DirectAdmin on a VPS for some months.

Since some weeks ago, the MySql suddenly stops. What my vendor told me is that I have used more RAM memory than I am allowed several times and for that my MySql stops. This happens each two - three weeks, the VPS host about 30 sites, 10 of them with databases.

What I do to restore the service is login as admin on my DirectAdmin console and start the mySql service.

The uname -a command sees this of my VPS:

Linux www.myhost.net 2.6.22.19-RH2207 #1 SMP Sat Apr 5 02:21:05 CDT 2008 i686 i686 i386 GNU/Linux

RAM: 512 Mb

I'm sure that should be a log where errors are logged. Can some one tell me where can I find it?

Any advice will be welcome!

Thanks on advance for your time!

 

[R1Lover]

Look in your system log, but you wont see what is causing the errors or using the most ram unless you install a script that runs to catch all the info.

With 10 databases running it might be a bit much depending on the useage of those said sites.

You can tweak my.cnf to suit your amount of ram though and that might help a bit. You can also adjust httpd.conf to also use a minimal amount of ram. These changes may cause your sites to perform a little slower but may reduce the ram useage to better levels to keep mysql running.

 

[AgusDiaz]

Thanks R1Lover for your advice.

I did not find a /etc/my.cnf file, just the files /etc/my.cnf.old and /etc/my.cnf.rpmsave. I will learn how to setup a my.cnf file to log the errors, at least. I also think to increase the RAM, may be it is small for 10 databasesd ( Joomla and OsCommerce ) and Im planning to add more sites.

Any other advice will be appreciated!

Thanks.

 

[R1Lover]

you can run this from the command line and locate your my.cnf file.

updatedb

then

locate my.cnf