Installing InnoDB

Revision as of 15:10, 22 May 2011 by BobS (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Enabling InnoDB for MySQL

Open this file:

UniServer\usr\local\mysql\my.ini

Search for the following line(s) and comment out skip-innodb (as shown) to activate InnoDB.

# Note: The innodb block is enabled/disabled using a single line
# Uncomment the next line to disable innodb tables. Comment line to enable innodb tables

# skip-innodb

That's it; no other changes needed, except to restart the server.


Older versions (pre-5.x-Nano)

InnoDB support is available in MySQL as a lot of users on the forum pointed out, but not enabled by default. To enable it, please follow the instructions below.
1. Open the W:\usr\local\mysql\bin\my-small.cnf file in Notepad or any other text editor of your choice.
2. Make sure the following lines appear as shown below -

# Uncomment the following if you are NOT using innodb tables
#skip-innodb

# Uncomment the following if you are using Innobase tables
innodb_data_file_path = ibdata1:100M
innodb_data_home_dir = /usr/local/mysql/data/
innodb_log_group_home_dir = /usr/local/mysql/data/
innodb_log_arch_dir = /usr/local/mysql/data/
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

3. You can modify the values to suit your needs, but the default ones work great.
4. Restart the server.
5. Go to PHPMyAdmin and click on "Show MySQL Runtime Information".
6. Click on InnoDB hyperlink which will take you to a lower part of the same page. Just under that information table, you will find a link for detailed "InnoDB Status".
7. On the top, what you are most likely to see is "InnoDB is disabled for this server". If not, you are good to go.
8. To resolve the issue in #7, shutdown the server once more.
9. Go to W:\usr\local\mysql\data\ and delete (or at least temporarily move) the files beginning with "ib_logfile*" and "ibdata*" where * indicates a number.
10. Restart the server, and follow steps 5-7 above. You should hopefully be able to now see "InnoDB is available on this MySQL server".

That's it. Enjoy.