[yanir3]

If I keep my server up for a few hours, the MYSQL starts to lag. When a player connects to the server, it takes more than 10 seconds for the server to fetch this single query:

PHP код:

mysql_format(sql, szQuery, sizeof(szQuery), "SELECT `username` FROM `newrp_users` WHERE `username` = '%s' AND `status` = 4", GetName(playerid));
        mysql_pquery(sql, szQuery, "OnPlayerDataLoaded", "d", playerid); 


When usually, it takes less than a second. Does anyone know what could be the cause?
This fixes itself after a gamemode restart.

Additional info:
Server is Linux, I'm using a static version of the plugin and latest version (R39-2).