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

Slowlog for long queries

The MySQL slowlog is enabled on all MySQL servers and groups 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 issues and ensure your site functions properly.

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

What about logs?

No MySQL log is created (apart from slowlogs) because the MySQL servers could not handle the load of millions of logs being recorded simultaneously. If needed, Infomaniak can activate this MySQL log for 5 minutes to allow you to analyze it with EXPLAIN and determine useful indexes, for example. To do this, contact Infomaniak support in writing.

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