Database Error

[Lemonate]

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)

-------- 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!

 

[cPanelMichael]

Hello

Could you let us know what error messages were in your MySQL error log when MySQL failed?

Thank you.

 

[Lemonate]

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!

 

[cPanelMichael]

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.

 

[nixuser]

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.

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!