SHOW STATUS LIKE Qcache?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jasondavis
Forum Commoner
Posts: 60
Joined: Sat Feb 04, 2006 5:35 pm

SHOW STATUS LIKE Qcache?

Post by jasondavis »

I can run

Code: Select all

SHOW STATUS LIKE 'Qcache%';


in phpmyadmin and it works but shows values as being a Blob so how can I get the result on a php page?
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post by raghavan20 »

i have seen the results to be like this...

Code: Select all

Variable_name  Value  
      Qcache_free_blocks 0 
      Qcache_free_memory 0 
      Qcache_hits 0 
      Qcache_inserts 0 
      Qcache_lowmem_prunes 0 
      Qcache_not_cached 0 
      Qcache_queries_in_cache 0 
      Qcache_total_blocks 0
it should not be a problem for you to loop over the existing results for two fields...

Code: Select all

while ($row = mysql_fetch_row($result)){
echo $row[0]."--".$row[1];
}
Post Reply