Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement