1CREATE TABLE t1 ( 2c1 INT AUTO_INCREMENT, 3c2 GEOMETRY NOT NULL, 4PRIMARY KEY(c1), 5SPATIAL INDEX(c2) 6) ENGINE=INNODB; 7INSERT INTO t1(c2) VALUES(Point(1,1)); 8INSERT INTO t1(c2) VALUES(Point(2,2)); 9INSERT INTO t1(c2) VALUES(Point(3,3)); 10INSERT INTO t1(c2) VALUES(Point(4,4)); 11INSERT INTO t1(c2) VALUES(Point(5,5)); 12INSERT INTO t1(c2) VALUES(Point(6,6)); 13INSERT INTO t1(c2) VALUES(Point(7,7)); 14INSERT INTO t1(c2) VALUES(Point(8,8)); 15INSERT INTO t1(c2) VALUES(Point(9,9)); 16INSERT INTO t1(c2) SELECT c2 FROM t1; 17INSERT INTO t1(c2) SELECT c2 FROM t1; 18INSERT INTO t1(c2) SELECT c2 FROM t1; 19INSERT INTO t1(c2) SELECT c2 FROM t1; 20INSERT INTO t1(c2) SELECT c2 FROM t1; 21INSERT INTO t1(c2) SELECT c2 FROM t1; 22INSERT INTO t1(c2) SELECT c2 FROM t1; 23INSERT INTO t1(c2) SELECT c2 FROM t1; 24INSERT INTO t1(c2) SELECT c2 FROM t1; 25SELECT COUNT(*) FROM t1; 26COUNT(*) 274608 28SELECT @@innodb_sort_buffer_size; 29@@innodb_sort_buffer_size 3065536 31SET SESSION debug="+d,row_merge_instrument_log_check_flush"; 32ALTER TABLE t1 ADD COLUMN c3 INT; 33DROP TABLE t1; 34