← Back to team overview

drizzle-discuss team mailing list archive

Re: Profiles, show profiles in drizzle, thoughts ?

 

Daniel,
On 16 Apr 2010, at 17:37, Daniel Salinas wrote:

Tom, profiles would be brilliant. Just keep one implementation thing in mind, in Drizzle there are to be *no* "show" commands. As far as I know the team is hell bent on keeping things in the data dictionary rather than maintaining a second set of special purpose "show" commands like there are in mysql.


I am aware that "no show" is the general plan for drizzle :-)
, but the information from profiles could be implemented in some way.

--
Tom

I am not the authority on this so they will be the ones to make/help with this but I thought I would chime in.

Daniel Salinas
Senior Database Architect
Rackspace Cloud

On Apr 16, 2010, at 3:50 PM, Tom Hanlon wrote:

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


_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : drizzle-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp


_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : drizzle-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

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




Follow ups

References