1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
View MySQL logs and slowlogs
This guide concerns MySQL/MariaDB and more specifically index analyses and queries with the Web hosting.
Slowlog for long queries
The slowlog MySQL is enabled on all MySQL servers and groups queries that take more than 5 seconds* to run. If your queries are well built, you will never see those files. Otherwise, consult regularly to correct any defects and thus ensure the proper functioning of your site.
Contact Infomaniak Support in writing in order to obtain them (except for old accommodation v1 directly accessible from the FTP File Manager a level above /web in the directory /logs).
What about the logs?
None log MySQL is not created (apart from slowlogs) because MySQL servers would not bear the burden of millions of simultaneous logs to save. In case of need, Infomaniak can activate this MySQL log for 5 minutes to allow you to analyze them with EXPLAIN and to determine useful indexes e.g. To this end, contact Infomaniak support in writing.
* of elapsed time. And regarding locks, the documentation provides the following precision: "The time to acquire the initial locks is not counted as execution time"