[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Optimize MySQL 5 tables

Posted on 2007-10-20
Medium Priority
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
  • 2
LVL 21

Expert Comment

ID: 20115382
Do you want to know what the function does to optimize the tables when this is clicked?

Author Comment

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

Accepted Solution

surajguptha earned 2000 total points
ID: 20117733
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.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month19 days, 7 hours left to enroll

872 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