répertoire /var/log/mysql et fichiers mysql-bin.

--- pingouin osmolateur
<pingouin_osmolateur@yahoo.fr> a écrit :

SAlut la liste
M'apercevant que mon serveur de logs augmenter
rapidement, je fais quelques investigations et je
m'aperçois que le répertoire /var/log/mysql fais 5.2
G
/var/log/mysql# du -h --max-depth=1 .
5,2G .

Je fais donc un petit
/var/log/mysql# ls -al
total 5405156
drwxr-s--- 2 mysql adm 4096 2005-04-18 06:25
.
drwxr-xr-x 11 root root 4096 2005-04-18 06:25
..
-rw-rw---- 1 mysql adm 8590 2005-04-04 16:20
mysql-bin.000001
-rw-rw---- 1 mysql adm 194944 2005-04-04 16:20
mysql-bin.000002
-rw-rw---- 1 mysql adm 206 2005-04-04 16:20
mysql-bin.000003
-rw-rw---- 1 mysql adm 472 2005-04-04 16:20
mysql-bin.000004
-rw-rw---- 1 mysql adm 629 2005-04-04 16:20
mysql-bin.000005
-rw-rw---- 1 mysql adm 90019 2005-04-05 17:27
mysql-bin.000006
-rw-rw---- 1 mysql adm 339 2005-04-05 17:31
mysql-bin.000007
-rw-rw---- 1 mysql adm 74114 2005-04-06 06:25
mysql-bin.000008
-rw-rw---- 1 mysql adm 104857664 2005-04-06 09:44
mysql-bin.000009
-rw-rw---- 1 mysql adm 104858291 2005-04-06 09:46
mysql-bin.000010
-rw-rw---- 1 mysql adm 104857788 2005-04-06 09:49
mysql-bin.000011
-rw-rw---- 1 mysql adm 104857890 2005-04-06 09:51
mysql-bin.000012
-rw-rw---- 1 mysql adm 104858056 2005-04-06 09:53
mysql-bin.000013
-rw-rw---- 1 mysql adm 104858223 2005-04-06 11:57
mysql-bin.000014
-rw-rw---- 1 mysql adm 43689580 2005-04-07 06:25
mysql-bin.000015
-rw-rw---- 1 mysql adm 104857723 2005-04-07 20:01
mysql-bin.000016
-rw-rw---- 1 mysql adm 67303177 2005-04-08 06:25
mysql-bin.000017
-rw-rw---- 1 mysql adm 104857804 2005-04-08 14:34
mysql-bin.000018
-rw-rw---- 1 mysql adm 70757758 2005-04-09 06:25
mysql-bin.000019
-rw-rw---- 1 mysql adm 36807458 2005-04-10 06:25
mysql-bin.000020
-rw-rw---- 1 mysql adm 36951819 2005-04-11 06:25
mysql-bin.000021
-rw-rw---- 1 mysql adm 34943102 2005-04-11 11:37
mysql-bin.000022
-rw-rw---- 1 mysql adm 104857782 2005-04-11 16:59
mysql-bin.000023
-rw-rw---- 1 mysql adm 104857796 2005-04-11 17:10
mysql-bin.000024
-rw-rw---- 1 mysql adm 104857997 2005-04-11 17:13
mysql-bin.000025
-rw-rw---- 1 mysql adm 104857852 2005-04-11 17:15
mysql-bin.000026
-rw-rw---- 1 mysql adm 20943158 2005-04-11 17:16
mysql-bin.000027
-rw-rw---- 1 mysql adm 80173179 2005-04-12 06:25
mysql-bin.000028
-rw-rw---- 1 mysql adm 104857993 2005-04-12 11:26
mysql-bin.000029
-rw-rw---- 1 mysql adm 104857647 2005-04-12 11:29
mysql-bin.000030
-rw-rw---- 1 mysql adm 104858275 2005-04-12 11:31
mysql-bin.000031
-rw-rw---- 1 mysql adm 104858023 2005-04-12 14:16
mysql-bin.000032
-rw-rw---- 1 mysql adm 104858246 2005-04-12 14:19
mysql-bin.000033
-rw-rw---- 1 mysql adm 104857785 2005-04-12 14:21
mysql-bin.000034
-rw-rw---- 1 mysql adm 104857907 2005-04-12 14:24
mysql-bin.000035
-rw-rw---- 1 mysql adm 104857748 2005-04-12 17:59
mysql-bin.000036
-rw-rw---- 1 mysql adm 104857651 2005-04-13 05:33
mysql-bin.000037
-rw-rw---- 1 mysql adm 6065620 2005-04-13 06:25
mysql-bin.000038
-rw-rw---- 1 mysql adm 104858233 2005-04-13 11:53
mysql-bin.000039
-rw-rw---- 1 mysql adm 104858308 2005-04-13 16:03
mysql-bin.000040
-rw-rw---- 1 mysql adm 29182780 2005-04-13 17:19
mysql-bin.000041
-rw-rw---- 1 mysql adm 104857793 2005-04-14 01:57
mysql-bin.000042
-rw-rw---- 1 mysql adm 52090496 2005-04-14 06:25
mysql-bin.000043
-rw-rw---- 1 mysql adm 63595762 2005-04-14 09:40
mysql-bin.000044
-rw-rw---- 1 mysql adm 79 2005-04-14 09:41
mysql-bin.000045
-rw-rw---- 1 mysql adm 209261 2005-04-14 09:41
mysql-bin.000046
-rw-rw---- 1 mysql adm 206 2005-04-14 09:41
mysql-bin.000047
-rw-rw---- 1 mysql adm 472 2005-04-14 09:41
mysql-bin.000048
-rw-rw---- 1 mysql adm 629 2005-04-14 09:41
mysql-bin.000049
-rw-rw---- 1 mysql adm 17114404 2005-04-14 10:14
mysql-bin.000050
-rw-rw---- 1 mysql adm 104857677 2005-04-14 14:01
mysql-bin.000051
-rw-rw---- 1 mysql adm 104858254 2005-04-14 14:16
mysql-bin.000052
-rw-rw---- 1 mysql adm 104857731 2005-04-14 16:22
mysql-bin.000053
-rw-rw---- 1 mysql adm 104857715 2005-04-14 18:39
mysql-bin.000054
-rw-rw---- 1 mysql adm 104857711 2005-04-15 01:06
mysql-bin.000055
-rw-rw---- 1 mysql adm 84434721 2005-04-15 06:25
mysql-bin.000056
-rw-rw---- 1 mysql adm 104857736 2005-04-15 09:57
mysql-bin.000057
-rw-rw---- 1 mysql adm 104858341 2005-04-15 10:55
mysql-bin.000058
-rw-rw---- 1 mysql adm 104857645 2005-04-15 11:17
mysql-bin.000059
-rw-rw---- 1 mysql adm 104858363 2005-04-15 12:50
mysql-bin.000060
-rw-rw---- 1 mysql adm 104857651 2005-04-15 14:32
mysql-bin.000061
-rw-rw---- 1 mysql adm 104858141 2005-04-15 18:38
mysql-bin.000062
-rw-rw---- 1 mysql adm 104857756 2005-04-16 00:08
mysql-bin.000063
-rw-rw---- 1 mysql adm 104857711 2005-04-16 05:46
mysql-bin.000064
-rw-rw---- 1 mysql adm 12285749 2005-04-16 06:25
mysql-bin.000065
-rw-rw---- 1 mysql adm 104857659 2005-04-16 12:00
mysql-bin.000066
-rw-rw---- 1 mysql adm 104857746 2005-04-16 17:36
mysql-bin.000067
-rw-rw---- 1 mysql adm 104857727 2005-04-16 23:13
mysql-bin.000068
-rw-rw---- 1 mysql adm 104857710 2005-04-17 04:41
mysql-bin.000069
-rw-rw---- 1 mysql adm 31982832 2005-04-17 06:25
mysql-bin.000070
-rw-rw---- 1 mysql adm 104857705 2005-04-17 12:05
mysql-bin.000071
-rw-rw---- 1 mysql adm 104857694 2005-04-17 17:41
mysql-bin.000072
-rw-rw---- 1 mysql adm 104857727 2005-04-17 23:17
mysql-bin.000073
-rw-rw---- 1 mysql adm 104857668 2005-04-18 04:49
mysql-bin.000074
-rw-rw---- 1 mysql adm 30223597 2005-04-18 06:25
mysql-bin.000075
-rw-rw---- 1 mysql adm 91173615 2005-04-18 11:01
mysql-bin.000076
-rw-rw---- 1 mysql adm 2432 2005-04-18 06:25
mysql-bin.index

