I’m having my usual fun with charts. Working on mycheckpoint, I’ve generated monitoring charts using the Google Chars API. But I’ve also had chance to experiment and deploy interactive charts, JavaScript based. In particular, I used and tweaked dygraphs.
I’d like to note some differences in using charts of both kinds. And I think it makes [...]
Revision #88 of mycheckpoint is released. In this revision:
Disk space monitoring
Improved charting
Enhanced auto-deploy
And more…
Disk space monitoring
mycheckpoint now monitors (on Linux only) three mount points:
The “/” (root) mount point
The datadir mount point
The tmpdir mount point
It may well be the case that two of the above (or perhaps all three of them) share the same mount point. [...]
Revision 76 of mycheckpoint comes with quite a few improvements, including:
OS monitoring (CPU, load average, memory)
Auto-deploy
Improved charting
Brief HTML reports
24/7 charts
OS Monitoring
When monitoring the local machine, mycheckpoint now monitors CPU utilization, load average, memory and swap space.
This only applies to the Linux operating system; there is currently no plan to work this out for other operating [...]
Rev. 57 of mycheckpoint has been released and is available for download.
New and updated in this revision:
Remote host monitoring
Improved charting
Flexible charting
Fix to questions vs. queries issues
Remote host monitoring
It is now possible to monitor one host, while writing into another. Either or both could be remote hosts:
mycheckpoint –host=localhost –monitored-host=192.168.10.178
The above monitors the MySQL server on 192.168.10.178, [...]
Time for another charting SQL query. I wish to present a single-query generated multi-line/area chart. I’ll walk through some of the steps towards making this happen. By the end of this post I’ll present some real-data charts, area charts and colored charts.
+———+———————————————————————————–+
| y_scale | chart |
+———+———————————————————————————–+
| 1 | ****———#######—————————————-*******——–###### |
| 0.88 | —-***—###——-##———————————–***——-***—##—— |
| 0.75 [...]
My other half says I’m losing it. But I think that as an enthusiast kernel developer she doesn’t have the right to criticize people. (“I like user space better!” – she exclaims upon reading this).
Shown below is a (single query) SQL-generated pie chart. I will walk through the steps towards making this happen, and conclude [...]
I wasn’t sure I was to go this far. After catching breath the following have been added to Generic, auto scaling, scaled SQL graphs, and these will conclude my current hacks:
Displaying X-axis min/max values.
Support for Y-axis values precision.
Support for pre-defined scale range.
The addition of the above makes for presentable, usable graphs. See also sample graphs [...]
In Rotating SQL graphs horizontally, I have shown how to rotate an ASCII SQL graph into horizontal position.
I was dissatisfied with some parts of the solution, which I will show now how to fix:
I had to manually scale the graph values so as to fit nicely into screen.
I had to rely on hard coded scaling [...]
We all love graphs. We all love SQL hacks. We all know the SQL hack which displays a character-based graph (example follows for those unfamiliar).
But we all love horizontal graphs, not vertical ones. We are used to the X axis being horizontal, Y being vertical. Not vice versa.
In this post I’ll present a SQL hack [...]