MYSQL Slow Query Warning

Marcox360 · 2019-03-14T09:02:31.320Z

Good Morning, since 2 weeks i’m getting a big list of [MYSQL] [SlowQuery Warning] in console on the Startup of the server.

Do someone of you fixed this, can someone help me fix this “ISSUE” please?

Screenshot_11245×202 28.2 KB

d0p3t · 2019-03-14T09:46:10.597Z

It’s probably due to inefficient queries or no indexing on the column you use in your conditions.

See Speeding up your Server 101 (Windows)

Marcox360 · 2019-03-14T10:00:39.126Z

d0p3t:

It’s probably due to inefficient queries or no indexing on the column you use in your conditions.

I’ve also upgraded my server from 4GB RAM to 16GB but i get the same message, when the server was frash so (20/30 users in database) it was all good, now i have like 300/400 and i think is that.

I will try to have a look to the link that u gave me. Thank you

Syntasu · 2019-03-14T11:05:20.839Z

A couple of things:

A) Do you really need all the data to be selected, going by the SELECT * FROM .. queries. Normally you only want to fetch a subset. This will cause the database engine to not perform any optimization since you return everything anyways.

B) As the link that @d0p3t send, it talks about indexes. I think you can get a massive speed up by indexing your tables and prevent hitches.

The indexes and SELECT * is something that @Hawaii_Beach/ESX should fix in their main repositories.

wird_klap · 2019-05-22T08:52:55.460Z

Can you say this in an easier kind of language because i do not understand how to index the tables

d0p3t · 2020-07-22T19:21:35.653Z