So, I’ve driven my server to that point that we reach 20+ players at the same time. But after reaching 20+ players the server gets laggy and the servers m/s goes up to thousands. What can cause the issue? Our VPS tells us it can be something wrong with the server. But everything is fine it’s just when we just reach 20+ players, the server gets laggy.
130 MbpH? What sort of unit is that?
What hardware specs does the VPS have?
Your issue is that you have 140 (likely unoptimized) scripts on your server.
I’ve got 130 megabits per seconds, sorry for my mistake. But they are optimized (I think) I sometimes get resource time warning can that be the case?
130 Mbps is really slow for a VPS. I’d consider looking for a better provider.
If you’re getting resource timing warning, it is either an underpowered VPS, or a resource intensive script. Do you know the hardware specs of the server? If you don’t mind me asking, how much do you pay per month for this server?
I pay around 22$ per month with GTXHosting. Here are the specs
Those specs should probably be fine, depending on the resources. Enable MySQL debugging (look at the mysql async thread) and see if it’s a query causing the hitch warning.
For $22/mo, you can probably find something better than that. FiveM relies somewhat heavily on a strong network connection. 130 Mbps isn’t great. What’s the upload speed?
The upload is around 140-170mbps
Still, the lag is most likely not because of VPS specs, but because of unoptimized code.
I’ll take one guess: Are you running an esx server?
If so, I’ve heard A LOT of complaints about servers with esx resources starting to lag, completely freeze etc at around 25 players. If you run the ESX framework then it’s most likely that.
And yea, do this. Make sure that the fields in your WHERE clauses of your MySQL queries are indices (INDEX) on in your database tables
I have the same problem, can you guys help me to analyze?
Can you send me the mysql async thread? I think I need to enable MySQL debugging
Don’t be lazy, use the search feature.
1 Like
The lion Leader! I need help with that please… Just send me the website
Very difficult to find. https://forum.cfx.re/search?q=mysql%20async%20category%3A7
If you can’t bother to search the website for mysql-async, just wait until you have to try to search scripts to find out where the root cause is. 
I am actually running an ESX server. Had one before this one that worked out perfectly so I am a little lost why it won’t “work” now.