HowtocheckMySQLstorageenginetypeonLinux_MySQL

來源：懂視網(wǎng) 責(zé)編：小采時(shí)間：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

推薦度：

點(diǎn)擊下載本文 文檔為doc格式

導(dǎo)讀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.

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com