--- pingouin osmolateur <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]