MySQL Performance

mechanics.fligt.com

TOPIC

SHOW STATUS
Slow query log
pt-stalk
Vivid Cortex

ps_helper
sys schema

Performaqnce schema

[mysqld]
performance_schema=on

shwo varibles like performace\_schema%l

show tables like setup\_%';
setup_actors

TOPIC

Don't enable an intrument unless you can use the output

Basic Terminiolg

Events is something the server does that can be timed
Objects, what objects are monitoired
OBJEJT_Typoes tables
Instruments
Events are reporte by instrumnets
Consumers
events are processed by consumers
Timers

TOPIC

Instruments
Events are reporte by instrumnets
Consumers
events are processed by consumers
Timers

www.markleith.co.uk
OurSQL podcasts 139-141

TOPIC

TOPIC

TOPIC