LuKo

mysql> show table status like 'time_log_merge_07';

+-------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+

| Name              | Engine     | Version | Row_format | Rows    | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation       | Checksum | Create_options | Comment |

+-------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+

| time_log_merge_07 | MRG_MyISAM |      10 | Dynamic    | 1542504 |            802 |    99788968 |               0 |            0 |         0 |              0 | NULL        | NULL        | NULL       | utf8_general_ci |     NULL | NULL           |         |

+-------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+

1 row in set (0.00 sec)

 

 

mysql> show engines;

+------------+----------+----------------------------------------------------------------+

| Engine     | Support  | Comment                                                        |

+------------+----------+----------------------------------------------------------------+

| MyISAM     | DEFAULT  | Default engine as of MySQL 3.23 with great performance         |

| MEMORY     | YES      | Hash based, stored in memory, useful for temporary tables      |

| InnoDB     | YES      | Supports transactions, row-level locking, and foreign keys     |

| BerkeleyDB | NO       | Supports transactions and page-level locking                   |

| BLACKHOLE  | NO       | /dev/null storage engine (anything you write to it disappears) |

| EXAMPLE    | NO       | Example storage engine                                         |

| ARCHIVE    | YES      | Archive storage engine                                         |

| CSV        | YES      | CSV storage engine                                             |

| ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables                 |

| FEDERATED  | YES      | Federated MySQL storage engine                                 |

| MRG_MYISAM | YES      | Collection of identical MyISAM tables                          |

| ISAM       | NO       | Obsolete storage engine                                        |

+------------+----------+----------------------------------------------------------------+

12 rows in set (0.00 sec)