I have the following settings in my my.cnf
#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
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.
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.
Categories: Tech
