Page 1 of 1

SHOW STATUS LIKE Qcache?

Posted: Sat Feb 18, 2006 10:20 am
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?

Posted: Sat Feb 18, 2006 11:27 am
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];
}