aiphee

HW + OS tuning

Disks

• Fsync performance: https://www.percona.com/blog/2018/02/08/fsync-performance-storage-devices/

STORAGE

• ZFS performance tuning: http://open-zfs.org/wiki/Performance_tuning#MySQL
• HW RAID configuration: https://www.percona.com/blog/2011/06/09/aligning-io-on-a-hard-disk-raid-the-theory/

Memory, connections, threads

aiphee

Query Planner

Engine Independent Table statistics: https://mariadb.com/kb/en/library/engine-independent-table-statistics/

Database design

Table schema

MySQL schema worst practices: https://docs.google.com/presentation/d/1q7e8wE5wz4aOglXhFjm1tndytWhwB3k9KqM3HQhwuMc/edit?usp=sharing

Indexes

Optimizer hints: https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html