Help with Slow Query MYSQL

FiveM Resource Development Discussion
1

Hi,
So Im trying to figure out Slow Query Warnings. I tryed I think almost everything. I added random indexes and error still appears. These errors:

[MySQL] [Slow Query Warning] [esx_vehicleshop] [967ms] SELECT * FROM vehicle_categories
[MySQL] [Slow Query Warning] [esx_shops] [963ms] SELECT * FROM items
[MySQL] [Slow Query Warning] [gcphone] [960ms] DELETE FROM phone_messages WHERE (DATEDIFF(CURRENT_DATE,time) > 10)
[MySQL] [Slow Query Warning] [es_extended] [958ms] SELECT * FROM items
[MySQL] [Slow Query Warning] [esx_weaponshop] [956ms] SELECT * FROM weashops
[MySQL] [Slow Query Warning] [esx_addoninventory] [963ms] SELECT * FROM items
[MySQL] [Slow Query Warning] [esx_addonaccount] [961ms] SELECT * FROM addon_account
[MySQL] [Slow Query Warning] [esx_property] [963ms] SELECT * FROM properties
[MySQL] [Slow Query Warning] [netr_garages] [961ms] DELETE FROM `user_parkings`
[MySQL] [Slow Query Warning] [esx_datastore] [981ms] SELECT * FROM datastore
[MySQL] [Slow Query Warning] [esx_society] [989ms] SELECT * FROM jobs

For every reply thanks a lot :smiley:

2

do you have a slow disk?

or have you exceeded available ram and your host is swapping heavily

adding “random” indexes is usually not a good idea, but would slow down writes not reads (selects)

https://bobcares.com/blog/mysql-performance-issues/

1 Like
3

I bought a VPS from the site (idk i can type the name of it here.) But specs are cool tbh. Intel Xeon E3-1270v6 3.8GHz 2x vCPU, Disk SSD 50gb and 4gb RAM. So I dont think the disk is slow becouse its SSD. 4GB RAM is enough.

4

checkout the linked post, and maybe open a support ticket with your server provider, they may be able to help you with mysql.

5

Make sure to open up your xampp control panel (if you are using that) and make sure that you started the modules you want. That is what fixed it for me.

6

Did you fix it ? I have same issue …!

7

I also have the same problem several days ago

8

How did the modules you asked for start?

9

What you can try to do is buy a webserver (vps). And set you’re database on that server.