cPanel restart MySQL script needs to run "flush tables;" before restarting SQL server

W

wizzy420

Well-Known Member
Nov 13, 2007
127
2
68
cPanel script simply runs a "mysql stop ; mysql start"

The problem with this is when the SQL server has a lot of buffers, open tables, etc. it basically takes the sever out the entire period it takes to flush out all open buffers, tables, etc, which on a heavily used SQL server can take minutes.

This basically takes the SQL server totally offline for some period of X minutes.

If cPanel did a "flush tables;" first the SQL server would stay up, flush, and then when done a "stop ; start" will be almost instantaneous.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
E SOLVED [CPANEL-20537] Reseller cannot restart MySQL Databases 2
Bigwebmaster SOLVED [CPANEL-20407] chkservd restarts MySQL when server time doesn't match MySQL time Databases 8
J cPanel routinely restarting MySQL? Databases 3
X cPanel 11.48.0.11 Upgrade has Caused MySQL to randomly hang and won't restart Databases 1
M Why is Cpanel restarting all instances of Mysql Databases 4
Similar threads
SOLVED [CPANEL-20537] Reseller cannot restart MySQL
SOLVED [CPANEL-20407] chkservd restarts MySQL when server time doesn't match MySQL time
cPanel routinely restarting MySQL?
cPanel 11.48.0.11 Upgrade has Caused MySQL to randomly hang and won't restart
Why is Cpanel restarting all instances of Mysql
Top Bottom