Debian Codegraph @

mysql-test/suite/ndb_ddl/drop_table_release_mdl.result

raw
1 # Create logfile group, tablespace, and table in the tablespace
2 CREATE LOGFILE GROUP lg1
3 ADD UNDOFILE 'lg1_undofile.dat'
4 INITIAL_SIZE 1M
5 UNDO_BUFFER_SIZE = 1M
6 ENGINE NDB;
7 CREATE TABLESPACE ts1
8 ADD DATAFILE 'ts1_datafile.dat'
9 USE LOGFILE GROUP lg1
10 INITIAL_SIZE 2M
11 ENGINE NDB;
12 CREATE TABLE t10 (
13 a INT PRIMARY KEY,
14 b VARCHAR(255)
15 ) ENGINE NDB
16 TABLESPACE ts1
17 STORAGE DISK;
18 # Drop the table, this caused problem on participant which didn't
19 # release an MDL lock in TRANSACTIONAL scope
20 DROP TABLE t10;
21 # mysqld2> Run query accessing the tablespace where t10 was located
22 SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE, EXTRA
23 FROM INFORMATION_SCHEMA.FILES
24 WHERE FILE_TYPE = 'UNDO LOG'
25 AND FILE_NAME IS NOT NULL
26 AND LOGFILE_GROUP_NAME IS NOT NULL
27 ORDER BY LOGFILE_GROUP_NAME;
28 LOGFILE_GROUP_NAME FILE_NAME TOTAL_EXTENTS INITIAL_SIZE ENGINE EXTRA
29 lg1 ./lg1_undofile.dat 262144 1048576 ndbcluster UNDO_BUFFER_SIZE=1048576
30 # Cleanup
31 ALTER TABLESPACE ts1
32 DROP DATAFILE 'ts1_datafile.dat';
33 DROP TABLESPACE ts1;
34 DROP LOGFILE GROUP lg1 ENGINE NDB;