altibase icon indicating copy to clipboard operation
altibase copied to clipboard

Published 20 hours ago • verified publisher icon ALTIBASE

Performance Test - config.sql for shard

Open Lee-Sangmin-70 opened this issue 4 years ago • 1 comments

delete from test;

exec dbms_shard.unset_shard_table ('sys','TEST');

exec dbms_shard.unset_node('dn1'); exec dbms_shard.unset_node('dn2'); exec dbms_shard.unset_node('dn3'); exec dbms_shard.unset_node('dn4'); -- exec dbms_shard.unset_node('dn5'); -- exec dbms_shard.unset_node('dn6'); -- exec dbms_shard.unset_node('dn7'); -- exec dbms_shard.unset_node('dn8'); -- exec dbms_shard.unset_node('dn9'); -- exec dbms_shard.unset_node('dn10'); -- exec dbms_shard.unset_node('dn11'); -- exec dbms_shard.unset_node('dn12'); -- exec dbms_shard.unset_node('dn13'); -- exec dbms_shard.unset_node('dn14'); -- exec dbms_shard.unset_node('dn15');

exec dbms_shard.set_node('dn1','dn1',20401); exec dbms_shard.set_node('dn2','dn2',20402); exec dbms_shard.set_node('dn3','dn3',20403); exec dbms_shard.set_node('dn4','dn4',20404);

alter session set shard linker=on;

exec dbms_shard.set_shard_table ('sys','TEST','h','K01');

exec dbms_shard.set_shard_hash ('sys','TEST', 250, 'dn1'); exec dbms_shard.set_shard_hash ('sys','TEST', 500, 'dn2'); exec dbms_shard.set_shard_hash ('sys','TEST', 740, 'dn3'); exec dbms_shard.set_shard_hash ('sys','TEST', 1000, 'dn4');

delete from test;

exec dbms_shard.unset_shard_table ('sys','TEST');

exec dbms_shard.unset_node('dn1'); exec dbms_shard.unset_node('dn2'); exec dbms_shard.unset_node('dn3'); exec dbms_shard.unset_node('dn4'); exec dbms_shard.unset_node('dn5'); exec dbms_shard.unset_node('dn6'); exec dbms_shard.unset_node('dn7'); exec dbms_shard.unset_node('dn8'); exec dbms_shard.unset_node('dn9'); exec dbms_shard.unset_node('dn10'); exec dbms_shard.unset_node('dn11'); exec dbms_shard.unset_node('dn12'); exec dbms_shard.unset_node('dn13'); exec dbms_shard.unset_node('dn14'); exec dbms_shard.unset_node('dn15');

exec dbms_shard.set_node('dn1','dn1',20401); exec dbms_shard.set_node('dn2','dn2',20402); exec dbms_shard.set_node('dn3','dn3',20403); exec dbms_shard.set_node('dn4','dn4',20404); exec dbms_shard.set_node('dn5','dn5',20405); exec dbms_shard.set_node('dn6','dn6',20406); exec dbms_shard.set_node('dn7','dn7',20407); exec dbms_shard.set_node('dn8','dn8',20408); exec dbms_shard.set_node('dn9','dn9',20409); exec dbms_shard.set_node('dn10','dn10',20410); exec dbms_shard.set_node('dn11','dn11',20411); exec dbms_shard.set_node('dn12','dn12',20412); exec dbms_shard.set_node('dn13','dn13',20413); exec dbms_shard.set_node('dn14','dn14',20414); exec dbms_shard.set_node('dn15','dn15',20415);

alter session set shard linker=on;

exec dbms_shard.set_shard_table ('sys','TEST','h','K01');

exec dbms_shard.set_shard_hash ('sys','TEST', 60, 'dn1'); exec dbms_shard.set_shard_hash ('sys','TEST', 120, 'dn2'); exec dbms_shard.set_shard_hash ('sys','TEST', 180, 'dn3'); exec dbms_shard.set_shard_hash ('sys','TEST', 240, 'dn4'); exec dbms_shard.set_shard_hash ('sys','TEST', 300, 'dn5'); exec dbms_shard.set_shard_hash ('sys','TEST', 360, 'dn6'); exec dbms_shard.set_shard_hash ('sys','TEST', 420, 'dn7'); exec dbms_shard.set_shard_hash ('sys','TEST', 480, 'dn8'); exec dbms_shard.set_shard_hash ('sys','TEST', 540, 'dn9'); exec dbms_shard.set_shard_hash ('sys','TEST', 600, 'dn10'); exec dbms_shard.set_shard_hash ('sys','TEST', 660, 'dn11'); exec dbms_shard.set_shard_hash ('sys','TEST', 720, 'dn12'); exec dbms_shard.set_shard_hash ('sys','TEST', 800, 'dn13'); exec dbms_shard.set_shard_hash ('sys','TEST', 900, 'dn14'); exec dbms_shard.set_shard_hash ('sys','TEST', 1000, 'dn15');

