← Back to team overview

drizzle-discuss team mailing list archive

Profiles, show profiles in drizzle, thoughts ?

 

Drizzle community,

So I set up my drizzle, and in order to get a feel for things I ran some commands.

I thought that profiles might be a useful way to get a look at how far the internals had changed so I

set @@profiling=1 and drizzle complained.

For those of you that are not familiar with the profiles patch, here is some info

Started as a patch and a concept by Jeremy Cole,

Here are the docs..
http://dev.mysql.com/doc/refman/5.1/en/show-profiles.html

Curious about what the drizzle community thinks about having show profiles, or some implementation that provides the same in drizzle.

My vote is for a simple interface not unlike the mysql implementation.




Below is some example output

mysql> show profile all for query 1\G
*************************** 1. row ***************************
             Status: starting
           Duration: 0.040246
           CPU_user: 0.000091
         CPU_system: 0.000107
  Context_voluntary: 0
Context_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: NULL
        Source_file: NULL
        Source_line: NULL
*************************** 2. row ***************************
             Status: checking permissions
           Duration: 0.000009
           CPU_user: 0.000007
         CPU_system: 0.000003
  Context_voluntary: 0
Context_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: unknown function
        Source_file: sql_parse.cc
        Source_line: 5198
*************************** 3. row ***************************
             Status: Opening tables
           Duration: 0.000014
           CPU_user: 0.000012
         CPU_system: 0.000001
  Context_voluntary: 0
Context_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: unknown function
        Source_file: sql_base.cc
        Source_line: 4478
*************************** 4. row ***************************


So as you see it shows some fairly useful information.


Tom Hanlon
tom@xxxxxxxxxxxxxxxxxxx
Cloudera Certified Hadoop Developer
Certified MySQL DBA




Follow ups