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: