Re: Dual Quad Core Xeon CPU but still high load
Posted by:
Ali Kiyani
Date: February 20, 2011 10:50PM
Thanks for taking interest in my problem. Here are the results:
SHOW VARIABLES LIKE 'query%';
+------------------------------+----------+
| Variable_name | Value |
+------------------------------+----------+
| query_alloc_block_size | 8192 |
| query_cache_limit | 67108864 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 67108864 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
+------------------------------+----------+
7 rows in set (0.00 sec)
SHOW GLOBAL STATUS LIKE 'Qc%';
+-------------------------+----------+
| Variable_name | Value |
+-------------------------+----------+
| Qcache_free_blocks | 1289 |
| Qcache_free_memory | 40701240 |
| Qcache_hits | 26186391 |
| Qcache_inserts | 5854315 |
| Qcache_lowmem_prunes | 3791539 |
| Qcache_not_cached | 94659 |
| Qcache_queries_in_cache | 9131 |
| Qcache_total_blocks | 20157 |
+-------------------------+----------+
8 rows in set (0.00 sec)
Subject
Views
Written By
Posted
3931
February 17, 2011 10:32AM
1105
February 19, 2011 08:53AM
1660
February 19, 2011 12:29PM
1309
February 20, 2011 09:56PM
Re: Dual Quad Core Xeon CPU but still high load
1143
February 20, 2011 10:50PM
1057
February 21, 2011 09:54AM
1151
February 21, 2011 09:20AM
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.