MySQL Forums
Forum List  »  Performance

SQL performance tuning advice
Posted by: Oliver C
Date: February 21, 2020 09:58AM

Hi,

I'm looking for some general advice regarding performance tuning of SQL queries on MySQL 5.7. I'm looking at MySQL Workbench currently and cannot understand the timing figures on High Cost SQL Statements -> Statement Analysis where the various "time" columns show up as (us). Is it possible to change this to milliseconds?
Is it possible to use Workbench to show the execution plans for some of these long running queries?
Is it possible to use Workbench to give advice on how to improve the SQL statements, if its possibly missing an index, etc. I'm thinking along the lines of what the SQL tuning advisor that Oracle RDBMS provides.

Any other general advice on performance tuning on MySQL 5.7 would be greatly appreciated. Any tools you've used would be helpful.

Thanks,
OC

Options: ReplyQuote


Subject
Views
Written By
Posted
SQL performance tuning advice
417
February 21, 2020 09:58AM
184
February 21, 2020 11:58AM
186
February 21, 2020 06:39PM
187
February 22, 2020 08:02AM


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.