Installing InnoDB: Difference between revisions
Upazixorys (talk | contribs) No edit summary |
No edit summary |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
= | ==Enabling InnoDB for MySQL== | ||
Open this file: | |||
UniServer\usr\local\mysql\my.ini | |||
3. You can modify the values to suit your needs, but the default ones work great. | Search for the following line(s) and comment out '''skip-innodb''' (as shown) to activate InnoDB. | ||
4. Restart the server. | |||
5. Go to PHPMyAdmin and click on | # Note: The innodb block is enabled/disabled using a single line <br> | ||
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 | # Uncomment the next line to disable innodb tables. Comment line to enable innodb tables | ||
7. On the top, what you are most likely to see is | |||
8. To resolve the issue in #7, shutdown the server once more. | # skip-innodb | ||
9. Go to W:\usr\local\mysql\data\ and delete (or at least temporarily move) the files beginning with | |||
10. Restart the server, and follow steps 5-7 above. You should hopefully be able to now see | 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 /> | |||
1. Open the W:\usr\local\mysql\bin\my-small.cnf file in Notepad or any other text editor of your choice. <br /> | |||
2. Make sure the following lines appear as shown below - <br /> | |||
# Uncomment the following if you are NOT using innodb tables <br /> | |||
#skip-innodb <br /> | |||
# Uncomment the following if you are using Innobase tables <br /> | |||
innodb_data_file_path = ibdata1:100M <br /> | |||
innodb_data_home_dir = /usr/local/mysql/data/ <br /> | |||
innodb_log_group_home_dir = /usr/local/mysql/data/ <br /> | |||
innodb_log_arch_dir = /usr/local/mysql/data/ <br /> | |||
set-variable = innodb_mirrored_log_groups=1 <br /> | |||
set-variable = innodb_log_files_in_group=3 <br /> | |||
set-variable = innodb_log_file_size=5M <br /> | |||
set-variable = innodb_log_buffer_size=8M <br /> | |||
innodb_flush_log_at_trx_commit=1 <br /> | |||
innodb_log_archive=0 <br /> | |||
set-variable = innodb_buffer_pool_size=16M <br /> | |||
set-variable = innodb_additional_mem_pool_size=2M <br /> | |||
set-variable = innodb_file_io_threads=4 <br /> | |||
set-variable = innodb_lock_wait_timeout=50 <br /> | |||
3. You can modify the values to suit your needs, but the default ones work great. <br /> | |||
4. Restart the server. <br /> | |||
5. Go to PHPMyAdmin and click on "Show MySQL Runtime Information". <br /> | |||
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". <br /> | |||
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. <br /> | |||
8. To resolve the issue in #7, shutdown the server once more. <br /> | |||
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. <br /> | |||
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". <br /> | |||
That's it. Enjoy. | That's it. Enjoy. | ||
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.