MySQL performance logging

On business hosting plans is available a new feature — MySQL performance logging.

Logging allows you to collect statistics and see which queries are executed more often than others, how long each query takes to execute, connection statistics and memory usage. This information helps to decide whether it is necessary to optimize the logic of the site's work with the database, caching of frequent queries, etc.

Performance Schema is used for logging. Once enabled, query data is collected in the performance_schema service database (it will be visible when connecting to the MySQL server, but is not available for viewing). The obtained information can be viewed in the statistics window.

Using logging reduces the speed of executing queries to MySQL and increases the CPU and RAM usage of the hosting account.

More information about MySQL performance logging can be found in our wiki.