1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Display MySQL logs and slow logs
This guide concerns MySQL/MariaDB and more specifically index analyses and queries 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 constructed, you will never see these files. Otherwise, check regularly to correct any potential issues and ensure the proper functioning of your site.
Contact Infomaniak support in writing to obtain them (except for old v1 hosting directly viewable from the FTP Manager file manager one level above /web in the /logs directory).
And the logs?
No MySQL log is created (except for slowlogs) as MySQL servers would not support the load of millions of simultaneous logs to record. If necessary, Infomaniak can enable 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.
* elapsed time. And regarding locks, the documentation provides the following clarification: "The time to acquire the initial locks is not counted as execution time"