将mariadb的所有MyISAM转为InnoDB已提高性能 MySQL 10 管理员:2025-10-06 12:37 SELECT CONCAT('ALTER TABLE `', TABLE_SCHEMA,'`.`', TABLE_NAME, '` ENGINE=InnoDB ROW_FORMAT=DYNAMIC;') AS sql_stmt FROM information_schema.TABLES WHERE 1=1 AND ENGINE='MyISAM';