MySQL Forums
Forum List  »  InnoDB

Re: High CPU usage by mysql process
Posted by: Szymon Lisowiec
Date: May 10, 2016 02:30PM

SHOW VARIABLES LIKE 'query%';
Result:
query_alloc_block_size = 8192
query_cache_limit = 17179869184
query_cache_min_res_unit = 4096
query_cache_size = 68719476736
query_cache_type = ON
query_cache_wlock_invalidate = OFF
query_prealloc_size = 8192


EXPLAIN SELECT `id`, `userid`, `itemid`, `token` FROM `orders` WHERE `status`='active' AND `nr`=2 ORDER BY `id` DESC
Result:
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra
1 | SIMPLE | orders |ref | status,nr,selectingByStatus | selectingByStatus | 56 | const,const | 40 | U

index selectingByStatus = for columns `status` and `nr`

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: High CPU usage by mysql process
2200
May 10, 2016 02:30PM


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.