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... Link to comment https://forums.phpfreaks.com/topic/20041-show-status-not-updating-certain-stats-very-odd/ 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. Link to comment https://forums.phpfreaks.com/topic/20041-show-status-not-updating-certain-stats-very-odd/#findComment-87938 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 :) Link to comment https://forums.phpfreaks.com/topic/20041-show-status-not-updating-certain-stats-very-odd/#findComment-87977 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.