Installing InnoDB: Difference between revisions
m
Reverted edits by Upazixorys (Talk); changed back to last version by Kisalay
Upazixorys (talk | contribs) No edit summary |
m (Reverted edits by Upazixorys (Talk); changed back to last version by Kisalay) |
||
| 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. | 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. | ||
<br /> | |||
1. Open the W:\usr\local\mysql\bin\my-small.cnf file in Notepad or any other text editor of your choice. | 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 - | 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 | innodb_data_file_path = ibdata1:100M <br /> | ||
innodb_data_home_dir = /usr/local/mysql/data/ | innodb_data_home_dir = /usr/local/mysql/data/ <br /> | ||
innodb_log_group_home_dir = /usr/local/mysql/data/ | innodb_log_group_home_dir = /usr/local/mysql/data/ <br /> | ||
innodb_log_arch_dir = /usr/local/mysql/data/ | innodb_log_arch_dir = /usr/local/mysql/data/ <br /> | ||
set-variable = innodb_mirrored_log_groups=1 | set-variable = innodb_mirrored_log_groups=1 <br /> | ||
set-variable = innodb_log_files_in_group=3 | set-variable = innodb_log_files_in_group=3 <br /> | ||
set-variable = innodb_log_file_size=5M | set-variable = innodb_log_file_size=5M <br /> | ||
set-variable = innodb_log_buffer_size=8M | set-variable = innodb_log_buffer_size=8M <br /> | ||
innodb_flush_log_at_trx_commit=1 | innodb_flush_log_at_trx_commit=1 <br /> | ||
innodb_log_archive=0 | innodb_log_archive=0 <br /> | ||
set-variable = innodb_buffer_pool_size=16M | set-variable = innodb_buffer_pool_size=16M <br /> | ||
set-variable = innodb_additional_mem_pool_size=2M | set-variable = innodb_additional_mem_pool_size=2M <br /> | ||
set-variable = innodb_file_io_threads=4 | set-variable = innodb_file_io_threads=4 <br /> | ||
set-variable = innodb_lock_wait_timeout=50 | set-variable = innodb_lock_wait_timeout=50 <br /> | ||
3. You can modify the values to suit your needs, but the default ones work great. | 3. You can modify the values to suit your needs, but the default ones work great. <br /> | ||
4. Restart the server. | 4. Restart the server. <br /> | ||
5. Go to PHPMyAdmin and click on | 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 | 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 | 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. | 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 | 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 | 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. | ||