[PRoleplay]

Does the BLUEG SQL Plugin synchronous?

[[cS]Owain]

mysql_tquery and mysql_function_query are asynchronous while mysql_query is synchronous.
Use async. ones to avoid server lag.

[PRoleplay]

is it safe to use async? Im worrying about when the middle of saving then the playir relog or /q the game

[[cS]Owain]

Well while saving you just take player-data and run a update query. So even if player quits when the query is running I don't think so it would be a problem as his data is already sent to mysql server via query and change in local pawn variables when he disconnects won't affect the query as its already been sent!

All big server uses async. queries for almost all its operations these days.

[PRoleplay]

thanks man EDIT: Do need to restart mysql regularly? to avoid lag? or not?

[[cS]Owain]

No.
My server runs for weeks sometimes one month+ without reloading plugins.

[PRoleplay]

imean if or everytme do Restart on my gamemode do i need to restart mysql too?

[BroZeus]

Nope.

[BroZeus]

Edit: wrong post sorry.