Re: Database Utilities
> To my surprise, on particular report went from running for
> about 25 seconds to running for over 5 minutes
You have the query cache on? It's deprecated in 5,7, gone in 8.0. Turn it off, turn on the slow query log to find slow queries then optimise those queries.
> I always thought that SQL products dealt with that
> without any user intervention
Originally EF Codd said SQL was about telling an RDBMS what to do rather than how to do it, but those were early days with simpler DBs. There's no cleanup fairy and no avoiding detailed maintenance.
MyISAM is near-obsolete, much more primitive than InnoDB, allows less optimisation yet needs extra care. You may want to consider upgrading tables to InnoDB. At least try it on a test system (you do have some of those, right?).
Edited 1 time(s). Last edit at 03/15/2019 01:41PM by Peter Brawley.
Subject
Views
Written By
Posted
1197
March 15, 2019 10:58AM
Re: Database Utilities
731
March 15, 2019 11:44AM
789
March 15, 2019 01:08PM
685
March 15, 2019 01:45PM
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.