« 10g tracing quick start | Main | Using EXPLAIN EXTENDED to see view query rewrites »

January 03, 2007


Feed You can follow this conversation by subscribing to the comment feed for this post.


Nice trick, but why aren't those values available from information_schema tables?


The instantaneous values are indeed obtained from INFORMATION_SCHEMA.GLOBAL_STATUS. The "trick" is to create an historical record of selected values so we can do some trending or historical diagnostics.

In the past we could have done this by running some external program (in perl say) that issued SHOW GLOBAL STATUS commands and saved the values and deltas back into tables in the DB. But with the INFORMATION_SCHEMA table we can get the values within a stored procedure, and with the new events mechanism, we can run that stored procedure _inside_ the database.

The comments to this entry are closed.