Re: MYSQL issues with query performance
Explain can't find a matching index for users, so i'd replace the users index (id,acceptsallworkgroups) starting with (competences_id,searching,acceptsallworkgroups)
and continue experimenting till the engine uses it.
(It's innodb so the pk id is automatically in the index).
Optimizer_switch settings:
show variables like 'optimizer_switch'\G
Edited 1 time(s). Last edit at 06/30/2020 03:52PM by Peter Brawley.
Subject
Views
Written By
Posted
597
June 24, 2020 02:47PM
272
June 24, 2020 06:55PM
281
June 29, 2020 06:32AM
260
June 29, 2020 02:55PM
260
June 30, 2020 06:13AM
237
June 30, 2020 08:15AM
274
June 30, 2020 10:09AM
Re: MYSQL issues with query performance
237
June 30, 2020 03:50PM
255
July 01, 2020 08:04AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.