MySQL troubleshooting tldr

May 2017

8 Mon

9 Tue

10 Wed

11 Thu 08:40 AM – 11:10 PM IST

12 Fri 08:40 AM – 06:00 PM IST

13 Sat

14 Sun

MLR Convention Centre, J P Nagar, Bangalore

All submissions

Previous Next

This submission has been added to the schedule

MySQL troubleshooting tldr

Submitted Mar 11, 2017

Section: Crisp talk of 15 mins duration Technical level: Intermediate

Sometimes the biggest problem is not knowing the correct question(s) to ask for the problem. This talk will teach you what “questions” to ask a MySQL server so you will be able to gather the necessary data to be able diagnose various generic problems in MySQL.

Outline

With a given generic server problem - what data should you initially be collecting to diagnose the root cause of the problem.

Example:
General Server Performance Issues

Error log
OS Data (Ex: IO, CPU, Memory, NUMA, etc)
SHOW GLOBAL VARIABLES
SHOW GLOBAL STATUS
SHOW FULL PROCESSLIST
SHOW ENGINE INNODB STATUS
Information from INFORMATION_SCHEMA

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.