swamper Posted September 7, 2006 Share Posted September 7, 2006 I just upgraded from 4.0.18 to 5.0.24a - some numbers in 'show status' appear to be correct but others are staying at zero and I'm really not understanding why...How can I have:[code]| Qcache_free_blocks | 4445 | | Qcache_free_memory | 17250328 | | Qcache_hits | 5552397 | | Qcache_inserts | 1395677 | | Qcache_lowmem_prunes | 15564 | | Qcache_not_cached | 17446 | | Qcache_queries_in_cache | 7215 | | Qcache_total_blocks | 19079 | | Questions | 8852772 | Table_locks_immediate | 2718043 | | Table_locks_waited | 33877 | [/code]with[code]| Bytes_received | 91 | | Bytes_sent | 86 | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 0 | | Select_range_check | 0 | | Select_scan | 1 | [/code]I'm confused... Quote Link to comment Share on other sites More sharing options...
fenway Posted September 7, 2006 Share Posted September 7, 2006 At some point this changed to show SESSION by default, instead of GLOBAL, or vice versa... I can never remember... specify the one you want explicitly. Quote Link to comment Share on other sites More sharing options...
swamper Posted September 7, 2006 Author Share Posted September 7, 2006 http://dev.mysql.com/doc/refman/5.0/en/show-status.htmlYou're right... I should've checked there first :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.