HowtocheckMySQLstorageenginetypeonLinux_MySQL

来源：懂视网责编：小采时间：2020-11-09 19:58:42

HowtocheckMySQLstorageenginetypeonLinux_MySQL

HowtocheckMySQLstorageenginetypeonLinux_MySQL:Question: I need to know whether my MySQL database table is MyISAM or Innodb type. How can I check the type of a MySQL database table There are two major MySQL storage engines used: MyISAM and Innodb . MyISAM is non-transactional, and thu

推荐度：

点击下载本文 文档为doc格式

导读HowtocheckMySQLstorageenginetypeonLinux_MySQL:Question: I need to know whether my MySQL database table is MyISAM or Innodb type. How can I check the type of a MySQL database table There are two major MySQL storage engines used: MyISAM and Innodb . MyISAM is non-transactional, and thu

Question: I need to know whether my MySQL database table is MyISAM or Innodb type. How can I check the type of a MySQL database table?

There are two major MySQL storage engines used: MyISAM and Innodb . MyISAM is non-transactional, and thus can be faster for reads, while InnoDB fully supports transactions (e.g., commit/rollback) with finer-grain locking. When you create a new MySQL table, you choose its type (i.e., storage engine). Without any choice, you will simply use a pre-configured default engine.

If you would like to know the type of an existing MySQL database table, there are a couple of ways to do it.

Method One

If you have access to phpMyAdmin, you can find out the database type from phpMyAdmin. Simply choose your database from phpMyAdmin to see a list of its tables. Under "Type" column, you will see the database type for each table.

Method Two

If you can log in to a MySQL server directly, another way to identify the storage engine is to run the following MySQL command inside your MySQL server after logging in.

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

The above command will show the engine type of a table called 'my_table' in 'my_database' database.

Method Three

Yet another method to check the MySQL engine is to use mysqlshow , a command-line utility which shows database information. The mysqlshow utility comes with MySQL client package installation . To use mysqlshow , you need to supply MySQL server login credential.

The following command will show information about a particular database. Under "Engine" column, you will see the storage engine for each table.

$ mysqlshow -u -p -i

Subscribe to Ask Xmodulo

Do you want to receive Linux related questions & answers published at Ask Xmodulo? Enter your email address below, and we will deliver our Linux Q&A straight to your email box, for free. Delivery powered by Google Feedburner.

声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com