首先查看默认的存储引擎是：
语句：
mysql> SHOW VARIABLES LIKE 'storage_engine' -> ;+----------------+--------+| Variable_name | Value |+----------------+--------+| storage_engine | MyISAM |+----------------+--------+1 row in set (0.00 sec)
可以看到我的这个是 ：MyISAM
默认这个引擎不支持那3个东西，所以要修改
我先查看一下：mysql> show engines; <----------- 用分号结尾 出来的是下面这样，分号和\G 出来的样子是不一样的。+------------+---------+------------------------------------------------------------+--------------+------+------------+| Engine | Support | Comment | Transactions | XA | Savepoints |+------------+---------+------------------------------------------------------------+--------------+------+------------+| CSV | YES | CSV storage engine | NO | NO | NO || InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES || MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO || MyISAM | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO || MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |+------------+---------+------------------------------------------------------------+--------------+------+------------+5 rows in set (0.00 sec)展示一下\G结尾的样子：
mysql> show engines \G*************************** 1. row *************************** Engine: CSV Support: YES Comment: CSV storage engineTransactions: NO XA: NO Savepoints: NO*************************** 2. row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keysTransactions: YES XA: YES Savepoints: YES*************************** 3. row *************************** Engine: MEMORY Support: YES Comment: Hash based, stored in memory, useful for temporary tablesTransactions: NO XA: NO Savepoints: NO*************************** 4. row *************************** Engine: MyISAM Support: YES Comment: Default engine as of MySQL 3.23 with great performanceTransactions: NO XA: NO Savepoints: NO*************************** 5. row *************************** Engine: MRG_MYISAM Support: YES Comment: Collection of identical MyISAM tablesTransactions: NO XA: NO Savepoints: NO5 rows in set (0.00 sec)
题外话说到这里，总之就是不支持那三个功能；Transactions 事物处理；XA；Savepoints；
所以我们要修改一下存储引擎：
找到文件my.cnf
root@b-ThinkPad-X230s:/usr/local/mysql# lsbin docs lib my.cnf share vardata include libexec mysql-test sql-bench编辑这个文件：
[mysqld] <---------------------------------------------------找到这里port = 3306socket = /tmp/mysql.sockskip-lockingkey_buffer_size = 16Mmax_allowed_packet = 1Mtable_open_cache = 64sort_buffer_size = 512Knet_buffer_length = 8Kread_buffer_size = 256Kread_rnd_buffer_size = 512Kmyisam_sort_buffer_size = 8Mdefault-storage-engine=INNODB 这句话是插入其中的，然后保存退出！接下来重启mysql这个服务，我使用的重启的方法是：
./mysqladmin -u root -p shutdown 这个命令，先把它关闭，然后查看进程没有了
然后再接着：
./mysqld_safe --user=root 把服务启动，查看进程，存在！
然后我们查看是否已经把数据库存储引擎修改了
mysql> show variables like 'storage_engine';+----------------+--------+| Variable_name | Value |+----------------+--------+| storage_engine | InnoDB |+----------------+--------+1 row in set (0.01 sec)哈哈！已经修改了！INNODB 是我们想要的！
转载于:https://www.cnblogs.com/persistcat/p/5010041.html
