mysql> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES;
+----------------------+--------------------+
| TABLE_NAME | ENGINE |
+----------------------+--------------------+
...
| pma_bookmark | MyISAM |
| pma_column_info | MyISAM |
| pma_designer_coords | MyISAM |
| pma_history | MyISAM |
| pma_pdf_pages | MyISAM |
| pma_recent | MyISAM |
| pma_relation | MyISAM |
| pma_table_coords | MyISAM |
| pma_table_info | MyISAM |
| pma_table_uiprefs | MyISAM |
| pma_tracking | MyISAM |
| pma_userconfig | MyISAM |
...
結果發現是 PHPMyAdmin 的那些 tables,由於這些影響不大,就操刀吧!以 pma_bookmark 為例
mysql> ALTER TABLE `phpmyadmin`.`pma_bookmark` ENGINE = INNODB;
收工。
沒有留言:
張貼留言