The Planet Forums > Enable InnoDB

The Planet Forums > Control Panels > cPanel/WHM

ckh

Oct 1 2008, 09:08 PM

I have the following settings in my my.cnf

QUOTE

#skip-innodb

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/
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

I restarted mysql and have the following in my logs

QUOTE

061009 15:49:45 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
061009 15:49:46 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
061009 15:49:46 InnoDB: Started; log sequence number 0 0
/usr/sbin/mysqld: ready for connections.

However, when I go to phpMyAdmin, select a db/table, click the operations, innodb isn't in the dropdown list for storage engines.

I can create/alter a table, or at least not get an error message using ENGINE=INNODB but when I view the list of tables in the database, they all show MYISAM and the ones that should have changed aren't reflecting INNODB.

Anyone have any tips or things to try?

Thanks.

ckh

Oct 1 2008, 10:24 PM

Got it fixed. Had an error message in the /var/lib/mysql/myhostname.err file saying:

InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of different size 0 5242880 bytes

So, I deleted the logfiles, restarted mysql and it was there and working now.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.