Posts: 534
Threads: 265
Joined: Jul 2014
Hi,
I want to ask.
What are doing big server with 500+ players if they are using mysql? because there i think commands, saving, loading is and there is a lot of queries is called in short of time and how there still is good playing, i mean no waiting queries or like that, or they don't use queries?
Posts: 385
Threads: 17
Joined: Oct 2008
Reputation:
0
I would say at least 90%, if not all, of these popular servers are using mysql.
Posts: 709
Threads: 63
Joined: Feb 2009
Reputation:
0
mySQL is made for many queries and big databases, much bigger entities than SA-MP servers are using it.
Posts: 6,242
Threads: 8
Joined: Jun 2008
The reason SA-MP servers use mysql is the speed at which you can get a response from the server and the fact you don't need to open files and wait...
It's all about speed.
Posts: 534
Threads: 265
Joined: Jul 2014
But i don't really understand... How queries is working then? when you send query from server, server is waiting a response and then do in callback now how threaded queries working, but when the first query is calling and getting response if in same time will be second query then it will have to wait until the first complete, get response and then it can be perfomed. But if more queries then and more waiting for complete and this make longer saving and other things.
Posts: 6,242
Threads: 8
Joined: Jun 2008
Quote:
Originally Posted by Banditukas
But i don't really understand... How queries is working then? when you send query from server, server is waiting a response and then do in callback now how threaded queries working, but when the first query is calling and getting response if in same time will be second query then it will have to wait until the first complete, get response and then it can be perfomed. But if more queries then and more waiting for complete and this make longer saving and other things.
|
Rather than open the whole file, reading it, and selecting the value I need, query the SQL server for the value I want and it'll respond faster.
And being that it is SQL, it can also sort, filter, and do everything that a file based system can do, much faster and without any significant load on the server.
The queries aren't requiring the player to be online to have their files open so they can be edited.
Where as you would have an issue if you put a SQL server in EU, and used a US server to play on/query from; if you plan your install and placement of those servers better you'll get good results. (No delay and no packet loss in the SQL query).
Posts: 534
Threads: 265
Joined: Jul 2014
But then what mysql plugin is faster and is faster threaded queries or non-threaded?
Posts: 6,242
Threads: 8
Joined: Jun 2008
Quote:
Originally Posted by Banditukas
But then what mysql plugin is faster and is faster threaded queries or non-threaded?
|
https://sampforum.blast.hk/showthread.php?tid=56564
This seems active on its github.
With regards to threaded vs non-threaded, you have to ask someone who knows more of SQL, and it's benefits on that.
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation:
0
Here's something to think about: the blink of an eye takes 300 to 400 milliseconds. Your average query is executed in 10 milliseconds.
