403Webshell
Server IP : 45.40.142.9  /  Your IP : 216.73.216.250
Web Server : Apache
System : Linux s45-40-142-9.secureserver.net 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64
User : bayspec ( 506)
PHP Version : 5.6.40
Disable Function : NONE
MySQL : ON  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /usr/share/mysql-test/suite/rpl/t/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /usr/share/mysql-test/suite/rpl/t/rpl_binlog_gcommit_options.test
############################################################
# Purpose:	WL#5223. Testing BGC options
# Author:	Serge Kozlov <serge.kozlov@oracle.com>
# Purpose:	Execute server code related to BGC options.
#		We do not test here the functionality of new 
#		options because of it requires a complex
#		test with debug-sync and just make sure
#		that there is no crash/assertion when 
#		that code executed.
############################################################
source include/not_gtid_enabled.inc;
source include/have_innodb.inc;
source include/have_log_bin.inc;
source include/master-slave.inc;

# Settings
let $loop_counter= 100;

--disable_query_log
# Create table
echo # Create table;
CREATE TABLE t (a INT NOT NULL, b VARCHAR(200), c TEXT, d DATETIME NOT NULL, e BIGINT NOT NULL, KEY(d,e)) ENGINE=InnoDB;

# Create connections
echo # Create connections;
connect(conn_1,localhost,root,,);
connect(conn_2,localhost,root,,);

# Main test
echo # Insert rows;
disable_query_log;
disable_result_log;
while ($loop_counter) {
  connection conn_1;
  send INSERT INTO t VALUES (1, '', REPEAT('a', 1), NOW(), 1);
  connection conn_2;
  send INSERT INTO t VALUES (1, '', REPEAT('a', 1), NOW(), 1);
  connection conn_1;
  reap;
  connection conn_2;
  reap;
  dec $loop_counter;  
}
enable_result_log;
enable_query_log;

# Results
echo # Master results;
connection master;
SELECT COUNT(a) FROM t;
--source include/sync_slave_sql_with_master.inc
echo # Slave results;
SELECT COUNT(a) FROM t;

# Clean up
echo # Clean up;
connection master;
DROP TABLE t;
--source include/sync_slave_sql_with_master.inc
source include/stop_slave.inc;
echo # End of tests;

Youez - 2016 - github.com/yon3zu
LinuXploit