Bug #14158 innodb_log_archive - unable to disable
Submitted: 19 Oct 2005 22:44 Modified: 19 Oct 2005 22:59
Reporter: Jeffrey Serpas Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.13-rc-standard-log OS:Solaris (Solaris 10 i386)
Assigned to: CPU Architecture:Any

[19 Oct 2005 22:44] Jeffrey Serpas
Description:
I am attempting to separate out the logs from my data directory using the following:

---- START my.cnf ----
...
#Log Files
log=/apps/mysql/mysql/logs/mysqlpoc.log
log-bin=/apps/mysql/mysql/logs/mysqlpoc-bin.log
log-error=/apps/mysql/mysql/logs/mysqlpoc.err
log-slow-queries=/apps/mysql/mysql/logs/mysqlpoc-slow.log
...
---- END my.cnf ----

However, I still have two files in my data directory approx 5MB in size called ib_logfile0 and ib_logfile1.  Looking through the documentation I found the following:

innodb_log_archive:
"This value should currently be set to 0. Because recovery from a backup is done by MySQL using its own log files, there is currently no need to archive InnoDB log files. The default for this option is 0."

I checked my server variables:

-bash-3.00$ bin/mysqladmin variables | grep innodb_log
| innodb_log_arch_dir             | 
| innodb_log_archive              | OFF 
| innodb_log_buffer_size         | 1048576
| innodb_log_file_size             | 5242880
| innodb_log_files_in_group      | 2  
| innodb_log_group_home_dir   | ./ 

innodb_log_archive shows it is OFF, however, the logs keep appearing.  Thanks.

How to repeat:
start the server and look in the data directory

Suggested fix:
N/A