delete from test;

exec dbms_shard.unset_shard_table ('sys','TEST');

exec dbms_shard.unset_node('dn1'); exec dbms_shard.unset_node('dn2'); exec dbms_shard.unset_node('dn3'); exec dbms_shard.unset_node('dn4'); exec dbms_shard.unset_node('dn5'); exec dbms_shard.unset_node('dn6'); exec dbms_shard.unset_node('dn7'); exec dbms_shard.unset_node('dn8'); exec dbms_shard.unset_node('dn9'); exec dbms_shard.unset_node('dn10'); exec dbms_shard.unset_node('dn11'); exec dbms_shard.unset_node('dn12'); exec dbms_shard.unset_node('dn13'); exec dbms_shard.unset_node('dn14'); exec dbms_shard.unset_node('dn15');

exec dbms_shard.set_node('dn1','dn1',20401);

alter session set shard linker=on;

exec dbms_shard.set_shard_table ('sys','TEST','h','K01');

exec dbms_shard.set_shard_hash ('sys','TEST', 1000, 'dn1');

delete from test;

exec dbms_shard.unset_shard_table ('sys','TEST');

exec dbms_shard.unset_node('dn1'); exec dbms_shard.unset_node('dn2'); exec dbms_shard.unset_node('dn3'); exec dbms_shard.unset_node('dn4'); exec dbms_shard.unset_node('dn5'); exec dbms_shard.unset_node('dn6'); exec dbms_shard.unset_node('dn7'); exec dbms_shard.unset_node('dn8'); exec dbms_shard.unset_node('dn9'); exec dbms_shard.unset_node('dn10'); exec dbms_shard.unset_node('dn11'); exec dbms_shard.unset_node('dn12'); exec dbms_shard.unset_node('dn13'); exec dbms_shard.unset_node('dn14'); exec dbms_shard.unset_node('dn15');

exec dbms_shard.set_node('dn1','dn1',20401); exec dbms_shard.set_node('dn2','dn2',20402);

alter session set shard linker=on;

exec dbms_shard.set_shard_table ('sys','TEST','h','K01');

exec dbms_shard.set_shard_hash ('sys','TEST', 500, 'dn1'); exec dbms_shard.set_shard_hash ('sys','TEST', 1000, 'dn2');

delete from test;

exec dbms_shard.unset_shard_table ('sys','TEST');

exec dbms_shard.unset_node('dn1'); exec dbms_shard.unset_node('dn2'); exec dbms_shard.unset_node('dn3'); exec dbms_shard.unset_node('dn4'); exec dbms_shard.unset_node('dn5'); exec dbms_shard.unset_node('dn6'); exec dbms_shard.unset_node('dn7'); exec dbms_shard.unset_node('dn8'); exec dbms_shard.unset_node('dn9'); exec dbms_shard.unset_node('dn10'); exec dbms_shard.unset_node('dn11'); exec dbms_shard.unset_node('dn12'); exec dbms_shard.unset_node('dn13'); exec dbms_shard.unset_node('dn14'); exec dbms_shard.unset_node('dn15');

exec dbms_shard.set_node('dn1','dn1',20401); exec dbms_shard.set_node('dn2','dn2',20402); exec dbms_shard.set_node('dn3','dn3',20403); exec dbms_shard.set_node('dn4','dn4',20404);

alter session set shard linker=on;

exec dbms_shard.set_shard_table ('sys','TEST','h','K01');

exec dbms_shard.set_shard_hash ('sys','TEST', 250, 'dn1'); exec dbms_shard.set_shard_hash ('sys','TEST', 500, 'dn2'); exec dbms_shard.set_shard_hash ('sys','TEST', 750, 'dn3'); exec dbms_shard.set_shard_hash ('sys','TEST', 1000, 'dn4');

delete from test;

exec dbms_shard.unset_shard_table ('sys','TEST');

exec dbms_shard.unset_node('dn1'); exec dbms_shard.unset_node('dn2'); exec dbms_shard.unset_node('dn3'); exec dbms_shard.unset_node('dn4'); exec dbms_shard.unset_node('dn5'); exec dbms_shard.unset_node('dn6'); exec dbms_shard.unset_node('dn7'); exec dbms_shard.unset_node('dn8'); exec dbms_shard.unset_node('dn9'); exec dbms_shard.unset_node('dn10'); exec dbms_shard.unset_node('dn11'); exec dbms_shard.unset_node('dn12'); exec dbms_shard.unset_node('dn13'); exec dbms_shard.unset_node('dn14'); exec dbms_shard.unset_node('dn15');

