Difference between revisions of "Enabling Innodb engine for MySQL"
From Notes_Wiki
(Created page with "=Enabling Innodb engine for MySQL= To enable Innodb engine for MySQL put following lines in `<tt>/etc/my.cnf</tt>' file <pre> innodb_data_home_dir = /usr/local/mysql/var/ inn...") |
m |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 6.x]] > [[Mariadb configuration|MariaDB configuration]] > [[Enabling Innodb engine for MySQL]] | |||
To enable Innodb engine for MySQL put following lines in `<tt>/etc/my.cnf</tt>' file | To enable Innodb engine for MySQL put following lines in `<tt>/etc/my.cnf</tt>' file | ||
| Line 18: | Line 19: | ||
You can check with command `<tt>mysql -e 'show engines'</tt>' which engines are working. | You can check with command `<tt>mysql -e 'show engines'</tt>' which engines are working. | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 6.x]] > [[Mariadb configuration|MariaDB configuration]] > [[Enabling Innodb engine for MySQL]] | |||
Latest revision as of 02:50, 5 March 2022
Home > CentOS > CentOS 6.x > MariaDB configuration > Enabling Innodb engine for MySQL
To enable Innodb engine for MySQL put following lines in `/etc/my.cnf' file
innodb_data_home_dir = /usr/local/mysql/var/ innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/var/ innodb_log_arch_dir = /usr/local/mysql/var/
The last line innodb_log_arch_dir may not be acceptable in all versions. If MySQL fails to start then check /var/log/mysql.log file to see if this configuration line is causing problems
You would also need to do:
mkdir /usr/local/mysql/var chown -R mysql:mysql /usr/local/mysql/var
You can check with command `mysql -e 'show engines'' which engines are working.
Home > CentOS > CentOS 6.x > MariaDB configuration > Enabling Innodb engine for MySQL
