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.217.163.75
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 /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
add_foreign_key.result
1.28
KB
-rw-r--r--
alter_crash.result
4.43
KB
-rw-r--r--
alter_foreign_crash.result
751
B
-rw-r--r--
alter_kill.result
2.42
KB
-rw-r--r--
alter_missing_tablespace.resul...
1.46
KB
-rw-r--r--
alter_page_size.result
1.14
KB
-rw-r--r--
alter_rename_existing.result
5.32
KB
-rw-r--r--
alter_rename_files.result
557
B
-rw-r--r--
alter_row_format.result
1.59
KB
-rw-r--r--
alter_table_redundant.result
278
B
-rw-r--r--
alter_table_stage_progress.res...
942
B
-rw-r--r--
analyze_index.result
705
B
-rw-r--r--
analyze_table.result
538
B
-rw-r--r--
attachable_trx.result
2.48
KB
-rw-r--r--
autoinc_debug.result
2.53
KB
-rw-r--r--
blob-crash-16k.result
2.1
KB
-rw-r--r--
blob-crash-4k.result
2.1
KB
-rw-r--r--
blob-crash.result
4.59
KB
-rw-r--r--
blob-update-debug.result
489
B
-rw-r--r--
blob_page_reserve.result
3.81
KB
-rw-r--r--
blob_redo.result
1.05
KB
-rw-r--r--
buf_pool_resize_oom.result
493
B
-rw-r--r--
bulk_create_index_online.resul...
1.21
KB
-rw-r--r--
cascade_lock_wait.result
1.52
KB
-rw-r--r--
check_ibd_filesize_16k.result
1.58
KB
-rw-r--r--
check_sector_size.result
276
B
-rw-r--r--
checksum.result
331
B
-rw-r--r--
cmp_per_index.result
2.96
KB
-rw-r--r--
crc32_endianness.result
540
B
-rw-r--r--
create-index.result
283
B
-rw-r--r--
create_isl_with_direct.result
328
B
-rw-r--r--
create_table.result
1.97
KB
-rw-r--r--
create_tablespace.result
81.15
KB
-rw-r--r--
create_tablespace_16k.result
69.23
KB
-rw-r--r--
create_tablespace_32k.result
7.33
KB
-rw-r--r--
create_tablespace_4k.result
36.13
KB
-rw-r--r--
create_tablespace_64k.result
7.64
KB
-rw-r--r--
create_tablespace_8k.result
50.53
KB
-rw-r--r--
create_tablespace_debug.result
5.02
KB
-rw-r--r--
create_tablespace_notembedded....
692
B
-rw-r--r--
create_tablespace_partition.re...
33.17
KB
-rw-r--r--
create_tablespace_replication....
2.02
KB
-rw-r--r--
deadlock_detect.result
562
B
-rw-r--r--
default_row_format.result
17.56
KB
-rw-r--r--
default_row_format_16k.result
17.91
KB
-rw-r--r--
default_row_format_compatibili...
4.14
KB
-rw-r--r--
default_row_format_tablespace....
8.64
KB
-rw-r--r--
deprecate_part_in_shared_ts.re...
5.87
KB
-rw-r--r--
doublewrite.result
8.1
KB
-rw-r--r--
dropdb.result
222
B
-rw-r--r--
end_range_check.result
3.06
KB
-rw-r--r--
end_range_check_2.result
811
B
-rw-r--r--
events-merge-tmp-path.result
1.33
KB
-rw-r--r--
file_format_defaults.result
2.84
KB
-rw-r--r--
file_format_upgrade_16k.result
420
B
-rw-r--r--
flush-hang.result
1.27
KB
-rw-r--r--
foreign_key.result
9.21
KB
-rw-r--r--
fts_exec_interrupt.result
723
B
-rw-r--r--
help_verbose.result
80
B
-rw-r--r--
high_prio_trx_1.result
505
B
-rw-r--r--
high_prio_trx_2.result
581
B
-rw-r--r--
high_prio_trx_3.result
665
B
-rw-r--r--
high_prio_trx_4.result
711
B
-rw-r--r--
high_prio_trx_5.result
858
B
-rw-r--r--
high_prio_trx_6.result
775
B
-rw-r--r--
high_prio_trx_7.result
5.67
KB
-rw-r--r--
high_prio_trx_commit_crash.res...
1
KB
-rw-r--r--
high_prio_trx_debug.result
1.09
KB
-rw-r--r--
high_prio_trx_fk.result
918
B
-rw-r--r--
high_prio_trx_predicate.result
824
B
-rw-r--r--
high_prio_trx_rpl.result
1.65
KB
-rw-r--r--
i_s_files_debug.result
471
B
-rw-r--r--
ibuf_not_empty.result
969
B
-rw-r--r--
import.result
1.72
KB
-rw-r--r--
import_compress_encrypt.result
5.28
KB
-rw-r--r--
import_compress_encrypt_upgrad...
2.53
KB
-rw-r--r--
import_export_4k.result
724
B
-rw-r--r--
import_tablespace_page_corrupt...
555
B
-rw-r--r--
import_tablespace_schema_missm...
2.11
KB
-rw-r--r--
import_update_stats.result
2.86
KB
-rw-r--r--
index-online-norebuild.result
897
B
-rw-r--r--
index_length.result
1.28
KB
-rw-r--r--
index_merge_threshold.result
54.7
KB
-rw-r--r--
index_tree_operation.result
1.65
KB
-rw-r--r--
innodb-2byte-collation.result
3.28
KB
-rw-r--r--
innodb-ac-non-locking-select.r...
861
B
-rw-r--r--
innodb-alter-autoinc.result
4.27
KB
-rw-r--r--
innodb-alter-debug-wl6554.resu...
12.79
KB
-rw-r--r--
innodb-alter-debug.result
2.64
KB
-rw-r--r--
innodb-alter-nullable.result
1.52
KB
-rw-r--r--
innodb-alter-wl6554.result
3.13
KB
-rw-r--r--
innodb-alter.result
30.33
KB
-rw-r--r--
innodb-analyze.result
58
B
-rw-r--r--
innodb-autoinc-18274.result
805
B
-rw-r--r--
innodb-autoinc-44030.result
732
B
-rw-r--r--
innodb-autoinc-56228.result
847
B
-rw-r--r--
innodb-autoinc-optimize.result
321
B
-rw-r--r--
innodb-autoinc.result
41.48
KB
-rw-r--r--
innodb-blob.result
4.91
KB
-rw-r--r--
innodb-bug-14068765.result
2.81
KB
-rw-r--r--
innodb-bug-14084530.result
701
B
-rw-r--r--
innodb-bug12552164.result
1.73
KB
-rw-r--r--
innodb-bug14219515.result
244
B
-rw-r--r--
innodb-change-buffer-recovery....
1.08
KB
-rw-r--r--
innodb-consistent.result
670
B
-rw-r--r--
innodb-import-partition-rpl.re...
2.46
KB
-rw-r--r--
innodb-import-partition.result
40.01
KB
-rw-r--r--
innodb-index-debug.result
13.64
KB
-rw-r--r--
innodb-index-online-delete.res...
642
B
-rw-r--r--
innodb-index-online-fk.result
26.4
KB
-rw-r--r--
innodb-index-online-purge.resu...
1.2
KB
-rw-r--r--
innodb-index-online.result
13.35
KB
-rw-r--r--
innodb-index.result
67.62
KB
-rw-r--r--
innodb-index_ucs2.result
3.62
KB
-rw-r--r--
innodb-isolation.result
43.25
KB
-rw-r--r--
innodb-large-prefix.result
1.27
KB
-rw-r--r--
innodb-lock-inherit-read_commi...
4.18
KB
-rw-r--r--
innodb-lock.result
3.22
KB
-rw-r--r--
innodb-multiple-tablespaces.re...
14.79
KB
-rw-r--r--
innodb-read-view.result
2.73
KB
-rw-r--r--
innodb-replace-debug.result
309
B
-rw-r--r--
innodb-semi-consistent.result
1.35
KB
-rw-r--r--
innodb-status-output.result
1.3
KB
-rw-r--r--
innodb-system-table-view.resul...
9.07
KB
-rw-r--r--
innodb-table-online.result
13.11
KB
-rw-r--r--
innodb-timeout.result
953
B
-rw-r--r--
innodb-truncate-debug.result
4.46
KB
-rw-r--r--
innodb-truncate.result
2.28
KB
-rw-r--r--
innodb-ucs2.result
15.38
KB
-rw-r--r--
innodb-update-insert.result
1.1
KB
-rw-r--r--
innodb-wl5522-1.result
29.45
KB
-rw-r--r--
innodb-wl5522-debug.result
30.05
KB
-rw-r--r--
innodb-wl5522.result
20.99
KB
-rw-r--r--
innodb-wl5980-alter.result
38.86
KB
-rw-r--r--
innodb-wl5980-debug.result
1.33
KB
-rw-r--r--
innodb-wl5980-discard.result
29.2
KB
-rw-r--r--
innodb-wl5980-linux.result
9.7
KB
-rw-r--r--
innodb-wl5980-windows.result
10.07
KB
-rw-r--r--
innodb-wl6045-1.result
3.72
KB
-rw-r--r--
innodb-wl6045-linux.result
11.11
KB
-rw-r--r--
innodb-wl6445-1.result
69
KB
-rw-r--r--
innodb-wl6445-2.result
3.57
KB
-rw-r--r--
innodb-wl6445.result
1.78
KB
-rw-r--r--
innodb.result
108.76
KB
-rw-r--r--
innodb_32k.result
3.25
KB
-rw-r--r--
innodb_64k.result
3.47
KB
-rw-r--r--
innodb_autoinc_lock_mode_zero....
1.22
KB
-rw-r--r--
innodb_autoinc_reset.result
423
B
-rw-r--r--
innodb_buffer_pool_dump_pct.re...
1.49
KB
-rw-r--r--
innodb_buffer_pool_load.result
2.02
KB
-rw-r--r--
innodb_buffer_pool_load_now.re...
1.6
KB
-rw-r--r--
innodb_buffer_pool_resize.resu...
1.29
KB
-rw-r--r--
innodb_buffer_pool_resize_debu...
3.24
KB
-rw-r--r--
innodb_buffer_pool_resize_with...
1.08
KB
-rw-r--r--
innodb_bug-13628249.result
988
B
-rw-r--r--
innodb_bug11754376.result
180
B
-rw-r--r--
innodb_bug11766634.result
396
B
-rw-r--r--
innodb_bug11789106.result
404
B
-rw-r--r--
innodb_bug11933790.result
135
B
-rw-r--r--
innodb_bug12400341.result
966
B
-rw-r--r--
innodb_bug12429573.result
708
B
-rw-r--r--
innodb_bug12661768.result
524
B
-rw-r--r--
innodb_bug14006907.result
934
B
-rw-r--r--
innodb_bug14007109.result
223
B
-rw-r--r--
innodb_bug14007649.result
1.17
KB
-rw-r--r--
innodb_bug14147491.result
730
B
-rw-r--r--
innodb_bug14169459.result
1.48
KB
-rw-r--r--
innodb_bug14676111.result
1.99
KB
-rw-r--r--
innodb_bug14704286.result
1.12
KB
-rw-r--r--
innodb_bug19164038.result
1023
B
-rw-r--r--
innodb_bug21704.result
2.65
KB
-rw-r--r--
innodb_bug30113362.result
2.95
KB
-rw-r--r--
innodb_bug30423.result
3.79
KB
-rw-r--r--
innodb_bug30594501.result
317
B
-rw-r--r--
innodb_bug30919.result
17.44
KB
-rw-r--r--
innodb_bug31205266.result
798
B
-rw-r--r--
innodb_bug34053.result
35
B
-rw-r--r--
innodb_bug34300.result
439
B
-rw-r--r--
innodb_bug35220.result
35
B
-rw-r--r--
innodb_bug38231.result
35
B
-rw-r--r--
innodb_bug39438.result
35
B
-rw-r--r--
innodb_bug40360.result
274
B
-rw-r--r--
innodb_bug40565.result
311
B
-rw-r--r--
innodb_bug41904.result
195
B
-rw-r--r--
innodb_bug42101-nonzero.result
810
B
-rw-r--r--
innodb_bug42101.result
704
B
-rw-r--r--
innodb_bug42419.result
858
B
-rw-r--r--
innodb_bug44032.result
313
B
-rw-r--r--
innodb_bug44369.result
300
B
-rw-r--r--
innodb_bug44571.result
334
B
-rw-r--r--
innodb_bug45357.result
290
B
-rw-r--r--
innodb_bug46000.result
906
B
-rw-r--r--
innodb_bug46676.result
362
B
-rw-r--r--
innodb_bug47167.result
1.51
KB
-rw-r--r--
innodb_bug47621.result
777
B
-rw-r--r--
innodb_bug47622.result
748
B
-rw-r--r--
innodb_bug47777.result
612
B
-rw-r--r--
innodb_bug48024.result
592
B
-rw-r--r--
innodb_bug49164.result
913
B
-rw-r--r--
innodb_bug51378.result
2.19
KB
-rw-r--r--
innodb_bug51920.result
316
B
-rw-r--r--
innodb_bug52199.result
175
B
-rw-r--r--
innodb_bug52663.result
857
B
-rw-r--r--
innodb_bug53046.result
1016
B
-rw-r--r--
innodb_bug53290.result
771
B
-rw-r--r--
innodb_bug53592.result
1.9
KB
-rw-r--r--
innodb_bug53674.result
234
B
-rw-r--r--
innodb_bug53756.result
3.62
KB
-rw-r--r--
innodb_bug54044.result
678
B
-rw-r--r--
innodb_bug56143.result
73.71
KB
-rw-r--r--
innodb_bug56716.result
168
B
-rw-r--r--
innodb_bug56947.result
406
B
-rw-r--r--
innodb_bug57252.result
89
B
-rw-r--r--
innodb_bug57255.result
501
B
-rw-r--r--
innodb_bug57904.result
1.3
KB
-rw-r--r--
innodb_bug59307.result
483
B
-rw-r--r--
innodb_bug59410.result
529
B
-rw-r--r--
innodb_bug59641.result
927
B
-rw-r--r--
innodb_bug59733.result
822
B
-rw-r--r--
innodb_bug60049.result
258
B
-rw-r--r--
innodb_bug60196.result
2.86
KB
-rw-r--r--
innodb_bug60229.result
955
B
-rw-r--r--
innodb_bug70867.result
126
B
-rw-r--r--
innodb_bulk_create_index.resul...
29.62
KB
-rw-r--r--
innodb_bulk_create_index_debug...
11.38
KB
-rw-r--r--
innodb_bulk_create_index_flush...
1.46
KB
-rw-r--r--
innodb_bulk_create_index_repli...
5.82
KB
-rw-r--r--
innodb_bulk_create_index_small...
4.26
KB
-rw-r--r--
innodb_corrupt_bit.result
2.61
KB
-rw-r--r--
innodb_corrupt_readonly.result
1011
B
-rw-r--r--
innodb_ctype_ldml.result
27.55
KB
-rw-r--r--
innodb_deadlock_with_autoinc.r...
565
B
-rw-r--r--
innodb_file_format.result
3.11
KB
-rw-r--r--
innodb_file_limit_check.result
457
B
-rw-r--r--
innodb_force_recovery.result
3.7
KB
-rw-r--r--
innodb_fts_limit_check.result
1.04
KB
-rw-r--r--
innodb_high_prio_commit_crash....
1.13
KB
-rw-r--r--
innodb_high_prio_rpl.result
1.07
KB
-rw-r--r--
innodb_i_s_innodb_locks.result
4.89
KB
-rw-r--r--
innodb_i_s_innodb_trx.result
2.85
KB
-rw-r--r--
innodb_information_schema_buff...
2.29
KB
-rw-r--r--
innodb_io_pf.result
407
B
-rw-r--r--
innodb_lock_wait_timeout_1.res...
9.04
KB
-rw-r--r--
innodb_misc1.result
29.29
KB
-rw-r--r--
innodb_multi_update.result
1.62
KB
-rw-r--r--
innodb_mysql.result
95.87
KB
-rw-r--r--
innodb_mysql_rbk.result
629
B
-rw-r--r--
innodb_notembedded.result
637
B
-rw-r--r--
innodb_page_size_func.result
1.49
KB
-rw-r--r--
innodb_pagesize_max_recordsize...
14.37
KB
-rw-r--r--
innodb_prefix_index_check.resu...
1.14
KB
-rw-r--r--
innodb_prefix_index_restart_se...
2.69
KB
-rw-r--r--
innodb_rename_index.result
31.12
KB
-rw-r--r--
innodb_rename_index_err.result
1.81
KB
-rw-r--r--
innodb_replace.result
2.7
KB
-rw-r--r--
innodb_row_log_read.result
867
B
-rw-r--r--
innodb_stats.result
11.62
KB
-rw-r--r--
innodb_stats_auto_recalc.resul...
1.33
KB
-rw-r--r--
innodb_stats_auto_recalc_ddl.r...
1.13
KB
-rw-r--r--
innodb_stats_auto_recalc_lots....
2.07
KB
-rw-r--r--
innodb_stats_auto_recalc_on_no...
2.19
KB
-rw-r--r--
innodb_stats_create_on_corrupt...
705
B
-rw-r--r--
innodb_stats_create_table.resu...
1.1
KB
-rw-r--r--
innodb_stats_del_mark.result
2.81
KB
-rw-r--r--
innodb_stats_drop_locked.resul...
1.55
KB
-rw-r--r--
innodb_stats_external_pages.re...
880
B
-rw-r--r--
innodb_stats_fetch.result
3.35
KB
-rw-r--r--
innodb_stats_fetch_corrupted.r...
1.01
KB
-rw-r--r--
innodb_stats_fetch_nonexistent...
980
B
-rw-r--r--
innodb_stats_flag_global_off.r...
7.36
KB
-rw-r--r--
innodb_stats_flag_global_on.re...
7.36
KB
-rw-r--r--
innodb_stats_rename_table.resu...
1.48
KB
-rw-r--r--
innodb_stats_rename_table_if_e...
1.89
KB
-rw-r--r--
innodb_stats_sample_pages.resu...
1023
B
-rw-r--r--
innodb_stats_table_flag_auto_r...
2.97
KB
-rw-r--r--
innodb_stats_table_flag_sample...
4.23
KB
-rw-r--r--
innodb_sys_var_valgrind.result
2.35
KB
-rw-r--r--
innodb_tablespace.result
22.76
KB
-rw-r--r--
innodb_tablespace_zip.result
1.13
KB
-rw-r--r--
innodb_thread_concurrency_debu...
824
B
-rw-r--r--
innodb_timeout_rollback.result
570
B
-rw-r--r--
innodb_trx_weight.result
35
B
-rw-r--r--
innodb_upd_stats_if_needed_not...
466
B
-rw-r--r--
innodb_ut_format_name.result
140
B
-rw-r--r--
innodb_wl6326.result
10.95
KB
-rw-r--r--
innodb_wl6326_big.result
17.67
KB
-rw-r--r--
innodb_wl6469_1.result
1.48
KB
-rw-r--r--
innodb_wl6469_debug.result
1.63
KB
-rw-r--r--
innodb_wl6470.result
3.11
KB
-rw-r--r--
innodb_wl6470_debug.result
1.42
KB
-rw-r--r--
innodb_wl6501_crash_1.result
15.37
KB
-rw-r--r--
innodb_wl6501_crash_2.result
15.37
KB
-rw-r--r--
innodb_wl6501_crash_6.result
13.07
KB
-rw-r--r--
innodb_wl6501_crash_7.result
13.07
KB
-rw-r--r--
innodb_wl6501_crash_8.result
468
B
-rw-r--r--
innodb_wl6560_1.result
7.27
KB
-rw-r--r--
innodb_wl6560_debug.result
3.36
KB
-rw-r--r--
innodb_wl6915.result
3.99
KB
-rw-r--r--
innodb_wl6915_debug.result
2.88
KB
-rw-r--r--
innodb_wl8114.result
1.78
KB
-rw-r--r--
insert_debug.result
956
B
-rw-r--r--
iodku.result
6.34
KB
-rw-r--r--
iodku_debug.result
2.71
KB
-rw-r--r--
log_alter_table.result
521
B
-rw-r--r--
log_corruption.result
843
B
-rw-r--r--
log_file.result
4.84
KB
-rw-r--r--
log_file_name.result
1.55
KB
-rw-r--r--
log_file_name_debug.result
345
B
-rw-r--r--
log_file_size.result
1.09
KB
-rw-r--r--
log_file_size_1.result
4.85
KB
-rw-r--r--
log_file_size_checkpoint.resul...
106
B
-rw-r--r--
missing_tablespaces.result
664
B
-rw-r--r--
monitor.result
23.64
KB
-rw-r--r--
monitor_restart.result
324
B
-rw-r--r--
mysqldump_max_recordsize.resul...
8.78
KB
-rw-r--r--
optimizer_temporary_table.resu...
114.72
KB
-rw-r--r--
page_reorganize.result
638
B
-rw-r--r--
partition-blob.result
1.53
KB
-rw-r--r--
partition-upgrade.result
33.24
KB
-rw-r--r--
partition.result
39.54
KB
-rw-r--r--
readahead.result
398
B
-rw-r--r--
readonly.result
713
B
-rw-r--r--
records_in_range.result
35.31
KB
-rw-r--r--
redo_log_during_checkpoint.res...
827
B
-rw-r--r--
rename_table.result
890
B
-rw-r--r--
row_format_redundant.result
1.71
KB
-rw-r--r--
sp_temp_table.result
5.72
KB
-rw-r--r--
stored_fk.result
3.52
KB
-rw-r--r--
strict_checksum.result
1.02
KB
-rw-r--r--
strict_mode.result
3.54
KB
-rw-r--r--
sys_tablestats.result
571
B
-rw-r--r--
table_compress.result
25.4
KB
-rw-r--r--
table_encrypt_1.result
6.82
KB
-rw-r--r--
table_encrypt_2.result
3.44
KB
-rw-r--r--
table_encrypt_3.result
66.48
KB
-rw-r--r--
table_encrypt_4.result
3.64
KB
-rw-r--r--
table_encrypt_5.result
56.6
KB
-rw-r--r--
table_encrypt_debug.result
3.22
KB
-rw-r--r--
table_encrypt_fts.result
1.7
KB
-rw-r--r--
table_encrypt_kill.result
7.59
KB
-rw-r--r--
table_encryption.result
3.42
KB
-rw-r--r--
tablespace_crash.result
8.16
KB
-rw-r--r--
tablespace_embedded.result
6.89
KB
-rw-r--r--
tablespace_embedded_windows.re...
6.93
KB
-rw-r--r--
tablespace_per_table.result
21.6
KB
-rw-r--r--
tablespace_per_table_not_windo...
9.11
KB
-rw-r--r--
tablespace_per_table_windows.r...
3.12
KB
-rw-r--r--
tablespace_portability.result
24.68
KB
-rw-r--r--
tablespace_portability_windows...
24.41
KB
-rw-r--r--
timestamp.result
790
B
-rw-r--r--
tinytext-groupby.result
1.33
KB
-rw-r--r--
tmpdir.result
1.8
KB
-rw-r--r--
trx_id_future.result
329
B
-rw-r--r--
undo.result
850
B
-rw-r--r--
update-cascade.result
8.04
KB
-rw-r--r--
update_time.result
1.62
KB
-rw-r--r--
update_time_wl6658.result
8.08
KB
-rw-r--r--
virtual_basic.result
53.55
KB
-rw-r--r--
virtual_blob.result
359
B
-rw-r--r--
virtual_debug.result
53.92
KB
-rw-r--r--
virtual_debug_purge.result
3.98
KB
-rw-r--r--
virtual_fk.result
28.34
KB
-rw-r--r--
virtual_fk_restart.result
1.48
KB
-rw-r--r--
virtual_index.result
7.71
KB
-rw-r--r--
virtual_purge.result
3.95
KB
-rw-r--r--
virtual_stats.result
4.84
KB
-rw-r--r--
xa_prepare_lock_release.result
1.21
KB
-rw-r--r--
xa_recovery.result
381
B
-rw-r--r--
xa_recovery_debug.result
528
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : innodb_wl6326_big.result
CREATE SCHEMA my_schema; USE my_schema; CREATE FUNCTION f_thread_id (i INT) RETURNS CHAR(4) DETERMINISTIC RETURN CONCAT(LPAD(CAST(i AS CHAR),3,'_'),'_') ; SELECT CONCAT('->', f_thread_id( 1), '<-'); CONCAT('->', f_thread_id( 1), '<-') ->__1_<- SELECT CONCAT('->', f_thread_id(12), '<-'); CONCAT('->', f_thread_id(12), '<-') ->_12_<- SET @extra_int = 1; SET @extra_string = f_thread_id(@extra_int); SELECT @extra_int , @extra_string; @extra_int @extra_string 1 __1_ CREATE FUNCTION f_col_int1 (i INT) RETURNS INT(20) DETERMINISTIC RETURN i * 1000 + @extra_int ; SELECT f_col_int1(my_col) AS my_result FROM (SELECT 1 AS my_col UNION SELECT 12 UNION SELECT 123 UNION SELECT 1234 UNION SELECT 12345) AS tx; my_result 1001 12001 123001 1234001 12345001 CREATE FUNCTION f_col_int2 (i INT) RETURNS INT(20) DETERMINISTIC RETURN @extra_int * 10000000 + i ; SELECT f_col_int2(my_col) AS my_result FROM (SELECT 1 AS my_col UNION SELECT 12 UNION SELECT 123 UNION SELECT 1234 UNION SELECT 12345) AS tx; my_result 10000001 10000012 10000123 10001234 10012345 CREATE FUNCTION f_col_int3 (i INT) RETURNS INT(20) DETERMINISTIC RETURN @extra_int ; SELECT f_col_int3(my_col) AS my_result FROM (SELECT 1 AS my_col UNION SELECT 12 UNION SELECT 123 UNION SELECT 1234 UNION SELECT 12345) AS tx; my_result 1 1 1 1 1 CREATE FUNCTION f_col_blob (i INT) RETURNS BLOB DETERMINISTIC RETURN RPAD(@extra_string,(@@innodb_page_size / 2 ) + 1,'a'); SELECT CONCAT('->', SUBSTR(f_col_blob(my_col) FROM 1 FOR 10), '<-.....->', SUBSTR(f_col_blob(my_col) FROM -10 FOR 10), '<-') AS my_result FROM (SELECT 1 AS my_col UNION SELECT 12 UNION SELECT 123 UNION SELECT 1234 UNION SELECT 12345) AS tx; my_result ->__1_aaaaaa<-.....->aaaaaaaaaa<- ->__1_aaaaaa<-.....->aaaaaaaaaa<- ->__1_aaaaaa<-.....->aaaaaaaaaa<- ->__1_aaaaaa<-.....->aaaaaaaaaa<- ->__1_aaaaaa<-.....->aaaaaaaaaa<- CREATE FUNCTION f_col_char0 (i INT) RETURNS CHAR(255) DETERMINISTIC RETURN LPAD(CAST(i AS CHAR),255,' '); SELECT CONCAT('->', f_col_char0(my_col), '<-') AS my_result FROM (SELECT 1 AS my_col UNION SELECT 12 UNION SELECT 123 UNION SELECT 1234 UNION SELECT 12345) AS tx; my_result -> 1<- -> 12<- -> 123<- -> 1234<- -> 12345<- CREATE FUNCTION f_col_char1 (i INT) RETURNS CHAR(26) DETERMINISTIC RETURN CONCAT('B', LPAD(SUBSTR(CAST(i AS CHAR),1,(LENGTH(CAST(i AS CHAR)) DIV 2)),10,' '), @extra_string, RPAD(SUBSTR(CAST(i AS CHAR), -((LENGTH(CAST(i AS CHAR)) + 1) DIV 2)),10,' '), 'E') ; SELECT CONCAT('->', f_col_char1(my_col), '<-') AS my_result FROM (SELECT 1 AS my_col UNION SELECT 12 UNION SELECT 123 UNION SELECT 1234 UNION SELECT 12345) AS tx; my_result ->B __1_1 E<- ->B 1__1_2 E<- ->B 1__1_23 E<- ->B 12__1_34 E<- ->B 12__1_345 E<- CREATE FUNCTION f_col_char2 (i INT) RETURNS CHAR(26) DETERMINISTIC RETURN CONCAT('B', RPAD(SUBSTR(CAST(i AS CHAR),1,(LENGTH(CAST(i AS CHAR)) DIV 2)),10,' '), @extra_string, LPAD(SUBSTR(CAST(i AS CHAR), -((LENGTH(CAST(i AS CHAR)) + 1) DIV 2)),10,' '), 'E'); SELECT CONCAT('->', f_col_char2(my_col), '<-') AS my_result FROM (SELECT 1 AS my_col UNION SELECT 12 UNION SELECT 123 UNION SELECT 1234 UNION SELECT 12345) AS tx; my_result ->B __1_ 1E<- ->B1 __1_ 2E<- ->B1 __1_ 23E<- ->B12 __1_ 34E<- ->B12 __1_ 345E<- CREATE FUNCTION f_col_char3 (i INT) RETURNS CHAR(26) DETERMINISTIC RETURN CONCAT('B',@extra_string,LPAD(CAST(i AS CHAR),20,' '),'E'); SELECT CONCAT('->', f_col_char3(my_col), '<-') AS my_result FROM (SELECT 1 AS my_col UNION SELECT 12 UNION SELECT 123 UNION SELECT 1234 UNION SELECT 12345) AS tx; my_result ->B__1_ 1E<- ->B__1_ 12E<- ->B__1_ 123E<- ->B__1_ 1234E<- ->B__1_ 12345E<- CREATE FUNCTION f_col_char4 (i INT) RETURNS CHAR(26) DETERMINISTIC RETURN CONCAT('B',RPAD(CAST(i AS CHAR),20,' '),@extra_string,'E'); SELECT CONCAT('->', f_col_char4(my_col), '<-') AS my_result FROM (SELECT 1 AS my_col UNION SELECT 12 UNION SELECT 123 UNION SELECT 1234 UNION SELECT 12345) AS tx; my_result ->B1 __1_E<- ->B12 __1_E<- ->B123 __1_E<- ->B1234 __1_E<- ->B12345 __1_E<- CREATE TABLE my_metrics LIKE information_schema.innodb_metrics; ALTER TABLE my_metrics ADD COLUMN phase ENUM('after', 'before'), DROP COLUMN SUBSYSTEM, DROP COLUMN TYPE, DROP COLUMN COMMENT, ADD PRIMARY KEY (NAME,phase); CREATE TABLE t1 ( col_int0 BIGINT, col_int1 BIGINT, col_int2 BIGINT, col_int3 BIGINT, col_blob BLOB, col_char0 VARCHAR(255), col_char1 VARCHAR(30), col_char2 VARCHAR(30), col_char3 VARCHAR(30), col_char4 VARCHAR(30) ) ENGINE = InnoDB; ALTER TABLE t1 ADD UNIQUE KEY uidx_col_int0 (col_int0), ADD UNIQUE KEY uidx1 (col_int1, col_char0), ADD UNIQUE KEY uidx2 (col_int2, col_char0, col_int1), ADD UNIQUE KEY uidx3 (col_int3, col_int2, col_char0), ADD UNIQUE KEY uidx4 (col_char1, col_char0), ADD UNIQUE KEY uidx5 (col_char2, col_char0, col_char1), ADD UNIQUE KEY uidx6 (col_char3, col_char2, col_char0), ADD UNIQUE KEY uidx7 (col_int1, col_int2, col_int3, col_char4, col_char1, col_char2, col_char3, col_char0), ADD KEY idx8 (col_blob(10), col_char4); CREATE PROCEDURE proc_fill_t1 (max_row_count INT, load_unit INT) BEGIN DECLARE my_count INTEGER DEFAULT 0; DECLARE max_load_count INTEGER DEFAULT 0; DROP TABLE IF EXISTS t0; CREATE TEMPORARY TABLE t0 (col_int0 BIGINT, PRIMARY KEY(col_int0)); WHILE (my_count < load_unit ) DO SET my_count = my_count + 1; INSERT INTO t0 SET col_int0 = my_count; END WHILE; SET max_load_count = (SELECT (max_row_count DIV load_unit) + 1 ); SELECT COUNT(col_int0) INTO @val FROM t1; SET my_count = 0; REPEAT INSERT INTO t1 (col_int0, col_int1, col_int2, col_int3, col_blob, col_char0, col_char1, col_char2,col_char3,col_char4) SELECT col_int0 + @val, f_col_int1(col_int0 + @val), f_col_int2(col_int0 + @val), f_col_int3(col_int0 + @val), f_col_blob(col_int0 + @val), f_col_char0(col_int0 + @val), f_col_char1(col_int0 + @val), f_col_char2(col_int0 + @val), f_col_char3(col_int0 + @val), f_col_char4(col_int0 + @val) FROM t0; COMMIT; SELECT MAX(col_int0) INTO @val FROM t1; SET my_count = my_count + 1; UNTIL( my_count > max_load_count OR @val >= max_row_count ) END REPEAT; DROP TEMPORARY TABLE t0; END| CREATE PROCEDURE proc_dml (max_duration INT, t1_stripe_half INT) BEGIN DECLARE aux INTEGER DEFAULT 0; DECLARE start_time INT; DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND BEGIN END; SET @extra_int = CONNECTION_ID(); SET @extra_string = f_thread_id(@extra_int); SELECT ROUND(MAX(col_int0) / 2 ) INTO @t1_half FROM t1; # The user lock 'Blocker' should be already set by some other session S1. # S1 starts the race by releasing that lock. # Wait till the lock is released and the lock can be obtained. # In order to prevent endless waiting in case of non foreseen problems # limit the timespan to 30 seconds. SELECT GET_LOCK('Blocker', 30) INTO @aux; # Release the lock immediate so that the other "runner" sessions start too. SELECT RELEASE_LOCK('Blocker') INTO @aux; SET start_time = UNIX_TIMESTAMP(); WHILE (UNIX_TIMESTAMP() - start_time < max_duration) DO SET @aux = @t1_half - t1_stripe_half + ROUND(RAND() * t1_stripe_half * 2); UPDATE t1 SET col_int1 = f_col_int1(col_int0), col_int2 = f_col_int2(col_int0), col_int3 = f_col_int3(col_int0), col_blob = f_col_blob(col_int0), col_char0 = f_col_char0(col_int0), col_char1 = f_col_char1(col_int0), col_char2 = f_col_char2(col_int0), col_char3 = f_col_char3(col_int0), col_char4 = f_col_char4(col_int0) WHERE col_int0 = @aux; COMMIT; END WHILE; END| SET GLOBAL innodb_monitor_disable = "innodb_rwlock_sx_%"; SET @pre_reset_ts = NOW(); SET GLOBAL innodb_monitor_reset = "innodb_rwlock_sx_%"; SET @pre_enable_ts = NOW(); SET GLOBAL innodb_monitor_enable = "innodb_rwlock_sx_%"; SET @pre_collect_ts = NOW(); DELETE FROM my_metrics; INSERT INTO my_metrics SELECT NAME, COUNT, MAX_COUNT, MIN_COUNT, AVG_COUNT, COUNT_RESET, MAX_COUNT_RESET, MIN_COUNT_RESET, AVG_COUNT_RESET, TIME_ENABLED, TIME_DISABLED, TIME_ELAPSED, TIME_RESET, STATUS, 'before' FROM information_schema.innodb_metrics WHERE NAME LIKE 'innodb_rwlock_sx_%'; # TC-01 There are exact three entries "innodb_rwlock_sx_%" with the # with the name which follow in innodb_metrics. # pass SELECT COUNT(*) INTO @sx_count FROM my_metrics; # TC-02 Counting is now enabled. ALL = @sx_count entries show that. # pass # TC-03 @pre_reset_ts < TIME_RESET. ALL = @sx_count entries show that. # pass # TC-04 @pre_enable_ts < TIME_ENABLED. ALL = @sx_count entries show that. # pass # TC-05 TIME_RESET < TIME_ENABLED AND TIME_ENABLED < @pre_collect_ts # AND TIME_ELAPSED > 0. ALL = @sx_count entries show that. # pass # TC-06 COUNT_RESET = MAX_COUNT_RESET. ALL = @sx_count entries show that. # pass SET GLOBAL innodb_monitor_reset = "innodb_rwlock_sx_%"; SHOW ENGINE INNODB STATUS; DELETE FROM my_metrics; INSERT INTO my_metrics SELECT NAME, COUNT, MAX_COUNT, MIN_COUNT, AVG_COUNT, COUNT_RESET, MAX_COUNT_RESET, MIN_COUNT_RESET, AVG_COUNT_RESET, TIME_ENABLED, TIME_DISABLED, TIME_ELAPSED, TIME_RESET, STATUS, 'before' FROM information_schema.innodb_metrics WHERE NAME LIKE 'innodb_rwlock_sx_%'; SET @extra_string = '__0_'; SET @extra_int = 0; # TC-07 One session inserts some significant amount of rows into t1. # The system MUST survive that. SET @max_row_count = <max_row_count>; SET @load_unit = <load_unit>; SET @start_time = UNIX_TIMESTAMP(); SET AUTOCOMMIT = OFF; CALL proc_fill_t1 (@max_row_count, @load_unit); # pass SET AUTOCOMMIT = ON; SELECT col_int0 INTO @t1_half FROM t1 WHERE col_int0 >= (@val DIV 2) ORDER BY col_int0 LIMIT 1; SHOW ENGINE INNODB STATUS; SELECT col_int0, col_int1, col_int2, col_int3, CONCAT('->', SUBSTR(col_blob FROM 1 FOR 10), '<-.....->', SUBSTR(col_blob FROM -10 FOR 10), '<-') AS col_blobx, CONCAT('->',col_char0,'<-') AS col_char0x, CONCAT('->',col_char1,'<-') AS col_char1x, CONCAT('->',col_char2,'<-') AS col_char2x, CONCAT('->',col_char3,'<-') AS col_char3x, CONCAT('->',col_char4,'<-') AS col_char4x FROM t1 WHERE col_int0 between 98 AND 102; col_int0 98 col_int1 98000 col_int2 98 col_int3 0 col_blobx ->__0_aaaaaa<-.....->aaaaaaaaaa<- col_char0x -> 98<- col_char1x ->B 9__0_8 E<- col_char2x ->B9 __0_ 8E<- col_char3x ->B__0_ 98E<- col_char4x ->B98 __0_E<- col_int0 99 col_int1 99000 col_int2 99 col_int3 0 col_blobx ->__0_aaaaaa<-.....->aaaaaaaaaa<- col_char0x -> 99<- col_char1x ->B 9__0_9 E<- col_char2x ->B9 __0_ 9E<- col_char3x ->B__0_ 99E<- col_char4x ->B99 __0_E<- col_int0 100 col_int1 100000 col_int2 100 col_int3 0 col_blobx ->__0_aaaaaa<-.....->aaaaaaaaaa<- col_char0x -> 100<- col_char1x ->B 1__0_00 E<- col_char2x ->B1 __0_ 00E<- col_char3x ->B__0_ 100E<- col_char4x ->B100 __0_E<- col_int0 101 col_int1 101000 col_int2 101 col_int3 0 col_blobx ->__0_aaaaaa<-.....->aaaaaaaaaa<- col_char0x -> 101<- col_char1x ->B 1__0_01 E<- col_char2x ->B1 __0_ 01E<- col_char3x ->B__0_ 101E<- col_char4x ->B101 __0_E<- col_int0 102 col_int1 102000 col_int2 102 col_int3 0 col_blobx ->__0_aaaaaa<-.....->aaaaaaaaaa<- col_char0x -> 102<- col_char1x ->B 1__0_02 E<- col_char2x ->B1 __0_ 02E<- col_char3x ->B__0_ 102E<- col_char4x ->B102 __0_E<- # TC-11 Several concurrent sessions perform updates in t1 like mad. # The system MUST survive this. # Printing of statements is partially suppressed. SET @start_time = UNIX_TIMESTAMP(); SELECT 1 FROM t1 WHERE col_int0 = @t1_half FOR UPDATE; 1 1 SELECT GET_LOCK('Blocker', 1000) ; GET_LOCK('Blocker', 1000) 1 RELEASE_LOCK('Blocker') 1 # pass SHOW ENGINE INNODB STATUS; # TC-13 One session performs ALTER TABLE t1 ADD KEY ... on the fat table t1. # The system MUST survive this. SET @start_time = UNIX_TIMESTAMP(); ALTER TABLE t1 ADD KEY idx_col_char4_col_char0 (col_char4,col_char0); SHOW ENGINE INNODB STATUS; # pass # TC-15 One session performs a fat update on the fat table t1. # The system MUST survive this. SET @start_time = UNIX_TIMESTAMP(); SET @extra_int = 13; SET @extra_string = f_thread_id(@extra_int); UPDATE t1 SET col_int1 = f_col_int1(col_int0), col_int2 = f_col_int2(col_int0), col_int3 = f_col_int3(col_int0), col_blob = f_col_blob(col_int0), col_char0 = f_col_char0(col_int0), col_char1 = f_col_char1(col_int0), col_char2 = f_col_char2(col_int0), col_char3 = f_col_char3(col_int0), col_char4 = f_col_char4(col_int0) WHERE col_int0 BETWEEN @t1_half - 2500 AND @t1_half + 2500; COMMIT; SHOW ENGINE INNODB STATUS; # pass INSERT INTO my_metrics SELECT NAME, COUNT, MAX_COUNT, MIN_COUNT, AVG_COUNT, COUNT_RESET, MAX_COUNT_RESET, MIN_COUNT_RESET, AVG_COUNT_RESET, TIME_ENABLED, TIME_DISABLED, TIME_ELAPSED, TIME_RESET, STATUS, 'after' FROM information_schema.innodb_metrics WHERE NAME LIKE 'innodb_rwlock_sx_%'; # TC-16 The following activities happend after reset in innodb_metrics # - Insert some significant amount of rows into t1. # - Several concurrent users perform excessive updates in t1. # - ALTER TABLE ... ADD KEY <sufficient big enough structure> # - One UPDATE statement modifying a huge slice of t1. # Any of them causes heavy use of SX lock and therefore COUNT_RESET # must have grown for ALL = @sx_count entries. # pass # TC-09 Heavy activity after reset. # COUNT_RESET = MAX_COUNT_RESET for ALL = @sx_count entries # needs to stay valid though he counters will have grown. # pass DELETE FROM my_metrics; INSERT INTO my_metrics SELECT NAME, COUNT, MAX_COUNT, MIN_COUNT, AVG_COUNT, COUNT_RESET, MAX_COUNT_RESET, MIN_COUNT_RESET, AVG_COUNT_RESET, TIME_ENABLED, TIME_DISABLED, TIME_ELAPSED, TIME_RESET, STATUS, 'before' FROM information_schema.innodb_metrics WHERE NAME LIKE 'innodb_rwlock_sx_%'; SET GLOBAL innodb_monitor_reset = "innodb_rwlock_sx_%"; INSERT INTO my_metrics SELECT NAME, COUNT, MAX_COUNT, MIN_COUNT, AVG_COUNT, COUNT_RESET, MAX_COUNT_RESET, MIN_COUNT_RESET, AVG_COUNT_RESET, TIME_ENABLED, TIME_DISABLED, TIME_ELAPSED, TIME_RESET, STATUS, 'after' FROM information_schema.innodb_metrics WHERE NAME LIKE 'innodb_rwlock_sx_%'; # TC-08 There was a reset. COUNT_RESET = MAX_COUNT_RESET for ALL # = @sx_count entries. # pass # TC-17 We had heavy activity causing big counters and after that a reset. # Reset causes COUNT > COUNT_RESET AND MAX_COUNT > MAX_COUNT_RESET # for ALL @sx_count entries. # pass # TC-18 We had some reset but this must not decrease COUNT or MAX_COUNT # after.COUNT >= before.COUNT AND # after.MAX_COUNT >= before.MAX_COUNT for ALL @sx_count entries. # pass # TC-19 We had some reset after heavy activity and this must cause # after.COUNT_RESET < before.COUNT_RESET # AND after.MAX_COUNT_RESET < before.MAX_COUNT_RESET AND # for ALL @sx_count entries. # pass USE test; DROP SCHEMA my_schema; SET GLOBAL innodb_monitor_disable = all; SET GLOBAL innodb_monitor_reset_all = all; SET GLOBAL innodb_monitor_enable = default; SET GLOBAL innodb_monitor_disable = default; SET GLOBAL innodb_monitor_reset = default; SET GLOBAL innodb_monitor_reset_all = default; SET GLOBAL innodb_monitor_disable = "innodb_rwlock_sx_%"; SET GLOBAL innodb_monitor_reset = "innodb_rwlock_sx_%";
Close