… the way, I think your 3 fundamental metrics are 3 fundamental *types* of metrics, not the metrics themselves. I wrote something a little…
Comment: Data mart or data warehouse?
July 16, 2010 By 14 Comments
… would be updated as soon as return occurs. A useful metric to record would be the rental duration, which would be… central fact table (which is typically normalized) to store the metrics of interest and link them to the dimension tables to… table for each level for the hierarchies along which the metrics are to be rolled up.
Comment: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 10, 2012 By 22 Comments
… buffer cache. Response time on writes isn’t the only metric. Amount of memory used (and wasted) by the redo log in the OS filesystem cache is another metric. Unfortunately there is no way to optimize for all three…
Comment: Adaptive flushing in MySQL 5.6
September 5, 2012 By 8 Comments
… was in your case, the true answer may give only METRICS counters during your test. @Peter: it can be true when… again, to get an idea about what is going on, METRICS stats should be collected. Rgds, -Dimitri
Comment: Full Text Search Webinar Questions Followup
August 27, 2012 By 5 Comments
…’t get that benchmark easily. There are well-defined relevancy metrics that let you compare different ranking formulas (and therefore different systems). All those metrics are however based on hand-made relevancy judgements. Lots of…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 9 Comments
… way in the Linux asynchronous IO library to get time metrics for particular IO block. so my testing command line looks…=16384 –report-interval=10 run You may see I gather metrics every 10 sec to see how stable the performance is…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 12 Comments
… way in the Linux asynchronous IO library to get time metrics for particular IO block. so my testing command line looks…=16384 –report-interval=10 run You may see I gather metrics every 10 sec to see how stable the performance is…
Post: Why don't our new Nagios plugins use caching?
February 19, 2012 By 1 Comment
… cache the data retrieved from MySQL, I cached the resulting metrics. This avoids having to do InnoDB parsing repeatedly, too. With… several minutes ago. In conclusion, you should cache for historical metrics monitoring, but not for fault detection monitoring. That’s why…
Comment: The four fundamental performance metrics
April 27, 2011 By 15 Comments
Any thoughts on providing a database table and accompanying procedures/triggers to begin logging the four fundamental metrics so that readers may implement this and derive the additional four long-term average metrics?
Comment: The four fundamental performance metrics
April 27, 2011 By 15 Comments
…-south.html I claim there are only 3 fundamental performance metrics: 1. A number or a count (e.g., RSS, queries… is derived. Actually, I can boil it down to 2 metrics but that requires that you understand how to do dimensional…
