Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 3.139.234.66
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
innodb /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
add_foreign_key.test
1.35
KB
-rw-r--r--
alter_crash.test
6.71
KB
-rw-r--r--
alter_foreign_crash.test
956
B
-rw-r--r--
alter_kill-master.opt
68
B
-rw-r--r--
alter_kill.test
5.1
KB
-rw-r--r--
alter_missing_tablespace.test
3.05
KB
-rw-r--r--
alter_page_size.test
705
B
-rw-r--r--
alter_rename_existing.test
5.49
KB
-rw-r--r--
alter_rename_files.test
746
B
-rw-r--r--
alter_row_format.test
1.47
KB
-rw-r--r--
alter_table_redundant.test
481
B
-rw-r--r--
alter_table_stage_progress-mas...
53
B
-rw-r--r--
alter_table_stage_progress.tes...
1.04
KB
-rw-r--r--
analyze_index.test
994
B
-rw-r--r--
analyze_table.test
896
B
-rw-r--r--
attachable_trx.test
3.32
KB
-rw-r--r--
autoinc_debug.test
2.14
KB
-rw-r--r--
blob-crash-16k.test
2.66
KB
-rw-r--r--
blob-crash-4k.test
2.76
KB
-rw-r--r--
blob-crash.test
5.95
KB
-rw-r--r--
blob-update-debug.test
525
B
-rw-r--r--
blob_page_reserve.test
3.73
KB
-rw-r--r--
blob_redo-master.opt
57
B
-rw-r--r--
blob_redo.test
1.71
KB
-rw-r--r--
buf_pool_resize_oom-master.opt
37
B
-rw-r--r--
buf_pool_resize_oom.test
1.72
KB
-rw-r--r--
bulk_create_index_online.test
1.96
KB
-rw-r--r--
cascade_lock_wait.test
1014
B
-rw-r--r--
check_ibd_filesize_16k.test
1.89
KB
-rw-r--r--
check_sector_size-master.opt
125
B
-rw-r--r--
check_sector_size.test
1.95
KB
-rw-r--r--
checksum.test
681
B
-rw-r--r--
cmp_per_index-master.opt
63
B
-rw-r--r--
cmp_per_index.test
2.5
KB
-rw-r--r--
crc32_endianness.test
1.67
KB
-rw-r--r--
crc32_endianness.zip
1.86
KB
-rw-r--r--
create-index.test
314
B
-rw-r--r--
create_isl_with_direct-master....
31
B
-rw-r--r--
create_isl_with_direct.test
1.1
KB
-rw-r--r--
create_table.test
1.33
KB
-rw-r--r--
create_tablespace.test
36.63
KB
-rw-r--r--
create_tablespace_16k.test
26.23
KB
-rw-r--r--
create_tablespace_32k.test
3.97
KB
-rw-r--r--
create_tablespace_4k.test
14.72
KB
-rw-r--r--
create_tablespace_64k.test
4.12
KB
-rw-r--r--
create_tablespace_8k.test
19.2
KB
-rw-r--r--
create_tablespace_debug.test
3.97
KB
-rw-r--r--
create_tablespace_notembedded....
670
B
-rw-r--r--
create_tablespace_partition.te...
10.38
KB
-rw-r--r--
create_tablespace_replication....
1.76
KB
-rw-r--r--
deadlock_detect.test
921
B
-rw-r--r--
default_row_format.test
1.62
KB
-rw-r--r--
default_row_format_16k.test
9.49
KB
-rw-r--r--
default_row_format_compatibili...
5.75
KB
-rw-r--r--
default_row_format_tablespace....
1.16
KB
-rw-r--r--
deprecate_part_in_shared_ts.te...
4.38
KB
-rw-r--r--
disabled.def
404
B
-rw-r--r--
doublewrite.test
10.88
KB
-rw-r--r--
dropdb.test
251
B
-rw-r--r--
end_range_check.test
3.2
KB
-rw-r--r--
end_range_check_2.test
1.25
KB
-rw-r--r--
events-merge-tmp-path-master.o...
149
B
-rw-r--r--
events-merge-tmp-path.test
1.65
KB
-rw-r--r--
file_format_defaults-master.op...
122
B
-rw-r--r--
file_format_defaults.test
2.14
KB
-rw-r--r--
file_format_upgrade_16k.test
1.91
KB
-rw-r--r--
flush-hang.test
1.51
KB
-rw-r--r--
foreign_key.test
7.61
KB
-rw-r--r--
fts_exec_interrupt.test
961
B
-rw-r--r--
help_verbose.test
1.01
KB
-rw-r--r--
high_prio_trx_1.test
1.24
KB
-rw-r--r--
high_prio_trx_2.test
1.3
KB
-rw-r--r--
high_prio_trx_3.test
1.86
KB
-rw-r--r--
high_prio_trx_4.test
1.5
KB
-rw-r--r--
high_prio_trx_5.test
2.24
KB
-rw-r--r--
high_prio_trx_6.test
2
KB
-rw-r--r--
high_prio_trx_7.test
11.13
KB
-rw-r--r--
high_prio_trx_commit_crash.tes...
2.05
KB
-rw-r--r--
high_prio_trx_debug.test
1.6
KB
-rw-r--r--
high_prio_trx_fk.test
1.42
KB
-rw-r--r--
high_prio_trx_predicate.test
1.41
KB
-rw-r--r--
high_prio_trx_rpl.test
1.95
KB
-rw-r--r--
i_s_files_debug.test
751
B
-rw-r--r--
ibuf_not_empty-master.opt
30
B
-rw-r--r--
ibuf_not_empty.test
1.67
KB
-rw-r--r--
import.test
763
B
-rw-r--r--
import_compress_encrypt.test
6.84
KB
-rw-r--r--
import_compress_encrypt_upgrad...
2.46
KB
-rw-r--r--
import_export_4k.test
1.06
KB
-rw-r--r--
import_tablespace_page_corrupt...
1.2
KB
-rw-r--r--
import_tablespace_schema_missm...
3.56
KB
-rw-r--r--
import_update_stats.test
1.46
KB
-rw-r--r--
index-online-norebuild.test
1.8
KB
-rw-r--r--
index_length.test
1.28
KB
-rw-r--r--
index_merge_threshold.test
6.25
KB
-rw-r--r--
index_tree_operation.test
2.36
KB
-rw-r--r--
innodb-2byte-collation-master....
48
B
-rw-r--r--
innodb-2byte-collation.test
2.95
KB
-rw-r--r--
innodb-ac-non-locking-select.t...
3
KB
-rw-r--r--
innodb-alter-autoinc.test
2.53
KB
-rw-r--r--
innodb-alter-debug-wl6554-mast...
21
B
-rw-r--r--
innodb-alter-debug-wl6554.test
8.65
KB
-rw-r--r--
innodb-alter-debug.test
2.68
KB
-rw-r--r--
innodb-alter-nullable.test
1.93
KB
-rw-r--r--
innodb-alter-wl6554.test
2.26
KB
-rw-r--r--
innodb-alter.test
15.61
KB
-rw-r--r--
innodb-analyze.test
1.65
KB
-rw-r--r--
innodb-autoinc-18274.test
661
B
-rw-r--r--
innodb-autoinc-44030-master.op...
81
B
-rw-r--r--
innodb-autoinc-44030.test
1.61
KB
-rw-r--r--
innodb-autoinc-56228-master.op...
29
B
-rw-r--r--
innodb-autoinc-56228.test
784
B
-rw-r--r--
innodb-autoinc-master.opt
81
B
-rw-r--r--
innodb-autoinc-optimize.test
432
B
-rw-r--r--
innodb-autoinc.test
26.79
KB
-rw-r--r--
innodb-blob.test
6.62
KB
-rw-r--r--
innodb-bug-14068765.test
2.97
KB
-rw-r--r--
innodb-bug-14084530.test
966
B
-rw-r--r--
innodb-bug12552164.test
1.46
KB
-rw-r--r--
innodb-bug14219515.test
472
B
-rw-r--r--
innodb-change-buffer-recovery-...
92
B
-rw-r--r--
innodb-change-buffer-recovery....
2.3
KB
-rw-r--r--
innodb-consistent-master.opt
29
B
-rw-r--r--
innodb-consistent.test
1.24
KB
-rw-r--r--
innodb-import-partition-rpl.te...
3.46
KB
-rw-r--r--
innodb-import-partition.test
9.51
KB
-rw-r--r--
innodb-index-debug-master.opt
30
B
-rw-r--r--
innodb-index-debug.test
4.39
KB
-rw-r--r--
innodb-index-master.opt
30
B
-rw-r--r--
innodb-index-online-delete.tes...
1.06
KB
-rw-r--r--
innodb-index-online-fk.test
15.6
KB
-rw-r--r--
innodb-index-online-master.opt
127
B
-rw-r--r--
innodb-index-online-purge.test
2.07
KB
-rw-r--r--
innodb-index-online.test
13.83
KB
-rw-r--r--
innodb-index.test
33.48
KB
-rw-r--r--
innodb-index_ucs2.test
124
B
-rw-r--r--
innodb-isolation.test
11.03
KB
-rw-r--r--
innodb-large-prefix.test
1.13
KB
-rw-r--r--
innodb-lock-inherit-read_commi...
2.58
KB
-rw-r--r--
innodb-lock.test
4.86
KB
-rw-r--r--
innodb-master.opt
136
B
-rw-r--r--
innodb-multiple-tablespaces.te...
18.21
KB
-rw-r--r--
innodb-read-view.test
4.52
KB
-rw-r--r--
innodb-replace-debug.test
399
B
-rw-r--r--
innodb-semi-consistent-master....
29
B
-rw-r--r--
innodb-semi-consistent.test
1.83
KB
-rw-r--r--
innodb-status-output.test
2.86
KB
-rw-r--r--
innodb-system-table-view.test
5.99
KB
-rw-r--r--
innodb-table-online-master.opt
126
B
-rw-r--r--
innodb-table-online.test
11.63
KB
-rw-r--r--
innodb-timeout.test
3.63
KB
-rw-r--r--
innodb-truncate-debug.test
5.27
KB
-rw-r--r--
innodb-truncate.test
2.03
KB
-rw-r--r--
innodb-ucs2.test
11.43
KB
-rw-r--r--
innodb-update-insert.test
848
B
-rw-r--r--
innodb-wl5522-1.test
145
B
-rw-r--r--
innodb-wl5522-debug.test
31
KB
-rw-r--r--
innodb-wl5522.test
20.25
KB
-rw-r--r--
innodb-wl5980-alter.test
18.47
KB
-rw-r--r--
innodb-wl5980-debug.test
2.58
KB
-rw-r--r--
innodb-wl5980-discard.test
23.6
KB
-rw-r--r--
innodb-wl5980-linux-master.opt
28
B
-rw-r--r--
innodb-wl5980-linux.test
7.75
KB
-rw-r--r--
innodb-wl5980-windows-master.o...
28
B
-rw-r--r--
innodb-wl5980-windows.test
8.42
KB
-rw-r--r--
innodb-wl6045-1-master.opt
77
B
-rw-r--r--
innodb-wl6045-1.test
6.84
KB
-rw-r--r--
innodb-wl6045-linux.test
12.82
KB
-rw-r--r--
innodb-wl6445-1.test
21.96
KB
-rw-r--r--
innodb-wl6445-2.test
7.4
KB
-rw-r--r--
innodb-wl6445.test
2.3
KB
-rw-r--r--
innodb.test
79.88
KB
-rw-r--r--
innodb_32k.test
198
B
-rw-r--r--
innodb_64k-master.opt
29
B
-rw-r--r--
innodb_64k.test
663
B
-rw-r--r--
innodb_autoinc_lock_mode_zero-...
29
B
-rw-r--r--
innodb_autoinc_lock_mode_zero....
1.1
KB
-rw-r--r--
innodb_autoinc_reset.test
519
B
-rw-r--r--
innodb_buffer_pool_dump_pct.te...
4.74
KB
-rw-r--r--
innodb_buffer_pool_load-master...
30
B
-rw-r--r--
innodb_buffer_pool_load.test
7.62
KB
-rw-r--r--
innodb_buffer_pool_load_now-ma...
113
B
-rw-r--r--
innodb_buffer_pool_load_now.te...
5.88
KB
-rw-r--r--
innodb_buffer_pool_resize-mast...
29
B
-rw-r--r--
innodb_buffer_pool_resize.test
2.26
KB
-rw-r--r--
innodb_buffer_pool_resize_debu...
64
B
-rw-r--r--
innodb_buffer_pool_resize_debu...
7.37
KB
-rw-r--r--
innodb_buffer_pool_resize_with...
65
B
-rw-r--r--
innodb_buffer_pool_resize_with...
2.06
KB
-rw-r--r--
innodb_bug-13628249.test
2.26
KB
-rw-r--r--
innodb_bug11754376.test
406
B
-rw-r--r--
innodb_bug11766634-master.opt
16
B
-rw-r--r--
innodb_bug11766634.test
1.82
KB
-rw-r--r--
innodb_bug11789106.test
546
B
-rw-r--r--
innodb_bug11933790.test
928
B
-rw-r--r--
innodb_bug12400341-master.opt
75
B
-rw-r--r--
innodb_bug12400341.test
2.65
KB
-rw-r--r--
innodb_bug12429573.test
1.4
KB
-rw-r--r--
innodb_bug12661768.test
2.03
KB
-rw-r--r--
innodb_bug14006907.test
1.38
KB
-rw-r--r--
innodb_bug14007109.test
1.19
KB
-rw-r--r--
innodb_bug14007649.test
1.1
KB
-rw-r--r--
innodb_bug14147491-master.opt
103
B
-rw-r--r--
innodb_bug14147491.test
2.76
KB
-rw-r--r--
innodb_bug14169459.test
1.96
KB
-rw-r--r--
innodb_bug14676111.test
3.92
KB
-rw-r--r--
innodb_bug14704286.test
2.03
KB
-rw-r--r--
innodb_bug19164038-master.opt
30
B
-rw-r--r--
innodb_bug19164038.test
1.27
KB
-rw-r--r--
innodb_bug21704.test
1.66
KB
-rw-r--r--
innodb_bug30113362.test
6.65
KB
-rw-r--r--
innodb_bug30423.test
6.45
KB
-rw-r--r--
innodb_bug30594501-master.opt
31
B
-rw-r--r--
innodb_bug30594501.test
552
B
-rw-r--r--
innodb_bug30919-master.opt
29
B
-rw-r--r--
innodb_bug30919.test
2.31
KB
-rw-r--r--
innodb_bug31205266.test
1.56
KB
-rw-r--r--
innodb_bug34053.test
1.6
KB
-rw-r--r--
innodb_bug34300.test
881
B
-rw-r--r--
innodb_bug35220.test
416
B
-rw-r--r--
innodb_bug38231.test
1.64
KB
-rw-r--r--
innodb_bug39438-master.opt
26
B
-rw-r--r--
innodb_bug39438.test
2.19
KB
-rw-r--r--
innodb_bug40360.test
340
B
-rw-r--r--
innodb_bug40565.test
327
B
-rw-r--r--
innodb_bug41904.test
328
B
-rw-r--r--
innodb_bug42101-nonzero-master...
30
B
-rw-r--r--
innodb_bug42101-nonzero.test
653
B
-rw-r--r--
innodb_bug42101.test
577
B
-rw-r--r--
innodb_bug42419.test
2.19
KB
-rw-r--r--
innodb_bug44032.test
543
B
-rw-r--r--
innodb_bug44369.test
530
B
-rw-r--r--
innodb_bug44571.test
788
B
-rw-r--r--
innodb_bug45357.test
326
B
-rw-r--r--
innodb_bug46000.test
941
B
-rw-r--r--
innodb_bug46676.test
602
B
-rw-r--r--
innodb_bug47167-master.opt
16
B
-rw-r--r--
innodb_bug47167.test
1.41
KB
-rw-r--r--
innodb_bug47621.test
1.79
KB
-rw-r--r--
innodb_bug47622.test
1.58
KB
-rw-r--r--
innodb_bug47777.test
972
B
-rw-r--r--
innodb_bug48024.test
863
B
-rw-r--r--
innodb_bug49164.test
928
B
-rw-r--r--
innodb_bug51378.test
2.53
KB
-rw-r--r--
innodb_bug51920.test
988
B
-rw-r--r--
innodb_bug52199.test
210
B
-rw-r--r--
innodb_bug52663.test
1003
B
-rw-r--r--
innodb_bug53046.test
1.13
KB
-rw-r--r--
innodb_bug53290.test
840
B
-rw-r--r--
innodb_bug53592.test
2.6
KB
-rw-r--r--
innodb_bug53674-master.opt
65
B
-rw-r--r--
innodb_bug53674.test
259
B
-rw-r--r--
innodb_bug53756-master.opt
36
B
-rw-r--r--
innodb_bug53756.test
4.62
KB
-rw-r--r--
innodb_bug54044.test
606
B
-rw-r--r--
innodb_bug56143.test
74.27
KB
-rw-r--r--
innodb_bug56716.test
268
B
-rw-r--r--
innodb_bug56947.test
472
B
-rw-r--r--
innodb_bug57252.test
1.27
KB
-rw-r--r--
innodb_bug57255.test
889
B
-rw-r--r--
innodb_bug57904.test
908
B
-rw-r--r--
innodb_bug59307.test
633
B
-rw-r--r--
innodb_bug59410.test
926
B
-rw-r--r--
innodb_bug59641.test
1.17
KB
-rw-r--r--
innodb_bug59733.test
2
KB
-rw-r--r--
innodb_bug60049-master.opt
25
B
-rw-r--r--
innodb_bug60049.test
1.76
KB
-rw-r--r--
innodb_bug60196-master.opt
27
B
-rw-r--r--
innodb_bug60196.test
3.15
KB
-rw-r--r--
innodb_bug60229.test
1.34
KB
-rw-r--r--
innodb_bug70867.test
1.29
KB
-rw-r--r--
innodb_bulk_create_index.test
1.89
KB
-rw-r--r--
innodb_bulk_create_index_debug...
651
B
-rw-r--r--
innodb_bulk_create_index_flush...
1.34
KB
-rw-r--r--
innodb_bulk_create_index_repli...
4.66
KB
-rw-r--r--
innodb_bulk_create_index_small...
2.81
KB
-rw-r--r--
innodb_corrupt_bit.test
2.67
KB
-rw-r--r--
innodb_corrupt_readonly.test
1.34
KB
-rw-r--r--
innodb_ctype_ldml-master.opt
80
B
-rw-r--r--
innodb_ctype_ldml.test
15.36
KB
-rw-r--r--
innodb_deadlock_with_autoinc-m...
29
B
-rw-r--r--
innodb_deadlock_with_autoinc.t...
1.22
KB
-rw-r--r--
innodb_file_format-master.opt
16
B
-rw-r--r--
innodb_file_format.test
1.32
KB
-rw-r--r--
innodb_file_limit_check.test
829
B
-rw-r--r--
innodb_force_recovery.test
3.19
KB
-rw-r--r--
innodb_fts_limit_check.test
891
B
-rw-r--r--
innodb_i_s_innodb_locks.test
4.54
KB
-rw-r--r--
innodb_i_s_innodb_trx.test
2.36
KB
-rw-r--r--
innodb_information_schema_buff...
2.39
KB
-rw-r--r--
innodb_io_pf.test
398
B
-rw-r--r--
innodb_lock_wait_timeout_1-mas...
29
B
-rw-r--r--
innodb_lock_wait_timeout_1.tes...
8.06
KB
-rw-r--r--
innodb_misc1-master.opt
55
B
-rw-r--r--
innodb_misc1.test
31.97
KB
-rw-r--r--
innodb_multi_update.test
2.04
KB
-rw-r--r--
innodb_mysql-master.opt
82
B
-rw-r--r--
innodb_mysql.test
27.09
KB
-rw-r--r--
innodb_mysql_rbk-master.opt
60
B
-rw-r--r--
innodb_mysql_rbk.test
849
B
-rw-r--r--
innodb_notembedded.test
1.13
KB
-rw-r--r--
innodb_page_size_func.test
11.26
KB
-rw-r--r--
innodb_pagesize_max_recordsize...
17.3
KB
-rw-r--r--
innodb_prefix_index_check.test
1.25
KB
-rw-r--r--
innodb_prefix_index_restart_se...
3.51
KB
-rw-r--r--
innodb_rename_index.test
16.76
KB
-rw-r--r--
innodb_rename_index_err.test
2.01
KB
-rw-r--r--
innodb_replace.test
5.42
KB
-rw-r--r--
innodb_row_log_read.test
1.42
KB
-rw-r--r--
innodb_stats.test
1.89
KB
-rw-r--r--
innodb_stats_auto_recalc.test
1.76
KB
-rw-r--r--
innodb_stats_auto_recalc_ddl.t...
1.65
KB
-rw-r--r--
innodb_stats_auto_recalc_lots....
932
B
-rw-r--r--
innodb_stats_auto_recalc_on_no...
1.87
KB
-rw-r--r--
innodb_stats_create_on_corrupt...
1.32
KB
-rw-r--r--
innodb_stats_create_table.test
1.43
KB
-rw-r--r--
innodb_stats_del_mark-master.o...
40
B
-rw-r--r--
innodb_stats_del_mark.test
3.6
KB
-rw-r--r--
innodb_stats_drop_locked.test
1.41
KB
-rw-r--r--
innodb_stats_external_pages.te...
2.62
KB
-rw-r--r--
innodb_stats_fetch.test
2.13
KB
-rw-r--r--
innodb_stats_fetch_corrupted.t...
1.64
KB
-rw-r--r--
innodb_stats_fetch_nonexistent...
1.14
KB
-rw-r--r--
innodb_stats_flag_global_off-m...
28
B
-rw-r--r--
innodb_stats_flag_global_off.t...
324
B
-rw-r--r--
innodb_stats_flag_global_on-ma...
28
B
-rw-r--r--
innodb_stats_flag_global_on.te...
323
B
-rw-r--r--
innodb_stats_rename_table.test
1.25
KB
-rw-r--r--
innodb_stats_rename_table_if_e...
1.43
KB
-rw-r--r--
innodb_stats_sample_pages.test
1.72
KB
-rw-r--r--
innodb_stats_table_flag_auto_r...
2.23
KB
-rw-r--r--
innodb_stats_table_flag_sample...
2.73
KB
-rw-r--r--
innodb_sys_var_valgrind.test
1.99
KB
-rw-r--r--
innodb_tablespace.test
13.91
KB
-rw-r--r--
innodb_tablespace_zip.test
1.32
KB
-rw-r--r--
innodb_thread_concurrency_debu...
1.16
KB
-rw-r--r--
innodb_timeout_rollback-master...
58
B
-rw-r--r--
innodb_timeout_rollback.test
108
B
-rw-r--r--
innodb_trx_weight.test
3.72
KB
-rw-r--r--
innodb_upd_stats_if_needed_not...
1.04
KB
-rw-r--r--
innodb_ut_format_name.test
298
B
-rw-r--r--
innodb_wl6326.test
14.46
KB
-rw-r--r--
innodb_wl6326_big.test
24.37
KB
-rw-r--r--
innodb_wl6469_1.test
2.08
KB
-rw-r--r--
innodb_wl6469_debug.test
2.94
KB
-rw-r--r--
innodb_wl6470.test
4.42
KB
-rw-r--r--
innodb_wl6470_debug.test
1.78
KB
-rw-r--r--
innodb_wl6501_crash_1.test
798
B
-rw-r--r--
innodb_wl6501_crash_2.test
798
B
-rw-r--r--
innodb_wl6501_crash_6.test
713
B
-rw-r--r--
innodb_wl6501_crash_7.test
713
B
-rw-r--r--
innodb_wl6501_crash_8.test
2.39
KB
-rw-r--r--
innodb_wl6560_1.test
11.71
KB
-rw-r--r--
innodb_wl6560_debug.test
5.9
KB
-rw-r--r--
innodb_wl6915.test
3.99
KB
-rw-r--r--
innodb_wl6915_debug.test
5.43
KB
-rw-r--r--
innodb_wl8114.test
1.52
KB
-rw-r--r--
insert_debug.test
1.13
KB
-rw-r--r--
iodku.test
5.65
KB
-rw-r--r--
iodku_debug.test
6.38
KB
-rw-r--r--
log_alter_table.test
1.81
KB
-rw-r--r--
log_corruption.test
7.06
KB
-rw-r--r--
log_corruption.zip
92.47
KB
-rw-r--r--
log_corruption0.zip
1.18
KB
-rw-r--r--
log_corruption1.zip
1.23
KB
-rw-r--r--
log_corruption2.zip
1.27
KB
-rw-r--r--
log_corruption3.zip
1.27
KB
-rw-r--r--
log_corruption4.zip
1.28
KB
-rw-r--r--
log_corruption4a.zip
1.28
KB
-rw-r--r--
log_corruption5.zip
1.28
KB
-rw-r--r--
log_corruption6.zip
1.28
KB
-rw-r--r--
log_file.test
8.9
KB
-rw-r--r--
log_file_name.test
9.17
KB
-rw-r--r--
log_file_name_debug.test
751
B
-rw-r--r--
log_file_size.test
6.3
KB
-rw-r--r--
log_file_size_1-master.opt
14
B
-rw-r--r--
log_file_size_1.test
8.45
KB
-rw-r--r--
log_file_size_checkpoint.test
1.14
KB
-rw-r--r--
missing_tablespaces.test
2.34
KB
-rw-r--r--
monitor.test
13.96
KB
-rw-r--r--
monitor_restart.test
807
B
-rw-r--r--
mysqldump_max_recordsize.test
13.96
KB
-rw-r--r--
optimizer_temporary_table-mast...
15
B
-rw-r--r--
optimizer_temporary_table.test
4.63
KB
-rw-r--r--
page_reorganize.test
1.31
KB
-rw-r--r--
partition-blob.test
1.43
KB
-rw-r--r--
partition-upgrade.test
7.46
KB
-rw-r--r--
partition.test
20.89
KB
-rw-r--r--
portability_wl5980_linux.zip
473.02
KB
-rw-r--r--
portability_wl5980_windows.zip
514.24
KB
-rw-r--r--
readahead.test
679
B
-rw-r--r--
readonly.test
1.17
KB
-rw-r--r--
records_in_range.test
24.93
KB
-rw-r--r--
redo_log_during_checkpoint.tes...
2.59
KB
-rw-r--r--
rename_table.test
914
B
-rw-r--r--
row_format_redundant.test
2.71
KB
-rw-r--r--
sp_temp_table.test
2.51
KB
-rw-r--r--
stored_fk.test
3.46
KB
-rw-r--r--
strict_checksum.test
2.95
KB
-rw-r--r--
strict_mode.test
3.33
KB
-rw-r--r--
sys_tablestats.test
1.01
KB
-rw-r--r--
table_compress.test
14.09
KB
-rw-r--r--
table_encrypt_1.test
10.06
KB
-rw-r--r--
table_encrypt_2-master.opt
94
B
-rw-r--r--
table_encrypt_2.test
5.46
KB
-rw-r--r--
table_encrypt_3.test
31.16
KB
-rw-r--r--
table_encrypt_4.test
6.83
KB
-rw-r--r--
table_encrypt_5-master.opt
20
B
-rw-r--r--
table_encrypt_5.test
30.54
KB
-rw-r--r--
table_encrypt_debug.test
6.16
KB
-rw-r--r--
table_encrypt_fts.test
3.22
KB
-rw-r--r--
table_encrypt_kill.test
15.3
KB
-rw-r--r--
table_encryption-master.opt
20
B
-rw-r--r--
table_encryption.test
3.25
KB
-rw-r--r--
tablespace_crash.test
7.61
KB
-rw-r--r--
tablespace_embedded.test
246
B
-rw-r--r--
tablespace_embedded_windows.te...
242
B
-rw-r--r--
tablespace_per_table.test
13.03
KB
-rw-r--r--
tablespace_per_table_not_windo...
6.58
KB
-rw-r--r--
tablespace_per_table_windows.t...
3.13
KB
-rw-r--r--
tablespace_portability.test
1.64
KB
-rw-r--r--
tablespace_portability_windows...
751
B
-rw-r--r--
timestamp.test
787
B
-rw-r--r--
tinytext-groupby.test
1.26
KB
-rw-r--r--
tmpdir.test
1.9
KB
-rw-r--r--
trx_id_future.test
1.8
KB
-rw-r--r--
undo.test
1.48
KB
-rw-r--r--
update-cascade.test
6.46
KB
-rw-r--r--
update_time-master.opt
30
B
-rw-r--r--
update_time.test
2.25
KB
-rw-r--r--
update_time_wl6658.test
8.3
KB
-rw-r--r--
virtual_basic.test
44.54
KB
-rw-r--r--
virtual_blob.test
468
B
-rw-r--r--
virtual_debug.test
18.75
KB
-rw-r--r--
virtual_debug_purge.test
4.27
KB
-rw-r--r--
virtual_fk.test
25.3
KB
-rw-r--r--
virtual_fk_restart.test
1.59
KB
-rw-r--r--
virtual_index.test
8.38
KB
-rw-r--r--
virtual_purge.test
3.21
KB
-rw-r--r--
virtual_stats.test
1.43
KB
-rw-r--r--
xa_prepare_lock_release.test
1.57
KB
-rw-r--r--
xa_recovery.test
894
B
-rw-r--r--
xa_recovery_debug.test
989
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : innodb-wl5980-discard.test
--echo # --echo # This test shows DISCARD/IMPORT of a remote tablespace. --echo # --source include/no_valgrind_without_big.inc # Not supported in embedded --source include/not_embedded.inc # These values can change during the test LET $innodb_file_per_table_orig=`select @@innodb_file_per_table`; # Set up some variables LET $INNODB_PAGE_SIZE = `select @@innodb_page_size`; LET $MYSQLD_DATADIR = `select @@datadir`; LET $data_directory_clause = DATA DIRECTORY='$MYSQL_TMP_DIR/alt_dir'; --enable_query_log SET default_storage_engine=InnoDB; SET GLOBAL innodb_file_per_table=ON; --disable_warnings DROP TABLE IF EXISTS t5980; --enable_warnings --echo # --echo # CREATE TABLE ... DATA DIRECTORY --echo # combined with WL#5522 - Transportable Tablespace --echo # Create the tablespace in MYSQL_TMP_DIR/alt_dir --echo # InnoDB will create the sub-directories if needed. --echo # Test that DISCARD and IMPORT work correctly. --echo # --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR eval CREATE TABLE t5980 (a int KEY, b text) $data_directory_clause; INSERT INTO t5980 VALUES (1, "Create the tablespace"); SELECT * FROM t5980; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Check that DATA DIRECTORY shows up in the SHOW CREATE TABLE results. --echo # --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t5980; --echo # --echo # Backup the cfg and ibd files. --echo # FLUSH TABLES t5980 FOR EXPORT; SELECT * FROM t5980; --copy_file $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg.bak --copy_file $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd.bak UNLOCK TABLES; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Do some DDL and DML. --echo # INSERT INTO t5980 VALUES (2,'Remote table has been FLUSHed and UNLOCKed'); START TRANSACTION; INSERT INTO t5980 VALUES (12,'Transactional record inserted'); COMMIT; START TRANSACTION; INSERT INTO t5980 VALUES (13,'Rollback this transactional record'); ROLLBACK; SELECT COUNT(*) FROM t5980; SELECT * FROM t5980; ALTER TABLE t5980 DROP PRIMARY KEY; ALTER TABLE t5980 ADD COLUMN c VARCHAR(50) DEFAULT NULL; INSERT INTO t5980(a,b,c) VALUES (2,'Duplicate value since primary key has been dropped','third column added'); SELECT * FROM t5980; --echo # --echo # Make a second backup of the cfg and ibd files. --echo # FLUSH TABLES t5980 FOR EXPORT; SELECT * FROM t5980; --copy_file $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg.bak2 --copy_file $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd.bak2 UNLOCK TABLES; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # DROP the table and make sure all files except the backups are gone. --echo # DROP TABLE t5980; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # CREATE the table again. --echo # --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR eval CREATE TABLE t5980 (a int KEY, b text) $data_directory_clause; INSERT INTO t5980 VALUES (1, "Create the tablespace a second time"); SELECT * FROM t5980; --echo # --echo # DISCARD existing tablespace so backed-up .ibd which can be imported/restored --echo # ALTER TABLE t5980 DISCARD TABLESPACE; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Restore the second backup of cfg and ibd files. --echo # --copy_file $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg.bak2 $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg --copy_file $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd.bak2 $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd --echo "### files in MYSQL_TMP_DIR/alt_dir/test" --list_files $MYSQL_TMP_DIR/alt_dir/test/ --echo # --echo # Try to Import the second backup. These backups have extra DDL and --echo # do not match the current frm file. --echo # --error ER_TABLE_SCHEMA_MISMATCH ALTER TABLE t5980 IMPORT TABLESPACE; CHECK TABLE t5980; --remove_file $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg --remove_file $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Restore the first backup of cfg and ibd files. --echo # --copy_file $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg.bak $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg --copy_file $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd.bak $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Import the tablespace and do some DDL and DML. --echo # ALTER TABLE t5980 IMPORT TABLESPACE; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test CHECK TABLE t5980; SELECT COUNT(*) FROM t5980; SELECT * FROM t5980; INSERT INTO t5980 VALUES (2,'Inserted record after IMPORT'); SELECT * FROM t5980; START TRANSACTION; INSERT INTO t5980 VALUES (12,'Transactional record inserted'); COMMIT; START TRANSACTION; INSERT INTO t5980 VALUES (13,'Rollback this transactional record'); ROLLBACK; SELECT * FROM t5980; ALTER TABLE t5980 DROP PRIMARY KEY; ALTER TABLE t5980 ADD COLUMN c VARCHAR(50) DEFAULT NULL; INSERT INTO t5980(a,b,c) VALUES (2,'Duplicate value since primary key has been dropped','third column added'); SELECT * FROM t5980; --echo # --echo # Show that the system tables have this table in them correctly. --echo # --source suite/innodb/include/show_i_s_tables.inc --source suite/innodb/include/show_i_s_tablespaces.inc --echo # --echo # Drop the imported table and show that the system tables are updated. --echo # DROP TABLE t5980; --source suite/innodb/include/show_i_s_tables.inc --source suite/innodb/include/show_i_s_tablespaces.inc --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # CREATE the table a third time. --echo # --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR eval CREATE TABLE t5980 (a int KEY, b text) $data_directory_clause; INSERT INTO t5980 VALUES (1, "Create the tablespace a third time"); SELECT * FROM t5980; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Restart the server --echo # This test makes sure that you can still execute the FLUSH TABLES command --echo # after restarting the server and the tablespace can still be found. --echo # --source include/restart_mysqld.inc SET GLOBAL innodb_file_per_table=ON; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test SELECT * FROM t5980; FLUSH TABLES t5980 FOR EXPORT; SELECT * FROM t5980; UNLOCK TABLES; --echo # --echo # Restart the server again. This test makes sure that you can --echo # still DISCARD a remote table after restarting the server. --echo # --source include/restart_mysqld.inc SET GLOBAL innodb_file_per_table=ON; SELECT * FROM t5980; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test ALTER TABLE t5980 DISCARD TABLESPACE; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Restore the backup of *.ibd and *.cfg files --echo # --copy_file $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd.bak $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd --copy_file $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg.bak $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Import the tablespace and check it out. --echo # ALTER TABLE t5980 IMPORT TABLESPACE; SELECT * FROM t5980; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t5980; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # DISCARD the tablespace again --echo # ALTER TABLE t5980 DISCARD TABLESPACE; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Restart the engine while the tablespace is in the discarded state --echo # --source include/restart_mysqld.inc SET GLOBAL innodb_file_per_table=ON; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980; CHECK TABLE t5980; --echo # --echo # Relocate this discarded file to the default directory --echo # instead of the remote directory it was discarded from. --echo # Put cfg and idb files into the default directory. --echo # Delete the isl file and the remote cfg file. --echo # Restart the engine again. --echo # The tablespace is still in the discarded state. --echo # --copy_file $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd.bak $MYSQLD_DATADIR/test/t5980.ibd --copy_file $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg.bak $MYSQLD_DATADIR/test/t5980.cfg --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # Restarting ... --source include/restart_mysqld.inc SET GLOBAL innodb_file_per_table=ON; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980; CHECK TABLE t5980; --echo # --echo # Try to import the tablespace. It can only be imported from --echo # the location it was discarded from. --echo # The error message for 1810 (IO_READ_ERROR) refers to a local path --echo # so do not display it. --echo # --disable_result_log --error ER_TABLESPACE_MISSING ALTER TABLE t5980 IMPORT TABLESPACE; --enable_result_log --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980; CHECK TABLE t5980; --echo # --echo # Restore the ibd and cfg files to the remote directory. --echo # Delete the ibd and cfg files from the default directory. --echo # The isl file is missing, but is no longer needed since the --echo # remote location is in the data dictionary. --echo # Import the tablespace and check it out. --echo # --copy_file $MYSQLD_DATADIR/test/t5980.ibd $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd --copy_file $MYSQLD_DATADIR/test/t5980.cfg $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg --remove_file $MYSQLD_DATADIR/test/t5980.ibd --remove_file $MYSQLD_DATADIR/test/t5980.cfg --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test ALTER TABLE t5980 IMPORT TABLESPACE; INSERT INTO t5980 VALUES (2, "Insert this record after IMPORT"); SELECT * FROM t5980; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t5980; --echo # --echo # Show that the system tables have this table in them correctly. --echo # --source suite/innodb/include/show_i_s_tables.inc --source suite/innodb/include/show_i_s_tablespaces.inc DROP TABLE t5980; --remove_file $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg.bak --remove_file $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd.bak --remove_file $MYSQL_TMP_DIR/alt_dir/test/t5980.cfg.bak2 --remove_file $MYSQL_TMP_DIR/alt_dir/test/t5980.ibd.bak2 --echo # --echo # Create a local and remote tablespaces, discard two and make --echo # the other two missing upon restart, and try some DDL and DML --echo # on these discarded and missing tablespaces. --echo # SET GLOBAL innodb_file_per_table=ON; CREATE TABLE t5980a (a int, b text) engine=InnoDB; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR eval CREATE TABLE t5980b (a int, b text) engine=InnoDB $data_directory_clause; CREATE TABLE t5980c (a int, b text) engine=InnoDB; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR eval CREATE TABLE t5980d (a int, b text) engine=InnoDB $data_directory_clause; INSERT INTO t5980a VALUES (1, "Default location, discarded."); INSERT INTO t5980b VALUES (1, "Remote location, discarded"); INSERT INTO t5980c VALUES (1, "Default location, missing"); INSERT INTO t5980d VALUES (1, "Remote location, missing"); SELECT * FROM t5980a; SELECT * FROM t5980b; SELECT * FROM t5980c; SELECT * FROM t5980d; SHOW CREATE TABLE t5980a; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t5980b; SHOW CREATE TABLE t5980c; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t5980d; --source suite/innodb/include/show_i_s_tables.inc --source suite/innodb/include/show_i_s_tablespaces.inc --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Shutdown the server, remove two tablespaces, restart server. --echo # --source include/shutdown_mysqld.inc --remove_file $MYSQLD_DATADIR/test/t5980c.ibd --remove_file $MYSQLD_DATADIR/test/t5980d.isl --remove_file $MYSQL_TMP_DIR/alt_dir/test/t5980d.ibd --source include/start_mysqld.inc FLUSH TABLES t5980a, t5980b FOR EXPORT; UNLOCK TABLES; ALTER TABLE t5980a DISCARD TABLESPACE; ALTER TABLE t5980b DISCARD TABLESPACE; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980a; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980b; --error ER_TABLESPACE_MISSING SELECT * FROM t5980c; --error ER_TABLESPACE_MISSING SELECT * FROM t5980d; SHOW CREATE TABLE t5980a; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t5980b; --error ER_TABLESPACE_MISSING SHOW CREATE TABLE t5980c; --error ER_TABLESPACE_MISSING SHOW CREATE TABLE t5980d; --source suite/innodb/include/show_i_s_tables.inc --source suite/innodb/include/show_i_s_tablespaces.inc --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Discarded and missing tablespaces cannot be TRUNCATED --echo # --error ER_TABLESPACE_DISCARDED TRUNCATE TABLE t5980a; --error ER_TABLESPACE_DISCARDED TRUNCATE TABLE t5980b; --error ER_TABLESPACE_MISSING TRUNCATE TABLE t5980c; --error ER_TABLESPACE_MISSING TRUNCATE TABLE t5980d; --echo # --echo # Discarded tablespaces can be RENAMED but they remain discarded --echo # RENAME TABLE t5980a TO t5980aa; RENAME TABLE t5980b TO t5980bb; --echo # --echo # Missing tablespaces cannot be RENAMED --echo # --error ER_ERROR_ON_RENAME RENAME TABLE t5980c TO t5980cc; --error ER_ERROR_ON_RENAME RENAME TABLE t5980d TO t5980dd; --error ER_NO_SUCH_TABLE SELECT * FROM t5980a; --error ER_NO_SUCH_TABLE SELECT * FROM t5980b; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980aa; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980bb; --error ER_TABLESPACE_MISSING SELECT * FROM t5980c; --error ER_TABLESPACE_MISSING SELECT * FROM t5980d; SHOW CREATE TABLE t5980aa; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t5980bb; --error ER_TABLESPACE_MISSING SHOW CREATE TABLE t5980c; --error ER_TABLESPACE_MISSING SHOW CREATE TABLE t5980d; --source suite/innodb/include/show_i_s_tables.inc --source suite/innodb/include/show_i_s_tablespaces.inc --echo # --echo # Discarded tablespaces cannot be ALTERED with ALGORITHM=COPY. --echo # --error ER_TABLESPACE_DISCARDED ALTER TABLE t5980aa ADD PRIMARY KEY(a), ALGORITHM=COPY; --error ER_TABLESPACE_DISCARDED ALTER TABLE t5980bb ADD PRIMARY KEY(a), ALGORITHM=COPY; --echo # --echo # Discarded tablespaces can be ALTERED with ALGORITHM=INPLACE. --echo # # NULL -> NOT NULL only allowed INPLACE if strict sql_mode is on. # And adding a PRIMARY KEY will also add NOT NULL implicitly! ALTER TABLE t5980aa ADD PRIMARY KEY(a), ALGORITHM=INPLACE; ALTER TABLE t5980bb ADD PRIMARY KEY(a), ALGORITHM=INPLACE; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Missing tablespaces cannot be ALTERED. --echo # --error ER_TABLESPACE_MISSING ALTER TABLE t5980c ADD PRIMARY KEY(a); --error ER_TABLESPACE_MISSING ALTER TABLE t5980d ADD PRIMARY KEY(a); --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980aa; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980bb; SHOW CREATE TABLE t5980aa; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t5980bb; --source suite/innodb/include/show_i_s_tables.inc --source suite/innodb/include/show_i_s_tablespaces.inc --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Restart the server to check if the discarded flag is persistent --echo # --source include/shutdown_mysqld.inc --source include/start_mysqld.inc --echo # --echo # Discarded tablespaces that were ALTERED IN_PLACE are still discarded. --echo # --error ER_TABLESPACE_DISCARDED INSERT INTO t5980aa VALUES (1, "Inserted into Discarded Local tablespace after ALTER ADD PRIMARY KEY, ALGORITHM=INPLACE"); --error ER_TABLESPACE_DISCARDED INSERT INTO t5980bb VALUES (1, "Inserted into Discarded Local tablespace after ALTER ADD PRIMARY KEY, ALGORITHM=INPLACE"); --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980aa; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980bb; RENAME TABLE t5980aa TO t5980a; RENAME TABLE t5980bb TO t5980b; SHOW CREATE TABLE t5980a; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR SHOW CREATE TABLE t5980b; --source suite/innodb/include/show_i_s_tables.inc --source suite/innodb/include/show_i_s_tablespaces.inc --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Discard tablespaces again and try another ALTER TABLE ROW_FORMAT. --echo # ALTER TABLE t5980a DISCARD TABLESPACE; ALTER TABLE t5980b DISCARD TABLESPACE; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980a; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980b; --echo # --echo # ALTER TABLE ALGORITHM=COPY cannot use a discarded tablespace. --echo # --error ER_TABLESPACE_DISCARDED ALTER TABLE t5980a ROW_FORMAT=REDUNDANT, ALGORITHM=COPY; --error ER_TABLESPACE_DISCARDED ALTER TABLE t5980b ROW_FORMAT=REDUNDANT, ALGORITHM=COPY; --echo # --echo # ALTER TABLE ALGORITHM=INPLACE can use a discarded tablespace. --echo # ALTER TABLE t5980a ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE, LOCK=NONE; ALTER TABLE t5980b ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE, LOCK=NONE; --echo # --echo # Discarded tablespaces that were ALTERED IN_PLACE are still discarded. --echo # --error ER_TABLESPACE_DISCARDED INSERT INTO t5980a VALUES (1, "Inserted into discarded local tablespace after ALTER ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE"); --error ER_TABLESPACE_DISCARDED INSERT INTO t5980b VALUES (1, "Inserted into discarded local tablespace after ALTER ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE"); --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980a; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980b; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Discard tablespaces again and try ALTER TABLE ADD COLUMN. --echo # ALTER TABLE t5980a DISCARD TABLESPACE; ALTER TABLE t5980b DISCARD TABLESPACE; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980a; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980b; --echo # --echo # ALTER TABLE ALGORITHM=COPY cannot use a discarded tablespace. --echo # --error ER_TABLESPACE_DISCARDED ALTER TABLE t5980a ADD COLUMN c CHAR(20), ALGORITHM=COPY; --error ER_TABLESPACE_DISCARDED ALTER TABLE t5980b ADD COLUMN c CHAR(20), ALGORITHM=COPY; --echo # --echo # ALTER TABLE ALGORITHM=INPLACE can use a discarded tablespace. --echo # ALTER TABLE t5980a ADD COLUMN c CHAR(20), ALGORITHM=INPLACE; ALTER TABLE t5980b ADD COLUMN c CHAR(20), ALGORITHM=INPLACE; --echo # --echo # Discarded tablespaces that were ALTERED IN_PLACE are still discarded. --echo # --error ER_TABLESPACE_DISCARDED DELETE FROM t5980a; --error ER_TABLESPACE_DISCARDED UPDATE t5980a SET c="Tablespace is DISCARDED"; --error ER_TABLESPACE_DISCARDED INSERT INTO t5980a VALUES (1, "Inserted into discarded local tablespace after ALTER ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE", "new column"); --error ER_TABLESPACE_DISCARDED INSERT INTO t5980b VALUES (1, "Inserted into discarded local tablespace after ALTER ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE", "new column"); --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980a; --error ER_TABLESPACE_DISCARDED SELECT * FROM t5980b; --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test DROP TABLE t5980a; DROP TABLE t5980b; DROP TABLE t5980c; DROP TABLE t5980d; --source suite/innodb/include/show_i_s_tables.inc --source suite/innodb/include/show_i_s_tablespaces.inc --echo ### files in MYSQLD_DATADIR/test --list_files $MYSQLD_DATADIR/test --echo ### files in MYSQL_TMP_DIR/alt_dir/test --list_files $MYSQL_TMP_DIR/alt_dir/test --echo # --echo # Cleanup --echo # --rmdir $MYSQL_TMP_DIR/alt_dir/test --rmdir $MYSQL_TMP_DIR/alt_dir -- disable_query_log eval set global innodb_file_per_table=$innodb_file_per_table_orig; # These warnings are expected in the log call mtr.add_suppression("\\[ERROR\\] InnoDB: Cannot delete tablespace .+ because it is not found in the tablespace memory cache"); call mtr.add_suppression("\\[ERROR\\] InnoDB: Cannot open datafile for read-only:"); call mtr.add_suppression("\\[ERROR\\] InnoDB: Could not find a valid tablespace file for"); call mtr.add_suppression("\\[ERROR\\] InnoDB: Failed to find tablespace for table .* in the cache. Attempting to load the tablespace with space id"); call mtr.add_suppression("\\[ERROR\\] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them."); call mtr.add_suppression("\\[ERROR\\] InnoDB: In file .*, tablespace id and flags are .*, but in the InnoDB data dictionary they are"); call mtr.add_suppression("\\[ERROR\\] InnoDB: Operating system error number 2 in a file operation."); call mtr.add_suppression("\\[ERROR\\] InnoDB: Table .* does not have an \.ibd file in the database directory."); call mtr.add_suppression("\\[ERROR\\] InnoDB: Table .* does not exist in the InnoDB internal data dictionary though MySQL is trying to rename the table"); call mtr.add_suppression("\\[ERROR\\] InnoDB: The error means the system cannot find the path specified."); call mtr.add_suppression("\\[ERROR\\] InnoDB: The table .* doesn't have a corresponding tablespace, it was discarded."); call mtr.add_suppression("\\[ERROR\\] InnoDB: Trying to import a tablespace, but could not open the tablespace file"); call mtr.add_suppression("\\[Warning\\] InnoDB: Cannot calculate statistics for table .* because the \.ibd file is missing"); call mtr.add_suppression("\\[Warning\\] InnoDB: Cannot delete tablespace .+ in DISCARD TABLESPACE. Tablespace not found"); call mtr.add_suppression("\\[Warning\\] InnoDB: Ignoring tablespace .* because it could not be opened"); call mtr.add_suppression("\\[Warning\\] InnoDB: Tablespace for table .* is set as discarded"); -- enable_query_log
Close