MySQL Forums
Forum List  »  MyISAM

Re: Database Utilities
Posted by: Peter Brawley
Date: March 15, 2019 11:44AM

> 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.

Options: ReplyQuote


Subject
Views
Written By
Posted
442
March 15, 2019 10:58AM
Re: Database Utilities
267
March 15, 2019 11:44AM
261
March 15, 2019 01:08PM
232
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.