Link to home
Start Free TrialLog in
Avatar of jagathi
jagathi

asked on

How do i enable innodb in mysql with in appserv

Database server does not support InnoDB storage engine.
 Database connection error
Avatar of Loganathan Natarajan
Loganathan Natarajan
Flag of India image

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

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Umesh
Umesh
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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