The Database That Forgets on Purpose: Reviving Pinba, a 15-Year-Old MySQL Monitoring Engine
A table that never remembers yesterday
Ask any DBA what a database is for, and they'll say: keeping data. Now imagine a MySQL table that does the opposite. You SELECTfrom it and get live statistics about every request your web application served in the last 15 minutes. Query it an hour later — that data is gone forever. Restart MySQL — everything vanishes, and nobody is upset.
That table is powered byPinba, and the amnesia is the whole point. Pinba is not a database; it's a monitoring server wearing a database costume. The costume matters: instead of learning yet another query DSL, you inspect your production traffic with plain SQL:
SELECT script_name, req_count, req_time_total, req_time_percentFROM pinba.report_by_script_nameORDER BY req_time_total DESCLIMIT 5;
Five lines, and you know which pages are eating your servers alive — right now, not in yesterday's logs.
Born inside a dating site
The story starts at...
Copyright of this story solely belongs to hackernoon.com. To see the full text click HERE
