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