1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Strange Problem with my vps

Discussion in 'Web Hosting' started by majdi107, Nov 18, 2015.

  1. majdi107

    majdi107 Senior Member

    Joined:
    Aug 28, 2014
    Messages:
    889
    Likes Received:
    105
    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 ?
     
  2. writehow

    writehow Regular Member

    Joined:
    Mar 3, 2014
    Messages:
    303
    Likes Received:
    56
    Location:
    What?Where?Who?
    Your issue is with MySQL and not related to traffic. Something makes your MySQL to crash.
     
    • Thanks Thanks x 1
  3. majdi107

    majdi107 Senior Member

    Joined:
    Aug 28, 2014
    Messages:
    889
    Likes Received:
    105
    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 ?
     
  4. XxUnivaxX

    XxUnivaxX Jr. VIP Jr. VIP

    Joined:
    Jan 15, 2013
    Messages:
    2,531
    Likes Received:
    1,223
    Gender:
    Male
    Location:
    Basement
    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
     
  5. ziplack

    ziplack Supreme Member

    Joined:
    Feb 18, 2010
    Messages:
    1,290
    Likes Received:
    661
    Location:
    BHW
  6. writehow

    writehow Regular Member

    Joined:
    Mar 3, 2014
    Messages:
    303
    Likes Received:
    56
    Location:
    What?Where?Who?
    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.
     
  7. majdi107

    majdi107 Senior Member

    Joined:
    Aug 28, 2014
    Messages:
    889
    Likes Received:
    105

    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 ?
     
  8. great9

    great9 Newbie

    Joined:
    Aug 2, 2013
    Messages:
    22
    Likes Received:
    3
    Occupation:
    IT specialist :)
    Location:
    europe
    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
     
    Last edited: Nov 18, 2015
  9. majdi107

    majdi107 Senior Member

    Joined:
    Aug 28, 2014
    Messages:
    889
    Likes Received:
    105


    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 ?
     
  10. great9

    great9 Newbie

    Joined:
    Aug 2, 2013
    Messages:
    22
    Likes Received:
    3
    Occupation:
    IT specialist :)
    Location:
    europe
    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).