[{"createTime":1735734952000,"id":1,"img":"hwy_ms_500_252.jpeg","link":"https://activity.huaweicloud.com/cps.html?fromacct=261f35b6-af54-4511-a2ca-910fa15905d1&utm_source=V1g3MDY4NTY=&utm_medium=cps&utm_campaign=201905","name":"华为云秒杀","status":9,"txt":"华为云38元秒杀","type":1,"updateTime":1735747411000,"userId":3},{"createTime":1736173885000,"id":2,"img":"txy_480_300.png","link":"https://cloud.tencent.com/act/cps/redirect?redirect=1077&cps_key=edb15096bfff75effaaa8c8bb66138bd&from=console","name":"腾讯云秒杀","status":9,"txt":"腾讯云限量秒杀","type":1,"updateTime":1736173885000,"userId":3},{"createTime":1736177492000,"id":3,"img":"aly_251_140.png","link":"https://www.aliyun.com/minisite/goods?userCode=pwp8kmv3","memo":"","name":"阿里云","status":9,"txt":"阿里云2折起","type":1,"updateTime":1736177492000,"userId":3},{"createTime":1735660800000,"id":4,"img":"vultr_560_300.png","link":"https://www.vultr.com/?ref=9603742-8H","name":"Vultr","status":9,"txt":"Vultr送$100","type":1,"updateTime":1735660800000,"userId":3},{"createTime":1735660800000,"id":5,"img":"jdy_663_320.jpg","link":"https://3.cn/2ay1-e5t","name":"京东云","status":9,"txt":"京东云特惠专区","type":1,"updateTime":1735660800000,"userId":3},{"createTime":1735660800000,"id":6,"img":"new_ads.png","link":"https://www.iodraw.com/ads","name":"发布广告","status":9,"txt":"发布广告","type":1,"updateTime":1735660800000,"userId":3},{"createTime":1735660800000,"id":7,"img":"yun_910_50.png","link":"https://activity.huaweicloud.com/discount_area_v5/index.html?fromacct=261f35b6-af54-4511-a2ca-910fa15905d1&utm_source=aXhpYW95YW5nOA===&utm_medium=cps&utm_campaign=201905","name":"底部","status":9,"txt":"高性能云服务器2折起","type":2,"updateTime":1735660800000,"userId":3}]
第一种方法：ALTER TABLE
将表从一个引擎修改为另一个引擎最简单的办法是使用ALTER TABLE语句，转换表的存储引擎会导致失去原引擎相关的所有特性。
例：将mytable的引擎修改为InnoDB
mysql> ALTER TABLE mytable ENGINE = InnoDB;
上述方法适用任何的存储引擎，但执行时间较长。MySQL会按行将数据从原表复制到一张新表中，在复制过程中会消耗系统所有的I/O能力，同时会对原表加上读锁。如果在繁忙的表上执行此操作需要特别小心。
第二种方法：导出和导入数据
使用mysqldump工具将数据导出到文件，然后修改文件中CREATE
TABLE语句的存储引擎选项和表名，同时注意mysqldump默认会自动加上CREATE
TABLE语句前加上DROPTABLE语句，若忽略此点可能会导致数据丢失。
第三种方法：创建与查询(CREATE 和 SELECT)
此方法综合了上述两种方法的高效和安全，不需要导出整个表，而是先创建一个新的存储引擎的表，然后利用 INSERT ... SELECT语法导入数据。
mysql > CREATE TABLE innodb_table LIKE myisam_table;
mysql > ALTER TABLE innodb_table ENGINE=InnoDB;
mysql > INSERT INTO innodb_table SELECT * FROM myisam_table;
如果数据量大，可考虑分批处理，针对每一段数据执行事务提交操作，以免大事务产生过多的undo。
假设有主键字段id，可重复运行以下语句将数据导入新表：
mysql > START TRANSACTION;
mysql > INSERT INTO innodb_table SELECT * FROM myisam_table
-> WHERE id BETWEEN x AND y;
mysql > COMMIT;
以上操作完成后，新表是原表的一个全量复制，原表不受任何影响。如果有必要，可以在执行中对原表加锁，确保新表与原表的数据一致。
persona Toolkit提供了一个pt-online-schema-change的工具，可以简单方便地执行上述的过程，避免手工操作可能导致的失误。
