← Back to team overview

drizzle-discuss team mailing list archive

Re: Profiles, show profiles in drizzle, thoughts ?

 

Oh cool, I wasn't sure if you knew.  I agree whole heartedly that we should have a profiler plugin.  I, unfortunately, lack the chops to make one but would be happy to test the feature should someone write it.


On Apr 16, 2010, at 5:15 PM, Tom Hanlon wrote:

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




References