Home | 简体中文 | 繁体中文 | 杂文 | Search | ITEYE 博客 | OSChina 博客 | Facebook | Linkedin | 作品与服务 | Email

22.3. Maintenance 数据库维护

22.3.1. CHECK 检查表

CHECK TABLE `dbname`.`actions`;
CHECK TABLE `dbname`.`actions` QUICK FAST MEDIUM EXTENDED CHANGED;
			

22.3.2. ANALYZE 分析表

ANALYZE TABLE `dbname`.`actions`;
			

22.3.3. CHECKSUM

CHECKSUM TABLE `dbname`.`actions` QUICK;
			

22.3.4. OPTIMIZE 优化表

OPTIMIZE TABLE `dbname`.`actions`;
			

22.3.5. REPAIR 修复

REPAIR TABLE `dbname`.`members`;
SHOW TABLE STATUS LIKE 'members';
			
comments powered by Disqus