Solved

Rebuild Mysql Indexes for a specific table

Posted on 2009-04-14
2
855 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
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
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, fr…
This video discusses moving either the default database or any database to a new volume.

744 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

15 Experts available now in Live!

Get 1:1 Help Now