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.
(replying to a all ideas)
- COM_STATISTICS is just a single data packet. Unless a COM_* command returns a resultset it's going to be a pain in the ass to parse with any normal client. This is similar in reason to why I stuck to the current binary protocol stats design in memcached... no parsing to do on the client to split up the data into key/value pairs.
- I tend to run SHOW GLOBAL STATUS on all of my DB's about once per second. More than that probably sucks. We definitely need a SHOW GLOBAL FAST STATUS along with a SHOW GLOBAL STATUS.
- yadda yadda. -Dormando _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
