{"id":2001,"date":"2026-01-09T09:23:17","date_gmt":"2026-01-09T08:23:17","guid":{"rendered":"https:\/\/www.delixirpro.com\/blog\/?p=2001"},"modified":"2026-01-09T09:23:17","modified_gmt":"2026-01-09T08:23:17","slug":"limiter-la-taille-du-log-mysql-mariadb","status":"publish","type":"post","link":"https:\/\/www.delixirpro.com\/blog\/2026\/01\/09\/limiter-la-taille-du-log-mysql-mariadb\/","title":{"rendered":"Limiter la taille du log MySQL (MariaDB)"},"content":{"rendered":"\n

Dans MySQL (MariaDB), on ne peut pas limiter la taille du jounal g\u00e9n\u00e9ral (mysql.log) mais seulement celle du bin-log.<\/p>\n\n\n\n

D’une mani\u00e8re g\u00e9n\u00e9rale, cette commande \u00e0 planifier permet de lire les X lignes d’un fichier et de les r\u00e9\u00e9crire au m\u00eame endroit, afin de ne conserver que les X lignes que l’on veut.<\/p>\n\n\n\n

Depuis une invite :<\/p>\n\n\n\n

$ tail -20000 \/path\/to\/mysql\/general.log | sponge \/path\/to\/mysql\/general.log<\/code><\/pre>\n\n\n\n
– Remplacer \u00ab\u00a020000\u00a0\u00bb par la valeur souhait\u00e9e (ici on conserve les 20000 derni\u00e8res lignes)<\/p>\n\n\n\n
Si l’application \u00ab\u00a0sponge<\/em>\u00a0\u00bb n’est pas disponible, il faudra l’installer pr\u00e9alablement via la commande :<\/p>\n\n\n\n
$ apt install moreutils<\/code><\/pre>\n\n\n\n
Il sufirra ensuite de planifier le lancement de cette t\u00e2che dans crontab pour qu’elle tourne r\u00e9guli\u00e8rement (ici 1 fois par jour \u00e0 2h du matin) :<\/p>\n\n\n\n
0 2 * * * tail -20000 \/srv\/log\/mysql\/mysql.log | sponge \/srv\/log\/mysql\/mysql.log<\/code><\/pre>\n\n\n\n
On peut utiliser cette m\u00e9thode pour d’autres fichiers dont il n’est pas possible de limiter la taille ou faire tourner les logs.<\/p>\n\n\n\n
Source : https:\/\/stackoverflow.com\/questions\/54763279\/how-to-limit-mysql-general-log-file-size<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Dans MySQL (MariaDB), on ne peut pas limiter la taille du jounal g\u00e9n\u00e9ral (mysql.log) mais seulement celle du bin-log. D’une mani\u00e8re g\u00e9n\u00e9rale, cette commande \u00e0 planifier permet de lire les X lignes d’un fichier...<\/p>\n","protected":false},"author":1,"featured_media":2002,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[238,237,239],"class_list":["post-2001","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech-tips","tag-log","tag-sponge","tag-tail"],"_links":{"self":[{"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/posts\/2001","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/comments?post=2001"}],"version-history":[{"count":1,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/posts\/2001\/revisions"}],"predecessor-version":[{"id":2003,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/posts\/2001\/revisions\/2003"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/media\/2002"}],"wp:attachment":[{"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/media?parent=2001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/categories?post=2001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/tags?post=2001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}