show profile

[Eclesiastes 2]

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.

[Wagner Bianchi 0]

A MySQL AB somente fornece isso na sua documentação, quando fala do PROFILE:

 

http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html

 

...enviei um e-mail para eles, caso eu receba mais alguma coisa eu posto aqui para termos informações mais precisas sobre esta ferramenta.

 

http://forum.imasters.com.br/public/style_emoticons/default/thumbsup.gif