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.23.92.44
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 /
ndb_rpl /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
ndb_dist_priv_common.result
2.33
KB
-rw-r--r--
ndb_rpl_2innodb.result
41.34
KB
-rw-r--r--
ndb_rpl_2myisam.result
41.34
KB
-rw-r--r--
ndb_rpl_2ndb.result
16.17
KB
-rw-r--r--
ndb_rpl_2other.result
32.71
KB
-rw-r--r--
ndb_rpl_add_column.result
5.99
KB
-rw-r--r--
ndb_rpl_apply_status.result
907
B
-rw-r--r--
ndb_rpl_auto_inc.result
3.72
KB
-rw-r--r--
ndb_rpl_bank.result
10.82
KB
-rw-r--r--
ndb_rpl_basic.result
13.52
KB
-rw-r--r--
ndb_rpl_batch.result
2.48
KB
-rw-r--r--
ndb_rpl_batch_handling.result
1.91
KB
-rw-r--r--
ndb_rpl_binlog_format_errors.r...
1.27
KB
-rw-r--r--
ndb_rpl_bitfield.result
14.48
KB
-rw-r--r--
ndb_rpl_blob.result
7.29
KB
-rw-r--r--
ndb_rpl_break_3_chain.result
3.17
KB
-rw-r--r--
ndb_rpl_bug22045.result
2.56
KB
-rw-r--r--
ndb_rpl_bug_13440282.result
2.3
KB
-rw-r--r--
ndb_rpl_check_for_mixed.result
483
B
-rw-r--r--
ndb_rpl_checksum.result
6.31
KB
-rw-r--r--
ndb_rpl_circular.result
5.13
KB
-rw-r--r--
ndb_rpl_circular_2ch.result
2.27
KB
-rw-r--r--
ndb_rpl_circular_2ch_rep_statu...
7.47
KB
-rw-r--r--
ndb_rpl_circular_simplex.resul...
1.28
KB
-rw-r--r--
ndb_rpl_conflict_basic.result
18.2
KB
-rw-r--r--
ndb_rpl_conflict_epoch.result
71.03
KB
-rw-r--r--
ndb_rpl_conflict_epoch2.result
143.62
KB
-rw-r--r--
ndb_rpl_conflict_epoch2_extra....
63.18
KB
-rw-r--r--
ndb_rpl_conflict_epoch2_trans....
47.12
KB
-rw-r--r--
ndb_rpl_conflict_epoch_ext.res...
106.6
KB
-rw-r--r--
ndb_rpl_conflict_epoch_extende...
13.51
KB
-rw-r--r--
ndb_rpl_conflict_epoch_trans.r...
23.13
KB
-rw-r--r--
ndb_rpl_conflict_epoch_trans_e...
23.62
KB
-rw-r--r--
ndb_rpl_conflict_max.result
36.46
KB
-rw-r--r--
ndb_rpl_conflict_max_delete_wi...
35.68
KB
-rw-r--r--
ndb_rpl_conflict_old.result
36.65
KB
-rw-r--r--
ndb_rpl_conflict_read_tracking...
29.94
KB
-rw-r--r--
ndb_rpl_ctype_ucs2_def.result
703
B
-rw-r--r--
ndb_rpl_dd_advance.result
8.9
KB
-rw-r--r--
ndb_rpl_dd_basic.result
2.4
KB
-rw-r--r--
ndb_rpl_dd_partitions.result
35.75
KB
-rw-r--r--
ndb_rpl_ddl_open_trans.result
1.87
KB
-rw-r--r--
ndb_rpl_dist_priv.result
11.31
KB
-rw-r--r--
ndb_rpl_do_db.result
1.44
KB
-rw-r--r--
ndb_rpl_do_table.result
1.13
KB
-rw-r--r--
ndb_rpl_empty_epoch.result
1.17
KB
-rw-r--r--
ndb_rpl_gap_event.result
1.38
KB
-rw-r--r--
ndb_rpl_idempotent.result
3.06
KB
-rw-r--r--
ndb_rpl_ignore_db.result
1.08
KB
-rw-r--r--
ndb_rpl_init_rep_status.result
2.17
KB
-rw-r--r--
ndb_rpl_innodb2ndb.result
41
KB
-rw-r--r--
ndb_rpl_innodb_trans.result
3.08
KB
-rw-r--r--
ndb_rpl_last_conflict_epoch_va...
2.06
KB
-rw-r--r--
ndb_rpl_load.result
1.27
KB
-rw-r--r--
ndb_rpl_logging.result
2.66
KB
-rw-r--r--
ndb_rpl_mix_eng_trans.result
10.51
KB
-rw-r--r--
ndb_rpl_mix_innodb.result
4.35
KB
-rw-r--r--
ndb_rpl_mixed_tables.result
7.28
KB
-rw-r--r--
ndb_rpl_multi.result
2.33
KB
-rw-r--r--
ndb_rpl_myisam2ndb.result
41
KB
-rw-r--r--
ndb_rpl_ndbapi-examples.result
522
B
-rw-r--r--
ndb_rpl_rep_error.result
16.79
KB
-rw-r--r--
ndb_rpl_rep_ignore.result
1.4
KB
-rw-r--r--
ndb_rpl_skip_gap_event.result
1.27
KB
-rw-r--r--
ndb_rpl_slave_binlog_index.res...
1.83
KB
-rw-r--r--
ndb_rpl_slave_conflict_role_va...
9.63
KB
-rw-r--r--
ndb_rpl_slave_lsu.result
53.8
KB
-rw-r--r--
ndb_rpl_slave_lsu_anyval.resul...
54.73
KB
-rw-r--r--
ndb_rpl_slave_replay.result
6.42
KB
-rw-r--r--
ndb_rpl_slave_restart.result
1.93
KB
-rw-r--r--
ndb_rpl_stm_innodb.result
4.38
KB
-rw-r--r--
ndb_rpl_sync.result
2.38
KB
-rw-r--r--
ndb_rpl_ui.result
1.86
KB
-rw-r--r--
ndb_rpl_ui2.result
813
B
-rw-r--r--
ndb_rpl_ui3.result
1.22
KB
-rw-r--r--
rpl_truncate_7ndb.result
3.27
KB
-rw-r--r--
rpl_truncate_7ndb_2.result
3.27
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ndb_rpl_batch.result
include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. [connection master] use test; Create a couple of tables to defeat Binlog Injector's creation of multi-image events which can be batch-applied on the slave regardless of slave_allow_batching create table t1 (pk int primary key, a varchar(8000)) engine=ndb; create table t2 (pk int primary key, a varchar(8000)) engine=ndb; Insert some data which we can later delete This also serves to 'prime' the Slave, so that NdbApi access related to slave setup (last_replicated_epoch fetch etc) can be ignored. insert into t1 values (1, repeat("I", 80)), (2, repeat("R", 80)); First pass with slave_allow_batching OFF set global slave_allow_batching=OFF; show variables like 'slave_allow_batching'; Variable_name Value slave_allow_batching OFF Check out batching Transaction includes deletes + inserts, and two different tables, shouldn't be entirely batchable without slave_allow_batching begin; delete from t1; insert into t1 values (3, repeat("I", 80)), (4, repeat("F", 80)); insert into t2 values (5, repeat("B", 90)), (6, repeat("E", 90)); commit; delete from t1; delete from t2; insert into t1 values (1, repeat("I", 80)), (2, repeat("R", 80)); Second pass with slave_allow_batching ON set global slave_allow_batching=ON; show variables like 'slave_allow_batching'; Variable_name Value slave_allow_batching ON Check out batching Transaction includes deletes + inserts, and two different tables, shouldn't be batchable without slave_allow_batching begin; delete from t1; insert into t1 values (3, repeat("I", 80)), (4, repeat("F", 80)); insert into t2 values (5, repeat("B", 90)), (6, repeat("E", 90)); commit; Determine slave activity in terms of PK ops and execute() calls Check that test compared like-for-like, and that slave_allow_batching came out ahead by a factor of at least 2. SELECT @batching_on_pk_ops = @batching_off_pk_ops AS 'Fair contest'; Fair contest 1 SELECT @batching_off_pk_ops >=4 as 'Batching can improve matters'; Batching can improve matters 1 SELECT @batching_on_execs * 2 < @batching_off_execs AS 'slave_allow_batching works'; slave_allow_batching works 1 Cleanup drop table t2; drop table t1; include/rpl_end.inc
Close
