Difference between revisions of "Installing InnoDB"

From The Uniform Server Wiki
Jump to navigation Jump to search
(New page: A lot of users like me have had issues enabling (or as you can call it installing) InnoDB within MySQL. InnoDB support is available in MySQL as a lot of users on the forum pointed out, but...)
 
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
A lot of users like me have had issues enabling (or as you can call it installing) InnoDB within MySQL. 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.
+
==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.
 +
 
 +
&#35; Note: The innodb block is enabled/disabled using a single line <br>
 +
&#35; Uncomment the next line to disable innodb tables. Comment line to enable innodb tables
 +
 +
&#35; 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.
 
<br />
 
<br />
 
1. Open the W:\usr\local\mysql\bin\my-small.cnf file in Notepad or any other text editor of your choice. <br />
 
1. Open the W:\usr\local\mysql\bin\my-small.cnf file in Notepad or any other text editor of your choice. <br />

Latest revision as of 15:10, 22 May 2011

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.