Rootconf 2017

On service reliability

MySQL Server Tuning for the SysAdmin

Submitted by ligaya turmelle (@lig) on Friday, 10 March 2017

videocam_off

Technical level

Intermediate

Section

Full talk of 40 mins duration

Status

Submitted

Vote on this proposal

Login to vote

Total votes:  +1

Abstract

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)

Outline

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

Speaker bio

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.

Comments

Login with Twitter or Google to leave a comment