On Thu, Mar 5, 2009 at 8:15 AM, MARK CALLAGHAN <[email protected]> wrote: <snip/> > > Well, I fixed this and then I removed all code for SHOW CLIENT_STATISTICS > from the next patch.
We don't use SHOW CLIENT_STATISTICS at our place. > We were not using it enough to justify the cost of > having that code there. SHOW INDEX_STATISTICS has been removed as well. We don't use SHOW INDEX_STATISTICS either. > SHOW TABLE_STATS and SHOW USER_STATS remain with changes to fix the mutex > contention that they used to create. We *do* use SHOW USER_STATISTICS (but haven't used SHOW TABLE_STATISTICS yet ...) We modified our patch so that SHOW USER_STATISTICS displays Cpu-time as a DOUBLE (since it is already a double internally). It also shows Rows_examined (in THD as examined_row_count and diff_total_examined_rows) for each user ... I'm not exactly certain about the origins of our current userstat patch. (My boss gave it to me back in November--when he hired me). I *think* it is an original Google patch, although some of our boxen are running a Percona-derived patch ...) Weldon Whipple [email protected] _______________________________________________ Mailing list: https://launchpad.net/~ourdelta-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~ourdelta-developers More help : https://help.launchpad.net/ListHelp

