Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL database optimization script

Discussion in 'Workarounds and Optimization' started by m3Rlin, Jul 27, 2011.

  1. m3Rlin

    m3Rlin Member

    Joined:
    Mar 1, 2007
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    Bartlett, IL, US
    Does anyone have a MySQL optimization / repair script written completely in SQL? I would like to run it as a scheduled procedure.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. syslint

    syslint Well-Known Member

    Joined:
    Oct 9, 2006
    Messages:
    262
    Likes Received:
    6
    Trophy Points:
    168
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    You may search for the mysql tuner script it will help little. But the tuning really depend on hardware and your database .
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice