Each Scalingo for MySQL® addon comes with several tools allowing for monitoring and auditing of your database. These tools give access to the database logs and to some metrics.

All these tools are available from the database dashboard.

Inspecting Database Logs

Database logs are a very valuable resource when it comes to monitoring and troubleshooting problems, tracking performance and auditing the database activity.

By default, only the most recent logs are directly and immediately available from the different tools (see below). We call these logs Hot Logs.

Once the logs reach 50MiB, they are compressed and placed in an archive. These archives are Cold Logs. They are still available, but they require a bit more work (see below).

Using the Database Dashboard

1. From your web browser, open your database dashboard
2. Click the Logs tab

The default view allows to consult the latest hot logs in real-time. The Archives link at the upper-right corner of the page allows to download the cold logs. These have to be manually unarchived to be processed.

Using the Command Line

1. Make sure you have correctly setup the Scalingo command line tool
2. Run the following command:
   • To access the hot logs of this addon:

     scalingo --app my-app --addon mysql logs --lines <number_of_lines>
     

   • To access the cold logs of this addon:

     scalingo --app my-app --addon mysql logs-archives
     

Analyzing Database Metrics

Database metrics are very helpful to identify and track overall performance issues, making them key indicators to watch.

The provided metrics include:

• CPU usage, memory consumption, storage usage and disk input/output operations per second (IOPS) for all nodes composing your database cluster
• CPU usage and memory consumption for all gateway nodes.

Using the Database Dashboard

1. From your web browser, open your database dashboard
2. Click the Metrics tab