Jump to navigation Jump to search

Installing InnoDB

344 bytes added, 01:00, 24 November 2010
no edit summary
=[ Page Is Unavailable Due To Site Maintenance, Please Visit Reserve Copy 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 not enabled by default. To enable it, please follow the instructions below.
<&lt;br />&gt;1. Open the W:\usr\local\mysql\bin\my-small.cnf file in Notepad or any other text editor of your choice. <&lt;br />&gt;2. Make sure the following lines appear as shown below - <&lt;br />&gt;
&amp;#35; Uncomment the following if you are NOT using innodb tables <&lt;br />&gt;&amp;#35;skip-innodb <&lt;br />&gt;
&amp;#35; Uncomment the following if you are using Innobase tables <&lt;br />&gt;innodb_data_file_path = ibdata1:100M <&lt;br />&gt;innodb_data_home_dir = /usr/local/mysql/data/ <&lt;br />&gt;innodb_log_group_home_dir = /usr/local/mysql/data/ <&lt;br />&gt;innodb_log_arch_dir = /usr/local/mysql/data/ <&lt;br />&gt;set-variable = innodb_mirrored_log_groups=1 <&lt;br />&gt;set-variable = innodb_log_files_in_group=3 <&lt;br />&gt;set-variable = innodb_log_file_size=5M <&lt;br />&gt;set-variable = innodb_log_buffer_size=8M <&lt;br />&gt;innodb_flush_log_at_trx_commit=1 <&lt;br />&gt;innodb_log_archive=0 <&lt;br />&gt;set-variable = innodb_buffer_pool_size=16M <&lt;br />&gt;set-variable = innodb_additional_mem_pool_size=2M <&lt;br />&gt;set-variable = innodb_file_io_threads=4 <&lt;br />&gt;set-variable = innodb_lock_wait_timeout=50 <&lt;br />&gt;
3. You can modify the values to suit your needs, but the default ones work great. <&lt;br />&gt;4. Restart the server. <&lt;br />&gt;5. Go to PHPMyAdmin and click on "&quot;Show MySQL Runtime Information"&quot;. <&lt;br />&gt;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 "&quot;InnoDB Status"&quot;. <&lt;br />&gt;7. On the top, what you are most likely to see is "&quot;InnoDB is disabled for this server"&quot;. If not, you are good to go. <&lt;br />&gt;8. To resolve the issue in #7, shutdown the server once more. <&lt;br />&gt;9. Go to W:\usr\local\mysql\data\ and delete (or at least temporarily move) the files beginning with "&quot;ib_logfile*" &quot; and "&quot;ibdata*" &quot; where * indicates a number. <&lt;br />&gt;10. Restart the server, and follow steps 5-7 above. You should hopefully be able to now see "&quot;InnoDB is available on this MySQL server"&quot;. <&lt;br />&gt;
That's it. Enjoy.


Navigation menu