Advertisement: Over 100,000 Jobs Worldwide. Click here to find one for you.

MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
Send This Page to Friend
Enter Friend's Email
Enter Your Email
http://www.kareerlinks.com/jobs/skill/MySQL
 
Home / Table Types or Storage Engines / Question No: 164

How to get storage engines available on MySQL server?

I need to know storage engines available on my MySQL Server?  You may explain, how to get storage engines available on MySQL Server?

Answer No: 164

MySQL provides SHOW ENGINES command to determine which engines are available to your MySQL server. Take an example:

mysql>SHOW ENGINES;

The above command will show you all available engines.  However, SHOW ENGINES isn’t supported in MySQL versions less than 4.1.2. You may use the following command to get available engines:

mysql>SHOW VARIABLES LIKE 'have_%';

Comments
Add Comments
Found a bug? Or do you have a better solution for this? Feel free to leave a message:
Leave a comment
Your Name: Your Email Address (optional):
Comment:


Related MySQL FAQs to the Above FAQ

What-is-default-table-type-of-MySQL What is default table type of MySQL?

How-to-change-the-default-storage-engine-of-MySQL How to change the default storage engine of MySQL?

How-to-convert-a-table-from-one-type-to-another-in-MySQL How to convert a table from one type to another in MySQL?

What-is-the-fastest-storage-engine-in-MySQL What is the fastest storage engine in MySQL?

What-are-transaction-safe-tables-and-not-transaction-safe-tables-in-MySQL What are transaction-safe tables and not transaction-safe tables in MySQL?