1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Show MySQL logs and slowlogs
This guide is about MySQL/MariaDB, focusing on index analysis and queries with Web Hosting.
Slowlog for Long Queries
The MySQL slowlog is enabled on all MySQL servers and contains queries that take more than 5 seconds* to execute. If your queries are well-constructed, you should never see these files. Otherwise, check them regularly to identify and fix any issues to ensure your site operates correctly.
Contact Infomaniak support in writing to obtain them (except for old v1 hosting, which can be accessed directly from the FTP Manager file manager, one level above /web, in the /logs directory).
And the Logs?
No MySQL logs are created (except slow logs) because MySQL servers cannot handle the load of generating millions of simultaneous logs. If needed, Infomaniak can activate MySQL logs for 5 minutes to allow you to analyze them with EXPLAIN and determine useful indexes, for example. To do this, please 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."