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 particularly the analysis of indexes and queries with the Web Hosting.
Slow log 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 the old v1 hosting, which can be viewed directly from the FTP Manager one level above /web in the /logs directory).
And the logs?
No MySQL log is created (except for slowlogs) as the servers would absolutely not support the load of recording 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.
* elapsed time. And regarding locks, the documentation provides the following clarification: "The time to acquire the initial locks is not counted as execution time