Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Nov 2007
    Posts
    114

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

    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. #2
    cPanel Partner NOC cPanel Partner NOC Badge WiredTree Joe's Avatar
    Join Date
    Dec 2006
    Location
    Chicago, IL
    Posts
    68

    Default

    This section of the forums:

    Feature Requests for cPanel and WHM - cPanel Forums

    might be better for your suggestion.
    Joe Doss
    www.wiredtree.com
    Fully Managed Dedicated Servers and VPS Hosting

Similar Threads & Tags
Similar threads

  1. Replies: 9
    Last Post: 01-31-2011, 04:25 PM
  2. Replies: 1
    Last Post: 05-16-2010, 09:53 AM
  3. Replies: 2
    Last Post: 04-14-2009, 05:00 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube