Posts: 60
Threads: 17
Joined: Feb 2013
Reputation:
0
hi , i have a samp server with 100/1000 players, but when players rise up to ~100, mysql plugin can't Read data from databases sucsfully and some times users details be same of another player.
for example a normal player when login, level of another player set for him and that player must relog to resolve ....
im using Cent os6, i think problem is my os and i want change to Ubunto.
which os is the best you think?!
Posts: 1,189
Threads: 51
Joined: Jan 2012
Reputation:
0
EDIT: Sorry, I believe Windows 2003 is good.
Posts: 1,013
Threads: 67
Joined: Nov 2011
Reputation:
0
Gentoo! It depends really on your setup, if it's a VPS then the resources you were promised are in fact not yours and are actually shared across all VM's. Especially the CPU, hence why MySQL may not always act the way you expect it. Oh and a lot of records usually means it will take longer for certain functions in MySQL, like we have a database with 1000+ records and depending on what machine the database is on the different amount of time it takes for queries.
Oh and MySQL returning wrong records is probably something to do with your setup rather than your server. OS doesn't always matter, it's usually a matter of personal preference. I personally like CentOS hence why every server I have ever used has it on.
Posts: 60
Threads: 17
Joined: Feb 2013
Reputation:
0
is Ubunto good for samp server with mysql ?!
Posts: 1,696
Threads: 6
Joined: Dec 2008
Obviously Gentoo if not Debian.
Posts: 767
Threads: 40
Joined: Dec 2011
Reputation:
0
Why would changing the OS solve your problem? Update your MySQL plugin to a more recent version.
Guest4390857394857
Unregistered
Debian 7
![Smiley](images/smilies/smile.png)
))