Solved

Rebuild Mysql Indexes for a specific table

Posted on 2009-04-14
2
867 Views
Last Modified: 2012-05-06
Do you have a SQL to rebuild an index for a specific table in the MySQL database?
Thanks
0
Comment
Question by:fred2k3
2 Comments
 
LVL 17

Accepted Solution

by:
leannonn earned 500 total points
ID: 24138161
You can use the `mysqlcheck` command from the command line (http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html) or one of the `CHECK TABLE` (http://dev.mysql.com/doc/refman/5.1/en/check-table.html) or `OPTIMIZE TABLE` (http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html) SQL statements.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Selecting specific rows 3 51
What does "flush tables;" do exactly? 7 72
Insert with SET how to handle join 6 59
MySql hide the stored procedures 2 40
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), 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, f…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 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

22 Experts available now in Live!

Get 1:1 Help Now