Log in

View Full Version : What is the best way to optimize a large mysql DB


dwhs
12-17-2010, 02:45 AM
Is there a script or process?

I have root access for the server.
djr33
12-17-2010, 04:32 AM
Post some details. MySQL is by default optimized unless you put data in it in an usual way. Delete unneeded data and simplify your queries. What else would you want to do?