MySQL Forums
Forum List  »  InnoDB

Re: High CPU usage by mysql process
Posted by: Szymon Lisowiec
Date: May 11, 2016 11:19AM

Such index is exists ("selectingByStatus" in my above post).

I corrected configuration. Now it looks like this:
query_alloc_block_size = 8192
query_cache_limit = 524288
query_cache_min_res_unit = 2048
query_cache_size = 83886080
query_cache_type = ON
query_cache_wlock_invalidate = OFF
query_prealloc_size = 8192
Is it good?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: High CPU usage by mysql process
2018
May 11, 2016 11:19AM


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.