Great work and thanks for sharing. Rumor has it you use the Information Schema to export the output from the monitoring rather than SHOW {TABLE,USER,INDEX}_STATISTICS. That sounds great. We are still in a MySQL 4.0 mindset and don’t know much about the Information Schema.
We just added support to rotate the slow query log. And we are trying to add SHOW CLIENT_STATISTICS that will aggregate resource consumption by client IP. That should be out in a patch soon.
Aaron
17 years ago
Hi Vadim,
What is the advantage of using the RHEL5 RPMs vs the generic RPMs on a CentOS/RedHat system?
Great work and thanks for sharing. Rumor has it you use the Information Schema to export the output from the monitoring rather than SHOW {TABLE,USER,INDEX}_STATISTICS. That sounds great. We are still in a MySQL 4.0 mindset and don’t know much about the Information Schema.
We just added support to rotate the slow query log. And we are trying to add SHOW CLIENT_STATISTICS that will aggregate resource consumption by client IP. That should be out in a patch soon.
Hi Vadim,
What is the advantage of using the RHEL5 RPMs vs the generic RPMs on a CentOS/RedHat system?
Thanks
Aaron,
Distribution specific RPMS is better updated for given distributive, as it takes into account standard paths, libraries, config files etc.
But in general generic RPMs also should work.
Mark,
We are not using INFORMATION_SCHEMA yet, but working on this patch right now.