devxlogo

Learn the Storage Engine Type of a Table in MySQL

Learn the Storage Engine Type of a Table in MySQL

There are plenty of commands in MySQL that are supported for particular types of storage engines.

We can use the following command to know the ENGINE type.

SHOW TABLE STATUS WHERE NAME ='STOCKPRICE'

Here, NAME is the name of the TABLE (In this case, it is STOCKPRICE)

Sample output:

+--------------+--------+-------+-----------+-----+---------------+------------+----------------+-------------+----------+---------------+-----------------------+------------+-----------+----------+---------+---------------+--------+|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 |+--------------+--------+-------+-----------+-----+---------------+------------+----------------+-------------+----------+---------------+-----------------------+------------+-----------+----------+---------+---------------+--------+|  STOCKPRICE  | InnoDB |  10   |  Compact  |  3  |  5461         |  16384     |  0             |  0          |  0       |  NULL         |  2018-01-16 17:56:09  |  NULL      |  NULL     |  utf8_bin|  NULL   |               |        |+--------------+--------+-------+-----------+-----+---------------+------------+----------------+-------------+----------+---------------+-----------------------+------------+-----------+----------+---------+---------------+--------+

devx-admin

Share the Post: