MySQL 5.0 Certification Study Guide

MySQL has the capability to check tables for problems and to repair them should problems be found. Other table-maintenance capabilities include table analysis and optimization. This chapter discusses how to perform these types of maintenance operations. It covers the following exam topics:

  • Types of table maintenance operations

  • SQL statements for table maintenance

  • Client and utility programs for table maintenance

  • Repairing InnoDB tables

  • Enabling auto-repair for MyISAM tables

Категории