List:General Discussion« Previous MessageNext Message »
From:Gary Smith Date:July 16 2009 8:18pm
Subject:Slave log files going nuts...
View as plain text  
I have a new slave I setup against a new master server.  The master server has 4 log files
in it, the most current being updated on the 16th.  The slave server on the other hand has
several files, many which seem to be blank.  This slave is set to slave the master and act
as a master for downstream slaves.  Note, there is no master/master on this configuration,
even though the master itself could do it.  

Below is the my.cnf file and a listing of the files generated on the slave. This portion
of the file is unique on both machines.  Only differences in the file are the server-id
and report-host.  Both servers are running 5.1.35

Any ideas?

#INNO DB settings
innodb_file_per_table
innodb_flush_log_at_trx_commit  = 1
innodb_autoextend_increment     = 2M
innodb_buffer_pool_size         = 256M
innodb_additional_mem_pool_size = 48M
innodb_log_file_size            = 10M 
innodb_log_buffer_size          = 64M
innodb_log_files_in_group       = 1

log-slave-updates
sync_binlog                     = 1
replicate-same-server-id        = 0
log_bin_trust_function_creators = 1
log-bin                         = /exports/mysql-log/log-repl
binlog-ignore-db                = mysql 
binlog-ignore-db                = information_schema 
replicate-ignore-db             = mysql
replicate-ignore-db             = information_schema
relay-log                       = hs-relay-bin
relay-log-index                 = hs-relay-index
relay-log-info-file             = hs-relay-info
relay-log-purge                 = 1


