dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: 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. Use this command to know the engine type.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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   |               |        |
+--------------+--------+-------+-----------+-----+---------------+------------+----------------+-------------+----------+---------------+-----------------------+------------+-----------+----------+---------+---------------+--------+

 

Visit the DevX Tip Bank

 





   
Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date