How to check MySql database table engine
Issue the following command on mysql console
MariaDB [(none)]> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'mybilling';
+-------------------------+--------+
| TABLE_NAME | ENGINE |
+-------------------------+--------+
| log_checkbilling | InnoDB |
| status | InnoDB |
| sys_files | MyISAM |
| sys_user_history_login | MyISAM |
| sys_user_login_attempts | MyISAM |
| sys_user_permissions | MyISAM |
| sys_user_profile | MyISAM |
| sys_user_roles | MyISAM |
| sys_user_sessions | MyISAM |
| sys_user_temp | MyISAM |
| sys_users | MyISAM |
| tabref | InnoDB |
| tabuser | InnoDB |
| tabuser_old | InnoDB |
+-------------------------+--------+
14 rows in set (0.00 sec)
Tidak ada komentar :
Posting Komentar