This guide concerns MySQL/MariaDB and more specifically index and query analysis with Web Hosting.

Slowlog for long queries

The MySQL slow log is enabled on all MySQL servers and groups together queries that take more than 5 seconds* to execute. If your queries are well-structured, you will never see these files. Otherwise, check them regularly to correct any potential issues and ensure your site functions properly.

Contact Infomaniak support in writing to obtain them (except for older v1 hosting plans - older packages), which can be accessed directly from the Web FTP, one level above /web in the /logs directory).

What about the logs?

No MySQL logs are created (except for slow logs) because the MySQL servers could not handle the load of millions of simultaneous logs. If needed, Infomaniak can activate this MySQL log for 5 minutes to allow you to analyze them with EXPLAIN and determine useful indexes, for example. To do this, contact Infomaniak support in writing.

* of elapsed time. And regarding locks, the documentation provides the following clarification: "The time to acquire the initial locks is not counted as execution time"