'Too many connections', 'Database error'

I have a vps from smokyhosts.com (I'm moving to wiredtree next month btw...) and I'm getting a daily downtime of about 1-5 hrs...Have any ideas what I can do to improve things, make some optimisations or shit like that? a link pointing to something with idiot proof instructions would be excellent.

 

http://www.google.com works best

 

set max_connection if my.cnf to higher number.

 

I think you have huge queries, maby optimising your database will help improving your server status!

 

Optimize the settings in my.cnf. That will improve the performance of the server.

Kailash

 

kthxdie

argothiusz, I tried that before, seemed like it didn't worked.

EricBruggema, I think so too, however I don't know how to do that.

 

Hire a professional to optimize your server/forum, also suggest you get a dedicated server, how much are you paying for the vps?

 

Raise your max connections for you mysql that should help..optimize your data base, and maybe you will need to get a bigger vps or small dedicated server.. with out seeing any logs or details its hard to say.

 

Just trying to give you a short tutorial on how to do this:

Login to your SSH with root first. On the prompt type this:

nano /etc/my.cnf

Code (markup):

Now, if it says nano command not found then only type this:

yum install nano

Code (markup):

This will install nano editor for you and then you can run the first command again. On nano run, it will open a window with my.cnf content inside. Now find this value inside:

max_connections = 

Code (markup):

And change this value to a big number you want. After completing the editing, press "CTRL + X", Press y, Press Enter.

Now simply run this command to affect the changes:

service mysql restart

Code (markup):

If you find this hard to do, download WinSCP and login to your SFTP with root details and browse /etc, now edit my.cnf file and run the mysql restart command to affect the changes.

Another way this can be done is using your VZ control panel depending on your provider. You should find a file manager in your VC control panel which can be used to browse /etc and edit your my.cnf file.

Good Luck