Rootconf 2017

On service reliability

ligaya turmelle

@lig

MySQL Server Tuning for the SysAdmin

Submitted Mar 11, 2017

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

{{ gettext('Login to leave a comment') }}

{{ gettext('Post a comment…') }}
{{ gettext('New comment') }}
{{ formTitle }}

{{ errorMsg }}

{{ gettext('No comments posted yet') }}

Hosted by

We care about site reliability, cloud costs, security and data privacy