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