Choose your SQL server:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our newsletter
Partners
Testimonials
Aaron T. Judow: "SQL Maestro Group have created an exceptional tool for MySQL server maintenance and data reservation. I recommend it to all who need to operate efficiently".
Jonathan Fistley: "I appreciate all the dedicated help we've gotten from you and your staff. I'm a fan of your product and of your service oriented approach".

More

Add your opinion

Customers
Download Buy

Service Center for MySQL online help

Prev  Table of Contents Next 

Server Maintenance


MySQL Service Center provides you with a possibility of using four operations for MySQL server maintenance. The maintenance features performs the following operations with MySQL tables:
  • Analyzing tables
    Analyses and stores the key distribution for the table(s). During the analysis, the table is locked with a read lock. This works for MyISAM and BDB tables.

  • Checking tables
    Checks the table(s) for errors. For MyISAM tables the key statistics are updated. This works only for MyISAM and InnoDB tables.

  • Repairing tables
    Repairs the corrupted table(s). This works only for MyISAM tables.

  • Optimizing tables
    Reclaims the unused space and defragments the datafile for the table(s) with variable-length rows. This works for MyISAM and BDB tables.





Prev  Table of Contents Next