Difference between revisions of "Enabling Innodb engine for MySQL"

From Notes_Wiki
m
m
Line 1: Line 1:
<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb>
=Enabling Innodb engine for MySQL=
=Enabling Innodb engine for MySQL=


Line 19: Line 21:
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.


Back to [[Mysql configuration]]
<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb>

Revision as of 08:07, 2 December 2012

<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb>

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.

<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb>