Menu
Is there a MySQL command that I can execute which will show settings such as innodb_file_format, or a configuration file which I should check?
MySQL version: 5.5.32
636
The easiest way to check whether the InnoDB engine is enabled is to log in to phpMyAdmin, click the SQL tab, type the following command in the box: show engines; and click Go to execute the query and see the available storage engines. Next to InnoDB engine, in the Support row you will see Yes if InnoDB is enabled.
show variables like 'inno%' should show up all the innodb settings in effect at the moment you run the query. As for files, there should probably be something like /etc/mysql/my. ini or a my.
Normally, InnoDB is initialized when the MySQL server is started for the first time. You can place InnoDB settings in the [mysqld] group of any option file that your server reads when it starts. The locations of MySQL option files are described in Section 4.2. 2.2, “Using Option Files”.
show variables like 'innodb%';
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
