~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/memcached_stats/r/query.result

  • Committer: Padraig O'Sullivan
  • Date: 2009-10-02 02:15:04 UTC
  • mto: This revision was merged to the branch mainline in revision 1167.
  • Revision ID: osullivan.padraig@gmail.com-20091002021504-6zho7rfkdhn0g1jy
Added a test suite for the memcached stats I_S tables. The test suite is
pretty simple at the moment.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
select * 
 
2
from information_schema.memcached_stats;
 
3
NAME    PORT_NUMBER     PROCESS_ID      UPTIME  TIME    VERSION POINTER_SIZE    RUSAGE_USER     RUSAGE_SYSTEM   CURRENT_ITEMS   TOTAL_ITEMS     BYTES   CURRENT_CONNECTIONS     TOTAL_CONNECTIONS       CONNECTION_STRUCTURES   GETS    SETS    HITS    MISSES  EVICTIONS       BYTES_READ      BYTES_WRITTEN   LIMIT_MAXBYTES  THREADS
 
4
select *
 
5
from information_schema.memcached_analysis;
 
6
SERVERS_ANALYZED        AVERAGE_ITEM_SIZE       NODE_WITH_MOST_MEM_CONSUMPTION  USED_BYTES      NODE_WITH_LEAST_FREE_SPACE      FREE_BYTES      NODE_WITH_LONGEST_UPTIME        LONGEST_UPTIME  POOL_WIDE_HIT_RATIO
 
7
select variable_name, variable_value
 
8
from information_schema.global_variables
 
9
where variable_name = 'memcached_stats_servers';
 
10
variable_name   variable_value
 
11
MEMCACHED_STATS_SERVERS 
 
12
set global memcached_stats_servers = 'localhost:11211';
 
13
select variable_name, variable_value
 
14
from information_schema.global_variables
 
15
where variable_name = 'memcached_stats_servers';
 
16
variable_name   variable_value
 
17
MEMCACHED_STATS_SERVERS localhost:11211