1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
MYSQL: logs and slow query logs
The MySQL slow query log is enabled on all MySQL servers and logs any queries that take longer than five seconds* to perform. If queries are properly constructed, you will never see files for them. Please check them regularly to correct any potential errors and therefore ensure that your site is working properly.
- With our previous web hosting formula, issued from our old platform, these potential .log files can be viewed directly from the FTP file manager, one level above /web in the /logs directory.
- With the new web hostings, you need to contact us in writing to access them.
Find out more
We do not make MySQL logs (apart from slow query logs) because the MySQL servers would in no way support the load of millions of logs that need to be registered at the same time. If necessary, we can enable the MySQL log for five minutes to allow you to carry out analyses with EXPLAIN and identify any indexes that could be useful, for example. To do this, please contact us in writing.
* time elapsed. With regard to the locks, the documents give the following clarification: "The time to acquire the initial locks is not counted as execution time"