MySQL DBA system Learning (11) Managing a problem with the Redo log log of the InnoDB engine

My my.cnf file is like this.

Innodb_data_home_dir =/usr/local/mysql/var

Innodb_data_file_path = Ibdata1:10m:autoextend

Innodb_log_group_home_dir =/usr/local/mysql/var

Innodb_buffer_pool_size = 16M

Innodb_additional_mem_pool_size = 2M

Innodb_log_file_size = 5M

Innodb_log_buffer_size = 8M

Innodb_flush_log_at_trx_commit = 1

Innodb_lock_wait_timeout = 50

The result starts with the following error:

130904 16:26:00 [ERROR]/usr/local/mysql/libexec/mysqld:unknown variable ' Innod

B_data_file_path=ibdata1:10m:autoextend '

130904 16:26:00 [ERROR] Aborting

130904 16:26:00 [note]/usr/local/mysql/libexec/mysqld:shutdown complete

130904 16:26:00 mysqld_safe mysqld from PID File/usr/local/mysql/var/test4.wolf

. Org.pid Ended

I checked and learned

>show variables like ' have% ';

If Have_innodb = no, it is indeed compiled when the InnoDB is not loaded.

Then you need to recompile./configure ...--with-plugins=innobase

Alas, alas, only recompile

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/MySQL/

[Root@test4 mysql-5.1.70]#./configure--prefix=/usr/local/mysql--enable-assembler--datadir=/mysql/data-- With-client-ldflags=-all-static--with-unix-socket-path=/tmp--with-charset=utf8--enable-thread-safe-client-- With-pthread--without-debug--with-big-tables--enable-community-features--enable-profiling--enable-local-infile --with-fast-mutexes--with-plugins=partition,federated,ndbcluster,innobase,csv,blackhole,myisam,innodb_plugin

[Root@test4 mysql-5.1.70]# make && strip sql/mysqld && make install

If you compile the installation and compile the Innnodb but there is still this problem, then solve

Resolved as follows:

/var/lib/mysql directory, delete ibdata1, Ib_logfile1, IB_LOGFILE0, and then restart MySQL to rebuild the files above:

Mysqladmin-uroot-p shutdown

sudo mysqld_safe &

Get!

This article from the "Live Well" blog, please be sure to keep this source http://wolfword.blog.51cto.com/4892126/1288657