Optimize MySQL 5 tables

Posted on 2007-10-20
Last Modified: 2013-11-26

Need som help with running optimize function in MySQL 5

I mySQL there are a option that is called

"Optimized Tables" under Table Maintenance

I need to run these querys manually, so which are the querys that is executed when I run this function?

Question by:AWestEng
    LVL 21

    Expert Comment

    Do you want to know what the function does to optimize the tables when this is clicked?
    LVL 1

    Author Comment

    no, I want yo know which query's that is tunned sp I can do the samr in my program.
    LVL 21

    Accepted Solution

    Click away this option and monitor all the queries that were run by the application. Those are the queries that were run to optimize the table.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now