XAMPP InnoDB Issue
am 29.03.2007 07:32:45 von Lasitha Alawatta------=_NextPartTM-000-0f54f962-7ee6-4770-b458-21dc35387676
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C771C3.ADECA016"
------_=_NextPart_001_01C771C3.ADECA016
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
=0AHi All,
=0AAny one have experiance on=
using XAMPP with configure MySQL InnoDB
engine.
=
=0AThis is my.cnf configuration settings, but it not working
=0D=
================= =====3D=
==================== =====3D=
======
# skip-innodb
=0A# Uncomment the followi=
ng if you are using InnoDB tables
=0Ainnodb_data_home_dir =3D C:=
/Program Files/xampp/mysql/data/
innodb_data_file_path =3D ibdata1:10M=
:autoextend
=0Ainnodb_log_group_home_dir =3D C:/Program Files/xampp/my=
sql/data/
innodb_log_arch_dir =3D C:/Program Files/xampp/mysql/data/=0D=
=0A# You can set .._buffer_pool_size up to 50 - 80 %
=0A# of RAM=
but beware of setting memory usage too high
=0Aset-variable =3D innod=
b_buffer_pool_size=3D16M
=0Aset-variable =3D innodb_additional_mem_poo=
l_size=3D2M
=0A#Set .._log_file_size to 25 % of buffer pool size=
=0Aset-variable =3D innodb_log_file_size=3D5M
=0Aset-variable =3D=
innodb_log_buffer_size=3D8M
=0Ainnodb_flush_log_at_trx_ commit=3D1
=
=0Aset-variable =3D innodb_lock_wait_timeout=3D50
====3D=
==================== =====3D=
==================== =====0D=
Thankx,
Lasitha
=0D= 0A
=0A=
=0ADOTW DISCLAIMER:
This e-mail and any attachments =
are strictly confidential and intended for the addressee only. If you are n=
ot 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 possib=
le. If you have received it in error, please contact the message sender imm=
ediately.
This e-mail and any attachments are believed to be free from=
viruses but it is your responsibility to carry out all necessary virus che=
cks and DOTW accepts no liability
in connection therewith.
=
=0AThis e-mail and all other electronic (including voice) communications fr=
om the sender's company are for informational purposes only. No such commu=
nication is intended
by the sender to constitute either an electronic =
record or an electronic signature or to constitute any agreement by the sen=
der to conduct a transaction by electronic means.
------_=_NextPart_001_01C771C3.ADECA016
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
=0A ; charset=3Dus-ascii"> d 11 (filtered medium)">