XXV füllt MySQL-Datenbank

3PO · 20. Dezember 2006

Hallo,

auf der Suche welcher "Übeltäter" mir meine Festplatte zumüllt, bin ich auf XXV gestoßen.

Code

vdr01 ~ # du -s -h /var/lib/mysql/*
40K     /var/lib/mysql/log.0000000001
288K    /var/lib/mysql/mysql
4,0K    /var/lib/mysql/mysql-bin.000001
4,0K    /var/lib/mysql/mysql-bin.000002
4,0K    /var/lib/mysql/mysql-bin.000003
4,0K    /var/lib/mysql/mysql-bin.000004
4,0K    /var/lib/mysql/mysql-bin.000005
4,0K    /var/lib/mysql/mysql-bin.000006
24K     /var/lib/mysql/mysql-bin.000007
4,0K    /var/lib/mysql/mysql-bin.000008
4,0K    /var/lib/mysql/mysql-bin.000009
4,0K    /var/lib/mysql/mysql-bin.000010
4,0K    /var/lib/mysql/mysql-bin.000011
4,0K    /var/lib/mysql/mysql-bin.000012
4,0K    /var/lib/mysql/mysql-bin.000013
336K    /var/lib/mysql/mysql-bin.000014
4,0K    /var/lib/mysql/mysql-bin.000015
4,0K    /var/lib/mysql/mysql-bin.000016
4,0K    /var/lib/mysql/mysql-bin.000017
4,0K    /var/lib/mysql/mysql-bin.000018
4,0K    /var/lib/mysql/mysql-bin.000019
8,0K    /var/lib/mysql/mysql-bin.000020
4,0K    /var/lib/mysql/mysql-bin.000021
4,0K    /var/lib/mysql/mysql-bin.000022
4,0K    /var/lib/mysql/mysql-bin.000023
11M     /var/lib/mysql/mysql-bin.000024
9,8M    /var/lib/mysql/mysql-bin.000025
11M     /var/lib/mysql/mysql-bin.000026
2,4M    /var/lib/mysql/mysql-bin.000027
4,0K    /var/lib/mysql/mysql-bin.000028
4,0K    /var/lib/mysql/mysql-bin.000029
4,0K    /var/lib/mysql/mysql-bin.000030
4,0K    /var/lib/mysql/mysql-bin.000031
4,0K    /var/lib/mysql/mysql-bin.000032
4,0K    /var/lib/mysql/mysql-bin.000033
2,9M    /var/lib/mysql/mysql-bin.000034
4,0K    /var/lib/mysql/mysql-bin.000035
4,0K    /var/lib/mysql/mysql-bin.000036
11M     /var/lib/mysql/mysql-bin.000037
2,7M    /var/lib/mysql/mysql-bin.000038
4,0K    /var/lib/mysql/mysql-bin.000039
11M     /var/lib/mysql/mysql-bin.000040
11M     /var/lib/mysql/mysql-bin.000041
11M     /var/lib/mysql/mysql-bin.000042
11M     /var/lib/mysql/mysql-bin.000043
11M     /var/lib/mysql/mysql-bin.000044
11M     /var/lib/mysql/mysql-bin.000045
5,6M    /var/lib/mysql/mysql-bin.000046
11M     /var/lib/mysql/mysql-bin.000047
11M     /var/lib/mysql/mysql-bin.000048
11M     /var/lib/mysql/mysql-bin.000049
11M     /var/lib/mysql/mysql-bin.000050
1020K   /var/lib/mysql/mysql-bin.000051
11M     /var/lib/mysql/mysql-bin.000052
3,1M    /var/lib/mysql/mysql-bin.000053
11M     /var/lib/mysql/mysql-bin.000054
11M     /var/lib/mysql/mysql-bin.000055
5,7M    /var/lib/mysql/mysql-bin.000056
9,6M    /var/lib/mysql/mysql-bin.000057
11M     /var/lib/mysql/mysql-bin.000058
7,9M    /var/lib/mysql/mysql-bin.000059
11M     /var/lib/mysql/mysql-bin.000060
3,8M    /var/lib/mysql/mysql-bin.000061
11M     /var/lib/mysql/mysql-bin.000062
11M     /var/lib/mysql/mysql-bin.000063
11M     /var/lib/mysql/mysql-bin.000064
4,4M    /var/lib/mysql/mysql-bin.000065
11M     /var/lib/mysql/mysql-bin.000066
3,7M    /var/lib/mysql/mysql-bin.000067
11M     /var/lib/mysql/mysql-bin.000068
6,3M    /var/lib/mysql/mysql-bin.000069
11M     /var/lib/mysql/mysql-bin.000070
1,7M    /var/lib/mysql/mysql-bin.000071
11M     /var/lib/mysql/mysql-bin.000072
11M     /var/lib/mysql/mysql-bin.000073
11M     /var/lib/mysql/mysql-bin.000074
11M     /var/lib/mysql/mysql-bin.000075
6,7M    /var/lib/mysql/mysql-bin.000076
11M     /var/lib/mysql/mysql-bin.000077
4,9M    /var/lib/mysql/mysql-bin.000078
9,0M    /var/lib/mysql/mysql-bin.000079
7,9M    /var/lib/mysql/mysql-bin.000080
11M     /var/lib/mysql/mysql-bin.000081
920K    /var/lib/mysql/mysql-bin.000082
11M     /var/lib/mysql/mysql-bin.000083
1,3M    /var/lib/mysql/mysql-bin.000084
2,6M    /var/lib/mysql/mysql-bin.000085
8,4M    /var/lib/mysql/mysql-bin.000086
11M     /var/lib/mysql/mysql-bin.000087
788K    /var/lib/mysql/mysql-bin.000088
11M     /var/lib/mysql/mysql-bin.000089
11M     /var/lib/mysql/mysql-bin.000090
11M     /var/lib/mysql/mysql-bin.000091
11M     /var/lib/mysql/mysql-bin.000092
11M     /var/lib/mysql/mysql-bin.000093
11M     /var/lib/mysql/mysql-bin.000094
11M     /var/lib/mysql/mysql-bin.000095
11M     /var/lib/mysql/mysql-bin.000096
11M     /var/lib/mysql/mysql-bin.000097
11M     /var/lib/mysql/mysql-bin.000098
11M     /var/lib/mysql/mysql-bin.000099
11M     /var/lib/mysql/mysql-bin.000100
11M     /var/lib/mysql/mysql-bin.000101
11M     /var/lib/mysql/mysql-bin.000102
11M     /var/lib/mysql/mysql-bin.000103
11M     /var/lib/mysql/mysql-bin.000104
11M     /var/lib/mysql/mysql-bin.000105
11M     /var/lib/mysql/mysql-bin.000106
11M     /var/lib/mysql/mysql-bin.000107
2,0M    /var/lib/mysql/mysql-bin.000108
11M     /var/lib/mysql/mysql-bin.000109
11M     /var/lib/mysql/mysql-bin.000110
2,8M    /var/lib/mysql/mysql-bin.000111
11M     /var/lib/mysql/mysql-bin.000112
11M     /var/lib/mysql/mysql-bin.000113
11M     /var/lib/mysql/mysql-bin.000114
11M     /var/lib/mysql/mysql-bin.000115
11M     /var/lib/mysql/mysql-bin.000116
11M     /var/lib/mysql/mysql-bin.000117
11M     /var/lib/mysql/mysql-bin.000118
11M     /var/lib/mysql/mysql-bin.000119
11M     /var/lib/mysql/mysql-bin.000120
11M     /var/lib/mysql/mysql-bin.000121
11M     /var/lib/mysql/mysql-bin.000122
11M     /var/lib/mysql/mysql-bin.000123
11M     /var/lib/mysql/mysql-bin.000124
11M     /var/lib/mysql/mysql-bin.000125
4,1M    /var/lib/mysql/mysql-bin.000126
11M     /var/lib/mysql/mysql-bin.000127
11M     /var/lib/mysql/mysql-bin.000128
11M     /var/lib/mysql/mysql-bin.000129
11M     /var/lib/mysql/mysql-bin.000130
11M     /var/lib/mysql/mysql-bin.000131
11M     /var/lib/mysql/mysql-bin.000132
11M     /var/lib/mysql/mysql-bin.000133
11M     /var/lib/mysql/mysql-bin.000134
9,9M    /var/lib/mysql/mysql-bin.000135
11M     /var/lib/mysql/mysql-bin.000136
11M     /var/lib/mysql/mysql-bin.000137
7,3M    /var/lib/mysql/mysql-bin.000138
11M     /var/lib/mysql/mysql-bin.000139
7,1M    /var/lib/mysql/mysql-bin.000140
11M     /var/lib/mysql/mysql-bin.000141
11M     /var/lib/mysql/mysql-bin.000142
228K    /var/lib/mysql/mysql-bin.000143
11M     /var/lib/mysql/mysql-bin.000144
220K    /var/lib/mysql/mysql-bin.000145
11M     /var/lib/mysql/mysql-bin.000146
11M     /var/lib/mysql/mysql-bin.000147
11M     /var/lib/mysql/mysql-bin.000148
11M     /var/lib/mysql/mysql-bin.000149
11M     /var/lib/mysql/mysql-bin.000150
11M     /var/lib/mysql/mysql-bin.000151
11M     /var/lib/mysql/mysql-bin.000152
11M     /var/lib/mysql/mysql-bin.000153
11M     /var/lib/mysql/mysql-bin.000154
11M     /var/lib/mysql/mysql-bin.000155
11M     /var/lib/mysql/mysql-bin.000156
11M     /var/lib/mysql/mysql-bin.000157
6,4M    /var/lib/mysql/mysql-bin.000158
11M     /var/lib/mysql/mysql-bin.000159
11M     /var/lib/mysql/mysql-bin.000160
11M     /var/lib/mysql/mysql-bin.000161
11M     /var/lib/mysql/mysql-bin.000162
11M     /var/lib/mysql/mysql-bin.000163
11M     /var/lib/mysql/mysql-bin.000164
6,8M    /var/lib/mysql/mysql-bin.000165
11M     /var/lib/mysql/mysql-bin.000166
11M     /var/lib/mysql/mysql-bin.000167
11M     /var/lib/mysql/mysql-bin.000168
11M     /var/lib/mysql/mysql-bin.000169
11M     /var/lib/mysql/mysql-bin.000170
11M     /var/lib/mysql/mysql-bin.000171
11M     /var/lib/mysql/mysql-bin.000172
11M     /var/lib/mysql/mysql-bin.000173
9,3M    /var/lib/mysql/mysql-bin.000174
11M     /var/lib/mysql/mysql-bin.000175
4,0M    /var/lib/mysql/mysql-bin.000176
11M     /var/lib/mysql/mysql-bin.000177
7,0M    /var/lib/mysql/mysql-bin.000178
5,9M    /var/lib/mysql/mysql-bin.000179
4,0K    /var/lib/mysql/mysql-bin.index
24K     /var/lib/mysql/test
20K     /var/lib/mysql/vdr01-slow.log
17M     /var/lib/mysql/xxv
384K    /var/lib/mysql/zm
vdr01 ~ #

