MySQL/MariaDB Query for Counting API Requests per Day

When we started our holidays API project, we only had a select number of users using our closed beta, we needed a quick and easy way to track API metrics. The first metric we wanted to track was obviously, the number of requests, the beta API was receiving.

In this article, we are going to describe, how we set this us very quickly and started getting a quick view of what was going on with the API. This exercise was actually the initial step to building a full-fledged dashboard and monitoring system around our API.