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
167
June 30, 2020 03:50PM


Sorry, you can't reply to this topic. It has been closed.

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.