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