Strange Problem with my vps

[Salamouna]

Hello
i ordered a linux vps from OVH 1 core 4GB ram 20 GB SSD installed centora 6 64bit and installed senora panel and installed my wp website and every thing is fine intill ..
i drive traffic from twitter and i have follow liker so i started the software to start tweeting and driving traffic but then my website down and get
"Error establishing a database connection " so i restarted the vps and every thing is fine
i decided to send some traffic from hitleap (traffic exchange website) to test how can the vps ...
i let it the hole night and it sent more then 1k visitor and every thing is fine so tried to run the twitter software again and after 2 min the website is down again :/
i don't have big accounts so after 2 min i propably get 20 visitor not more ??
so how this happen and is there any solution for this ?

 

[writehow]

Your issue is with MySQL and not related to traffic. Something makes your MySQL to crash.

 

[Salamouna]

Thank you for the reply so how i can check what the problem in mysql ?
i contacted the vps provider and they say every thing is fine from their side
i can't even check the log
how to do that ?

 

[Univa]

Yes issue is with Mysql install Monit it will start the mysql on its own within few moments.
But still you can expect 2-3 minutes or even less downtime.

Cheers

 

[ziplack]

whats"senora panel" ?
1 install debian
use this links to install webmin & virtualmin
http://www.webmin.com/deb.html
http://eitwebguru.com/webmin-error-the-web-server-is-running-in-ssl-mode/
http://vpsshack.com/how-to-install-mysql-and-php-on-ubuntu-and-debian/
http://joealdeguer.com/installing-virtualmin-gpl-on-debian-7-wheezy/

 

[writehow]

ziplack.. he mean sentora , its the new project of the discontinued zPanel.. Its good and stable. The issue is not related to the LAMP he is using but the script he is using.

OP : Reinstall MYSQL , contact Sentora support or write on their forum their community is pretty active.

 

[Salamouna]

Yes issue is with Mysql install Monit it will start the mysql on its own within few moments.
But still you can expect 2-3 minutes or even less downtime.

Cheers

Thanks for the reply but i see that it's permanent solution
i uploaded the old sql and it failed many times
so can this be the problem ?

 

[great9]

Your MySQL server might be under high load and not accepting new connections. This could be due to bad database/table structures and overall performance problems.

I would advise to turn on slow_query_logging in mysql.
You can do that by editing the /etc/my.cnf and adding the following under
[mysqld]
long_query_time=1
log-slow-queries=/var/log/mysqld-slow-query.log
log-queries-not-using-indexes

and restarting mysqld by doing: /etc/init.d/mysqld restart

after that mysql will log all slow sql queries to /var/log/mysqld-sloq-query.log

 

[Salamouna]

Your MySQL server might be under high load and not accepting new connections. This could be due to bad database/table structures and overall performance problems.

I would advise to turn on slow_query_logging in mysql.
You can do that by editing the /etc/my.cnf and adding the following under
[mysqld]
long_query_time=1
log-slow-queries=/var/log/mysqld-slow-query.log
log-queries-not-using-indexes

and restarting mysqld by doing: /etc/init.d/mysqld restart

after that mysql will log all slow sql queries to /var/log/mysqld-sloq-query.log

Thanks for the reply but im linux noob
so where to find /etc/my.cnf and how i can acces it via ssh ?
what i should type ?

 

[great9]

connect through ssh.
type in "nano /etc/my.cnf".
make changes as described in the previus post.
press CTRL+o, hit ENTER
type "/etc/init.d/mysqld restart"
but then .. you'll need to learn a bit about linux or get sometone to read the log file and make adjustements (PM me).