MySQL Forums
Forum List  »  InnoDB

Prevent Mysqld from stopping if InnoDB is not running
Posted by: Maarten Stolte
Date: January 07, 2008 03:15AM

Hello,

We migrated our database contents to a new server using mysqldump. After doing this we discovered that all tables were now using MyIsam instead of InnoDB. Looking at the server logs I discovered mysqld was started without innodb, due to errors:

070914 12:21:05 mysqld started
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 393216000 bytes!
070914 12:21:06 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.22-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

I'm going to have to convert all tables that were InnoDB manually I'm assuming, but first I would like to be able to set mysqld up in such a way that a failure to start the innodb engine would prevent mysqld from starting at all, preventing a problem like the above in the future.

I'd also like to know what the best way is to restart the mysqld now to regain it innodb engine capabilities, I'm guessing delete all ib* files and restart the mysqld, and ofcourse check the logfile direct...

For reference I paste the my.cnf below:

[mysqld]
datadir=/var/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# START myompany specifics

# http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
innodb_buffer_pool_size = 1500M
innodb_additional_mem_pool_size=20M
innodb_log_file_size=375M
innodb_log_buffer_size=8M

# http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html
innodb_file_per_table

binlog-ignore-db = test
binlog-ignore-db = test_ballot
binlog-ignore-db = test_old
binlog-ignore-db = pretest
binlog-ignore-db = pretest_ballot
binlog-ignore-db = pretest_old
log-bin = /var/mysql/mysql-mycompany-bin

sort_buffer_size = 1M
key_buffer_size = 256M
max_connections = 200
myisam_sort_buffer_size = 64M
old_passwords=0
read_buffer_size = 1M
read_rnd_buffer_size = 4M
sort_buffer_size = 1M
query_cache_size = 32M
table_cache = 256
query_cache_size = 8

# END mycompany specifics

[mysql.server]
user=mysql
basedir=/var/

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Options: ReplyQuote


Subject
Views
Written By
Posted
Prevent Mysqld from stopping if InnoDB is not running
2759
January 07, 2008 03:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.