MySQL Forums
Forum List  »  Performance

Re: MYSQL issues with query performance
Posted by: Peter Brawley
Date: June 30, 2020 03:50PM

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.

Options: ReplyQuote

Written By
Re: MYSQL issues with query performance
June 30, 2020 03:50PM

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.