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?
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?
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
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.
Can you say this in an easier kind of language because i do not understand how to index the tables