source include/not_valgrind.inc; source include/have_memcached_plugin.inc; source include/not_windows.inc; SET @transaction_isolation= @@global.transaction_isolation; SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; # Create the memcached tables --disable_query_log source include/memcache_config.inc; --enable_query_log INSERT INTO cache_policies VALUES("cache_policy", "innodb_only", "innodb_only", "innodb_only", "innodb_only"); INSERT INTO config_options VALUES("separator", "|"); # describe table for memcache INSERT INTO containers VALUES ("desc_t1", "test", "t1", "c1", "c2", "c3", "c4", "c5", "PRIMARY"); USE test; CREATE TABLE t1 (c1 VARCHAR(32), c2 VARCHAR(1024), c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1)) ENGINE = INNODB; --disable_warnings # Tables must exist before plugin can be started! --let $memcached_address=127.0.0.1:11259 --source ../include/load_daemon_memcached_expecting_success.inc --enable_warnings --echo # We expect a warning to be printed from INSTALL PLUGIN. SHOW WARNINGS; UNINSTALL PLUGIN daemon_memcached; --source include/shutdown_mysqld.inc --echo # We expect a warning in error log to NOT be printed. let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err; let SEARCH_PATTERN='InnoDB Memcached Plugin' is deprecated; --source include/search_pattern.inc --let $restart_parameters=restart:--plugin-load="libmemcached.so" --daemon_memcached=OFF --source include/start_mysqld.inc --source include/shutdown_mysqld.inc --echo # We expect a warning in error log to NOT be printed. let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err; let SEARCH_PATTERN='InnoDB Memcached Plugin' is deprecated; --source include/search_pattern.inc --let $restart_parameters=restart:--plugin-load="libmemcached.so" --source include/start_mysqld.inc # Stop plugin before innodb_memcached configuration UNINSTALL PLUGIN daemon_memcached; --source include/shutdown_mysqld.inc --echo # We expect a warning in error log to be printed. let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err; let SEARCH_PATTERN='InnoDB Memcached Plugin' is deprecated; --source include/search_pattern.inc --let $restart_parameters=restart: --source include/start_mysqld.inc DROP TABLE t1; DROP DATABASE innodb_memcache;