SET @tmp_query_cache_size = @@query_cache_size;
SET GLOBAL query_cache_size = 1048576;
DROP TABLE IF EXISTS simple_table;
CREATE TABLE simple_table (
id INT PRIMARY KEY
) COMMENT = 'ENGINE "InnoDB"' DEFAULT CHARSET=UTF8;
SHOW CREATE TABLE simple_table;
Table	Create Table
simple_table	CREATE TABLE `simple_table` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=mroonga DEFAULT CHARSET=utf8 COMMENT='ENGINE "InnoDB"'
INSERT INTO simple_table (id) VALUES (1),(2);
USE test;
START TRANSACTION;
INSERT INTO simple_table (id) VALUES (3);
SELECT * FROM simple_table;
id
1
2
COMMIT;
SELECT * FROM simple_table;
id
1
2
3
DROP TABLE simple_table;
SET GLOBAL query_cache_size = @tmp_query_cache_size;
