Re: New to MySQL
Posted by: Peter Brawley
Date: September 02, 2021 08:34PM

> According to our end users, application is slow

Rebuilding indexes is unlikely to affect such slowness, which is usually due to incorrect, inadequate or just inefficient indexing. I suggest you enable the slow query log, then optimise the queries it reports such that they use indexes efficiently.



Edited 1 time(s). Last edit at 09/02/2021 08:36PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
September 02, 2021 03:40PM
September 02, 2021 03:57PM
September 02, 2021 04:00PM
Re: New to MySQL
September 02, 2021 08:34PM


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.