MySQL Forums
Forum List  »  MyISAM

Database Utilities
Posted by: Scott Krise
Date: March 15, 2019 10:58AM

Hello,

Are there any utilities that should be run to optimize your databases?

We are running Mysql 5.7...and we have some large tables (1.5 million records) that we feel are slowing down our system, so as a test, I deleted all records older than 5 years, just to see how it affected my performance. To my surprise, on particular report went from running for about 25 seconds to running for over 5 minutes when I did that! So, this lead me down the path where maybe some of our latency is due to tables not being optimized from time to time.

Using other data types, it was necessary to run utilities that would remove deleted records from your tables, or to reindex them...but I always thought that SQL products dealt with that without any user intervention. Am I wrong about that? Any thoughts as to why I just saw such a drastic change in performance?

Options: ReplyQuote


Subject
Views
Written By
Posted
Database Utilities
443
March 15, 2019 10:58AM
268
March 15, 2019 11:44AM
262
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.