-rw-rw---- 1 mysql mysql     125 Jul 11 23:43 log-repl.000001
-rw-rw---- 1 mysql mysql     125 Jul 11 23:43 log-repl.000002
-rw-rw---- 1 mysql mysql     125 Jul 11 23:43 log-repl.000003
-rw-rw---- 1 mysql mysql 2350918 Jul 14 08:33 log-repl.000004
-rw-rw---- 1 mysql mysql     148 Jul 14 08:33 log-repl.000005
-rw-rw---- 1 mysql mysql     148 Jul 14 08:33 log-repl.000006
-rw-rw---- 1 mysql mysql     148 Jul 14 08:33 log-repl.000007
-rw-rw---- 1 mysql mysql     148 Jul 14 08:33 log-repl.000008
-rw-rw---- 1 mysql mysql     148 Jul 14 08:33 log-repl.000009
-rw-rw---- 1 mysql mysql     148 Jul 14 08:33 log-repl.000010
-rw-rw---- 1 mysql mysql     148 Jul 14 08:33 log-repl.000011
-rw-rw---- 1 mysql mysql     148 Jul 14 08:33 log-repl.000012
-rw-rw---- 1 mysql mysql     148 Jul 14 08:33 log-repl.000013
-rw-rw---- 1 mysql mysql     148 Jul 14 08:33 log-repl.000014
-rw-rw---- 1 mysql mysql  117655 Jul 14 11:24 log-repl.000015
-rw-rw---- 1 mysql mysql     148 Jul 14 11:24 log-repl.000016
-rw-rw---- 1 mysql mysql     148 Jul 14 11:24 log-repl.000017
-rw-rw---- 1 mysql mysql     148 Jul 14 11:24 log-repl.000018
-rw-rw---- 1 mysql mysql     148 Jul 14 11:24 log-repl.000019
-rw-rw---- 1 mysql mysql     148 Jul 14 11:24 log-repl.000020
-rw-rw---- 1 mysql mysql     148 Jul 14 11:24 log-repl.000021
-rw-rw---- 1 mysql mysql     148 Jul 14 11:24 log-repl.000022
-rw-rw---- 1 mysql mysql     148 Jul 14 11:24 log-repl.000023
-rw-rw---- 1 mysql mysql     148 Jul 14 11:24 log-repl.000024
-rw-rw---- 1 mysql mysql     148 Jul 14 11:24 log-repl.000025
-rw-rw---- 1 mysql mysql     148 Jul 14 11:25 log-repl.000026
-rw-rw---- 1 mysql mysql     148 Jul 14 11:25 log-repl.000027
-rw-rw---- 1 mysql mysql     148 Jul 14 11:25 log-repl.000028
-rw-rw---- 1 mysql mysql     148 Jul 14 11:25 log-repl.000029
-rw-rw---- 1 mysql mysql     148 Jul 14 11:25 log-repl.000030
-rw-rw---- 1 mysql mysql     148 Jul 14 11:25 log-repl.000031
-rw-rw---- 1 mysql mysql     148 Jul 14 11:25 log-repl.000032
-rw-rw---- 1 mysql mysql     148 Jul 14 11:25 log-repl.000033
-rw-rw---- 1 mysql mysql     148 Jul 14 11:25 log-repl.000034
-rw-rw---- 1 mysql mysql     148 Jul 14 11:25 log-repl.000035
-rw-rw---- 1 mysql mysql     148 Jul 14 11:25 log-repl.000036
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000037
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000038
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000039
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000040
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000041
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000042
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000043
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000044
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000045
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000046
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000047
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000048
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000049
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000050
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000051
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000052
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000053
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000054
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000055
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000056
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000057
-rw-rw---- 1 mysql mysql     148 Jul 14 11:26 log-repl.000058
-rw-rw---- 1 mysql mysql     148 Jul 14 11:27 log-repl.000059
-rw-rw---- 1 mysql mysql     148 Jul 14 11:27 log-repl.000060
-rw-rw---- 1 mysql mysql     148 Jul 14 11:27 log-repl.000061
-rw-rw---- 1 mysql mysql     148 Jul 14 11:27 log-repl.000062
-rw-rw---- 1 mysql mysql     148 Jul 14 11:27 log-repl.000063
-rw-rw---- 1 mysql mysql     148 Jul 14 11:27 log-repl.000064
-rw-rw---- 1 mysql mysql     148 Jul 14 11:27 log-repl.000065
-rw-rw---- 1 mysql mysql     148 Jul 14 11:27 log-repl.000066
-rw-rw---- 1 mysql mysql     148 Jul 14 11:27 log-repl.000067
-rw-rw---- 1 mysql mysql     148 Jul 14 11:27 log-repl.000068
-rw-rw---- 1 mysql mysql     148 Jul 14 11:27 log-repl.000069
-rw-rw---- 1 mysql mysql  128433 Jul 15 01:02 log-repl.000070
-rw-rw---- 1 mysql mysql     148 Jul 15 01:02 log-repl.000071
-rw-rw---- 1 mysql mysql     148 Jul 15 01:02 log-repl.000072
-rw-rw---- 1 mysql mysql     148 Jul 15 01:02 log-repl.000073
-rw-rw---- 1 mysql mysql     148 Jul 15 01:02 log-repl.000074
-rw-rw---- 1 mysql mysql     148 Jul 15 01:02 log-repl.000075
-rw-rw---- 1 mysql mysql     148 Jul 15 01:02 log-repl.000076
-rw-rw---- 1 mysql mysql     148 Jul 15 01:02 log-repl.000077
-rw-rw---- 1 mysql mysql     148 Jul 15 01:02 log-repl.000078
-rw-rw---- 1 mysql mysql     148 Jul 15 01:02 log-repl.000079
-rw-rw---- 1 mysql mysql     148 Jul 15 01:02 log-repl.000080
-rw-rw---- 1 mysql mysql     148 Jul 16 01:02 log-repl.000081
-rw-rw---- 1 mysql mysql     148 Jul 16 01:02 log-repl.000082
-rw-rw---- 1 mysql mysql     148 Jul 16 01:02 log-repl.000083
-rw-rw---- 1 mysql mysql     148 Jul 16 01:02 log-repl.000084
-rw-rw---- 1 mysql mysql     148 Jul 16 01:02 log-repl.000085
-rw-rw---- 1 mysql mysql     148 Jul 16 01:02 log-repl.000086
-rw-rw---- 1 mysql mysql     148 Jul 16 01:02 log-repl.000087
-rw-rw---- 1 mysql mysql     148 Jul 16 01:02 log-repl.000088
-rw-rw---- 1 mysql mysql     148 Jul 16 01:02 log-repl.000089
-rw-rw---- 1 mysql mysql     148 Jul 16 01:02 log-repl.000090
-rw-rw---- 1 mysql mysql     148 Jul 16 01:02 log-repl.000091
-rw-rw---- 1 mysql mysql   27956 Jul 16 13:07 log-repl.000092
-rw-rw---- 1 mysql mysql    3220 Jul 16 01:02 log-repl.index
Thread
Slave log files going nuts...Gary Smith16 Jul
  • Re: Slave log files going nuts...Todd Lyons16 Jul
    • RE: Slave log files going nuts...Gary Smith17 Jul
      • RE: Slave log files going nuts...Gavin Towey17 Jul
        • RE: Slave log files going nuts...Gary Smith19 Jul