| 1 |
--source include/not_valgrind.inc |
| 2 |
--source include/have_innodb_default_undo_tablespaces.inc |
| 3 |
|
| 4 |
--echo # |
| 5 |
--echo # WL7943 Implement INFORMATION_SCHEMA.FILES |
| 6 |
--echo # |
| 7 |
|
| 8 |
--echo # Mysqld is initialized in this test with with: |
| 9 |
--echo # --innodb_rollback_segments=1 |
| 10 |
--echo # --bootstrap --innodb_page_size=32k |
| 11 |
--echo # 2 implicit and 6 explicit undo tablespaces |
| 12 |
|
| 13 |
CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu'; |
| 14 |
CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'undo_004.ibu'; |
| 15 |
CREATE UNDO TABLESPACE undo_005 ADD DATAFILE 'undo_005.ibu'; |
| 16 |
CREATE UNDO TABLESPACE undo_006 ADD DATAFILE 'undo_006.ibu'; |
| 17 |
CREATE UNDO TABLESPACE undo_007 ADD DATAFILE 'undo_007.ibu'; |
| 18 |
CREATE UNDO TABLESPACE undo_008 ADD DATAFILE 'undo_008.ibu'; |
| 19 |
|
| 20 |
--source suite/innodb_undo/include/i_s_files.inc |
| 21 |
|
| 22 |
--echo # Set all explicit undo tablespaces to inacitve. |
| 23 |
ALTER UNDO TABLESPACE undo_003 SET INACTIVE; |
| 24 |
ALTER UNDO TABLESPACE undo_004 SET INACTIVE; |
| 25 |
ALTER UNDO TABLESPACE undo_005 SET INACTIVE; |
| 26 |
ALTER UNDO TABLESPACE undo_006 SET INACTIVE; |
| 27 |
ALTER UNDO TABLESPACE undo_007 SET INACTIVE; |
| 28 |
ALTER UNDO TABLESPACE undo_008 SET INACTIVE; |
| 29 |
|
| 30 |
--echo # Wait for all explicit undo tablespaces to become empty. |
| 31 |
let $inactive_undo_space = undo_003; |
| 32 |
source include/wait_until_undo_space_is_empty.inc; |
| 33 |
let $inactive_undo_space = undo_004; |
| 34 |
source include/wait_until_undo_space_is_empty.inc; |
| 35 |
let $inactive_undo_space = undo_005; |
| 36 |
source include/wait_until_undo_space_is_empty.inc; |
| 37 |
let $inactive_undo_space = undo_006; |
| 38 |
source include/wait_until_undo_space_is_empty.inc; |
| 39 |
let $inactive_undo_space = undo_007; |
| 40 |
source include/wait_until_undo_space_is_empty.inc; |
| 41 |
let $inactive_undo_space = undo_008; |
| 42 |
source include/wait_until_undo_space_is_empty.inc; |
| 43 |
|
| 44 |
--echo # Drop all explicit undo tablespaces. |
| 45 |
DROP UNDO TABLESPACE undo_003; |
| 46 |
DROP UNDO TABLESPACE undo_004; |
| 47 |
DROP UNDO TABLESPACE undo_005; |
| 48 |
DROP UNDO TABLESPACE undo_006; |
| 49 |
DROP UNDO TABLESPACE undo_007; |
| 50 |
DROP UNDO TABLESPACE undo_008; |