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


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


Sorry, only registered users may post in this forum.

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.