[xxmitsu]

I'm using linux CentOS.
I've even recompiled the plugin on my machine with my mysql includes, still the same problem.

I've increased mysql query cache to 32MB in mysql server my.cnf but the problem is still there.

Anyone has any idea what to do? Since I can't use this plugin at all. It only works for about 2 minutes, then my whole server is down(no one can login, logged in player's accounts aren't saved anymore, etc) as it depends on mysql.


LATER:
I've made a 15 sec timer with mysq_reconnect();
Connection stayed. But on intense traffic, it all gets messed up.

Код:

[07:20:25] CMySQLHandler::Ping() - An error has occured (MySQL server has gone away, Error ID: 2006)
[07:20:25] CMySQLHandler::ProcessQueryThread(SELECT id FROM players WHERE LOWER(Name) = LOWER('foreverStrong') LIMIT 1, Resultid: 1) - An error has occured in your query. (MySQL server has gone away))
[07:20:35] >> mysql_real_escape_string( Connection handle: 1 )

then

Код:

[07:20:38] CMySQLHandler::Ping() - An error has occured (MySQL server has gone away, Error ID: 2006)
[07:20:38] CMySQLHandler::Ping() - An error has occured (MySQL server has gone away, Error ID: 2006)
[07:20:38] CMySQLHandler::Connect() - Connection was successful.
[07:20:54] >> mysql_reconnect( Connection handle: 1 )
[07:20:54] CMySQLHandler::Ping() - An error has occured (Commands out of sync; you can't run this command now, Error ID: 2014)
[07:20:54] CMySQLHandler::Ping() - An error has occured (Commands out of sync; you can't run this command now, Error ID: 2014)
[07:20:54] CMySQLHandler::Connect() - Connection was successful.
[07:21:10] >> mysql_reconnect( Connection handle: 1 )
[07:21:10] CMySQLHandler::Ping() - An error has occured (Commands out of sync; you can't run this command now, Error ID: 2014)
[07:21:10] CMySQLHandler::Ping() - An error has occured (Commands out of sync; you can't run this command now, Error ID: 2014)
[07:21:10] CMySQLHandler::Connect() - Connection was successful.
[07:21:26] >> mysql_reconnect( Connection handle: 1 )
[07:21:26] CMySQLHandler::Ping() - An error has occured (Commands out of sync; you can't run this command now, Error ID: 2014)
[07:21:26] CMySQLHandler::Ping() - An error has occured (Commands out of sync; you can't run this command now, Error ID: 2014)
[07:21:26] CMySQLHandler::Connect() - Connection was successful.

I've found that this "Commands out of sync" errors are happening if you are storing the results without freem them first or vice-versa.
I've revised my code three times, there isn't anything like that.
Then, I've discovered that this also occurs if is used mysql_ping or mysql_reconnect at the same time with an unfinished query..

Anyone has any idea how to fix this? I would really apreciate.

Thank you in advance.

Mike.