29.04.2012, 16:31
Hello i have a problem with my mysql system
when too many players join, failed the connection to the server
here the mysql logs before the server crash is there a bug in the logs ?
when too many players join, failed the connection to the server
here the mysql logs before the server crash is there a bug in the logs ?
Код:
[18:09:26] CMySQLHandler::EscapeString(mmm); - Escaped 12 characters to mmmm. [18:09:26] >> mysql_query( Connection handle: 1 ) [18:09:26] CMySQLHandler::Query(SELECT * FROM `playerinfo` WHERE `user` = 'mmm' AND `password` = '1C3AFC9C1A5D22A1FE41AC18B070E2816B52049546C238364FA896A872546BA9A5BE527D1CB5175A1F883380D6F8E3CFDF5F8A3158D1348040BC949386204290' LIMIT 1) - Successfully executed. [18:09:26] >> mysql_store_result( Connection handle: 1 ) [18:09:26] CMySQLHandler::StoreResult() - Result was stored. [18:09:26] >> mysql_num_rows( Connection handle: 1 ) [18:09:26] CMySQLHandler::NumRows() - Returned 1 row(s) [18:09:26] >> mysql_fetch_row_format( Connection handle: 1 ) [18:09:26] CMySQLHandler::FetchRow() - Return: mmm|1C3AFC9C1A5D22A1FE41AC18B070E2816B52049546C238364FA896A872546BA9A5BE527D1CB5175A1F883380D6F8E3CFDF5F8A3158D1348040BC949386204290|19|18|19|25497|87.188.177.180|0|NULL|NULL|1|29/4/2012 [18:09:26] >> mysql_fetch_field_row( Connection handle: 1 ) [18:09:26] CMySQLHandler::FetchField("adminlvl") - 0 [18:09:26] >> mysql_fetch_field_row( Connection handle: 1 ) [18:09:26] CMySQLHandler::FetchField("kills") - 19 [18:09:26] >> mysql_fetch_field_row( Connection handle: 1 ) [18:09:26] CMySQLHandler::FetchField("deaths") - 18 [18:09:26] >> mysql_fetch_field_row( Connection handle: 1 ) [18:09:26] CMySQLHandler::FetchField("ratio") - 1 [18:09:26] >> mysql_fetch_field_row( Connection handle: 1 ) [18:09:26] CMySQLHandler::FetchField("regdate") - 29/4/2012 [18:09:26] >> mysql_free_result( Connection handle: 1 ) [18:09:26] CMySQLHandler::FreeResult() - Result was successfully free'd. [18:09:26] >> mysql_real_escape_string( Connection handle: 1 ) [18:09:26] CMySQLHandler::EscapeString(mmm); - Escaped 12 characters to mmm. [18:09:26] >> mysql_query( Connection handle: 1 ) [18:09:26] CMySQLHandler::Query(UPDATE `playerinfo` SET IP = '87.555555' WHERE user='mmm') - Successfully executed. [18:27:09] [18:27:09] --------------------------- [18:27:09] MySQL Debugging activated (04/29/12) [18:27:09] ---------------------------