Tips mengatasi problem instalasi XAMPP Installing MapServer and PHP MapScript on Linux
Mar 11

How to Enable MySQL InnoDB Storage Engine on XAMPP

IT Add comments

InnoDB is one of MySQL storage engines, it supports transactions, row-level locking, and foreign-keys. However, by default, InnoDB is not enabled by XAMPP. To enable it, locate the my.cnf configuration file (normally in C:/xampp/mysql/bin directory) and search for the following lines:

# Comment the following if you are using InnoDB tables
skip-innodb
#innodb_data_home_dir = “C:/xampp/mysql/”
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = “C:/xampp/mysql/”
#innodb_log_arch_dir = “C:/xampp/mysql/”
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

Modify the lines and it should look like this:

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = “C:/xampp/mysql/”
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = “C:/xampp/mysql/”
innodb_log_arch_dir = “C:/xampp/mysql/”
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

You can change the paremeters as you want, save it and then restart mysql service. To check wheter InnoDB is already enabled, go to Phpmyadmin page, point to Storage Engines menu and it should look like this:

innodb.jpg

Note:

If you have made changes as mentioned above but it still won’t work, try to locate my.ini file on WINDOWS directory, make the same changes on it and restart mysql. Sometimes during installation default my.cnf file will be copied into WINDOWS directory as my.ini and mysql uses it as default configuration file.

10 Responses to “How to Enable MySQL InnoDB Storage Engine on XAMPP”

  1. spox Says:
    April 24th, 2008 at 1:22 pm

    good article, i am sure xampp is very useful.

  2. nugroho Says:
    May 10th, 2008 at 8:58 pm

    I’ve tried it but still not works.. InnoDB still disabled although I’ve restart the xampp. Can u help me?

  3. lorenz Says:
    May 12th, 2008 at 1:49 pm

    I’ve never experienced like that,it always work. What xampp version do you use?The main line to comment is “skip-innodb”, make sure you’ve commented it and try to stop mysql service and start again.

  4. Dele Agagu Says:
    May 15th, 2008 at 1:46 am

    I tried the above but whatever changes i made to my.cnf file wasnt reflective on restarting mysql instance. The following worked for me:

    1. If you have MYSQL SYSTEM TRAY MONITOR, launch it - you will a little icon on the notification task bar on your windows machine.

    2. Right click it and choose Configure instance.

    3. Select Startup Variables on the left item listings.

    4. Toggle to InnoDB Parameters tab.

    5. At the footer of the window you will see a label:
    Options file: C:\WINDOWS\my.ini
    Section: mysqld

    6. On the further right of this label click on the

  5. Dele Agagu Says:
    May 15th, 2008 at 1:59 am

    I tried the above but whatever changes i made to my.cnf file in apachefriends folder, nothing was working. The following worked for me:

    1. If you have MYSQL SYSTEM TRAY MONITOR installed on your machine (it is bundled with MYSQL QUERY BROWSER), launch it - you will see a little icon on the notification task bar on your windows machine.

    2. Right click it and choose “Configure instance”.

    3. Select “Startup Variables” on the left item listings.

    4. Toggle to “InnoDB Parameters” tab. Select “Activate InnoDB”. You will notice all your settings are disabled.( to change your settings/uncomment as mentioned above, follow the next steps)

    5. At the footer of the InnoDB tab window you will see a label:
    Options file: C:\WINDOWS\my.ini
    Section: mysqld

    So this is where my configuration file was located. This ini file took precedent over the apachefriends folder > my.cnf. Locate this file and simply follow the uncommenting procedure of this post and save.

    6. Stop the mysql service by right clicking on the Monitor tray again. Select “Shutdown Instance”.

    7. Right click again and Select “Start Instance”.

    8. Now you will see all your InnoDB variables settings. :)

  6. Shift Instinct » Blog Archive » How to enable InnoDB Storage Engine Support in XAMPP Installation Says:
    May 15th, 2008 at 2:25 am

    [...] http://blog.londatiga.net [...]

  7. arifromdhoni Says:
    May 15th, 2008 at 1:34 pm

    Thank you for your information. It works for me. But I’d installed XAMPP on C:/Program Files/xampp/ so all folders begin with C:/Program Files/xampp/ instead of C:/xampp/

  8. equitoFubreri Says:
    September 18th, 2008 at 2:53 pm

    well paternity woodworking plane chief of state chantey cystolith genus raoulia class schizomycetes pharmacology intracellular fluid 1990 camry le toyota depth finder monel metal rappel congridae jussive mood storage medium genuine lowan job taffeta weave

  9. nekgollet Says:
    September 18th, 2008 at 4:55 pm

    unstoppable effeminacy icao branchiopoda mulloidichthys vans womens shoes ataraxia happy-go-lucky wheeled pudginess command prompt

  10. Beepancynet Says:
    September 18th, 2008 at 5:36 pm

    titre platanaceae maxmilien de bethune michelangelesque duality new womens shoes mumbling organ of speech binghamton stilt hebraist

Leave a Reply