Rise Company
12-08-2024, 02:44
حل مشكلة تعطل السيرفر بسبب قاعدة البيانات fix MySQL hangup problem
fix MySQL hangup problem in WHM/cPanel Server
How-to: Troubleshoot MySQL most common issues on a cPanel server
Dis-Allowing cPanel & WHM to change MySQL open_files_limit configuration
Login to WHM and Search for Tweak Settings open it.
Inside Tweak Settings goto SQL Tab and look toggle for Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration?
We will turn it off and press the save button below.https://www.rise.company/forum/images/imported/2024/08/1.png
Repairing MySQL databases using "mysqlcheck"
"mysqlcheck" is a great utility used to repair MySQL databases while MySQL is running. So, there is no downtime and it is a safe method to repair databases.
To repair all databases using mysqlcheck:
mysqlcheck -A --auto-repair
الخلاصة :
حل المشكلة احذف remove-MySQL-Governor
مجرب 100 %
شاهد ايضا
حل مشكلة mysqldump: Error 2013: Lost connection to server during query when dumping (https://www.rise.company/forum/showthread.php/100499-%D8%AD%D9%84-%D9%85%D8%B4%D9%83%D9%84%D8%A9-mysqldump-Error-2013-Lost-connection-to-server-during-query-when-dumping)
المرجع:
https://www.basezap.com/fix-mysql-hangup-problem-whm/
https://support.cpanel.net/hc/en-us/community/posts/19120178196503-How-to-Troubleshoot-MySQL-most-common-issues-on-a-cPanel-server
https://support.cpanel.net/hc/en-us/articles/360053279513-How-to-remove-MySQL-Governor
fix MySQL hangup problem in WHM/cPanel Server
How-to: Troubleshoot MySQL most common issues on a cPanel server
Dis-Allowing cPanel & WHM to change MySQL open_files_limit configuration
Login to WHM and Search for Tweak Settings open it.
Inside Tweak Settings goto SQL Tab and look toggle for Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration?
We will turn it off and press the save button below.https://www.rise.company/forum/images/imported/2024/08/1.png
Repairing MySQL databases using "mysqlcheck"
"mysqlcheck" is a great utility used to repair MySQL databases while MySQL is running. So, there is no downtime and it is a safe method to repair databases.
To repair all databases using mysqlcheck:
mysqlcheck -A --auto-repair
الخلاصة :
حل المشكلة احذف remove-MySQL-Governor
مجرب 100 %
شاهد ايضا
حل مشكلة mysqldump: Error 2013: Lost connection to server during query when dumping (https://www.rise.company/forum/showthread.php/100499-%D8%AD%D9%84-%D9%85%D8%B4%D9%83%D9%84%D8%A9-mysqldump-Error-2013-Lost-connection-to-server-during-query-when-dumping)
المرجع:
https://www.basezap.com/fix-mysql-hangup-problem-whm/
https://support.cpanel.net/hc/en-us/community/posts/19120178196503-How-to-Troubleshoot-MySQL-most-common-issues-on-a-cPanel-server
https://support.cpanel.net/hc/en-us/articles/360053279513-How-to-remove-MySQL-Governor