1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
#
# perform a query on the memcached I_S statistics tables before the
# memcached related system variable has been set. Both of these queries
# should return 0 rows
#
--exec sh $MYSQLTEST_VARDIR/../../plugin/memcached_functions/start_mc.sh stop
--exec sh $MYSQLTEST_VARDIR/../../plugin/memcached_functions/start_mc.sh start
--disable_warnings
create schema if not exists data_dictionary;
--enable_warnings
--error 1105
select * from data_dictionary.memcached_stats;
#
# Look at the current value of the memcached related system variable
#
select variable_name, variable_value
from data_dictionary.global_variables
where variable_name = 'memcached_stats_servers';
#
# Now try setting it to a certain value
#
--replace_result $MC_PORT MC_A_PORT
--eval set global memcached_stats_servers = 'localhost:$MC_PORT';
#
# make sure the system variable has been updated
#
--replace_column 2 #
select variable_name, variable_value
from data_dictionary.global_variables
where variable_name = 'memcached_stats_servers';
--replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 13 # 14 # 15 # 21 # 22 # 23 # 24 # 25 #
select *
from data_dictionary.memcached_stats;
#
# Once the ability to created an embedded server has been added to
# memcached, we will actually start up an embedded server and perform some
# queries on it here...
#
--exec sh $MYSQLTEST_VARDIR/../../plugin/memcached_functions/start_mc.sh stop
|