jagathi
asked on
How do i enable innodb in mysql with in appserv
Database server does not support InnoDB storage engine.
Database connection error
Database connection error
if it is _innodb=DISABLED
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/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 = 256M
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry not refreshed...
After the change, just restart the MySQL
jagathi,
I see you have accepted my comment as answer but in my opinion "logudotcom" was also rite...so I appreciate if you can split the points with "logudotcom" as he's the first person who attempted.
Thanks,
Umesh
I see you have accepted my comment as answer but in my opinion "logudotcom" was also rite...so I appreciate if you can split the points with "logudotcom" as he's the first person who attempted.
Thanks,
Umesh
http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html