[Release] MySQL Async Library - 3.3.2

The creators will have to comment on this but you’re not using an approved database / a database that’s been benchmarked and I suspect that you’re encountering issues because of that. It’s very likely that you will experience fewer issues if you downgrade to MariaDB 10.3 or 10.4.

Add this to your server.cfg

set mysql_slow_query_warning 10000

how do we optimize tables? can you give an example please?

 [MariaDB:10.4.18-MariaDB] [WARNING] [DP_Inventory] [1068ms] SELECT * FROM ammunition : []
[  script:mysql-async] [MariaDB:10.4.18-MariaDB] [WARNING] [esx_addonaccount] [1067ms] SELECT * FROM addon_account : []
[  script:mysql-async] [MariaDB:10.4.18-MariaDB] [WARNING] [es_extended] [433ms] SELECT * FROM items : []
[  script:mysql-async] [MariaDB:10.4.18-MariaDB] [WARNING] [es_extended] [433ms] SELECT * FROM jobs : []

i can check setting mysql like that worked for me. no more timeout error

1 Like

I did fix the issue on my side by doing this

set mysql_connection_string “server=0.0.0.0;database=.;userid=user;password=pwd;connectTimeout=20000;supportBigNumbers=true;acquireTimeout=20000”

“Failed to load script @mysql-async/lib/MySQL.lua” any idea guys ?