Alles anzeigen

... aber voher kommen die vielen mysql-bin.000xxx Dateien?

Bei jedem Rechnerneustart wird in die mysqld.err folgendes eingetragen:

Code

061219 10:05:25  mysqld started
061219 10:05:27 [Warning] 'user' entry 'root@vdr01' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] 'user' entry '@vdr01' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] Found invalid password for user: 'xpix@localhost'; Ignoring user
061219 10:05:27 [Warning] 'db' entry 'test                                                                             @%                                                           ' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] 'db' entry 'test_%                                                                          @%                                                           ' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] 'db' entry 'GiantDisc                                                        music           @%                                                           ' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] 'db' entry 'GiantDisc                                                        music           @localhost                                                   ' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] 'db' entry 'GiantDisc                                                        music           @127.0.0.1                                                   ' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] 'db' entry 'GiantDisc                                                        apache          @localhost                                                   ' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] 'db' entry 'xxv                                                              xpix            @localhost                                                   ' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] 'db' entry 'GiantDisc                                                        vdr             @localhost                                                   ' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] 'db' entry 'zm                                                               zmuser          @localhost                                                   ' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] 'db' entry 'zm                                                               zmuser          @%                                                           ' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] 'db' entry 'zoneminder                                                       zmuser          @%                                                           ' ignored in --skip-name-resolve mode.
061219 10:05:27 [Warning] 'db' entry 'zoneminder                                                       zmuser          @localhost                                                   ' ignored in --skip-name-resolve mode.
061219 10:05:27 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.26-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Gentoo Linux mysql-5.0.26-r1
061219 10:06:02 [Warning] './xxv/VERSION' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
061219 10:06:02 [Warning] './xxv/USER' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
061219 10:06:02 [Warning] './xxv/TIMERS' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
061219 10:06:02 [ERROR] /usr/sbin/mysqld: Table './xxv/TIMERS' is marked as crashed and should be repaired
061219 10:06:02 [Warning] './xxv/TIMERS' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
061219 10:06:02 [Warning] Checking table:   './xxv/TIMERS'
061219 10:06:03 [ERROR] /usr/sbin/mysqld: Table './xxv/RECORDS' is marked as crashed and should be repaired
061219 10:06:03 [Warning] Checking table:   './xxv/RECORDS'
061219 10:06:03 [Warning] Recovering table: './xxv/RECORDS'
061219 10:06:04 [Warning] './xxv/MUSIC' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
061219 10:06:04 [Warning] './xxv/EPG' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
061219 10:06:04 [ERROR] /usr/sbin/mysqld: Table './xxv/EPG' is marked as crashed and should be repaired
061219 10:06:04 [Warning] './xxv/EPG' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
061219 10:06:04 [Warning] Checking table:   './xxv/EPG'
061219 10:06:04 [Warning] Recovering table: './xxv/EPG'
061219 10:06:06 [Warning] './xxv/AUTOTIMER' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
061219 10:06:06 [Warning] './xxv/OLDEPG' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
061219 10:06:06 [ERROR] /usr/sbin/mysqld: Table './xxv/OLDEPG' is marked as crashed and should be repaired
061219 10:06:06 [Warning] './xxv/OLDEPG' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
061219 10:06:06 [Warning] Checking table:   './xxv/OLDEPG'
061219 10:06:07 [Warning] Recovering table: './xxv/OLDEPG'
061219 16:06:03 [Warning] './xxv/CHANNELGROUPS' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
061219 20:42:48 [Note] /usr/sbin/mysqld: Normal shutdown


