Normally if you want to track metrics on MySQL, you have to do it manually, and it only gives you a snapshot of the data at that moment. If you want to streamline the process, you could write a web app to report on the metrics. Or – if you want to save time and skip re-inventing the wheel – you could use Telemetric.io, a free service that keeps track of any value in MySQL and how it changes over time.
Newly launched Telemetric.io is a free service that pings a MySQL database hourly (with daily checkpoints) to keep track of a specific metric. That metric could be any aggregate value (such as how many records in a table, or the sum or average of a certain column) – and the tool even allows for custom SQL to really get advanced with it. Telemetric.io remotely connects using basic credentials – there’s nothing to install, and they only use SELECT queries, so your data is safe.
This free tool – which is basically Google Analytics meets MySQL databases – makes it easy to keep track of changing activity in your database. Just a handful of examples of what you can track include: order revenue, product sales, coupon usage, etc; how many people are make reservations or bookings daily; how many users you have, how many are active, inactive, churn, etc; rolling averages, by writing custom SQL that limits the search to the past X days; operational statistics about your business workflows, such as error logs, etc.
Telemetric.io is an exciting addition to the market because of its “plug and play” nature, allowing users to start tracking anything in their database in seconds, finding new metrics they didn’t even know they wanted to track until they could. The tool is super easy to use, with nothing to install. Simply enter the remote connection details for your MySQL database, and choose what you want to track.
Features
Telemetric.io allows users to:
- Monitor daily changes to any MySQL value: Telemetric.io pings your database once per hour to get the latest value, and keeps daily checkpoints, allowing you to unlock insights hidden within your MySQL databases.
- Create beautiful charts in minutes, and embed them on your own website: Once enough data is collected, Telemtric generates responsive charts to show how a specific metric is changing over time – which can be embedded anywhere you’d like, whether your website or a dashboard. Adjust settings such as title, colors, and formatting – and track how your trends grow over time.
- Track any value in seconds: Track up to 25 metrics at any given time, with 12 months of history.
Interested?
If you’re looking for an actually free – no hidden fees, sales processes, or paid upgrades – tool to track your MySQL metrics, , you can sign up for on their website in seconds, no credit card required.