Quelqu'un peut me dire ce que c'est que ces fichiers
et si je peux les supprimer.

En cherchant un peu plus j'ai trouvé quelques
explications, il existe un fichier
/etc/mysql/debian-log-rotate.conf


# This is the config file for
# /etc/logrotate.d/mysql-server (for normal
logs)
# /etc/cron.daily/mysql-server-4.1 (for binary
logs)
# It should be kept in shell script syntax and contain
only variables.
#
# Both log file types are rotated daily, whenever
"FLUSH LOGS;" is
# issued and when the server (re)starts so do not
choose too low numbers.

# Configuring /etc/logrotate.d/mysql-server does not
yet work.

# The number of binary log files that are kept. They
are rotated daily
# and on "FLUSH LOGS;". A value of 0 disables rotating
and is set as default
# for backward compatibility.
KEEP_BINARY_LOGS=2

Mais je ne vois pas quoi en faire ???? est-ce que
quelqu'un peut me renseigner ?

Sinon j'ai rajouté un cron de la forme suivante
find /var/log/mysql -name mysql-bin.* -mtime +2
-exec rm -f {} ;

le temps que j'écrive le mail un nouveau fichier
mysql-bin.000077 est apparu
-rw-rw---- 1 mysql adm 1273457 2005-04-18 11:24
mysql-bin.000077
-rw-rw---- 1 mysql adm 2464 2005-04-18 11:22
mysql-bin.index

Merci pour vos réponses
AC

__________________________________________________________________
Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos mails !
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com/


--
Pensez à lire la FAQ de la liste avant de poser une question :
http://wiki.debian.net/?DebianFrench

Pensez à rajouter le mot ``spam'' dans vos champs "From" et "Reply-To:"

To UNSUBSCRIBE, email to debian-user-french-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

Salut

Pour purger les fichiers bin tu fais au choix :

PURGE MASTER LOGS TO 'mysql-bin.010';

PURGE MASTER LOGS BEFORE '2003-04-02 22:46:26';

Je ne sais pas si cela a de l'importance (j'imagine que oui) mais il y a
egalement un fichier d'index dans ce repertoire. Les commandes ci-dessus le
mettent à jour. A integrer dans un cron par exemple.
mysqladmin -u root -pxxxx purge master logs etc....

Pat



"pingouin osmolateur" <pingouin_osmolateur@yahoo.fr> a écrit dans le message
de news: 20050418092618.35965.qmail@web25402.mail.ukl.yahoo.com...
SAlut la liste
M'apercevant que mon serveur de logs augmenter
rapidement, je fais quelques investigations et je
m'aperçois que le répertoire /var/log/mysql fais 5.2 G
/var/log/mysql# du -h --max-depth=1 .
5,2G .

Je fais donc un petit
/var/log/mysql# ls -al
total 5405156
drwxr-s--- 2 mysql adm 4096 2005-04-18 06:25 .
drwxr-xr-x 11 root root 4096 2005-04-18 06:25
..
-rw-rw---- 1 mysql adm 8590 2005-04-04 16:20
mysql-bin.000001
-rw-rw---- 1 mysql adm 194944 2005-04-04 16:20
mysql-bin.000002
-rw-rw---- 1 mysql adm 206 2005-04-04 16:20
mysql-bin.000003
-rw-rw---- 1 mysql adm 472 2005-04-04 16:20
mysql-bin.000004
-rw-rw---- 1 mysql adm 629 2005-04-04 16:20
mysql-bin.000005
-rw-rw---- 1 mysql adm 90019 2005-04-05 17:27
mysql-bin.000006
-rw-rw---- 1 mysql adm 339 2005-04-05 17:31
mysql-bin.000007
-rw-rw---- 1 mysql adm 74114 2005-04-06 06:25
mysql-bin.000008
-rw-rw---- 1 mysql adm 104857664 2005-04-06 09:44
mysql-bin.000009
-rw-rw---- 1 mysql adm 104858291 2005-04-06 09:46
mysql-bin.000010
-rw-rw---- 1 mysql adm 104857788 2005-04-06 09:49
mysql-bin.000011
-rw-rw---- 1 mysql adm 104857890 2005-04-06 09:51
mysql-bin.000012
-rw-rw---- 1 mysql adm 104858056 2005-04-06 09:53
mysql-bin.000013
-rw-rw---- 1 mysql adm 104858223 2005-04-06 11:57
mysql-bin.000014
-rw-rw---- 1 mysql adm 43689580 2005-04-07 06:25
mysql-bin.000015
-rw-rw---- 1 mysql adm 104857723 2005-04-07 20:01
mysql-bin.000016
-rw-rw---- 1 mysql adm 67303177 2005-04-08 06:25
mysql-bin.000017
-rw-rw---- 1 mysql adm 104857804 2005-04-08 14:34
mysql-bin.000018
-rw-rw---- 1 mysql adm 70757758 2005-04-09 06:25
mysql-bin.000019
-rw-rw---- 1 mysql adm 36807458 2005-04-10 06:25
mysql-bin.000020
-rw-rw---- 1 mysql adm 36951819 2005-04-11 06:25
mysql-bin.000021
-rw-rw---- 1 mysql adm 34943102 2005-04-11 11:37
mysql-bin.000022
-rw-rw---- 1 mysql adm 104857782 2005-04-11 16:59
mysql-bin.000023
-rw-rw---- 1 mysql adm 104857796 2005-04-11 17:10
mysql-bin.000024
-rw-rw---- 1 mysql adm 104857997 2005-04-11 17:13
mysql-bin.000025
-rw-rw---- 1 mysql adm 104857852 2005-04-11 17:15
mysql-bin.000026
-rw-rw---- 1 mysql adm 20943158 2005-04-11 17:16
mysql-bin.000027
-rw-rw---- 1 mysql adm 80173179 2005-04-12 06:25
mysql-bin.000028
-rw-rw---- 1 mysql adm 104857993 2005-04-12 11:26
mysql-bin.000029
-rw-rw---- 1 mysql adm 104857647 2005-04-12 11:29
mysql-bin.000030
-rw-rw---- 1 mysql adm 104858275 2005-04-12 11:31
mysql-bin.000031
-rw-rw---- 1 mysql adm 104858023 2005-04-12 14:16
mysql-bin.000032
-rw-rw---- 1 mysql adm 104858246 2005-04-12 14:19
mysql-bin.000033
-rw-rw---- 1 mysql adm 104857785 2005-04-12 14:21
mysql-bin.000034
-rw-rw---- 1 mysql adm 104857907 2005-04-12 14:24
mysql-bin.000035
-rw-rw---- 1 mysql adm 104857748 2005-04-12 17:59
mysql-bin.000036
-rw-rw---- 1 mysql adm 104857651 2005-04-13 05:33
mysql-bin.000037
-rw-rw---- 1 mysql adm 6065620 2005-04-13 06:25
mysql-bin.000038
-rw-rw---- 1 mysql adm 104858233 2005-04-13 11:53
mysql-bin.000039
-rw-rw---- 1 mysql adm 104858308 2005-04-13 16:03
mysql-bin.000040
-rw-rw---- 1 mysql adm 29182780 2005-04-13 17:19
mysql-bin.000041
-rw-rw---- 1 mysql adm 104857793 2005-04-14 01:57
mysql-bin.000042
-rw-rw---- 1 mysql adm 52090496 2005-04-14 06:25
mysql-bin.000043
-rw-rw---- 1 mysql adm 63595762 2005-04-14 09:40
mysql-bin.000044
-rw-rw---- 1 mysql adm 79 2005-04-14 09:41
mysql-bin.000045
-rw-rw---- 1 mysql adm 209261 2005-04-14 09:41
mysql-bin.000046
-rw-rw---- 1 mysql adm 206 2005-04-14 09:41
mysql-bin.000047
-rw-rw---- 1 mysql adm 472 2005-04-14 09:41
mysql-bin.000048
-rw-rw---- 1 mysql adm 629 2005-04-14 09:41
mysql-bin.000049
-rw-rw---- 1 mysql adm 17114404 2005-04-14 10:14
mysql-bin.000050
-rw-rw---- 1 mysql adm 104857677 2005-04-14 14:01
mysql-bin.000051
-rw-rw---- 1 mysql adm 104858254 2005-04-14 14:16
mysql-bin.000052
-rw-rw---- 1 mysql adm 104857731 2005-04-14 16:22
mysql-bin.000053
-rw-rw---- 1 mysql adm 104857715 2005-04-14 18:39
mysql-bin.000054
-rw-rw---- 1 mysql adm 104857711 2005-04-15 01:06
mysql-bin.000055
-rw-rw---- 1 mysql adm 84434721 2005-04-15 06:25
mysql-bin.000056
-rw-rw---- 1 mysql adm 104857736 2005-04-15 09:57
mysql-bin.000057
-rw-rw---- 1 mysql adm 104858341 2005-04-15 10:55
mysql-bin.000058
-rw-rw---- 1 mysql adm 104857645 2005-04-15 11:17
mysql-bin.000059
-rw-rw---- 1 mysql adm 104858363 2005-04-15 12:50
mysql-bin.000060
-rw-rw---- 1 mysql adm 104857651 2005-04-15 14:32
mysql-bin.000061
-rw-rw---- 1 mysql adm 104858141 2005-04-15 18:38
mysql-bin.000062
-rw-rw---- 1 mysql adm 104857756 2005-04-16 00:08
mysql-bin.000063
-rw-rw---- 1 mysql adm 104857711 2005-04-16 05:46
mysql-bin.000064
-rw-rw---- 1 mysql adm 12285749 2005-04-16 06:25
mysql-bin.000065
-rw-rw---- 1 mysql adm 104857659 2005-04-16 12:00
mysql-bin.000066
-rw-rw---- 1 mysql adm 104857746 2005-04-16 17:36
mysql-bin.000067
-rw-rw---- 1 mysql adm 104857727 2005-04-16 23:13
mysql-bin.000068
-rw-rw---- 1 mysql adm 104857710 2005-04-17 04:41
mysql-bin.000069
-rw-rw---- 1 mysql adm 31982832 2005-04-17 06:25
mysql-bin.000070
-rw-rw---- 1 mysql adm 104857705 2005-04-17 12:05
mysql-bin.000071
-rw-rw---- 1 mysql adm 104857694 2005-04-17 17:41
mysql-bin.000072
-rw-rw---- 1 mysql adm 104857727 2005-04-17 23:17
mysql-bin.000073
-rw-rw---- 1 mysql adm 104857668 2005-04-18 04:49
mysql-bin.000074
-rw-rw---- 1 mysql adm 30223597 2005-04-18 06:25
mysql-bin.000075
-rw-rw---- 1 mysql adm 91173615 2005-04-18 11:01
mysql-bin.000076
-rw-rw---- 1 mysql adm 2432 2005-04-18 06:25
mysql-bin.index

Quelqu'un peut me dire ce que c'est que ces fichiers
et si je peux les supprimer.
le temps que j'écrive le mail un nouveau fichier
mysql-bin.000077 est apparu
-rw-rw---- 1 mysql adm 1273457 2005-04-18 11:24
mysql-bin.000077
-rw-rw---- 1 mysql adm 2464 2005-04-18 11:22
mysql-bin.index

Merci pour vos réponses
AC








__________________________________________________________________
Découvrez le nouveau Yahoo! Mail : 250 Mo d'espace de stockage pour vos
mails !
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com/


--
Pensez à lire la FAQ de la liste avant de poser une question :
http://wiki.debian.net/?DebianFrench

Pensez à rajouter le mot ``spam'' dans vos champs "From" et "Reply-To:"

To UNSUBSCRIBE, email to debian-user-french-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact
listmaster@lists.debian.org




--
Pensez à lire la FAQ de la liste avant de poser une question :
http://wiki.debian.net/?DebianFrench

Pensez à rajouter le mot ``spam'' dans vos champs "From" et "Reply-To:"

To UNSUBSCRIBE, email to debian-user-french-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org