Hi
All,
Any
one have experiance on using XAMPP with configure MySQL InnoDB engine.
This
is my.cnf configuration settings, but it not working
=====================================================
#
skip-innodb
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir
= C:/Program Files/xampp/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = C:/Program Files/xampp/mysql/data/
innodb_log_arch_dir = C:/Program Files/xampp/mysql/data/
#
You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
#Set
.._log_file_size to 25 % of buffer pool size
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_lock_wait_timeout=50
=====================================================
Thankx,
Lasitha
DOTW DISCLAIMER:
This e-mail and any attachments are strictly confidential and intended for the addressee only. If you are not the named addressee you must not disclose, copy or take
any action in reliance of this transmission and you should notify us as soon as possible. If you have received it in error, please contact the message sender immediately.
This e-mail and any attachments are believed to be free from viruses but it is your responsibility to carry out all necessary virus checks and DOTW accepts no liability
in connection therewith.
This e-mail and all other electronic (including voice) communications from the sender's company are for informational purposes only. No such communication is intended
by the sender to constitute either an electronic record or an electronic signature or to constitute any agreement by the sender to conduct a transaction by electronic means.
|
|
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
