Quote:
Originally Posted by lolmaster123
The bug ISNT in the source!
The bug IS in the MySQL system!
How to fix it ?
Get MySQL Gui toolz and Optimize the BUFFER Space and the Query Cache!
TA DAA!
FIXED
How the get the right Values to fix it ?
TRY IT!
Can i use my Current source WITHOUT ANY EDIT IN THE SOURCE?
YEEE!
Btw LOTF works nice with Accs / Chars /Guilds in MySQL and Rest in INI files^^
|
This may work i dunno but it's a ghettofabulous way to say it's fixed it is only a temp solution at best when the problem is in the db class itself,It is written horribly and incorrrectly to handle the loads of saves at high volumes of players.
I don't care if ya set the buffer and query cache to 9999999999 lol outcome at high volume of players will still result in same problems and dropped sql connections without rewriting the database class the right way to handle it,And even if ya do that server will still freeze up for other reasons that have nothing to do with sql at all.And what you didn't tell people is that messing with the buffer and cache and raising them too high will eat up all the resources on your box if your not careful.
There is no need to write anything to ini's or mess with the cache and buffer if sql is written right.
We are talking about death! 
