We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

How do i enable innodb in mysql with in appserv

jagathi
jagathi asked
on
Medium Priority
2,625 Views
Last Modified: 2012-06-21
Database server does not support InnoDB storage engine.
 Database connection error
Comment
Watch Question

Loganathan NatarajanLAMP Developer
CERTIFIED EXPERT

Commented:
Loganathan NatarajanLAMP Developer
CERTIFIED EXPERT

Commented:
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

Senior Principal Technical Support Engineer
Top Expert 2009
Commented:
Add below lines to your MySQL's config file and change /path/to/mysql/datadir/ to actual MySQL data dir path.....
    # skip-innodb
 
    innodb_data_home_dir = /path/to/mysql/datadir/
    innodb_data_file_path = ibdata1:10M:autoextend
    innodb_log_group_home_dir = /path/to/mysql/datadir/
    innodb_log_arch_dir = /path/to/mysql/datadir/
 
    set-variable = innodb_buffer_pool_size=16M
    set-variable = innodb_additional_mem_pool_size=2M
 
    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 
 
 
 
 
 
 
## AFter Adding above lines restart MySQL and check ..value should be yes
 
show variables like 'have_innodb';

Open in new window

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
UmeshSenior Principal Technical Support Engineer
Top Expert 2009

Commented:
Sorry not refreshed...
Loganathan NatarajanLAMP Developer
CERTIFIED EXPERT

Commented:
After the change, just restart the MySQL
UmeshSenior Principal Technical Support Engineer
Top Expert 2009

Commented:
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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.