Hi!
On Aug 8, 2008, at 6:51 PM, MARK CALLAGHAN wrote:
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.
Yeah, I didn't mean SHOW GLOBAL STATISTICS literally, probably
should've picked different words.
There must be a way of getting basic statistics without incurring any
locks, ideally it should be able to run it as frequent as you wish
without interfering with normal operations.
Other information might be expensive to get at, but that information
should not be part of this call in question (or data access must be
faster/less expensive).
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
