Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 915
  • Last Modified:

Rebuild Mysql Indexes for a specific table

Do you have a SQL to rebuild an index for a specific table in the MySQL database?
Thanks
0
fred2k3
Asked:
fred2k3
1 Solution
 
Aleksandar BradarićSoftware DeveloperCommented:
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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now