kb:linux:generalites:benchmark_cluster_mariadb_galera
no way to compare when less than two revisions
Différences
Ci-dessous, les différences entre deux révisions de la page.
— | kb:linux:generalites:benchmark_cluster_mariadb_galera [2020/04/28 21:34] (Version actuelle) – créée beu | ||
---|---|---|---|
Ligne 1: | Ligne 1: | ||
+ | ====== Benchmark MariaDB ====== | ||
+ | L' | ||
+ | |||
+ | Ceci a été réalisé sur plusieurs VM avec les specs suivantes : | ||
+ | |||
+ | ^ CPU | 1 cœur | | ||
+ | ^ RAM | 2GB | | ||
+ | ^ Disque | ||
+ | ^ OS | Debian Buster | ||
+ | ^ Version | 10.3.22-0+deb10u1 | | ||
+ | |||
+ | Pour servir de référence, | ||
+ | |||
+ | === READ ONLY : === | ||
+ | <code bash> | ||
+ | # sysbench / | ||
+ | |||
+ | SQL statistics: | ||
+ | queries performed: | ||
+ | read: 786340 | ||
+ | write: | ||
+ | other: | ||
+ | total: | ||
+ | transactions: | ||
+ | queries: | ||
+ | ignored errors: | ||
+ | reconnects: | ||
+ | |||
+ | General statistics: | ||
+ | total time: 60.0619s | ||
+ | total number of events: | ||
+ | |||
+ | Latency (ms): | ||
+ | | ||
+ | | ||
+ | | ||
+ | 95th percentile: | ||
+ | | ||
+ | |||
+ | Threads fairness: | ||
+ | events (avg/ | ||
+ | execution time (avg/ | ||
+ | </ | ||
+ | |||
+ | |||
+ | === WRITE ONLY : === | ||
+ | <code bash> | ||
+ | # sysbench / | ||
+ | |||
+ | SQL statistics: | ||
+ | queries performed: | ||
+ | read: 0 | ||
+ | write: | ||
+ | other: | ||
+ | total: | ||
+ | transactions: | ||
+ | queries: | ||
+ | ignored errors: | ||
+ | reconnects: | ||
+ | |||
+ | General statistics: | ||
+ | total time: 60.1321s | ||
+ | total number of events: | ||
+ | |||
+ | Latency (ms): | ||
+ | | ||
+ | | ||
+ | | ||
+ | 95th percentile: | ||
+ | | ||
+ | |||
+ | Threads fairness: | ||
+ | events (avg/ | ||
+ | execution time (avg/ | ||
+ | | ||
+ | </ | ||
+ | |||
+ | |||
+ | === READ/WRITE ONLY : === | ||
+ | <code bash> | ||
+ | # sysbench / | ||
+ | |||
+ | SQL statistics: | ||
+ | queries performed: | ||
+ | read: 338790 | ||
+ | write: | ||
+ | other: | ||
+ | total: | ||
+ | transactions: | ||
+ | queries: | ||
+ | ignored errors: | ||
+ | reconnects: | ||
+ | |||
+ | General statistics: | ||
+ | total time: 60.4814s | ||
+ | total number of events: | ||
+ | |||
+ | Latency (ms): | ||
+ | | ||
+ | | ||
+ | | ||
+ | 95th percentile: | ||
+ | | ||
+ | |||
+ | Threads fairness: | ||
+ | events (avg/ | ||
+ | execution time (avg/ | ||
+ | |||
+ | </ | ||
+ | |||
+ | Et pour le cluster : | ||
+ | |||
+ | === READ ONLY === | ||
+ | |||
+ | <code bash> | ||
+ | # sysbench / | ||
+ | |||
+ | READ CLUSTER : | ||
+ | SQL statistics: | ||
+ | queries performed: | ||
+ | read: 1696160 | ||
+ | write: | ||
+ | other: | ||
+ | total: | ||
+ | transactions: | ||
+ | queries: | ||
+ | ignored errors: | ||
+ | reconnects: | ||
+ | |||
+ | General statistics: | ||
+ | total time: 60.1061s | ||
+ | total number of events: | ||
+ | |||
+ | Latency (ms): | ||
+ | | ||
+ | | ||
+ | | ||
+ | 95th percentile: | ||
+ | | ||
+ | |||
+ | Threads fairness: | ||
+ | events (avg/ | ||
+ | execution time (avg/ | ||
+ | </ | ||
+ | |||
+ | === WRITE ONLY : === | ||
+ | |||
+ | <code bash> | ||
+ | # sysbench / | ||
+ | |||
+ | SQL statistics: | ||
+ | queries performed: | ||
+ | read: 0 | ||
+ | write: | ||
+ | other: | ||
+ | total: | ||
+ | transactions: | ||
+ | queries: | ||
+ | ignored errors: | ||
+ | reconnects: | ||
+ | |||
+ | General statistics: | ||
+ | total time: 73.7405s | ||
+ | total number of events: | ||
+ | |||
+ | Latency (ms): | ||
+ | | ||
+ | | ||
+ | | ||
+ | 95th percentile: | ||
+ | | ||
+ | |||
+ | Threads fairness: | ||
+ | events (avg/ | ||
+ | execution time (avg/ | ||
+ | |||
+ | </ | ||
+ | |||
+ | === READ/WRITE ONLY : === | ||
+ | |||
+ | <code bash> | ||
+ | # sysbench / | ||
+ | |||
+ | SQL statistics: | ||
+ | queries performed: | ||
+ | read: 55220 | ||
+ | write: | ||
+ | other: | ||
+ | total: | ||
+ | transactions: | ||
+ | queries: | ||
+ | ignored errors: | ||
+ | reconnects: | ||
+ | |||
+ | General statistics: | ||
+ | total time: 75.3617s | ||
+ | total number of events: | ||
+ | |||
+ | Latency (ms): | ||
+ | | ||
+ | | ||
+ | | ||
+ | 95th percentile: | ||
+ | | ||
+ | |||
+ | Threads fairness: | ||
+ | events (avg/ | ||
+ | execution time (avg/ | ||
+ | </ | ||
+ | |||
+ | ==== Conclusion : ==== | ||
+ | |||
+ | D'un point de vue requêtes de lecture, il y a un gain significatif de performance, |
kb/linux/generalites/benchmark_cluster_mariadb_galera.txt · Dernière modification : 2020/04/28 21:34 de beu