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


Well-Known Member
Nov 13, 2007
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.