The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' started by wizzy420, May 15, 2010.

  1. wizzy420

    wizzy420 Well-Known Member

    Joined:
    Nov 13, 2007
    Messages:
    125
    Likes Received:
    2
    Trophy Points:
    18
    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.
     
  2. WiredTree Joe

    WiredTree Joe Well-Known Member
    PartnerNOC

    Joined:
    Dec 13, 2006
    Messages:
    68
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Chicago, IL
Loading...

Share This Page