MySQL Forums
Forum List  »  Performance

Re: Analyse-Optimize and tablecache
Posted by: Rick James
Date: February 18, 2015 03:54PM

- analyze on all tables every day
- optimize on all tables every Sunday

In almost all installations, both of those are a waste of time.

Is "tablecache" referring to the key_buffer? Or InnoDB's "buffer pool"?

Any kind of "cache" is operating best when it is full or nearly full. If your actions are purging the cache, then that is probably counterproductive. OPTIMIZE TABLE will purge any caches that deal with that table.

What happens to the "hitrate"? A high value is probably "good". A low value is likely to indicate the need for changing the schema, adding indexes, or reformulating the queries. It probably does _not_ mean that it is time for ANALYZE or OPTIMIZE.

What monitoring tool is misleading you?

If you are having performance problems, let's look at your configuration and slow queries.

Options: ReplyQuote


Subject
Views
Written By
Posted
1678
February 16, 2015 03:49AM
Re: Analyse-Optimize and tablecache
736
February 18, 2015 03:54PM


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.