The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Database Error

Discussion in 'Workarounds and Optimization' started by Lemonate, Feb 28, 2014.

  1. Lemonate

    Lemonate Registered

    Joined:
    Feb 28, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hello,

    My site went down with database error, tried to restart database but again went down, Until I used Cloud-flare then it became online!

    Here is the result after it was down: (If someone knows please help)

    Code:
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 17d 15h 13m 36s (255M q [167.599 qps], 42M conn, TX: 560B, RX: 29B)
    [--] Reads / Writes: 92% / 8%
    [--] Total buffers: 26.2G global + 3.8M per thread (300 max threads)
    [OK] Maximum possible memory usage: 27.3G (43% of installed RAM)
    [OK] Slow queries: 0% (7K/255M)
    [!!] Highest connection usage: 100%  (301/300)
    [OK] Key buffer size / total MyISAM indexes: 320.0M/23.5M
    [OK] Key buffer hit rate: 99.1% (5M cached / 47K reads)
    [OK] Query cache efficiency: 68.1% (94M cached / 138M selects)
    [OK] Query cache prunes per day: 0
    [OK] Sorts requiring temporary tables: 0% (4K temp sorts / 762K sorts)
    [OK] Temporary tables created on disk: 20% (3K on disk / 17K total)
    [OK] Thread cache hit rate: 99% (301 created / 42M connections)
    [OK] Table cache hit rate: 92% (283 open / 307 opened)
    [OK] Open file limit used: 0% (101/49K)
    [OK] Table locks acquired immediately: 99% (47M immediate / 47M locks)
    [!!] Connections aborted: 6%
    [OK] InnoDB data size / buffer pool: 3.1G/24.0G
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        Reduce or eliminate persistent connections to reduce connection usage
        Your applications are not closing MySQL connections properly
    Variables to adjust:
        max_connections (> 300)
        wait_timeout (< 3600)
        interactive_timeout (< 10)
    Any one has any idea??? Thanks in advance!
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    669
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. Lemonate

    Lemonate Registered

    Joined:
    Feb 28, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hello,

    I have checked my log also, the errors are:

    140228 15:06:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 29003 user: 'database_name'

    140228 15:06:17 InnoDB: Starting shutdown...
    140228 15:06:34 InnoDB: Shutdown completed; log sequence number 32032587700
    140228 15:06:34 [Note] /usr/sbin/mysqld: Shutdown complete

    I could find those error, if there is more how to find them? (also sql went down and couldn't access the site, because it's all connected to the sql).

    Thanks in advance!
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    669
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    I have moved this thread to the "Optimization" forum so you will receive more user feedback on how to best optimize your MySQL configuration.

    Thank you.
     
  5. nixuser

    nixuser Member

    Joined:
    May 30, 2014
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Is the my.cnf optimized for your server? how much is the server RAM?

    May be your db tables are corrupting, try repairing the tables and db.

     
Loading...

Share This Page