exec dbms_shard.set_node('dn1','dn1',20401); exec dbms_shard.set_node('dn2','dn2',20402); exec dbms_shard.set_node('dn3','dn3',20403); exec dbms_shard.set_node('dn4','dn4',20404); exec dbms_shard.set_node('dn5','dn5',20405); exec dbms_shard.set_node('dn6','dn6',20406); exec dbms_shard.set_node('dn7','dn7',20407); exec dbms_shard.set_node('dn8','dn8',20408);

alter session set shard linker=on;

exec dbms_shard.set_shard_table ('sys','TEST','h','K01');

exec dbms_shard.set_shard_hash ('sys','TEST', 125, 'dn1'); exec dbms_shard.set_shard_hash ('sys','TEST', 250, 'dn2'); exec dbms_shard.set_shard_hash ('sys','TEST', 375, 'dn3'); exec dbms_shard.set_shard_hash ('sys','TEST', 500, 'dn4'); exec dbms_shard.set_shard_hash ('sys','TEST', 625, 'dn5'); exec dbms_shard.set_shard_hash ('sys','TEST', 750, 'dn6'); exec dbms_shard.set_shard_hash ('sys','TEST', 875, 'dn7'); exec dbms_shard.set_shard_hash ('sys','TEST', 1000, 'dn8');

delete from test; exec dbms_shard.unset_shard_table ('sys','TEST');

exec dbms_shard.unset_node('dn1'); exec dbms_shard.unset_node('dn2'); exec dbms_shard.unset_node('dn3'); exec dbms_shard.unset_node('dn4'); exec dbms_shard.unset_node('dn5'); exec dbms_shard.unset_node('dn6'); exec dbms_shard.unset_node('dn7'); exec dbms_shard.unset_node('dn8'); exec dbms_shard.unset_node('dn9'); exec dbms_shard.unset_node('dn10'); exec dbms_shard.unset_node('dn11'); exec dbms_shard.unset_node('dn12'); exec dbms_shard.unset_node('dn13'); exec dbms_shard.unset_node('dn14'); exec dbms_shard.unset_node('dn15');

exec dbms_shard.set_node('dn1','192.168.1.106',20301); exec dbms_shard.set_node('dn2','192.168.1.106',20302); exec dbms_shard.set_node('dn3','192.168.1.106',20303); exec dbms_shard.set_node('dn4','192.168.1.107',20301); exec dbms_shard.set_node('dn5','192.168.1.107',20302); exec dbms_shard.set_node('dn6','192.168.1.107',20303); exec dbms_shard.set_node('dn7','192.168.1.108',20301); exec dbms_shard.set_node('dn8','192.168.1.108',20302); exec dbms_shard.set_node('dn9','192.168.1.108',20303); exec dbms_shard.set_node('dn10','192.168.1.112',20301); exec dbms_shard.set_node('dn11','192.168.1.112',20302); exec dbms_shard.set_node('dn12','192.168.1.112',20303); exec dbms_shard.set_node('dn13','192.168.1.113',20301); exec dbms_shard.set_node('dn14','192.168.1.113',20302); exec dbms_shard.set_node('dn15','192.168.1.113',20303);

exec dbms_shard.set_shard_table ('sys','TEST','c');