061219 20:42:49 [Note] /usr/sbin/mysqld: Shutdown complete


061219 20:42:49  mysqld ended

Alles anzeigen

Ich habe mal eine von den mysql-bin.000xxx Dateien mit einem Editor angeschaut, - sind alles alte EPG Daten.

Frage:
Wie kann ich xxv abgewöhnen so große Dateien anzulegen (-> außer xxv zu deaktivieren), bzw. wie kann ich die alten mysql-bin.000xxx Dateien löschen ohne meine MySQL-Datenbank zu zerschiesen?

sigiberlin · 21. Dezember 2006

das ist nur indirekt XXV. der eigentliche Übeltäter ist der mysql-Server, der die Angewohnheit hat, alles in so ein log zu schreiben.

da ich die entsprechende Einstellung für mysql nicht gefunden habe, hab ich mir angewöhnt, alle paar Tage die "alten" logfiles per Hand zu löschen. Wenn jemand nen entsprechendes Shellscript für mich hat, das man in den Cron einbauen kann ?

klak · 21. Dezember 2006

Hallo,

entweder das Logging abschalten: die log_bin-Zeile auskommentieren

oder den Parameter expire_logs_days runtersetzen.

Hier ein Auszug aus meiner conf:

Zitat

# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
expireexpire_logs_days_logs_days = 3
max_binlog_size = 100M

Alles anzeigen

klak

ps: RESTART mysql nicht vergessen.

XXV füllt MySQL-Datenbank

Jetzt mitmachen!

Teilen

Benutzer online in diesem Thema