MySQL Forums
Forum List  »  MyISAM

Re: Database Utilities
Posted by: Scott Krise
Date: March 15, 2019 01:08PM

Yes, certainly have test systems to experiment on. So, the intent of the original question was to find out what detailed maintenance needs to be done. I've done numerous web searches but haven't found anything definitive on what should be done, and how often.

query_cache_size is currently set to 1,048,576...so you are saying I should turn that off by setting it to 0?

And when I look at the slow query log, it doesn't show a full path name, just a file name...and i cant locate the file anywhere. Where might that be kept?

Options: ReplyQuote


Subject
Views
Written By
Posted
457
March 15, 2019 10:58AM
276
March 15, 2019 11:44AM
Re: Database Utilities
273
March 15, 2019 01:08PM
241
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.