Re: Total ?

(pour les contenus en base de données mariadb ou redis, hors fichiers d'images, caches, logs, etc)

avant le nettoyage :

ls -l --si
-rw------- 1 root root 2,0G janv. 29 05:27 mariadb.dump.gz
-rw------- 1 root root 20M janv. 29 05:27 redis.rdb.gz

après le nettoyage :

-rw------- 1 root root 1,9G janv. 30 03:25 mariadb.dump.gz
-rw------- 1 root root 20M janv. 30 03:25 redis.rdb.gz

(8,9 GiB pour mariadb.dump hors compression gzip)

data_length + index_length : 12.85 GiB selon MariaDB

+----------------------+------------+---------+
| Table | Size (MiB) | Rows |
+----------------------+------------+---------+
| news_versions | 8969.06 | 383245 |
| comments | 3219.47 | 1888308 |
| diaries | 271.13 | 39730 |
| paragraphs | 190.19 | 220226 |
| news | 169.41 | 27263 |
| posts | 165.66 | 39876 |
| friendly_id_slugs | 29.11 | 181798 |
| nodes | 27.13 | 115099 |
| wiki_versions | 26.66 | 2201 |
| taggings | 26.50 | 154177 |
| accounts | 18.13 | 33400 |
| oauth_access_tokens | 14.52 | 7473 |
| links | 12.03 | 85217 |
| trackers | 5.83 | 1987 |
| users | 5.03 | 53852 |
| wiki_pages | 2.53 | 154 |
| tags | 2.30 | 14096 |
| bookmarks | 2.03 | 5625 |
| logs | 1.78 | 12028 |
| oauth_access_grants | 0.56 | 1576 |
| poll_answers | 0.47 | 4080 |
| polls | 0.31 | 469 |
| pages | 0.17 | 13 |
| oauth_applications | 0.05 | 20 |
| sections | 0.05 | 99 |
| forums | 0.03 | 39 |
| friend_sites | 0.03 | 13 |
| banners | 0.02 | 14 |
| responses | 0.02 | 12 |
| schema_migrations | 0.02 | 74 |
| categories | 0.02 | 31 |
+----------------------+------------+---------+