On Fri, Aug 8, 2008 at 9:41 AM, Kay Röpke <[EMAIL PROTECTED]> wrote: > > On Aug 8, 2008, at 4:31 PM, Mark Leith wrote: > >> Could be interesting to keep it, and return a much saner result.. >> >> Sharing quick and easy stats on the load of an instance across a cloud is >> certainly something that needs more thought however.. > > > Agreed, but I'd throw it out and add something else back in. Something that > returns a sane format (like a table!? :)). And frankly parsing "show global > statistics" or whatever isn't exactly slow, it depends whether the backing > data store is fast or not. I don't think there's a need to have that on the > protocol level at all.
SHOW GLOBAL STATISTICS can be nasty on a busy server because it locks each thread to read and update counters. We added rate limiting to prevent this from running too frequently. It would be nice if this were done without locking threads one at a time. > > cheers, > -k > -- > Kay Roepke > Software Engineer, MySQL Enterprise Tools > > Sun Microsystems GmbH Sonnenallee 1, DE-85551 Kirchheim-Heimstetten > Geschaeftsfuehrer: Thomas Schroeder, Wolfang Engels, Dr. Roland Boemer > Vorsitz d. Aufs.rat.: Martin Haering HRB MUC 161028 > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- Mark Callaghan [EMAIL PROTECTED] _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
