ストレージエンジンの確認

システムで使用できるエンジンを確認

show engines;

既存テーブルのエンジンを確認

show create table テーブル名;

mysql> show create table hoge;
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                                                                                                                                                                          |
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| hoge | CREATE TABLE `hoge` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(256) NOT NULL,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1004 DEFAULT CHARSET=utf8 |
+-------+---------------------------------------------------------------------

こちらでも可

show table status like 'テーブル名' \G;

mysql> show table status like 'pv_log' \G;
*************************** 1. row ***************************
           Name: pv_log
         Engine: MyISAM
        Version: 10
     Row_format: Dynamic
           Rows: 39788154
 Avg_row_length: 205
    Data_length: 8159129296
Max_data_length: 281474976710655
   Index_length: 259055616
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2010-06-01 18:52:52
    Update_time: 2010-06-01 18:58:37
     Check_time: 2010-06-01 19:06:11
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options:
        Comment:
1 row in set (0.00 sec)