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: