Re: 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/
Reply to: