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
[email protected]
Cloudera Certified Hadoop Developer
Certified MySQL DBA
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
Tom Hanlon
[email protected]
Cloudera Certified Hadoop Developer
Certified MySQL DBA
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
