MySQL Performance profiling-profiles

Tag: Init row off SSI time down table function value

First, show profiles
See if the Profiles feature is turned on

mysql> show variables like ‘profiling‘;+---------------+-------+| Variable_name | Value |+---------------+-------+| profiling     | OFF   |+---------------+-------+1 row in set (0.03 sec)

Open profiles in the current session

mysql> show variables like ‘profiling‘;+---------------+-------+| Variable_name | Value |+---------------+-------+| profiling     | OFF   |+---------------+-------+1 row in set (0.03 sec)

Query what SQL the current session has

show profiles

The detailed time spent querying the specified SQL

mysql> show profile for query 3;+----------------------+----------+| Status               | Duration |+----------------------+----------+| starting             | 0.000087 || checking permissions | 0.000017 || Opening tables       | 0.000023 || init                 | 0.000045 || System lock          | 0.000018 || optimizing           | 0.000021 || statistics           | 0.000075 || preparing            | 0.000028 || Sorting result       | 0.000016 || executing            | 0.000015 || Sending data         | 0.000023 || Creating sort index  | 0.026676 || end                  | 0.000026 || query end            | 0.000018 || closing tables       | 0.000020 || freeing items        | 0.000024 || logging slow query   | 0.000038 || cleaning up          | 0.000021 |+----------------------+----------+18 rows in set, 1 warning (0.04 sec)

MySQL Performance profiling-profiles