| 1 |
--source include/have_debug_sync.inc |
| 2 |
|
| 3 |
--enable_warnings |
| 4 |
--enable_query_log |
| 5 |
|
| 6 |
# Create some non-LRU files so there exists the limit value that can't be set. |
| 7 |
let $i = 9; |
| 8 |
while ($i >= 0) |
| 9 |
{ |
| 10 |
let $sql = CREATE UNDO TABLESPACE undo_00$i ADD DATAFILE 'undo_00$i.ibu'; |
| 11 |
--eval $sql |
| 12 |
--dec $i |
| 13 |
} |
| 14 |
|
| 15 |
|
| 16 |
SET @start_global_value = @@GLOBAL.innodb_open_files; |
| 17 |
SELECT @start_global_value; |
| 18 |
|
| 19 |
SELECT innodb_set_open_files_limit(150); |
| 20 |
|
| 21 |
# |
| 22 |
# Set value concurrently. |
| 23 |
# |
| 24 |
--connect (con1,localhost,root,,) |
| 25 |
SET DEBUG_SYNC='fil_open_files_desired_limit_set SIGNAL started WAIT_FOR proceed'; |
| 26 |
--send SELECT innodb_set_open_files_limit(200); |
| 27 |
|
| 28 |
--connection default |
| 29 |
SET DEBUG_SYNC= 'now WAIT_FOR started'; |
| 30 |
--error ER_CONCURRENT_PROCEDURE_USAGE |
| 31 |
SELECT innodb_set_open_files_limit(250); |
| 32 |
SET DEBUG_SYNC= 'now SIGNAL proceed'; |
| 33 |
|
| 34 |
--connection con1 |
| 35 |
--reap |
| 36 |
--disconnect con1 |
| 37 |
--connection default |
| 38 |
SELECT @@GLOBAL.innodb_open_files; |
| 39 |
|
| 40 |
|
| 41 |
# |
| 42 |
# Cleanup |
| 43 |
# |
| 44 |
let $i = 9; |
| 45 |
while ($i >= 0) |
| 46 |
{ |
| 47 |
let $sql = ALTER UNDO TABLESPACE undo_00$i SET INACTIVE; |
| 48 |
--eval $sql |
| 49 |
--dec $i |
| 50 |
} |
| 51 |
|
| 52 |
let $i = 9; |
| 53 |
while ($i >= 0) |
| 54 |
{ |
| 55 |
let $inactive_undo_space = undo_00$i; |
| 56 |
source include/wait_until_undo_space_is_empty.inc; |
| 57 |
let $sql = DROP UNDO TABLESPACE undo_00$i; |
| 58 |
--eval $sql |
| 59 |
|
| 60 |
--dec $i |
| 61 |
} |
| 62 |
|
| 63 |
SELECT innodb_set_open_files_limit(@start_global_value); |
| 64 |
SELECT @@GLOBAL.innodb_open_files; |