mirror of
https://github.com/MariaDB/server.git
synced 2025-04-21 22:55:35 +02:00
893472d005
The option innodb_rollback_segments was deprecated already in MariaDB Server 10.0. Its misleadingly named replacement innodb_undo_logs is of very limited use. It makes sense to always create and use the maximum number of rollback segments. Let us remove the deprecated parameter innodb_rollback_segments and deprecate&ignore the parameter innodb_undo_logs (to be removed in a later major release). This work involves some cleanup of InnoDB startup. Similar to other write operations, DROP TABLE will no longer be allowed if innodb_force_recovery is set to a value larger than 3.
28 lines
1.2 KiB
Text
28 lines
1.2 KiB
Text
call mtr.add_suppression("InnoDB: Warning: cannot find a free slot for an undo log. Do you have too*");
|
|
call mtr.add_suppression("\\[Warning\\] InnoDB: Cannot find a free slot for an undo log. Do you have too");
|
|
show variables like "max_connections";
|
|
Variable_name Value
|
|
max_connections 64
|
|
show variables like "innodb_thread_concurrency";
|
|
Variable_name Value
|
|
innodb_thread_concurrency 0
|
|
show variables like "innodb_file_per_table";
|
|
Variable_name Value
|
|
innodb_file_per_table ON
|
|
drop database if exists mysqltest;
|
|
create database mysqltest;
|
|
CREATE TABLE mysqltest.transtable (id int unsigned NOT NULL PRIMARY KEY, val int DEFAULT 0) ENGINE=InnoDB;
|
|
select count(*) from information_schema.processlist where command != 'Daemon';
|
|
count(*)
|
|
33
|
|
connection default;
|
|
CREATE TABLE mysqltest.testtable (id int unsigned not null primary key) ENGINE=InnoDB;
|
|
ERROR HY000: Can't create table `mysqltest`.`testtable` (errno: 177 "Too many active concurrent transactions")
|
|
select count(*) from information_schema.processlist where command != 'Daemon';
|
|
count(*)
|
|
33
|
|
connection default;
|
|
select count(*) from information_schema.processlist where command != 'Daemon';
|
|
count(*)
|
|
33
|
|
drop database mysqltest;
|