MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

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?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
High CPU usage by mysql process
13168
Szymon Lisowiec
May 04, 2016 03:32PM
Re: High CPU usage by mysql process
4302
Rick James
May 05, 2016 09:51PM
Re: High CPU usage by mysql process
3573
Szymon Lisowiec
May 06, 2016 09:33AM
Re: High CPU usage by mysql process
3221
Szymon Lisowiec
May 08, 2016 04:56PM
Re: High CPU usage by mysql process
2844
Rick James
May 09, 2016 08:57PM
Re: High CPU usage by mysql process
2907
Szymon Lisowiec
May 10, 2016 02:30PM
Re: High CPU usage by mysql process
2607
Rick James
May 10, 2016 05:56PM
Re: High CPU usage by mysql process
2512
Peter Brawley
May 10, 2016 07:59PM
Re: High CPU usage by mysql process
2620
Szymon Lisowiec
May 11, 2016 11:19AM
Re: High CPU usage by mysql process
2382
Shane Bester
May 08, 2016 04:18AM


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.