MySQL Forums
Forum List  »  Performance

Re: Query optimization needed
Posted by: Devrishi Shandilya
Date: November 06, 2015 11:25PM

Hi Peter,

Thanks for reply, my first concern is this, in execution phase it's taking huge time in 'storing resultset in query cache', but i think it never cached, because when it comes again it again showing storing result in query cache, not served from query cache. can you explain me this behavior. I have already run flush query cache and reset query cache. my query cache setting are :

query_cache_min_res_unit = 1024
query_cache_limit = 512000
query_cache_size = 800M
query_cache_type = 1

I am using mysql 5.6 with 64 GB RAM and SSD.

Global status of query cache variables

mysql> show global status like '%qcache%';
+-------------------------+-----------+
| Variable_name | Value |
+-------------------------+-----------+
| Qcache_free_blocks | 1591 |
| Qcache_free_memory | 811144744 |
| Qcache_hits | 53953728 |
| Qcache_inserts | 189434597 |
| Qcache_lowmem_prunes | 132186957 |
| Qcache_not_cached | 19409636 |
| Qcache_queries_in_cache | 7414 |
| Qcache_total_blocks | 16881 |
+-------------------------+-----------+

Second concern is if i have turned left joins to inner joins, even after that row_examined is same. Can it be optimize further with Inner joins. suggest...

Devrishi

Options: ReplyQuote


Subject
Views
Written By
Posted
1848
November 05, 2015 01:42AM
717
November 05, 2015 11:40PM
Re: Query optimization needed
822
November 06, 2015 11:25PM
864
November 08, 2015 04:32PM
787
November 17, 2015 05:43AM
798
November 26, 2015 09:21PM


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.