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 | : 18.218.106.172
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 : create_tablespace_16k.test
# # WL#6205 - A series of tests to show the correct behavior for # CREATE TABLESPACE and associated SQL statements for 16k page size. # --source include/have_innodb.inc --source include/have_innodb_16k.inc --source include/not_embedded.inc --echo # --echo # CREATE TABLESPACE related tests for 16k page sizes. --echo # SET DEFAULT_STORAGE_ENGINE=InnoDB; LET $MYSQLD_DATADIR = `select @@datadir`; LET $INNODB_PAGE_SIZE = `select @@innodb_page_size`; --echo # Strict-mode has no effect on CREATE TABLESPACE. But it does affect --echo # whether an invalid KEY_BLOCK_SIZE is rejected or adjusted. SHOW VARIABLES LIKE 'innodb_strict_mode'; SHOW VARIABLES LIKE 'innodb_file_per_table'; --echo # --echo # Create a tablespace with compressed page sizes that can match --echo # innodb-page-size. --echo # CREATE TABLESPACE s_1k ADD DATAFILE 's_1k.ibd' FILE_BLOCK_SIZE=1k; CREATE TABLESPACE s_2k ADD DATAFILE 's_2k.ibd' FILE_BLOCK_SIZE=2k; CREATE TABLESPACE s_4k ADD DATAFILE 's_4k.ibd' FILE_BLOCK_SIZE=4k; CREATE TABLESPACE s_8k ADD DATAFILE 's_8k.ibd' FILE_BLOCK_SIZE=8k; CREATE TABLESPACE s_16k ADD DATAFILE 's_16k.ibd' FILE_BLOCK_SIZE=16k; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLESPACE s_32k ADD DATAFILE 's_32k.ibd' FILE_BLOCK_SIZE=32k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLESPACE s_64k ADD DATAFILE 's_64k.ibd' FILE_BLOCK_SIZE=64k; SHOW WARNINGS; --source suite/innodb/include/show_i_s_tablespaces.inc --echo # --echo # Try to put a temporary table into a non-temporary compressed tablespace --echo # --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TEMPORARY TABLE t_temp_zip (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_1k; SHOW WARNINGS; --echo # --echo # Add tables to the 1K tablespace. --echo # CREATE TABLE t_zip1k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_1k; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip2k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_1k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip4k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_1k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip8k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_1k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip16k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_1k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip32k_in_1k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_1k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_red_in_1k (a int, b text) ROW_FORMAT=Redundant TABLESPACE s_1k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_cmp_in_1k (a int, b text) ROW_FORMAT=Compact TABLESPACE s_1k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_dyn_in_1k (a int, b text) ROW_FORMAT=Dynamic TABLESPACE s_1k; SHOW WARNINGS; --echo # --echo # Add tables to the 2K tablespace. --echo # --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip1k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_2k; SHOW WARNINGS; CREATE TABLE t_zip2k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_2k; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip4k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_2k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip8k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_2k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip16k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_2k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip32k_in_2k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_2k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_red_in_2k (a int, b text) ROW_FORMAT=Redundant TABLESPACE s_2k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_cmp_in_2k (a int, b text) ROW_FORMAT=Compact TABLESPACE s_2k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_dyn_in_2k (a int, b text) ROW_FORMAT=Dynamic TABLESPACE s_2k; SHOW WARNINGS; --echo # --echo # Add tables to the 4K tablespace. --echo # --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip1k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_4k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip2k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_4k; SHOW WARNINGS; CREATE TABLE t_zip4k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_4k; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip8k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_4k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip16k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_4k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip32k_in_4k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_4k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_red_in_4k (a int, b text) ROW_FORMAT=Redundant TABLESPACE s_4k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_cmp_in_4k (a int, b text) ROW_FORMAT=Compact TABLESPACE s_4k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_dyn_in_4k (a int, b text) ROW_FORMAT=Dynamic TABLESPACE s_4k; SHOW WARNINGS; --echo # --echo # Add tables to the 8K tablespace. --echo # --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip1k_in_8k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_8k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip2k_in_8k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_8k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip4k_in_8k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_8k; SHOW WARNINGS; CREATE TABLE t_zip8k_in_8k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_8k; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip16k_in_8k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_8k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip32k_in_8k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_8k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_red_in_8k (a int, b text) ROW_FORMAT=redundant TABLESPACE s_8k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_com_in_8k (a int, b text) ROW_FORMAT=compact TABLESPACE s_8k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_dyn_in_8k (a int, b text) ROW_FORMAT=dynamic TABLESPACE s_8k; SHOW WARNINGS; --echo # --echo # Add tables to the 16K tablespace. --echo # --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip1k_in_16k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=1 TABLESPACE s_16k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip2k_in_16k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=2 TABLESPACE s_16k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip4k_in_16k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=4 TABLESPACE s_16k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip8k_in_16k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=8 TABLESPACE s_16k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip16k_in_16k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=16 TABLESPACE s_16k; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION CREATE TABLE t_zip32k_in_16k (a int, b text) ROW_FORMAT=Compressed KEY_BLOCK_SIZE=32 TABLESPACE s_16k; SHOW WARNINGS; CREATE TABLE t_red_in_16k (a int, b text) ROW_FORMAT=redundant TABLESPACE s_16k; CREATE TABLE t_com_in_16k (a int, b text) ROW_FORMAT=compact TABLESPACE s_16k; CREATE TABLE t_dyn_in_16k (a int, b text) ROW_FORMAT=dynamic TABLESPACE s_16k; --echo # Add data to the existing Tables INSERT INTO t_zip1k_in_1k VALUES (1,'a'),(2,'b'),(3,'c'); INSERT INTO t_zip2k_in_2k VALUES (1,'a'),(2,'b'),(3,'c'); INSERT INTO t_zip4k_in_4k VALUES (1,'a'),(2,'b'),(3,'c'); INSERT INTO t_zip8k_in_8k VALUES (1,'a'),(2,'b'),(3,'c'); INSERT INTO t_red_in_16k VALUES (1,'a'),(2,'b'),(3,'c'); INSERT INTO t_com_in_16k VALUES (1,'a'),(2,'b'),(3,'c'); INSERT INTO t_dyn_in_16k VALUES (1,'a'),(2,'b'),(3,'c'); --echo # Restart mysqld --source include/restart_mysqld.inc --echo # --echo # Try to drop these tablespaces which are not empty --echo # --error ER_DROP_FILEGROUP_FAILED DROP TABLESPACE s_1k; SHOW WARNINGS; --error ER_DROP_FILEGROUP_FAILED DROP TABLESPACE s_2k; SHOW WARNINGS; --error ER_DROP_FILEGROUP_FAILED DROP TABLESPACE s_4k; SHOW WARNINGS; --error ER_DROP_FILEGROUP_FAILED DROP TABLESPACE s_8k; SHOW WARNINGS; --error ER_DROP_FILEGROUP_FAILED DROP TABLESPACE s_16k; SHOW WARNINGS; --echo # --echo # Add more data to the existing Tables --echo # INSERT INTO t_zip1k_in_1k VALUES (4,'d'); INSERT INTO t_zip2k_in_2k VALUES (4,'d'); INSERT INTO t_zip4k_in_4k VALUES (4,'d'); INSERT INTO t_zip8k_in_8k VALUES (4,'d'); INSERT INTO t_red_in_16k VALUES (4,'d'); INSERT INTO t_com_in_16k VALUES (4,'d'); INSERT INTO t_dyn_in_16k VALUES (4,'d'); --echo # --echo # Create an empty copy of each table using LIKE --echo # CREATE TABLE t_zip1k_in_1k_like LIKE t_zip1k_in_1k; CREATE TABLE t_zip2k_in_2k_like LIKE t_zip2k_in_2k; CREATE TABLE t_zip4k_in_4k_like LIKE t_zip4k_in_4k; CREATE TABLE t_zip8k_in_8k_like LIKE t_zip8k_in_8k; CREATE TABLE t_red_in_16k_like LIKE t_red_in_16k; CREATE TABLE t_com_in_16k_like LIKE t_com_in_16k; CREATE TABLE t_dyn_in_16k_like LIKE t_dyn_in_16k; --echo # --echo # Create a full copy of each table using AS --echo # CREATE TABLE t_zip1k_in_1k_as TABLESPACE=s_1k KEY_BLOCK_SIZE=1 AS (SELECT * FROM t_zip1k_in_1k); CREATE TABLE t_zip2k_in_2k_as TABLESPACE=s_2k KEY_BLOCK_SIZE=2 AS (SELECT * FROM t_zip2k_in_2k); CREATE TABLE t_zip4k_in_4k_as TABLESPACE=s_4k KEY_BLOCK_SIZE=4 AS (SELECT * FROM t_zip4k_in_4k); CREATE TABLE t_zip8k_in_8k_as TABLESPACE=s_8k KEY_BLOCK_SIZE=8 AS (SELECT * FROM t_zip8k_in_8k); CREATE TABLE t_red_in_16k_as TABLESPACE=s_16k ROW_FORMAT=redundant AS (SELECT * FROM t_red_in_16k); CREATE TABLE t_com_in_16k_as TABLESPACE=s_16k ROW_FORMAT=compact AS (SELECT * FROM t_com_in_16k); CREATE TABLE t_dyn_in_16k_as TABLESPACE=s_16k ROW_FORMAT=dynamic AS (SELECT * FROM t_dyn_in_16k); --echo # --echo # Create a copy of the 1k table, moving it to another tablespace with a different --echo # FILE_BLOCK_SIZE, while changing the KEY_BLOCK_SIZE. --echo # CREATE TABLE t_zip2k_in_2k_from_1k TABLESPACE s_2k KEY_BLOCK_SIZE=2 AS (SELECT * FROM t_zip1k_in_1k); CREATE TABLE t_zip4k_in_4k_from_1k TABLESPACE s_4k KEY_BLOCK_SIZE=4 AS (SELECT * FROM t_zip1k_in_1k); CREATE TABLE t_zip8k_in_8k_from_1k TABLESPACE s_8k KEY_BLOCK_SIZE=8 AS (SELECT * FROM t_zip1k_in_1k); CREATE TABLE t_red_in_16k_from_1k TABLESPACE s_16k ROW_FORMAT=redundant AS (SELECT * FROM t_zip1k_in_1k); CREATE TABLE t_com_in_16k_from_1k TABLESPACE s_16k ROW_FORMAT=compact AS (SELECT * FROM t_zip1k_in_1k); CREATE TABLE t_dyn_in_16k_from_1k TABLESPACE s_16k ROW_FORMAT=dynamic AS (SELECT * FROM t_zip1k_in_1k); --echo # --echo # Create a tablespace that will be deleted while the engine is not --echo # running to show that it can still be dropped. --echo # CREATE TABLESPACE s_missing ADD DATAFILE 'delete_me.ibd'; CREATE TABLE t_missing (a int) TABLESPACE=s_missing; --source suite/innodb/include/show_i_s_tablespaces.inc --source suite/innodb/include/show_i_s_tables.inc --echo # Directory of MYSQLD_DATADIR/ --list_files $MYSQLD_DATADIR/ *.ibd --echo # Directory of MYSQLD_DATADIR/test/ --list_files $MYSQLD_DATADIR/test/ *.ibd --echo # --echo # Stop the server. --source include/shutdown_mysqld.inc --echo # Delete a general tablespace datafile. --remove_file $MYSQLD_DATADIR/delete_me.ibd --source include/start_mysqld.inc --echo # Make sure that the missing tablespace can be dropped and --echo # everything else is OK. --echo # --source suite/innodb/include/show_i_s_tablespaces.inc --source suite/innodb/include/show_i_s_tables.inc --echo # Directory of MYSQLD_DATADIR/ --list_files $MYSQLD_DATADIR/ *.ibd --echo # Directory of MYSQLD_DATADIR/test/ --list_files $MYSQLD_DATADIR/test/ *.ibd --echo # --echo # Clean-up tables we no longer need --echo # --error ER_DROP_FILEGROUP_FAILED DROP TABLESPACE s_missing; SHOW WARNINGS; DROP TABLE t_missing; DROP TABLESPACE s_missing; DROP TABLE t_zip1k_in_1k_like; DROP TABLE t_zip2k_in_2k_like; DROP TABLE t_zip4k_in_4k_like; DROP TABLE t_zip8k_in_8k_like; DROP TABLE t_red_in_16k_like; DROP TABLE t_com_in_16k_like; DROP TABLE t_dyn_in_16k_like; DROP TABLE t_zip1k_in_1k_as; DROP TABLE t_zip2k_in_2k_as; DROP TABLE t_zip4k_in_4k_as; DROP TABLE t_zip8k_in_8k_as; DROP TABLE t_red_in_16k_as; DROP TABLE t_com_in_16k_as; DROP TABLE t_dyn_in_16k_as; DROP TABLE t_zip2k_in_2k_from_1k; DROP TABLE t_zip4k_in_4k_from_1k; DROP TABLE t_zip8k_in_8k_from_1k; DROP TABLE t_red_in_16k_from_1k; DROP TABLE t_com_in_16k_from_1k; DROP TABLE t_dyn_in_16k_from_1k; CHECK TABLE t_zip1k_in_1k; CHECK TABLE t_zip2k_in_2k; CHECK TABLE t_zip4k_in_4k; CHECK TABLE t_zip8k_in_8k; CHECK TABLE t_red_in_16k; CHECK TABLE t_com_in_16k; CHECK TABLE t_dyn_in_16k; DROP TABLE t_zip1k_in_1k; DROP TABLE t_zip2k_in_2k; DROP TABLE t_zip4k_in_4k; DROP TABLE t_zip8k_in_8k; DROP TABLE t_red_in_16k; DROP TABLE t_com_in_16k; DROP TABLE t_dyn_in_16k; --echo # --echo # Create compressed tables explicitly as file_per_table tablespaces. --echo # CREATE TABLE t_zip1k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=1; CREATE TABLE t_zip2k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=2; CREATE TABLE t_zip4k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=4; CREATE TABLE t_zip8k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=8; CREATE TABLE t_zip16k_as_file_per_table (a int, b text) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=16; --echo # --echo # Create compressed tables in remote locations using file-per-table. --echo # --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR eval CREATE TABLE t_zip1k_as_remote (a int, b text) KEY_BLOCK_SIZE=1 TABLESPACE=innodb_file_per_table DATA DIRECTORY='$MYSQL_TMP_DIR'; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR eval CREATE TABLE t_zip2k_as_remote (a int, b text) KEY_BLOCK_SIZE=2 TABLESPACE=innodb_file_per_table DATA DIRECTORY='$MYSQL_TMP_DIR'; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR eval CREATE TABLE t_zip4k_as_remote (a int, b text) KEY_BLOCK_SIZE=4 TABLESPACE=innodb_file_per_table DATA DIRECTORY='$MYSQL_TMP_DIR'; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR eval CREATE TABLE t_zip8k_as_remote (a int, b text) KEY_BLOCK_SIZE=8 TABLESPACE=innodb_file_per_table DATA DIRECTORY='$MYSQL_TMP_DIR'; --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR eval CREATE TABLE t_zip16k_as_remote (a int, b text) KEY_BLOCK_SIZE=16 TABLESPACE=innodb_file_per_table DATA DIRECTORY='$MYSQL_TMP_DIR'; --source suite/innodb/include/show_i_s_tablespaces.inc --source suite/innodb/include/show_i_s_tables.inc --echo # MYSQLD_DATADIR/ --list_files $MYSQLD_DATADIR/ *.ibd --echo # MYSQLD_DATADIR/test/ --list_files $MYSQLD_DATADIR/test/ *.ibd --echo # --echo # These file_per_table tables cannot be moved to a general tablespace if the --echo # FILE_BLOCK_SIZE does not match the KEY_BLOCK_SIZE or if the tablespace is --echo # not compressed. --echo # --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_1k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip4k_as_file_per_table` TABLESPACE=`s_1k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip8k_as_file_per_table` TABLESPACE=`s_1k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip16k_as_file_per_table` TABLESPACE=`s_1k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_1k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip4k_as_remote` TABLESPACE=`s_1k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip8k_as_remote` TABLESPACE=`s_1k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip16k_as_remote` TABLESPACE=`s_1k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_2k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip4k_as_file_per_table` TABLESPACE=`s_2k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip8k_as_file_per_table` TABLESPACE=`s_2k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip16k_as_file_per_table` TABLESPACE=`s_2k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_2k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip4k_as_remote` TABLESPACE=`s_2k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip8k_as_remote` TABLESPACE=`s_2k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip16k_as_remote` TABLESPACE=`s_2k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_4k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_4k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip8k_as_file_per_table` TABLESPACE=`s_4k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip16k_as_file_per_table` TABLESPACE=`s_4k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_4k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_4k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip8k_as_remote` TABLESPACE=`s_4k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip16k_as_remote` TABLESPACE=`s_4k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_8k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_8k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip4k_as_file_per_table` TABLESPACE=`s_8k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip16k_as_file_per_table` TABLESPACE=`s_8k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_8k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_8k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip4k_as_remote` TABLESPACE=`s_8k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip16k_as_remote` TABLESPACE=`s_8k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_16k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_16k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip4k_as_file_per_table` TABLESPACE=`s_16k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip8k_as_file_per_table` TABLESPACE=`s_16k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip16k_as_file_per_table` TABLESPACE=`s_16k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_16k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_16k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip4k_as_remote` TABLESPACE=`s_16k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip8k_as_remote` TABLESPACE=`s_16k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip16k_as_remote` TABLESPACE=`s_16k`; SHOW WARNINGS; DROP TABLE `t_zip16k_as_remote`; --echo # --echo # These explicit file_per_table tables can be moved to a general tablespace --echo # if FILE_BLOCK_SIZE matches KEY_BLOCK_SIZE and the tablespace is compressed. --echo # ALTER TABLE `t_zip1k_as_file_per_table` TABLESPACE=`s_1k`, RENAME TO `t_zip1k_in_s_1k`; ALTER TABLE `t_zip2k_as_file_per_table` TABLESPACE=`s_2k`, RENAME TO `t_zip2k_in_s_2k`; ALTER TABLE `t_zip4k_as_file_per_table` TABLESPACE=`s_4k`, RENAME TO `t_zip4k_in_s_4k`; ALTER TABLE `t_zip8k_as_file_per_table` TABLESPACE=`s_8k`, RENAME TO `t_zip8k_in_s_8k`; ALTER TABLE `t_zip1k_as_remote` TABLESPACE=`s_1k`, RENAME TO `t_zip1k_remote_in_s_1k`; ALTER TABLE `t_zip2k_as_remote` TABLESPACE=`s_2k`, RENAME TO `t_zip2k_remote_in_s_2k`; ALTER TABLE `t_zip4k_as_remote` TABLESPACE=`s_4k`, RENAME TO `t_zip4k_remote_in_s_4k`; ALTER TABLE `t_zip8k_as_remote` TABLESPACE=`s_8k`, RENAME TO `t_zip8k_remote_in_s_8k`; --source suite/innodb/include/show_i_s_tablespaces.inc --source suite/innodb/include/show_i_s_tables.inc --echo # MYSQLD_DATADIR/ --list_files $MYSQLD_DATADIR/ *.ibd --echo # MYSQLD_DATADIR/test/ --list_files $MYSQLD_DATADIR/test/ *.ibd CHECK TABLE `t_zip1k_in_s_1k`; CHECK TABLE `t_zip2k_in_s_2k`; CHECK TABLE `t_zip4k_in_s_4k`; CHECK TABLE `t_zip8k_in_s_8k`; CHECK TABLE `t_zip1k_remote_in_s_1k`; CHECK TABLE `t_zip2k_remote_in_s_2k`; CHECK TABLE `t_zip4k_remote_in_s_4k`; CHECK TABLE `t_zip8k_remote_in_s_8k`; --echo # --echo # Tables in general tablespaces cannot be moved to another general tablespace if the --echo # FILE_BLOCK_SIZE does not match the KEY_BLOCK_SIZE or if the tablespace is --echo # not compressed. --echo # --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`s_1k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip4k_in_s_4k` TABLESPACE=`s_1k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip8k_in_s_8k` TABLESPACE=`s_1k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`s_2k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip4k_in_s_4k` TABLESPACE=`s_2k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip8k_in_s_8k` TABLESPACE=`s_2k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`s_4k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`s_4k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip8k_in_s_8k` TABLESPACE=`s_4k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`s_8k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`s_8k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip4k_in_s_4k` TABLESPACE=`s_8k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`s_16k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`s_16k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip4k_in_s_4k` TABLESPACE=`s_16k`; SHOW WARNINGS; --error ER_ILLEGAL_HA_CREATE_OPTION ALTER TABLE `t_zip8k_in_s_8k` TABLESPACE=`s_16k`; SHOW WARNINGS; --echo # --echo # Tables in a general tablespace can be moved to file_per_table locations. --echo # ALTER TABLE `t_zip1k_in_s_1k` TABLESPACE=`innodb_file_per_table`, RENAME TO `t_zip1k_to_file_per_table`; ALTER TABLE `t_zip2k_in_s_2k` TABLESPACE=`innodb_file_per_table`, RENAME TO `t_zip2k_to_file_per_table`; ALTER TABLE `t_zip4k_in_s_4k` TABLESPACE=`innodb_file_per_table`, RENAME TO `t_zip4k_to_file_per_table`; ALTER TABLE `t_zip8k_in_s_8k` TABLESPACE=`innodb_file_per_table`, RENAME TO `t_zip8k_to_file_per_table`; --source suite/innodb/include/show_i_s_tablespaces.inc --source suite/innodb/include/show_i_s_tables.inc CHECK TABLE `t_zip1k_to_file_per_table`; CHECK TABLE `t_zip2k_to_file_per_table`; CHECK TABLE `t_zip4k_to_file_per_table`; CHECK TABLE `t_zip8k_to_file_per_table`; CHECK TABLE `t_zip16k_as_file_per_table`; DROP TABLE `t_zip1k_to_file_per_table`; DROP TABLE `t_zip2k_to_file_per_table`; DROP TABLE `t_zip4k_to_file_per_table`; DROP TABLE `t_zip8k_to_file_per_table`; DROP TABLE `t_zip16k_as_file_per_table`; --echo # --echo # Tables in a general tablespace cannot be moved to remote file_per_table locations --echo # because MySQL ignores DATA DIRECTORY in ALTER TABLE. --echo # ALTER TABLE `t_zip1k_remote_in_s_1k` TABLESPACE=`innodb_file_per_table`, DATA DIRECTORY='$MYSQL_TMP_DIR', RENAME TO `t_zip1k_to_file_per_table`; ALTER TABLE `t_zip2k_remote_in_s_2k` TABLESPACE=`innodb_file_per_table`, DATA DIRECTORY='$MYSQL_TMP_DIR', RENAME TO `t_zip2k_to_file_per_table`; ALTER TABLE `t_zip4k_remote_in_s_4k` TABLESPACE=`innodb_file_per_table`, DATA DIRECTORY='$MYSQL_TMP_DIR', RENAME TO `t_zip4k_to_file_per_table`; ALTER TABLE `t_zip8k_remote_in_s_8k` TABLESPACE=`innodb_file_per_table`, DATA DIRECTORY='$MYSQL_TMP_DIR', RENAME TO `t_zip8k_to_file_per_table`; --source suite/innodb/include/show_i_s_tablespaces.inc --source suite/innodb/include/show_i_s_tables.inc DROP TABLE `t_zip1k_to_file_per_table`; DROP TABLE `t_zip2k_to_file_per_table`; DROP TABLE `t_zip4k_to_file_per_table`; DROP TABLE `t_zip8k_to_file_per_table`; --echo # --echo # Clean-up. --echo # DROP TABLESPACE s_1k; DROP TABLESPACE s_2k; DROP TABLESPACE s_4k; DROP TABLESPACE s_8k; DROP TABLESPACE s_16k; --rmdir $MYSQL_TMP_DIR/test --disable_query_log call mtr.add_suppression("\\[ERROR\\] InnoDB: Operating system error number .* in a file operation"); call mtr.add_suppression("\\[ERROR\\] InnoDB: The error means the system cannot find the path specified"); call mtr.add_suppression("\\[ERROR\\] InnoDB: Cannot open datafile for read-only"); 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: Failed to find tablespace for table `test`.`t_missing` in the cache. Attempting to load the tablespace with space id .*"); call mtr.add_suppression("\\[Warning\\] InnoDB: Ignoring tablespace `s_missing` because it could not be opened"); 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: Could not find a valid tablespace file for `s_missing`. Please refer to .* for how to resolve the issue."); --enable_query_log
Close