Ben_Banned
Insert dank meme here.
- Location
- Liverpool
Roleplay UK
Join the UK's biggest roleplay community on FiveM and experience endless new roleplay opportunities!
This is happening 2 hours into every server session, the whole system is lagging.
- Thread starter Ben_Banned
- Start date
Baislcy it happens sometimes where the garages lag and says, "Spawning in vehicle" for ages so people move off then at once it catches up with its self and this happens it spawns in a cluster of vehicles happened yesterday and a lot of deaths because of explosions.
Also people have to abandon vehicles because they are not storing.
Last edited by a moderator:
Jan Henrik
Well-known member
- Location
- Norway
you cant store them wilco, cuse the server is lagging. people are standing their for 10 min before their vehicles gets stored
Ben_Banned
Insert dank meme here.
- Location
- Liverpool
I doubt its because the server is lagging... no doubt its the other way around being a connection problem with the server and the SQL DB mainly because of the amount thats going on.... which in turn is causing the server to lag, i will speak to Ciaran to see what the issue is and if we need more hardware.
Last edited by a moderator:
Vento
Community Ban
- Location
- Portugal
fuckThisImOut
Well-known member
Is the db on the same machine? Maybe another dedicated db box is in order 
.
.Perhaps run the MySQL server locally instead of externally, maybe it would help with any connection/lag issues
You woild expect so, although the servers use the @extdb start up parametersIs the db on the same machine? Maybe another dedicated db box is in order
- Location
- /dev/null
Remote databases cause more lag with EXTDB unless they are sitting on the same network and accessible locally, for the four PM reboot I have designed a "Priority Query" system where logins are more important than people opening their cellphone...
Last edited by a moderator:
What about experimenting with a separate dedi solely for MySql and hosted in the same datacentre? Less load on the current cpu and still on a fast internal network
fuckThisImOut
Well-known member
Prioritizing is not a solution unfortunately, it just passes the problem to other areas, possibly making interaction in general much slower.
Surely there is a cheap vps option available in your data centre. Even a £20/more vps would be fine for a single mysql server.
Or try a different db hive extension. Epoch has used redis with quite good success. Or do what was mentioned earlier bulk the queries together in the queue. unless there is an inherent flaw in extDB dll i doubt any change in that will make any difference. It seems to be the sheer number of db calls per server frame. Literally the only solutions to tjat would be;
Very expensive hardware.
Maybe setup a headless client and offload a lot of code to it.
Rewrite the Altos life code to be more efficient/less db calls.
Or rewrite/write a new hive DLL to handle bulk queries.
Just thinking
Edit.
Just wondering is mysql setup for this level of performance, I gather you are using innodb tables. Think myisam would help?
Surely there is a cheap vps option available in your data centre. Even a £20/more vps would be fine for a single mysql server.
Or try a different db hive extension. Epoch has used redis with quite good success. Or do what was mentioned earlier bulk the queries together in the queue. unless there is an inherent flaw in extDB dll i doubt any change in that will make any difference. It seems to be the sheer number of db calls per server frame. Literally the only solutions to tjat would be;
Very expensive hardware.
Maybe setup a headless client and offload a lot of code to it.
Rewrite the Altos life code to be more efficient/less db calls.
Or rewrite/write a new hive DLL to handle bulk queries.
Just thinking
Edit.
Just wondering is mysql setup for this level of performance, I gather you are using innodb tables. Think myisam would help?
Last edited by a moderator: