Debian Codegraph @

mysql-test/suite/galera/r/tmp_space_usage.result

raw
1 connection node_2;
2 connection node_1;
3 #
4 # MDEV-37808 "Local temporary space limit reached" on not so rare
5 # occasions
6 #
7 connection node_1;
8 set @@max_tmp_session_space_usage=1024*1024*1024;
9 create user foo;
10 grant all privileges on *.* to foo;
11 use test;
12 create table t1(a int, b varchar(1024)) engine=innodb;
13 insert into t1 select seq, repeat("a", 500) from seq_1_to_100;
14 create table t2(a int, b varchar(1024)) engine=myisam;
15 insert into t2 select seq, repeat("a", 500) from seq_1_to_100;
16 show status like "%tmp_space%";
17 Variable_name Value
18 Max_tmp_space_used 102054
19 Tmp_space_used 102054
20 use test;
21 select count(*) from t1;
22 count(*)
23 100
24 show status like "%tmp_space%";
25 Variable_name Value
26 Max_tmp_space_used 102054
27 Tmp_space_used 0
28 drop table t1,t2;
29 drop user foo;