exec dbms_shard.set_shard_clone ('sys','TEST', 'dn1'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn2'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn3'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn4'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn5'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn6'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn7'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn8'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn9'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn10'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn11'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn12'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn13'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn14'); exec dbms_shard.set_shard_clone ('sys','TEST', 'dn15');

delete from test; exec dbms_shard.unset_shard_table ('sys','TEST');

exec dbms_shard.unset_node('dn1'); exec dbms_shard.unset_node('dn2'); exec dbms_shard.unset_node('dn3'); exec dbms_shard.unset_node('dn4');

exec dbms_shard.set_node('dn1','dn1',20401); exec dbms_shard.set_node('dn2','dn2',20402); exec dbms_shard.set_node('dn3','dn3',20403); exec dbms_shard.set_node('dn4','dn4',20404);

alter session set shard linker=on;

exec dbms_shard.set_shard_table ('sys','TEST','h','K01');

exec dbms_shard.set_shard_hash ('sys','TEST', 60, 'dn1'); exec dbms_shard.set_shard_hash ('sys','TEST', 120, 'dn2'); exec dbms_shard.set_shard_hash ('sys','TEST', 180, 'dn3'); exec dbms_shard.set_shard_hash ('sys','TEST', 1000, 'dn4');

delete from test; exec dbms_shard.unset_shard_table ('sys','TEST');

exec dbms_shard.unset_node('dn1'); exec dbms_shard.unset_node('dn2'); exec dbms_shard.unset_node('dn3'); exec dbms_shard.unset_node('dn4');

exec dbms_shard.set_node('dn1','dn1',20401); exec dbms_shard.set_node('dn2','dn2',20402); exec dbms_shard.set_node('dn3','dn3',20403); exec dbms_shard.set_node('dn4','dn4',20404);

alter session set shard linker=on;

exec dbms_shard.set_shard_table ('sys','TEST','l','K02','dn1');

exec dbms_shard.set_shard_list ('sys','TEST',1, 'dn1'); exec dbms_shard.set_shard_list ('sys','TEST',2, 'dn2'); exec dbms_shard.set_shard_list ('sys','TEST',3, 'dn3'); exec dbms_shard.set_shard_list ('sys','TEST',4, 'dn4');

delete from test; exec dbms_shard.unset_shard_table ('sys','TEST');

exec dbms_shard.unset_node('dn1'); exec dbms_shard.unset_node('dn2'); exec dbms_shard.unset_node('dn3'); exec dbms_shard.unset_node('dn4');

exec dbms_shard.set_node('dn1','dn1',20401); exec dbms_shard.set_node('dn2','dn2',20402); exec dbms_shard.set_node('dn3','dn3',20403); exec dbms_shard.set_node('dn4','dn4',20404);

alter session set shard linker=on;

exec dbms_shard.set_shard_table ('sys','TEST','r','K01');

exec dbms_shard.set_shard_range ('sys','TEST', 6000, 'dn1'); exec dbms_shard.set_shard_range ('sys','TEST', 12000, 'dn2'); exec dbms_shard.set_shard_range ('sys','TEST', 18000, 'dn3'); exec dbms_shard.set_shard_range ('sys','TEST', 1240000, 'dn4');

delete from test; exec dbms_shard.unset_shard_table ('sys','TEST');

exec dbms_shard.unset_node('dn1'); exec dbms_shard.unset_node('dn2'); exec dbms_shard.unset_node('dn3'); exec dbms_shard.unset_node('dn4'); exec dbms_shard.unset_node('dn5'); exec dbms_shard.unset_node('dn6'); exec dbms_shard.unset_node('dn7'); exec dbms_shard.unset_node('dn8'); exec dbms_shard.unset_node('dn9'); exec dbms_shard.unset_node('dn10'); exec dbms_shard.unset_node('dn11'); exec dbms_shard.unset_node('dn12'); exec dbms_shard.unset_node('dn13'); exec dbms_shard.unset_node('dn14'); exec dbms_shard.unset_node('dn15');

exec dbms_shard.set_node('dn1','192.168.1.106',20301); exec dbms_shard.set_node('dn2','192.168.1.107',20301); exec dbms_shard.set_node('dn3','192.168.1.108',20301); exec dbms_shard.set_node('dn4','192.168.1.112',20301); exec dbms_shard.set_node('dn5','192.168.1.113',20301);

alter session set shard linker=on;

exec dbms_shard.set_shard_table ('sys','TEST','r','K01');

exec dbms_shard.set_shard_range ('sys','TEST', 200000, 'dn1'); exec dbms_shard.set_shard_range ('sys','TEST', 400000, 'dn2'); exec dbms_shard.set_shard_range ('sys','TEST', 600000, 'dn3'); exec dbms_shard.set_shard_range ('sys','TEST', 800000, 'dn4'); exec dbms_shard.set_shard_range ('sys','TEST', 1000000, 'dn5');

exec dbms_shard.check_data('sys','test'); EXEC DBMS_SHARD.CREATE_META();

exec dbms_shard.set_node('dn1','192.168.1.106',20301); exec dbms_shard.set_node('dn2','192.168.1.107',20301); exec dbms_shard.set_node('dn3','192.168.1.108',20301); exec dbms_shard.set_node('dn4','192.168.1.112',20301); exec dbms_shard.set_node('dn5','192.168.1.113',20301);

alter session set shard linker=on;

exec dbms_shard.set_shard_table ('sys','TEST','h','K01');

exec dbms_shard.set_shard_hash ('sys','TEST', 200, 'dn1'); exec dbms_shard.set_shard_hash ('sys','TEST', 400, 'dn2'); exec dbms_shard.set_shard_hash ('sys','TEST', 600, 'dn3'); exec dbms_shard.set_shard_hash ('sys','TEST', 800, 'dn4'); exec dbms_shard.set_shard_hash ('sys','TEST', 1000, 'dn5');

Lee-Sangmin-70 avatar Sep 27 '21 14:09 Lee-Sangmin-70

Performance Test - config.sql for shard

Lee-Sangmin-70 avatar Sep 27 '21 14:09 Lee-Sangmin-70