I have a C# application using NPoco that is doing many queries on a MySQL server (version 5.6.17).
The usual time for these queries is between a couple of ms and 40 ms.
However sometimes it seems that some queries are taking the usual time plus 5000 ms and I absolutely don’t understand why (e.g. 5021 ms). It is also always the queries that are already the most heavy ones that have this behavior (i.e. the queries that takes usually around 40 ms).
(I've installed the MySQL server with the WAMP package (http://www.wampserver.com/) because I also needed the Apache server and the PHP server.)
Do you have an idea where I should look to fix this annoying problem?