Jump to content


Photo

SHOW STATUS not updating certain stats - very odd


  • Please log in to reply
2 replies to this topic

#1 swamper

swamper
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 07 September 2006 - 07:10 PM

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:

| 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      |

with

| 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          |

I'm confused...

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 07 September 2006 - 07:28 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 swamper

swamper
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 07 September 2006 - 08:40 PM

http://dev.mysql.com...how-status.html

You're right... I should've checked there first :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users