View source for Enabling Innodb engine for MySQL

[[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
<pre>
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/
</pre>

''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:
<pre>
mkdir /usr/local/mysql/var
chown -R mysql:mysql /usr/local/mysql/var
</pre>

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]]