| 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; |