show profile

Olá pessoal, alguém consegue decifrar com absolutamente certeza o que significa cada informação retornada pelo PROFILE do MySQL?

SHOW PROFILE ALL FOR QUERY 1 \G************************* 1. row *********************** Status: (initialization) Duration: 0.000002 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: send_result_to_client Source_file: sql_cache.cc Source_line: 1099*********************** 2. row *********************** Status: checking query cache for query Duration: 0.000044 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: open_tables Source_file: sql_base.cc Source_line: 2629*********************** 3. row *********************** Status: Opening tables Duration: 0.000008 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: mysql_lock_tables Source_file: lock.cc Source_line: 153*********************** 4. row *********************** Status: System lock Duration: 0.000004 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: mysql_lock_tables Source_file: lock.cc Source_line: 162*********************** 5. row *********************** Status: Table lock Duration: 0.000023 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: mysql_select Source_file: sql_select.cc Source_line: 2242*********************** 6. row *********************** Status: init Duration: 0.00003 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: optimize Source_file: sql_select.cc Source_line: 745*********************** 7. row *********************** Status: optimizing Duration: 0.000013 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: optimize Source_file: sql_select.cc Source_line: 904*********************** 8. row *********************** Status: statistics Duration: 0.000016 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: optimize Source_file: sql_select.cc Source_line: 914*********************** 9. row *********************** Status: preparing Duration: 0.000014 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: exec Source_file: sql_select.cc Source_line: 1565*********************** 10. row *********************** Status: executing Duration: 0.000004 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: exec Source_file: sql_select.cc Source_line: 2083*********************** 11. row *********************** Status: Sending data Duration: 1.613078 CPU_user: 0.732046 CPU_system: 0.260016 Context_voluntary: 2Context_involuntary: 7810 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: mysql_select Source_file: sql_select.cc Source_line: 2287*********************** 12. row *********************** Status: end Duration: 0.000012 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: mysql_execute_command Source_file: sql_parse.cc Source_line: 5122*********************** 13. row *********************** Status: query end Duration: 0.000005 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: mysql_parse Source_file: sql_parse.cc Source_line: 6116*********************** 14. row *********************** Status: freeing items Duration: 0.000013 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: dispatch_command Source_file: sql_parse.cc Source_line: 2146*********************** 15. row *********************** Status: closing tables Duration: 0.000008 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: log_slow_statement Source_file: sql_parse.cc Source_line: 2204*********************** 16. row ************************* Status: logging slow query Duration: 0.000002 CPU_user: 0 CPU_system: 0 Context_voluntary: 0Context_involuntary: 0 Block_ops_in: 0 Block_ops_out: 0 Messages_sent: 0 Messages_received: 0 Page_faults_major: 0 Page_faults_minor: 0 Swaps: 0 Source_function: dispatch_command Source_file: sql_parse.cc Source_line: 216916 rows in set (0.00 sec)

Não achei nenhum blog, ou na própria documentação que explique detalhadamente.

Grato.