1#
2# Bug #30607708	IF ANALYZE TABLE RUNS MORE THAN 600 SECONDS DIAGNOSTIC QUERY MAY CRASH SERVER
3#
4CREATE TABLE t1(a int, index inda(a)) ENGINE=INNODB;
5INSERT INTO t1 VALUES(1);
6SET DEBUG_SYNC='innodb_dict_stats_update_persistent SIGNAL analyze.running WAIT_FOR analyze.finish';
7ANALYZE TABLE t1;
8SET DEBUG_SYNC='now WAIT_FOR analyze.running';
9SELECT ENGINE,SUM(DATA_LENGTH+INDEX_LENGTH),COUNT(ENGINE),SUM(DATA_LENGTH),SUM(INDEX_LENGTH) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema', 'performance_schema', 'mysql') AND ENGINE='InnoDB';
10SET DEBUG_SYNC='now SIGNAL analyze.finish';
11Table	Op	Msg_type	Msg_text
12test.t1	analyze	status	OK
13SET DEBUG_SYNC= 'RESET';
14DROP TABLE t1;
15