← Back to team overview

drizzle-discuss team mailing list archive

Re: Profiles, show profiles in drizzle, thoughts ?

 

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 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




Follow ups

References