MySQL Forums
Forum List  »  Performance

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


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.


Options: ReplyQuote

Written By
SQL performance tuning advice
February 21, 2020 09:58AM
February 21, 2020 11:58AM
February 21, 2020 06:39PM
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.