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.224.5.46
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_wl6560_1.test
# # WL#6560: InnoDB: separate tablespace for innodb-temp-tables. # --source include/have_innodb.inc # Embedded server does not support crashing --source include/not_embedded.inc # Avoid CrashReporter popup on Mac --source include/not_crashrep.inc call mtr.add_suppression("Please add another temp-data file or use 'autoextend' for the last data file"); call mtr.add_suppression("The table 't1' is full"); ################################################################################ # # Will test following scenarios: # # 1. ddl + dml operation involving temp-tablespace. # a) insert/delete/update/transacion/select # b) create index/drop index/add column/drop column # c) alter inplace/copy on temp table # 2. ddl + dml operation on temp table from 2 sessions. # a) Both session create 20 tables each of same name. # b) No error expected across session as temp tables are not be # visible across session. # c) create drop same table multiple time # 3. Temp table operation - # a) can not create temp table with partition # b) can not create/drop view on temp tables. # c) select/join on temp tables. # d) Lock/flush on tables # e) create temp table as select # 4. Temp table operation - # a) restart on existing datadir and see ibtmp1 removed on clean shutdown # ################################################################################ #----------------------------------------------------------------------------- # set global innodb_file_per_table = off; let $MYSQL_DATA_DIR = `select @@datadir`; let $MYSQL_TMP_DIR = `select @@tmpdir`; #----------------------------------------------------------------------------- # # 1. ddl + dml operation involving temp-tablespace. # a) insert/delete/update/transacion/select # b) create index/drop index/add column/drop column # c) alter inplace/copy on temp table SELECT @@global.innodb_file_per_table; --replace_column 1 NUM SELECT @mycount_SYS_DATAFILES:=COUNT(*) FROM information_schema.INNODB_SYS_DATAFILES; CREATE TEMPORARY TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, b FLOAT(5,3), c BLOB(100),d VARCHAR(100),e TEXT) ENGINE=InnoDB; --echo # creation of shared temp-tablespace in MYSQL_DATA_DIR --list_files $MYSQL_DATA_DIR/ ibtmp1* --echo # check no entries made INNODB_SYS_DATAFILES SELECT @mycount_SYS_DATAFILES=COUNT(*) FROM information_schema.INNODB_SYS_DATAFILES; INSERT INTO t1(b,c,d,e) VALUES (11.111,REPEAT('a1',50),REPEAT('a1',50), REPEAT('a1',50)); # DML+TRANSACTION START TRANSACTION; INSERT INTO t1(b,c,d,e) VALUES (12.111,REPEAT('a2',50),REPEAT('a2',50), REPEAT('a2',50)); INSERT INTO t1(b,c,d,e) VALUES (13.111,REPEAT('a3',50),REPEAT('a3',50), REPEAT('a3',50)); UPDATE t1 SET e = REPEAT('ta',50); DELETE FROM t1 WHERE a = 3; SAVEPOINT A; INSERT INTO t1(b,c,d,e) VALUES (14.111,REPEAT('a4',50),REPEAT('a4',50), REPEAT('a4',50)); UPDATE t1 SET e = REPEAT('yb',50); DELETE FROM t1 WHERE a = 1; SAVEPOINT B; SELECT a,RIGHT(b,10),RIGHT(c,10),RIGHT(d,10),RIGHT(e,10) FROM t1; ROLLBACK TO SAVEPOINT A; COMMIT; SELECT a,RIGHT(b,10),RIGHT(c,10),RIGHT(d,10),RIGHT(e,10) FROM t1; # DDL ALTER TABLE t1 ADD COLUMN f BLOB(100), ADD INDEX `idx1` (d); SELECT a,RIGHT(b,10),RIGHT(c,10),RIGHT(d,10),RIGHT(e,10),RIGHT(f,10) FROM t1; --error 1845 ALTER TABLE t1 DROP COLUMN f, DROP INDEX `idx1` , ADD INDEX `idx2` (d), ALGORITHM=INPLACE; ALTER TABLE t1 DROP COLUMN f, DROP INDEX `idx1` , ADD INDEX `idx2` (d), ALGORITHM=COPY; SELECT a,RIGHT(b,10),RIGHT(c,10),RIGHT(d,10),RIGHT(e,10) FROM t1; # drop table DROP TABLE t1; #----------------------------------------------------------------------------- # # 2. ddl + dml operation on temp table from 2 sessions. # a) Both session create 20 tables each of same name. # b) No error expected across session as temp tables are not be # visible across session. # c) create drop same table multiple time # --disable_warnings DROP TABLE IF EXISTS t1; DROP DATABASE IF EXISTS test_db; --enable_warnings # check by allowing file per table on set global innodb_file_per_table = on; SELECT @@global.innodb_file_per_table; let $counter= 2; CREATE DATABASE test_db; --echo "Create con1 client connection" connect (con1,localhost,root,,); --disable_query_log while ($counter<23) { # create table from con1 connection connection con1; USE test_db; EVAL CREATE TEMPORARY TABLE t$counter (a INT AUTO_INCREMENT PRIMARY KEY, b FLOAT(5,3), c BLOB(100),d VARCHAR(100),e TEXT) ENGINE=InnoDB; EVAL INSERT INTO t$counter(b,c,d,e) VALUES (11.111,REPEAT('a1',50),REPEAT('a1',50), REPEAT('a1',50)); START TRANSACTION; EVAL INSERT INTO t$counter(b,c,d,e) VALUES (12.111,REPEAT('a2',50),REPEAT('a2',50), REPEAT('a2',50)); EVAL INSERT INTO t$counter(b,c,d,e) VALUES (13.111,REPEAT('a3',50),REPEAT('a3',50), REPEAT('a3',50)); EVAL UPDATE t$counter SET e = REPEAT('ta',50); EVAL DELETE FROM t$counter WHERE a = 3; SAVEPOINT A; EVAL INSERT INTO t$counter(b,c,d,e) VALUES (14.111,REPEAT('a4',50),REPEAT('a4',50), REPEAT('a4',50)); EVAL UPDATE t$counter SET e = REPEAT('yb',50); EVAL DELETE FROM t$counter WHERE a = 1; SAVEPOINT B; ROLLBACK TO SAVEPOINT A; COMMIT; EVAL ALTER TABLE t$counter ADD COLUMN f BLOB(100), ADD INDEX `idx1` (d); EVAL ALTER TABLE t$counter DROP COLUMN f, DROP INDEX `idx1` , ADD INDEX `idx2` (d), ALGORITHM=COPY; # create same table from default connection connection default; USE test_db; EVAL CREATE TEMPORARY TABLE t$counter (a INT AUTO_INCREMENT PRIMARY KEY, b FLOAT(5,3), c BLOB(100),d VARCHAR(100),e TEXT) ENGINE=InnoDB; EVAL INSERT INTO t$counter(b,c,d,e) VALUES (11.111,REPEAT('a1',50),REPEAT('a1',50), REPEAT('a1',50)); START TRANSACTION; EVAL INSERT INTO t$counter(b,c,d,e) VALUES (12.111,REPEAT('a2',50),REPEAT('a2',50), REPEAT('a2',50)); EVAL INSERT INTO t$counter(b,c,d,e) VALUES (13.111,REPEAT('a3',50),REPEAT('a3',50), REPEAT('a3',50)); EVAL UPDATE t$counter SET e = REPEAT('ta',50); EVAL DELETE FROM t$counter WHERE a = 3; SAVEPOINT A; EVAL INSERT INTO t$counter(b,c,d,e) VALUES (14.111,REPEAT('a4',50),REPEAT('a4',50), REPEAT('a4',50)); EVAL UPDATE t$counter SET e = REPEAT('yb',50); EVAL DELETE FROM t$counter WHERE a = 1; SAVEPOINT B; ROLLBACK TO SAVEPOINT A; COMMIT; EVAL ALTER TABLE t$counter ADD COLUMN f BLOB(100), ADD INDEX `idx1` (d); EVAL ALTER TABLE t$counter DROP COLUMN f, DROP INDEX `idx1` , ADD INDEX `idx2` (d), ALGORITHM=COPY; # create and drop same table in loop CREATE TEMPORARY TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, b FLOAT(5,3), c BLOB(100),d VARCHAR(100),e TEXT) ENGINE=InnoDB; INSERT INTO t1(b,c,d,e) VALUES (11.111,REPEAT('a1',50),REPEAT('a1',50), REPEAT('a1',50)); START TRANSACTION; INSERT INTO t1(b,c,d,e) VALUES (12.111,REPEAT('a2',50),REPEAT('a2',50), REPEAT('a2',50)); INSERT INTO t1(b,c,d,e) VALUES (13.111,REPEAT('a3',50),REPEAT('a3',50), REPEAT('a3',50)); UPDATE t1 SET e = REPEAT('ta',50); DELETE FROM t1 WHERE a = 3; SAVEPOINT A; INSERT INTO t1(b,c,d,e) VALUES (14.111,REPEAT('a4',50),REPEAT('a4',50), REPEAT('a4',50)); UPDATE t1 SET e = REPEAT('yb',50); DELETE FROM t1 WHERE a = 1; SAVEPOINT B; ROLLBACK TO SAVEPOINT A; COMMIT; ALTER TABLE t1 ADD COLUMN f BLOB(100), ADD INDEX `idx1` (d); ALTER TABLE t1 DROP COLUMN f, DROP INDEX `idx1` , ADD INDEX `idx2` (d), ALGORITHM=COPY; DROP TABLE t1; # check separate ibd file is not created --list_files $MYSQL_DATA_DIR/test_db/ *ibd --inc $counter } DROP DATABASE test_db; USE test; --enable_query_log --echo # creation of shared temp-tablespace in MYSQL_DATA_DIR --list_files $MYSQL_DATA_DIR/ ibtmp1* #----------------------------------------------------------------------------- # # 3. Temp table operation - # a) can not create temp table with partition # b) can not create/drop view on temp tables. # c) select/join on temp tables. # d) Lock/flush on tables # e) create temp table as select # --disable_warnings DROP TABLE IF EXISTS t1,t2,t3,t4; --enable_warnings # check by allowing file per table on SELECT @@global.innodb_file_per_table; USE test; CREATE TEMPORARY TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, b FLOAT(5,3), c BLOB(100),d VARCHAR(100),e TEXT) ENGINE=InnoDB; CREATE TEMPORARY TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, b FLOAT, c BLOB(100), d VARCHAR(100),e TEXT) ENGINE=InnoDB; # Can not create temp table with partition --ERROR 1562 CREATE TEMPORARY TABLE t3 (val INT) ENGINE = InnoDB PARTITION BY LIST(val)( PARTITION mypart1 VALUES IN (1,3,5), PARTITION MyPart2 VALUES IN (2,4,6) ); INSERT INTO t1(b,c,d,e) VALUES (11.111,REPEAT('a1',50),REPEAT('a1',50), REPEAT('a1',50)); INSERT INTO t2(b,c,d,e) VALUES (11.111,REPEAT('t1',50),REPEAT('t1',50), REPEAT('a2',50)); INSERT INTO t2(b,c,d,e) VALUES (11.111,REPEAT('t2',50),REPEAT('t2',50), REPEAT('a2',50)); # Check with join of SELECT t1.a,t2.a,RIGHT(t1.c,10),RIGHT(t2.c,10) FROM t1,t2 WHERE t1.c LIKE t2.c; SELECT t1.a,t2.a,RIGHT(t1.c,10),RIGHT(t2.c,10) FROM t1,t2 WHERE t1.c NOT LIKE t2.c AND t1.a=t2.a; # you cannot create a TEMPORARY view --ERROR 1352 CREATE OR REPLACE VIEW vw1 AS SELECT * FROM t1; # Check with create temp as <select> CREATE TEMPORARY TABLE t3 AS SELECT t1.a,RIGHT(t1.c,10),RIGHT(t2.c,10) FROM t1,t2 WHERE t1.c NOT LIKE t2.c AND t1.a=t2.a; SELECT * FROM t3; CREATE TABLE t4 AS SELECT t1.a,RIGHT(t1.c,10),RIGHT(t2.c,10) FROM t1,t2 WHERE t1.c NOT LIKE t2.c AND t1.a=t2.a; SELECT * FROM t4; # join on temp and non temp table SELECT * FROM t3,t4 WHERE t3.a=t4.a; SELECT * FROM t3,t4 WHERE t3.a!=t4.a; #Acquire lock and flush LOCK TABLES t1 READ; SELECT t1.a,t2.a,RIGHT(t1.c,10),RIGHT(t2.c,10) FROM t1,t2 WHERE t1.c LIKE t2.c; SELECT t1.a,t2.a,RIGHT(t1.c,10),RIGHT(t2.c,10) FROM t1,t2 WHERE t1.c NOT LIKE t2.c AND t1.a=t2.a; # delete records even type is read as lock table is ignored for temp tables DELETE FROM t1; SELECT * FROM t1; UNLOCK TABLES; LOCK TABLES t2 WRITE,t3 WRITE,t4 WRITE; DELETE FROM t2 WHERE t2.c LIKE REPEAT('t2',50); SELECT t2.a,RIGHT(t2.c,10) FROM t2; DELETE FROM t3; DELETE FROM t4; SELECT * FROM t3,t4; UNLOCK TABLES; --list_files $MYSQL_DATA_DIR/ ibtmp1* --list_files $MYSQL_DATA_DIR/test/ t4*ibd* DROP TABLE t1,t2,t3,t4; #----------------------------------------------------------------------------- # # 4. Temp table operation - # a) restart on existing datadir and see ibtmp1 removed on clean shutdown # # check by allowing file per table on SELECT @@global.innodb_file_per_table; CREATE TEMPORARY TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, b FLOAT(5,3), c BLOB(100),d VARCHAR(100),e TEXT) ENGINE=InnoDB; CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, b FLOAT(5,3), c BLOB(100),d VARCHAR(100),e TEXT) ENGINE=InnoDB; INSERT INTO t1(b,c,d,e) VALUES (11.111,REPEAT('a1',50),REPEAT('a1',50), REPEAT('a1',50)); INSERT INTO t1(b,c,d,e) VALUES (11.111,REPEAT('a1',50),REPEAT('a1',50), REPEAT('a1',50)); SELECT a,b,RIGHT(c,10),RIGHT(d,10),RIGHT(e,10) FROM t1; UPDATE t1 SET a = a + 5; DELETE FROM t1 WHERE a > 6; SELECT a,b,RIGHT(c,10),RIGHT(d,10),RIGHT(e,10) FROM t1; INSERT INTO t2(b,c,d,e) VALUES (11.111,REPEAT('a1',50),REPEAT('a1',50), REPEAT('a1',50)); SELECT a,b,RIGHT(c,10),RIGHT(d,10),RIGHT(e,10) FROM t2; UPDATE t2 SET a = a + 5; DELETE FROM t2 WHERE a > 6; SELECT a,b,RIGHT(c,10),RIGHT(d,10),RIGHT(e,10) FROM t2; # --echo # shutting down the server --source include/shutdown_mysqld.inc --echo # list_file, no files expected - temp tablespace cleared on stopping server --list_files $MYSQL_DATA_DIR/ ibtmp1* # --source include/start_mysqld.inc # check temp table after restart CREATE TEMPORARY TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, b FLOAT(5,3), c BLOB(100),d VARCHAR(100),e TEXT) ENGINE=InnoDB; INSERT INTO t1(b,c,d,e) VALUES (11.111,REPEAT('a1',50),REPEAT('a1',50), REPEAT('a1',50)); INSERT INTO t1(b,c,d,e) VALUES (11.111,REPEAT('a1',50),REPEAT('a1',50), REPEAT('a1',50)); SELECT a,b,RIGHT(c,10),RIGHT(d,10),RIGHT(e,10) FROM t1; UPDATE t1 SET a = a + 5; DELETE FROM t1 WHERE a > 6; SELECT a,b,RIGHT(c,10),RIGHT(d,10),RIGHT(e,10) FROM t1; DROP TABLE t1; --source include/restart_mysqld.inc # check not temp table SHOW TABLES; DROP TABLE t2;
Close