Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to view the MySql storage engine under Linux. It is very detailed and has a certain reference value. Interested friends must finish reading it!

There is only one storage engine in databases such as Oracle and SQL Server, and all data storage management mechanisms are the same. The MySql database provides a variety of storage engines. Users can choose different storage engines for data tables according to different needs, and users can also write their own storage engines according to their own needs.

Method one

If you can access phpMyAdmin, you can find the default database type from phpMyAdmin. Select the database from phpMyAdmin to view its list of tables. Under the "Type" column, you will see the data table type of each table.

Method two

If you can log in to the MySQL server directly, another way to identify the storage engine is to log in to the MySQL server and run the following MySQL command:

Mysql > SELECT ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'my_database' AND TABLE_NAME =' my_table'

The above command displays the engine type of the mytable' table in the 'mydatabase' database'.

Method three

Another way to check the engine is to use mysqlshow, a tool that displays database information on the command line. Mysqlshow is available in the MySQL client installation package. To use mysqlshow, you need to provide login credentials for the MySQL server.

The following command displays specific database information. Under the "Engine" column, you can see the engine used by each table.

The above $mysqlshow-u-p-I is all the contents of the article "how to View the MySql Storage engine under Linux". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.