MySQL Server Tuning for the SysAdmin
Submitted by ligaya turmelle (@lig) on Friday, 10 March 2017
Full talk of 40 mins duration
Tuning queries is still the best way to get performance out of the MySQL Server but you can still tune the MySQL server from a SysAdmin’s point of view. (Placeholder)
Not sure yet but some things that come to mind that can be covered - swappiness, filesystem, numactl, scheduler, nice, SSD settings, distributing IO, mysqld limits, and MySQL server settings related to the underlying server
Ligaya Turmelle is a full time Goddess, part time MySQL DBA, occasional PHP programmer, and frequent world traveler. She currently has visited or lived in 21 countries and now resides in Florida with her husband and their Belgian Malinois. As a MySQL Support Engineer for Oracle she still manages to stay involved with the PHP Community as a founding Principal of phpwomen.org, blogger and long-time busy body of the PHPCommunity channel (#phpc) on freenode. She hopes to one day actually meet all the people she talks to. Now for all the letters – OCP: MySQL 5.6 DBA, OCP: MySQL 5.6 Dev, CMDBA (5.0), CMDEV (5.0), MySQL Core (4.1), ZCE (PHP4&5) and Oracle ACE for MySQL.