--source include/have_innodb_max_16k.inc SET GLOBAL innodb_change_buffering=all; SELECT @@global.innodb_change_buffering; CREATE TABLE t1(f1 POINT NOT NULL); INSERT INTO t1 VALUES (POINT(15, 20)); INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; SELECT COUNT(*) FROM t1; CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table SELECT * FROM t1 LIMIT 366; CREATE SPATIAL INDEX k1 ON tmp_table(f1); DROP TABLE t1; SET GLOBAL innodb_change_buffering=default;