Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug12400341.result

raw
1 # Test for bug #12400341: INNODB CAN LEAVE ORPHAN IBD FILES AROUND
2 set @old_innodb_rollback_segments = @@innodb_rollback_segments;
3 set global innodb_rollback_segments=1;
4 show variables like "max_connections";
5 Variable_name Value
6 max_connections 10
7 show variables like "innodb_thread_concurrency";
8 Variable_name Value
9 innodb_thread_concurrency 0
10 show variables like "innodb_file_per_table";
11 Variable_name Value
12 innodb_file_per_table ON
13 show variables like "innodb_rollback_segments";
14 Variable_name Value
15 innodb_rollback_segments 1
16 show variables like "innodb_trx_rseg_n_slots_debug";
17 Variable_name Value
18 innodb_trx_rseg_n_slots_debug 5
19 drop database if exists mysqltest;
20 create database mysqltest;
21 CREATE TABLE mysqltest.transtable (id int unsigned NOT NULL PRIMARY KEY, val int DEFAULT 0) ENGINE=InnoDB;
22 select count(*) from information_schema.processlist;
23 count(*)
24 12
25 Warnings:
26 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
27 CREATE TABLE mysqltest.testtable (id int unsigned not null primary key) ENGINE=InnoDB;
28 ERROR HY000: Too many active concurrent transactions
29 select count(*) from information_schema.processlist;
30 count(*)
31 12
32 Warnings:
33 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
34 select count(*) from information_schema.processlist;
35 count(*)
36 12
37 Warnings:
38 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
39 drop database mysqltest;
40 set global innodb_rollback_segments = @old_innodb_rollback_segments;