mysql> SHOW GLOBAL STATUS LIKE 'qc%';
+-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| Qcache_free_blocks | 1 |
| Qcache_free_memory | 4289872288 |
| Qcache_hits | 9583 |
| Qcache_inserts | 1969 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 1047 |
| Qcache_queries_in_cache | 1969 |
| Qcache_total_blocks | 4295 |
+-------------------------+------------+
Not sure if the numbers are useful as I had restarted the server to run tests. We are making use of QC where ever possible.
We have apache running on the box. But I thought on a single query mysql only uses 1 core anyway?
The data is inserted in the order of x,y,year,month. I did an ALTER tbl ORDER BY x,y,year,month and OPTIMIZE TABLE tbl hoping it will solve the problem. It helped but not a significant amount.
year is typically 30 years range. x,y varies. We are dealing with climate data. temperature, wind, solar radiation, etc