Re: High CPU usage by mysql process
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`
Subject
Views
Written By
Posted
12655
May 04, 2016 03:32PM
4112
May 05, 2016 09:51PM
3339
May 06, 2016 09:33AM
3018
May 08, 2016 04:56PM
2653
May 09, 2016 08:57PM
Re: High CPU usage by mysql process
2714
May 10, 2016 02:30PM
2421
May 10, 2016 05:56PM
2342
May 10, 2016 07:59PM
2436
May 11, 2016 11:19AM
2169
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.