[Excarius]

Hey guys, let me first tell everything from it's beginning.

First is, i got 2 VPS, and 1 free gamehost, however what im trying now is to move server from gamehost to VPS, one vps is 2GB ram, and other one is 512mb ram.

The problem is here, each VPS is from differen host, let me make it look like list

VPS 1: Windows Server 2008 Standard 64bit (2GB Ram, 100mbits ethernet)
VPS 2: Windows 7 Starter 32bit (512MB Ram, 1gbits ethernet)

VPS 1 Issue: Works fine, mySQL is local and connects nice, during something changes at mySQL table doesn't slowdown it, but causes some random player crash (i'll show you log soon)

VPS 2 Issue: Works fine, mySQL is local and connects nice, during something changes at mySQL table slowsdown the server (response is aprox 1sec), each time something change occurs in mySQL takes 1mb (also server fully stops respond for 1 second). It causes NO any random player crash (even though, both of the logs in VPS 1 and VPS 2 are giving same results, yet doesn't cause any player crashes... really wierd)


Here is what result is

Код:

[13:11:12] >> mysql_store_result( Connection handle: 1 )
 
[13:11:12] CMySQLHandler::StoreResult() - Result was stored.
 
[13:11:12] >> mysql_fetch_int( Connection handle: 1 )
 
[13:11:12] CMySQLHandler::FetchRow() - Return: 50776093
 
[13:11:12] >> mysql_free_result( Connection handle: 1 )
 
[13:11:12] CMySQLHandler::FreeResult() - Result was successfully free'd.
 
[13:11:12] >> mysql_query( Connection handle: 1 )

As you can see the "Return" is really heavy, just sometimes that number changes to ~580000000 (i know, WoW...)


So, what is the cause? on both VPS i get the same returns, but one VPS doesn't kick randomly while the other VPS does, and one VPS doesn't lag during SQL table changes, while the other VPS does.


Help please, i couldn't figure it out the issue, currently installing Windows Server 2012 64bit to VPS 1 (dunno maybe impossible with server 2012 lol)

Thanks for reading my thread to the end.

EDIT: The mySQL debug log is REALLY huge, so i just putted the most important part.

[SaltySandy]

Your VPS 2 has too little RAM to process both Windows, as the SA-MP server as the SQL server.
Also, you might want to consider switching to Ubuntu. It's RAM usage is not as high, and it's not resource-intensive. Also, Ubuntu is more stable. Just a tip.