mirror of
				https://github.com/MariaDB/server.git
				synced 2025-10-31 02:46:29 +01:00 
			
		
		
		
	 ebfc4e6ad0
			
		
	
	
	ebfc4e6ad0
	
	
	
		
			
			copy of
commit 86587affafe77ef555f7c3839839de44f0f203f3
Author: Tian Xia <tianx@fb.com>
Date:   Tue Oct 4 10:01:52 2016 -0700
    Allow filtering of show commands through admission control
		
	
			
		
			
				
	
	
		
			47 lines
		
	
	
	
		
			1.1 KiB
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			47 lines
		
	
	
	
		
			1.1 KiB
		
	
	
	
		
			Text
		
	
	
	
	
	
| 
 | |
| source suite/rocksdb_hotbackup/include/setup.inc;
 | |
| 
 | |
| --let $rpl_server_number= 2
 | |
| --source include/rpl_stop_server.inc
 | |
| 
 | |
| --exec suite/rocksdb_hotbackup/include/load_data_and_run.sh 2>&1
 | |
| 
 | |
| --let $rpl_server_number= 2
 | |
| --source include/rpl_start_server.inc
 | |
| 
 | |
| connection server_2;
 | |
| let $num_rows = `select count(*) from db1.t1`;
 | |
| let $max_id = `select id from db1.t1 order by id desc limit 1`;
 | |
| 
 | |
| if($num_rows != $max_id) {
 | |
|   echo Number of rows($num_rows) and last_id($max_id) does not match;
 | |
| }
 | |
| if($num_rows < 250000) {
 | |
|   echo Number of rows($num_rows) is less than 250000;
 | |
| }
 | |
| if($num_rows > 500000) {
 | |
|   echo Number of rows($num_rows) is more than 500000;
 | |
| }
 | |
| 
 | |
| --source suite/rocksdb_hotbackup/include/setup_replication_gtid_and_sync.inc
 | |
| 
 | |
| connection server_2;
 | |
| select count(*) from db1.t1;
 | |
| 
 | |
| connection server_1;
 | |
| let $checksum1 = `checksum tables db1.t1`;
 | |
| connection server_2;
 | |
| let $checksum2 = `checksum tables db1.t1`;
 | |
| 
 | |
| if($checksum1 != $checksum2) {
 | |
|   echo Checksums ($checksum1 and $checksum2) do not match;
 | |
| }
 | |
| 
 | |
| connection server_1;
 | |
| drop database db1;
 | |
| sync_slave_with_master;
 | |
| connection server_2;
 | |
| stop slave;
 | |
| reset slave;
 | |
| 
 | |
| source suite/rocksdb_hotbackup/include/cleanup.inc;
 |