⚙️ Tuning & Performance – MariaDB

Les 10 briques pratiques pour optimiser MariaDB (prod IDEO-Lab).

SLO p95, volumétrie, QPS, budget mémoire/CPU, priorités d’optimisation.

Slow log, performance_schema, Grafana/Prometheus, pt-query-digest (24–48 h).

max_connections, wait_timeout, thread_cache, Django CONN_MAX_AGE, sizing workers.

Buffer Pool (taille/instances), log_file_size, log_buffer, flush, io_capacity.

Index composés/couvrants, FKs, cardinalité, partitions (logs & historiques).

EXPLAIN, éviter ALL/filesort/temp, pagination keyset, batch INSERT/UPDATE.

tmp_table_size, max_heap_table_size, join/sort buffers, tmpdir NVMe.

Redis, cache Django (vue/fragment), matérialisation nocturne, N+1.

O_DIRECT, filesystem, scheduler, open_files_limit, table_open_cache.

Réplication & read replicas, ProxySQL, sauvegardes, RBAC, TLS, purges.