一、确定版本 查看MySQL版本 复制代码 代码如下:mysql -V 或者可以登录MySQL使用select version();或status;命令查看 二、开始工作 关闭MySQL 复制代码 代码如下: service mysql stop 如果上面的命令无
一、确定版本
查看MySQL版本复制代码 代码如下:mysql -V或者可以登录MySQL使用select version();或status;命令查看
二、开始工作
关闭MySQL复制代码 代码如下:service mysql stop如果上面的命令无法关闭MySQL，则使用kill -9命令强制杀掉进程；
修改MySQL配置文件my.cnf（通常位于/etc/mysql/my.cnf）下加入如下字段
对于MySQL 5.5而言：
复制代码 代码如下:default-storage-engine=MyISAMloose-skip-innodb
loose-innodb-trx=0 loose-innodb-locks=0 loose-innodb-lock-waits=0 loose-innodb-cmp=0 loose-innodb-cmp-per-index=0loose-innodb-cmp-per-index-reset=0loose-innodb-cmp-reset=0 loose-innodb-cmpmem=0 loose-innodb-cmpmem-reset=0 loose-innodb-buffer-page=0 loose-innodb-buffer-page-lru=0 loose-innodb-buffer-pool-stats=0对于MySQL 5.6而言：复制代码 代码如下:default-storage-engine=MyISAMdefault-tmp-storage-engine=MYISAMloose-skip-innodb
loose-innodb-trx=0 loose-innodb-locks=0 loose-innodb-lock-waits=0 loose-innodb-cmp=0 loose-innodb-cmp-per-index=0loose-innodb-cmp-per-index-reset=0loose-innodb-cmp-reset=0 loose-innodb-cmpmem=0 loose-innodb-cmpmem-reset=0 loose-innodb-buffer-page=0 loose-innodb-buffer-page-lru=0 loose-innodb-buffer-pool-stats=0 loose-innodb-metrics=0 loose-innodb-ft-default-stopword=0 loose-innodb-ft-inserted=0 loose-innodb-ft-deleted=0 loose-innodb-ft-being-deleted=0 loose-innodb-ft-config=0 loose-innodb-ft-index-cache=0 loose-innodb-ft-index-table=0 loose-innodb-sys-tables=0 loose-innodb-sys-tablestats=0 loose-innodb-sys-indexes=0 loose-innodb-sys-columns=0 loose-innodb-sys-fields=0 loose-innodb-sys-foreign=0 loose-innodb-sys-foreign-cols=0
三、查看成效
登录MySQL复制代码 代码如下:mysql -uroot -p你的密码显示使用的数据库引擎复制代码 代码如下:show engines+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+| Engine | Support | Comment | Transactions | XA | Savepoints |+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL || CSV | YES | CSV storage engine | NO | NO | NO || MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO || BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO || MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO || InnoDB | NO | Supports transactions, row-level locking, and foreign keys | NULL | NULL | NULL || ARCHIVE | YES | Archive storage engine | NO | NO | NO || MyISAM | DEFAULT | MyISAM storage engine | NO | NO | NO || PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+9 rows in set (0.00 sec)
