Advertisement
Guest User

LuKo

a guest
Sep 13th, 2009
649
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.83 KB | None | 0 0
  1. mysql> show table status like 'time_log_merge_07';
  2. +-------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+
  3. | 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 |
  4. +-------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+
  5. | time_log_merge_07 | MRG_MyISAM | 10 | Dynamic | 1542504 | 802 | 99788968 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | utf8_general_ci | NULL | NULL | |
  6. +-------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+
  7. 1 row in set (0.00 sec)
  8.  
  9.  
  10. mysql> show engines;
  11. +------------+----------+----------------------------------------------------------------+
  12. | Engine | Support | Comment |
  13. +------------+----------+----------------------------------------------------------------+
  14. | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
  15. | MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
  16. | InnoDB | YES | Supports transactions, row-level locking, and foreign keys |
  17. | BerkeleyDB | NO | Supports transactions and page-level locking |
  18. | BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) |
  19. | EXAMPLE | NO | Example storage engine |
  20. | ARCHIVE | YES | Archive storage engine |
  21. | CSV | YES | CSV storage engine |
  22. | ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables |
  23. | FEDERATED | YES | Federated MySQL storage engine |
  24. | MRG_MYISAM | YES | Collection of identical MyISAM tables |
  25. | ISAM | NO | Obsolete storage engine |
  26. +------------+----------+----------------------------------------------------------------+
  27. 12 rows in set (0.00 sec)
  28.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement