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
Subject
Views
Written By
Posted
SQL performance tuning advice
1055
February 21, 2020 09:58AM
438
February 21, 2020 11:58AM
437
February 21, 2020 06:39PM
449
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.