SET @transaction_isolation= @@global.transaction_isolation; SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; INSERT INTO cache_policies VALUES("cache_policy", "innodb_only", "innodb_only", "innodb_only", "innodb_only"); INSERT INTO config_options VALUES("separator", "|"); 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; INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so'; # We expect a warning to be printed from INSTALL PLUGIN. SHOW WARNINGS; Level Code Message Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release. UNINSTALL PLUGIN daemon_memcached; # We expect a warning in error log to NOT be printed. Pattern "'InnoDB Memcached Plugin' is deprecated" not found # restart:--plugin-load=libmemcached.so --daemon_memcached=OFF # We expect a warning in error log to NOT be printed. Pattern "'InnoDB Memcached Plugin' is deprecated" not found # restart:--plugin-load=libmemcached.so UNINSTALL PLUGIN daemon_memcached; # We expect a warning in error log to be printed. Pattern "'InnoDB Memcached Plugin' is deprecated" found # restart: DROP TABLE t1; DROP DATABASE innodb_memcache;