天道酬勤,学无止境

mysqlcheck

MySQL之mysqlcheck、check、optimize和analyze

MySQL之mysqlcheckcheck、optimize和analyze ㈠ optimize optimize可以回收空间、减少碎片、提高I/O 目前支持的存储引擎有:InnoDB、MyASIM和ARCHIVE 如果是Replication环境、可加NO_WRITE_TO_BINLOG(或者LOCAL、意思完全相同)、比如: optimize local table table_name; 以下是一个简单测试: [plain] view plain copy [mysql@odd employees]$ ls -alh t.ibd -rw-rw---- 1 mysql dba 24M 05-22 16:48 t.ibd 未optimize前、有24M mysql> optimize table t; +-------------+----------+----------+-------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-------------+----------+----------+--------------------------------------------------------------

2021-04-19 15:44:37    分类:博客    mysqlcheck   mysql

MySQL之mysqlcheck、check、optimize和analyze

MySQL之mysqlcheckcheck、optimize和analyze ㈠ optimize optimize可以回收空间、减少碎片、提高I/O 目前支持的存储引擎有:InnoDB、MyASIM和ARCHIVE 如果是Replication环境、可加NO_WRITE_TO_BINLOG(或者LOCAL、意思完全相同)、比如: optimize local table table_name; 以下是一个简单测试:[plain] view plain copy[mysql@odd employees]$ ls -alh t.ibd -rw-rw---- 1 mysql dba 24M 05-22 16:48 t.ibd 未optimize前、有24M mysql> optimize table t; +-------------+----------+----------+-------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-------------+----------+----------+----------------------------------------------------------------

2021-04-19 10:41:19    分类:博客    mysql   mysqlcheck