Many MySQL users are familiar with using slow query logs and
tools such as mysqldumpslow to identify poor-performing SQL
commands, and MySQL 5.6 introduces new powerful tools in
PERFORMANCE_SCHEMA. Both allow you to identify the
date/time and the user account from which the command was issued,
which is helpful – but if you’re using MySQL Enterprise Monitor
(MEM), you can immediately identify the actual line of code
responsible for the SQL command in question. This happens
to be one of my favorite and powerful features of MEM, but it’s
frequently overlooked by new and experienced MEM users alike, so
I’m writing the post to highlight it.
MySQL Enterprise Monitor, of course, is a commercial product
that’s part of the MySQL Enterprise subscription. But it’s
freely-available under 30-day trial terms for evaluation from
Oracle
Software Delivery Cloud – if …
[Read more]