overextended/oxmysql

Query execute warnings

Mitakk opened this issue · 4 comments

Mitakk commented

Describe the bug
I am having this spam query warnings. Is this needed to optimize database? This warnings still spamming when server less players. When it gets 100 players or more server just get laggy and players takes a long time to interact.

Screenshots
warning2
warning1

OxMysql versions

  • 2.6.0

Server details

  • 6478
  • Ubuntu 22.04
  • Localhost (DB)

Database details

  • MariaDB
Griefa commented

Sounds like you need to stop using a shitty framework like ESX

Your database/table design is unoptimized, server is slow, bad script design, or all of the above. Likely the fault of your server specs, or qs-* scripts more likely.

Mitakk commented

Its not qs- scripts. Any scripts that have databases are spamming like these. Is there any way to solve this?

Any scripts that have databases

They don't have databases, you have a database.

spamming like these. Is there any way to solve this?

This is an issue with your database and/or server hardware.

When it gets 100 players or more server just get laggy and players takes a long time to interact.

Yes, it takes a long time to do things because.. 500ms query time is huge.

Note there's also server thread hitches mixed in there, so the server is struggling and any queries executed before and resolved after a hitch will display higher times.

This is nothing to do with oxmysql.


There's also very little context on these warnings - how long a period did these occur over? If the server is already hitching and you continue to query the database it'll lead to further delays. A player won't know the server is hitching and keep trying to request to spawn their vehicle (see this same query triggering over and over).
image

There can be crap like terrible indexing resulting in full table scans, unnecessarily fetching all columns from a table rather, bad mysql server settings and cache.