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.148.250.110
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-wl6445-1.test
######## suite/innodb/t/innodb-wl6445-1 ########## # # # Testcase for worklog WL#6445: InnoDB should be able to work with # # read-only tables # All sub-test in this file focus on restarting server in read only # # and verify necessary operations blocked # # operations # # # # # # Creation: # # 2011-09-06 Implemented this test as part of WL#6445 # # # ###################################################################### # Restarting is not supported in embedded --source include/not_embedded.inc --source include/have_innodb.inc # This test takes long time, so only run it with the --big-test mtr-flag. --source include/big_test.inc let MYSQLD_DATADIR =`SELECT @@datadir`; let $innodb_file_per_table = `SELECT @@innodb_file_per_table`; let $innodb_flush_log_at_trx_commit_orig =`select @@innodb_flush_log_at_trx_commit`; SET GLOBAL innodb_file_per_table = 1; SELECT @@innodb_file_per_table; let $MYSQLD_DATADIR = `SELECT @@datadir`; let $data_index_directory = DATA DIRECTORY='$MYSQL_TMP_DIR/alt_dir'; CREATE DATABASE testdb_wl6445; #------------------------------------------------------------------------------ # Testcase 1 covers # a) Create table/data , restart server in readonly mode # b) verify DDL/DML/DCL in read only mode # c) statements blocked for non root and root user from differet sessions. #------------------------------------------------------------------------------ --echo case # 1 USE testdb_wl6445; CREATE TABLE t1 ( i int PRIMARY KEY , j blob) ENGINE = InnoDB; INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200)); SELECT i,LEFT(j,20) FROM t1 ORDER BY i; # Create user with minimun access CREATE USER 'test1'@'localhost' IDENTIFIED BY '123'; GRANT ALL ON testdb_wl6445.* TO 'test1'@'localhost'; # Create user with root access CREATE USER 'test2'@'localhost' IDENTIFIED BY '123'; GRANT ALL ON *.* TO 'test2'@'localhost'; # check when datadir and index dir are specified --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR EVAL CREATE TABLE otherlocation (id int PRIMARY KEY) ENGINE=InnoDB , $data_index_directory; INSERT INTO otherlocation VALUES (1),(2),(3); SELECT * FROM otherlocation ORDER BY id; #SHOW ENGINE INNODB STATUS; # let $restart_parameters = restart: --innodb-read-only; --source include/restart_mysqld.inc SET GLOBAL innodb_file_per_table = 1; # Nothing to do with wl64645.non-InnoDB issue. But need to document in QA note. CREATE USER 'test3'@'localhost' IDENTIFIED BY '123'; GRANT ALL ON testdb_wl6445.* TO 'test3'@'localhost'; USE testdb_wl6445; SELECT i FROM t1 ORDER BY i; --ERROR ER_CANT_LOCK INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200)); SELECT i,LEFT(j,20) FROM t1 ORDER BY i; --echo # connection con_test1_user try to modify --connect (con_test1_user,'localhost','test1','123',) SELECT user(); USE testdb_wl6445; --ERROR ER_CANT_LOCK INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200)); SELECT i,LEFT(j,20) FROM t1 ORDER BY i; --ERROR ER_INNODB_READ_ONLY CREATE TABLE t2 ( i int ,j blob) ENGINE = Innodb; --ERROR ER_CANT_LOCK UPDATE t1 SET i = i+1; --echo # disconnect con_test1_user --disconnect con_test1_user --echo # connection con_test2_user --connect (con_test2_user,'localhost','test2','123',) SELECT user(); USE testdb_wl6445; --ERROR ER_CANT_LOCK INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200)); SELECT i,LEFT(j,20) FROM t1 ORDER BY i; --ERROR ER_INNODB_READ_ONLY CREATE TABLE t2 ( i int , j blob) ENGINE = Innodb; --ERROR ER_CANT_LOCK UPDATE t1 SET i = i+1; # Fix in next revision - known ( no data returned) #SHOW ENGINE INNODB STATUS; FLUSH STATUS; FLUSH LOGS; FLUSH TABLES t1; FLUSH TABLES WITH READ LOCK; UNLOCK TABLES; --echo # disconnect con_test2_user --disconnect con_test2_user --echo # connection default --connection default USE testdb_wl6445; --ERROR ER_CANT_LOCK INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200)); SELECT i,LEFT(j,20) FROM t1 ORDER BY i; --ERROR ER_INNODB_READ_ONLY CREATE TABLE t2 ( i int , j blob) ENGINE = Innodb; --ERROR ER_CANT_LOCK UPDATE t1 SET i = i+1; # check with table having data and index directory specified --ERROR ER_CANT_LOCK INSERT INTO otherlocation VALUES (1),(2),(3); SELECT * FROM otherlocation ORDER BY id; # Fix in next revision - known ( no data returned) # SHOW ENGINE INNODB STATUS; FLUSH STATUS; FLUSH LOGS; FLUSH TABLES t1; FLUSH TABLES WITH READ LOCK; UNLOCK TABLES; #------------------------------------------------------------------------------ # clean-up #------------------------------------------------------------------------------ # let $restart_parameters = restart; --source include/restart_mysqld.inc DROP USER 'test1'@'localhost'; DROP USER 'test2'@'localhost'; DROP USER 'test3'@'localhost'; DROP DATABASE testdb_wl6445; #------------------------------------------------------------------------------ # Testcase 2 covers # a) Create table/data , perform transaction , restart server in readonly mode # b) verfiy DDL/DML/DCL in read only mode #------------------------------------------------------------------------------ --echo case # 2 CREATE DATABASE testdb_wl6445; SET GLOBAL innodb_file_per_table = 1; USE testdb_wl6445; CREATE TABLE t1 ( i int PRIMARY KEY , j blob) ENGINE = InnoDB; INSERT INTO t1 VALUES (1,repeat('a',4000)),(2,repeat('b',4000)),(3,repeat('c',4000)); SELECT i,LEFT(j,20) FROM t1 ORDER BY i; START TRANSACTION; let $counter= 50; --disable_query_log while ($counter>3) { EVAL INSERT INTO testdb_wl6445.t1 VALUES ($counter,repeat(CONCAT('a',$counter),2000)); --dec $counter } --enable_query_log SAVEPOINT A; let $counter= 100; --disable_query_log while ($counter>50) { EVAL INSERT INTO testdb_wl6445.t1 VALUES ($counter,repeat(CONCAT('a',$counter),2000)); --dec $counter } --enable_query_log SAVEPOINT B; ROLLBACK TO A; --echo "---commit first 50 records " COMMIT; SELECT COUNT(*) FROM testdb_wl6445.t1; #SHOW ENGINE INNODB STATUS; # let $restart_parameters = restart: --innodb-read-only; --source include/restart_mysqld.inc USE testdb_wl6445; --ERROR ER_CANT_LOCK INSERT INTO t1 VALUES (211,repeat('a',200)),(212,repeat('b',200)),(213,repeat('c',200)); SELECT i,LEFT(j,20) FROM t1 WHERE i%10=0 ORDER BY i; --ERROR ER_INNODB_READ_ONLY CREATE TABLE t2 ( i int , j blob) ENGINE = Innodb; --ERROR ER_CANT_LOCK UPDATE t1 SET i = i+1; SELECT i,LEFT(j,20) FROM t1 WHERE i%10=0 ORDER BY i; # Check with transaction in read-only mode with innodb_flush_log_at_trx_commit=0 START TRANSACTION; SET GLOBAL innodb_flush_log_at_trx_commit = 0; let $counter= 200; --disable_query_log while ($counter>150) { --ERROR ER_CANT_LOCK EVAL INSERT INTO testdb_wl6445.t1 VALUES ($counter,repeat(CONCAT('a',$counter),2000)); --ERROR ER_CANT_LOCK UPDATE testdb_wl6445.t1 SET i = i + 1; --ERROR ER_CANT_LOCK DELETE FROM testdb_wl6445.t1; --dec $counter } --enable_query_log SAVEPOINT A; let $counter= 250; --disable_query_log while ($counter>200) { --ERROR ER_CANT_LOCK EVAL INSERT INTO testdb_wl6445.t1 VALUES ($counter,repeat(CONCAT('a',$counter),2000)); --ERROR ER_CANT_LOCK UPDATE testdb_wl6445.t1 SET i = i + 1; --ERROR ER_CANT_LOCK DELETE FROM testdb_wl6445.t1; --dec $counter } --enable_query_log SAVEPOINT B; ROLLBACK TO A; --echo "---commit first 50 records with innodb_flush_log_at_trx_commit = 0 --" COMMIT; SELECT i,LEFT(j,20) FROM t1 WHERE i%10=0 ORDER BY i; # Check with transaction in read-only mode with innodb_flush_log_at_trx_commit=1 START TRANSACTION; SET GLOBAL innodb_flush_log_at_trx_commit = 1; let $counter= 200; --disable_query_log while ($counter>150) { --ERROR ER_CANT_LOCK EVAL INSERT INTO testdb_wl6445.t1 VALUES ($counter,repeat(CONCAT('a',$counter),2000)); --ERROR ER_CANT_LOCK UPDATE testdb_wl6445.t1 SET i = i + 1; --ERROR ER_CANT_LOCK DELETE FROM testdb_wl6445.t1; --dec $counter } --enable_query_log SAVEPOINT A; let $counter= 250; --disable_query_log while ($counter>200) { --ERROR ER_CANT_LOCK EVAL INSERT INTO testdb_wl6445.t1 VALUES ($counter,repeat(CONCAT('a',$counter),2000)); --ERROR ER_CANT_LOCK UPDATE testdb_wl6445.t1 SET i = i + 1; --ERROR ER_CANT_LOCK DELETE FROM testdb_wl6445.t1; --dec $counter } --enable_query_log SAVEPOINT B; ROLLBACK TO A; --echo "---commit first 50 records with innodb_flush_log_at_trx_commit = 1 --" COMMIT; SELECT i,LEFT(j,20) FROM t1 WHERE i%10=0 ORDER BY i; # Check with transaction in read-only mode with innodb_flush_log_at_trx_commit=2 START TRANSACTION; SET GLOBAL innodb_flush_log_at_trx_commit = 2; let $counter= 200; --disable_query_log while ($counter>150) { --ERROR ER_CANT_LOCK EVAL INSERT INTO testdb_wl6445.t1 VALUES ($counter,repeat(CONCAT('a',$counter),2000)); --ERROR ER_CANT_LOCK UPDATE testdb_wl6445.t1 SET i = i + 1; --ERROR ER_CANT_LOCK DELETE FROM testdb_wl6445.t1; --dec $counter } --enable_query_log SAVEPOINT A; let $counter= 250; --disable_query_log while ($counter>200) { --ERROR ER_CANT_LOCK EVAL INSERT INTO testdb_wl6445.t1 VALUES ($counter,repeat(CONCAT('a',$counter),2000)); --ERROR ER_CANT_LOCK UPDATE testdb_wl6445.t1 SET i = i + 1; --ERROR ER_CANT_LOCK DELETE FROM testdb_wl6445.t1; --dec $counter } --enable_query_log SAVEPOINT B; ROLLBACK TO A; --echo "---commit first 50 records with innodb_flush_log_at_trx_commit = 2 --" COMMIT; # Fix in next revision - known ( no data returned) # SHOW ENGINE INNODB STATUS; FLUSH STATUS; FLUSH LOGS; FLUSH TABLES t1; FLUSH TABLES WITH READ LOCK; UNLOCK TABLES; #------------------------------------------------------------------------------ # clean-up #------------------------------------------------------------------------------ # let $restart_parameters = restart; --source include/restart_mysqld.inc DROP DATABASE testdb_wl6445; #------------------------------------------------------------------------------ # Testcase 3 covers # a) Create table/data with trigger & procedure, partitioned table # b) restart server in readonly mode # c) verfiy behavior with trigger,procedure,partitioned and temp table #------------------------------------------------------------------------------ --echo case # 3 CREATE DATABASE testdb_wl6445; USE testdb_wl6445; CREATE TABLE t1 ( i int PRIMARY KEY , j blob) ENGINE = InnoDB; CREATE TABLE t2 ( t2_i int PRIMARY KEY , t2_j blob) ENGINE = InnoDB; CREATE TABLE t3 ( i int PRIMARY KEY , j VARCHAR(20)) ENGINE = InnoDB; # create partitioned table CREATE TABLE t4 (val INT) PARTITION BY LIST(val)( PARTITION mypart_odd VALUES IN (1,3,5), PARTITION MyPart_even VALUES IN (2,4,6)); INSERT INTO testdb_wl6445.t4 VALUES (1),(2),(3),(4),(5),(6); SELECT * FROM testdb_wl6445.t4 ORDER BY val; DELIMITER //; CREATE TRIGGER TRIGGER_1 BEFORE INSERT ON testdb_wl6445.t1 FOR EACH ROW BEGIN INSERT INTO testdb_wl6445.t2 SET t2_i = NEW.i , t2_j = NEW.j; END;// CREATE PROCEDURE proc1 (OUT param1 INT) BEGIN SELECT COUNT(*) INTO param1 FROM testdb_wl6445.t1; END;// CREATE PROCEDURE proc2 (IN param1 INT,IN param2 VARCHAR(20)) BEGIN INSERT INTO testdb_wl6445.t3 VALUES (param1,param2); END;// DELIMITER ;// INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200)); SELECT i,LEFT(j,20) FROM t1 ORDER BY i; SELECT t2_i,LEFT(t2_j,20) FROM t2 ORDER BY t2_i; CALL proc1(@a); SELECT @a; CALL proc2(1,'test1'); SELECT * FROM t3; #SHOW ENGINE INNODB STATUS; # let $restart_parameters = restart: --innodb-read-only; --source include/restart_mysqld.inc SET GLOBAL innodb_file_per_table = 1; USE testdb_wl6445; --ERROR ER_CANT_LOCK INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200)); SELECT i,LEFT(j,20) FROM t1 ORDER BY i; SELECT t2_i,LEFT(t2_j,20) FROM t2 ORDER BY t2_i; CALL proc1(@a); SELECT @a; --ERROR ER_CANT_LOCK CALL proc2(2,'test2'); SELECT * FROM t3; # try to CREATE temp table --ERROR ER_INNODB_READ_ONLY CREATE TEMPORARY TABLE temp_1 ( i INT ) ENGINE = Innodb; # Try to insert with partitioned table --ERROR ER_CANT_LOCK INSERT INTO testdb_wl6445.t4 VALUES (1),(2),(3),(4),(5),(6); SELECT * FROM testdb_wl6445.t4 ORDER BY val; FLUSH STATUS; FLUSH LOGS; FLUSH TABLES t1,t2,t3; FLUSH TABLES WITH READ LOCK; UNLOCK TABLES; #------------------------------------------------------------------------------ # clean-up #------------------------------------------------------------------------------ # let $restart_parameters = restart; --source include/restart_mysqld.inc DROP DATABASE testdb_wl6445; #------------------------------------------------------------------------------ # Testcase 4 covers # a) Create table/data restart server in readonly mode # b) check the effect of server variables impacting change of RO # ( they will be ignored) #------------------------------------------------------------------------------ --echo case # 4 CREATE DATABASE testdb_wl6445; USE testdb_wl6445; CREATE TABLE t1 ( i int PRIMARY KEY , j VARCHAR(300), FULLTEXT KEY (j)) ENGINE = InnoDB; CREATE INDEX idx1 ON testdb_wl6445.t1(i); INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200)); INSERT INTO t1 VALUES (4,'mysql database'),(5,'mysql database innodb support'),(6,'innodb engine'); SELECT i,LEFT(j,20) FROM t1 ORDER BY i; #FTS Query SELECT * FROM t1 WHERE MATCH (j) AGAINST ('mysql (+database -innodb)' IN BOOLEAN MODE) ; # store initial values let $innodb_max_purge_lag_orig = `SELECT @@innodb_max_purge_lag`; let $innodb_max_purge_lag_delay_orig = `SELECT @@innodb_max_purge_lag_delay`; let $innodb_purge_batch_size_orig = `select @@innodb_purge_batch_size`; let $innodb_purge_threads_orig = `SELECT @@innodb_purge_threads`; let $relay_log_purge_orig = `select @@relay_log_purge`; let $innodb_buffer_pool_size_orig = `select @@innodb_buffer_pool_size`; let $innodb_change_buffer_max_size_orig = `select @@innodb_change_buffer_max_size`; let $innodb_change_buffering_orig = `select @@innodb_change_buffering`; let $innodb_print_all_deadlocks_orig = `select @@innodb_print_all_deadlocks`; let $restart_parameters = restart: --innodb-read-only --innodb_purge_threads=5 --innodb_buffer_pool_size=16M; --source include/restart_mysqld.inc SET GLOBAL innodb_max_purge_lag = 10; SET GLOBAL innodb_max_purge_lag_delay = 10; SET GLOBAL innodb_purge_batch_size = 600; # purge thread is read only variable #SET GLOBAL innodb_purge_threads = 5; SET GLOBAL relay_log_purge = 0; SET GLOBAL innodb_change_buffer_max_size = 30; SET GLOBAL innodb_change_buffering = 'changes'; SET GLOBAL innodb_print_all_deadlocks = 'ON'; USE testdb_wl6445; --ERROR ER_CANT_LOCK INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200)); --ERROR ER_CANT_LOCK UPDATE t1 SET i = i + 1; --ERROR ER_CANT_LOCK DELETE FROM t1 ; SELECT @@innodb_max_purge_lag,@@innodb_max_purge_lag_delay,@@innodb_purge_batch_size, @@innodb_purge_threads,@@relay_log_purge,@@innodb_buffer_pool_size, @@innodb_change_buffer_max_size,@@innodb_change_buffering,@@innodb_print_all_deadlocks; SELECT i,LEFT(j,20) FROM t1 ORDER BY i; #FTS Query SELECT * FROM t1 WHERE MATCH (j) AGAINST ('mysql (+database -innodb)' IN BOOLEAN MODE) ; SELECT * FROM t1 WHERE MATCH (j) AGAINST ('innodb') ; # restore initial values --disable_query_log eval SET GLOBAL innodb_max_purge_lag=$innodb_max_purge_lag_orig; eval SET GLOBAL innodb_max_purge_lag_delay=$innodb_max_purge_lag_delay_orig; eval SET GLOBAL innodb_purge_batch_size = $innodb_purge_batch_size_orig; #eval SET GLOBAL innodb_purge_threads = $innodb_purge_threads_orig; eval SET GLOBAL relay_log_purge = $relay_log_purge_orig; eval SET GLOBAL innodb_change_buffer_max_size = $innodb_change_buffer_max_size_orig; eval SET GLOBAL innodb_change_buffering = $innodb_change_buffering_orig; eval SET GLOBAL innodb_print_all_deadlocks = $innodb_print_all_deadlocks_orig; --enable_query_log #------------------------------------------------------------------------------ # clean-up #------------------------------------------------------------------------------ # let $restart_parameters = restart; --source include/restart_mysqld.inc DROP DATABASE testdb_wl6445; #------------------------------------------------------------------------------ # Testcase 5 covers # a) Create table/data restart server in readonly mode # b) check starting with both --read-only and --innodb-read-only # c) check starting with only --read-only #------------------------------------------------------------------------------ --echo case # 5 CREATE DATABASE testdb_wl6445; USE testdb_wl6445; CREATE TABLE t1 ( i int PRIMARY KEY , j VARCHAR(300), FULLTEXT KEY (j)) ENGINE = InnoDB; CREATE INDEX idx1 ON testdb_wl6445.t1(i); INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200)); INSERT INTO t1 VALUES (4,'mysql database'),(5,'mysql database innodb support'),(6,'innodb engine'); #FTS Query SELECT * FROM t1 WHERE MATCH (j) AGAINST ('mysql (+database -innodb)' IN BOOLEAN MODE) ; SELECT * FROM t1 WHERE MATCH (j) AGAINST ('innodb') ; let $restart_parameters = restart: --innodb-read-only --read-only; --source include/restart_mysqld.inc USE testdb_wl6445; show tables; select * from t1 where i = 4; # check if root user able to modify --ERROR ER_CANT_LOCK INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200)); --ERROR ER_CANT_LOCK UPDATE t1 SET i = i + 20; --ERROR ER_CANT_LOCK DELETE FROM t1; --ERROR ER_INNODB_READ_ONLY CREATE TABLE t2 ( i INT ) ENGINE = Innodb; CREATE USER 'test5'@'localhost' IDENTIFIED BY '123'; GRANT ALL ON testdb_wl6445.* TO 'test5'@'localhost'; let $restart_parameters = restart: --read-only; --source include/restart_mysqld.inc USE testdb_wl6445; # check if root user able to do DML/DDL INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200)); SELECT i,LEFT(j,20) FROM t1 ORDER BY i; UPDATE t1 SET i = i + 20; SELECT i,LEFT(j,20) FROM t1 ORDER BY i; DELETE FROM t1; SELECT i,LEFT(j,20) FROM t1 ORDER BY i; CREATE TABLE t2 ( i INT ) ENGINE = Innodb; CREATE USER 'test5_2'@'localhost' IDENTIFIED BY '123'; GRANT ALL ON testdb_wl6445.* TO 'test5_2'@'localhost'; #------------------------------------------------------------------------------ # clean-up #------------------------------------------------------------------------------ # let $restart_parameters = restart; --source include/restart_mysqld.inc DROP USER 'test5_2'@'localhost'; DROP USER 'test5'@'localhost'; DROP DATABASE testdb_wl6445; #------------------------------------------------------------------------------ # Testcase 6 covers # a) Create table/data restart server in readonly mode # b) check mysqldump/mysqlimport work #------------------------------------------------------------------------------ --echo case # 6 CREATE DATABASE testdb_wl6445; USE testdb_wl6445; CREATE TABLE t1 ( i int PRIMARY KEY ) ENGINE = InnoDB; CREATE INDEX idx1 ON testdb_wl6445.t1(i); INSERT INTO t1 VALUES (1),(2),(3); SELECT i FROM t1 ORDER BY i; --echo # Creating a temp sql file to be loaded. --write_file $MYSQLTEST_VARDIR/tmp/t1.sql 11 12 13 EOF let $restart_parameters = restart: --innodb-read-only; --source include/restart_mysqld.inc USE testdb_wl6445; # try mysql import --replace_regex /.*Error//i --error 1 --exec $MYSQL_IMPORT -uroot testdb_wl6445 $MYSQLTEST_VARDIR/tmp/t1.sql 2>&1 # only 3 records get in select as import shoudl fail due to --innodb-read-only SELECT i FROM t1 ORDER BY i; # mysqldump works --exec $MYSQL_DUMP --skip-comments --databases testdb_wl6445 > $MYSQLTEST_VARDIR/tmp/testdb_wl6445_dump.txt --error 0,1 --remove_file $MYSQLTEST_VARDIR/tmp/testdb_wl6445_dump.txt --error 0,1 --remove_file $MYSQLTEST_VARDIR/tmp/t1.sql #------------------------------------------------------------------------------ # clean-up #------------------------------------------------------------------------------ let $restart_parameters = restart; --source include/restart_mysqld.inc DROP DATABASE testdb_wl6445; --rmdir $MYSQL_TMP_DIR/alt_dir/testdb_wl6445 --rmdir $MYSQL_TMP_DIR/alt_dir --disable_query_log eval SET GLOBAL INNODB_FILE_PER_TABLE=$innodb_file_per_table; eval SET GLOBAL innodb_flush_log_at_trx_commit = $innodb_flush_log_at_trx_commit_orig; call mtr.add_suppression("deleting orphaned .ibd file"); call mtr.add_suppression("\\[ERROR\\] InnoDB: Cannot open datafile for read-only:"); call mtr.add_suppression("\\[ERROR\\] InnoDB: Operating system error number 2 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: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them."); --enable_query_log #------------------------------------------------------------------------------ # Testcase 7 covers # a) Create/Load table in normal mode such that index level > 1. # b) Restart server in read-only mode and try to check validity of table/data. #------------------------------------------------------------------------------ --echo case # 7 (restart server in read-only mode and perform check table) use test; # create table t1 ( i int, f float, c char(100), b blob ) engine = innodb; # delimiter |; CREATE PROCEDURE populate_t1() BEGIN DECLARE i INT DEFAULT 1; while (i <= 100) DO insert into t1 values ( i, 2.323, 'adfaqfafafafafsasfafsa', 'badfadfsaeerer234234asdfdsafdasr2354234324234234'); SET i = i + 1; END WHILE; END| delimiter ;| begin; call populate_t1(); commit; check table t1 extended; # # let $restart_parameters = restart: --innodb-read-only; --source include/restart_mysqld.inc # check table t1 extended; #------------------------------------------------------------------------------ # clean-up #------------------------------------------------------------------------------ let $restart_parameters = restart; --source include/restart_mysqld.inc check table t1 extended; drop table t1; drop procedure populate_t1;
Close