~/talk

MySQL Performance for DevOps

Talkat FOSDEM 2021 · on Saturday, 2021-02-06· at 14:45· D.mariadb· [databases, devops-and-delivery]

speaker

name:Sveta Smirnova

links:none on file

resources

video:https://youtu.be/vkV0z44Iea4

slides:https://fosdem.org/2021/schedule/event/mariadb_devops/attachments/slides/4306/export/events/attachments/mariadb_devops/slides/4306/DevOps_perf.pdf

https://www2.slideshare.net/SvetaSmirnova/mysql-performance-for-devops

summary

Practical checklist of changeable bottlenecks and concrete values: set swappiness=1 and enable NUMA interleave in BIOS, use SSDs with battery backed write cache, set IO scheduler to noop or deadline and CPU governor to performance. Size innodb_buffer_pool to hold the active dataset, increase innodb_log_file_size so background flushes keep up, tune innodb_io_capacity, prefer O_DIRECT and set innodb_thread_concurrency to roughly CPU cores. Trade durability for speed with innodb_flush_log_at_trx_commit=2 or coarser sync_binlog, and raise table_open_cache when OPEN_TABLES waits appear; monitor with Percona Monitoring and Management.

AI-written summary · about

chapters (5)

related talks