How we use php-call-site-stats to get cache hit ratios for each call-site
This post was originally written on 2014–04–01 on itbrokeand.ifixit.com by Daniel Beardsley. It’s being migrated to a new home on iFixit Engineering.
We’ve been using php-call-site-stats in production since June 2013 and it’s been a great asset to our team. We hope you find it useful as well.
What We Get
The php-call-site-stats project has enabled us to provide information like mean, min, max, std-dev of the execution time for each and every database query in our code. The gathered data is then inserted in our code, just above the query execution. Note: units are in milliseconds and these stats were collected over a 24-hour period.
// avg:1.328 count:111 sum:147.361 std:3.753 min:0.465 max:35.607 - callsite(2013-11-25):
$db->execute($q_insert, array(T_S, $text, T_S, $tagtype));
We also get hit ratios for all of our cache gets (diff is the number of misses):
// diff:476696 1508814 / 1985510 = 75.99% - callsite(2013-11-25):
if (($reputation = $cache->get($key)) === false) {
Cache replacement times for each set()
(i.e. the time between a get with a cache miss and the following set()
of the same key):
// avg:69.28 count:158 sum:10947.06 std:12.56 min:51.95 max:149.79 - callsite(2013-11-25):
$cache->set($key, $device, CACHE_SHORT);
And lastly, we get query times for each usage of ::find()
through our ORM:
// avg:0.921 count:8457 sum:7792.918 std:2.332 min:0 max:44.624 - callsite(2013-11-25):
$author = User::find($guide->authorid);
Every few months we turn on the recording of these stats for a day, aggregate them and replace the existing stats in our entire codebase. The stats recording incurs minimal overhead (we track it too) with an average additional time of 5ms per request. The process is very automated; downloading the log from each machine and aggregating them is a single command. Replacing existing stats with new aggregated numbers is another single command.
How It Works
- Code in your database layer records a stat
self::recordCallSite("dbquery", (microtime(true) - $start) * 1000);
- php-call-site-stats examines a stack trace, walks back up the stack and records the first .php file after leaving the current class (i.e. the calling class).
- A line like:
/path/to/file.php:241 dbquery 2.325
is written to the log each time a query is made - Logging is turned off and the all the log files are concatenated.
- The summarize tool is used to aggregate by call-site (file/path:linenumber)
- Summarized results are inserted into source files at the appropriate places via some carefully crafted
sed
commands.
How It’s Used
There’s a much more thorough explanation in the README, but it only takes a few lines of code to start logging lots of useful data:
Imagine you have a Cache
class, decorate it like this and you'll get a record of hits and misses for every place in your code that $cache->get(...)
is called.
class Cache {
use CallSiteStats
// Needed to record call-sites outside of this file
protected function isExternalCallSite($file) {
return $file != __FILE__;
}
public function get($key) {
//...
$this->recordCallSite('cache-get', $gets = 1, $cacheHit ? 1 : 0);
}
}// Then, during shutdown:
file_put_contents('cache-gets.log', $cache->getCallSiteStats(), FILE_APPEND);
The Value
This information stored in inline comments helps our team make good decisions when looking for performance issues, refactoring a section of code, or ferreting out bugs. It can help highlight problems like a cache key with a really high miss rate, a DB query that is run way too often, takes far too long, or has a really high variability. It’s especially helpful when trying to make decisions about caching. Questions like: Is this thing worth caching?, Is this cache effective?, and Is this the appropriate length of time to cache this data? can more readily be answered because we have raw data staring us in the face. We hope the community finds this project as useful as we have.