|
|
||||||||||||||||||||||||||||||||
|
|
How to convert MySQL's SHOW PROFILES into a real profileSHOW PROFILES shows how much time MySQL spends in various phases of query execution, but it isn't a full-featured profile. By that, I mean that it doesn't show similar phases aggregated together, doesn't sort them by worst-first, and doesn't show the relative amount of time consumed. I'll profile the "nicer_but_slower_film_list" included with the Sakila sample [...]
using
|
gravatar
|
data
|
media
|
daily
|
free
|
incremental
|
day
|
expo
|
friends
|
announcing
|
available
|
backups
|
blocks
|
xtrabackup
|
issue
|
magento
|
uk
|
matt
|
plugin
|
html
|
don
|
miss
|
editor
|
hide
|
ie
|
xtra
|
meet
|
high
|
replication
|
server
|
cluster
|
db
|
conference
|
sql
|
performance
|
blog
|
backup
|
percona
|
enterprise
|