]]>
]]>

HandlerSocket on SSD

Results

mln rowsFusionIORAID10
40628938631476
41629218631463
42629177631251
43629132630615
44629342631178
45629452631955
46629187632067
47628755632183
48629387631816
49629290630920
50629344630683
51629480631278
52628493631369
53628232631489
54628825631324
55628022629970
56627828630176
57627435630013
58627633630126
59627916629912
60627643630633
61627816630902
62628234630543
63627928629852
64627124630138
65626898629272
66627267630237
67627070629931
68627539629971
69627210629770
70627151629303
71627546629029
72626846629443
73626914629052
74626029628755
75626909629869
76627150630274
77626900630307
78626553630272
79626354630332
80626238628312
81626352628923
82626150628644
83626274628062
84626329628194
85626080629469
86625733629497
87625444629651
88625699629376
89625990629101
90625960629285
91626149628547
92625438625680
93625309628658
94625390629030
95624853627514
96625392627951
97624231628453
98625200628233
99625220627575
100625042628844
101625391628408
102625113628589
103625485628209
104625389628435
105625578627476
106625715627533
107625235627640
108625067627272
109625245627214
110624731627673
111625270627888
112624772627759
113624566627386
114624492627333
115624065627345
116624351627677
117623766627486
118624084627285
119624179627717
120624312627390
121624200627027
122624151626805
123623986626888
124624185626760
125623868626662
126623541626557
127623527626463
128624115626236
129624244625795
130624318625905
131624062625964
132624559626107
133624524626347
134623717625912
135624660625112
136623504625728
137623079625668
138623775625881
139623359626037
140623556625578
141623805625354
142623283625628
143623188625218
144623172624699
145623249624717
146623309624095
147622748624220
148623298624312
149623150624141
150623001624373
151612121532607
152607333471580
153603245427119
154600497397013
155594515373566
156583939346570
157575058311441
158566134279928
159559615255787
160552989236486
161546000217984
162540036207336
163533995192079
164527948180972
165522959171137
166518506162942
167516269154906
168510378144608
169502959135713
170498014131454
171494161126958
172490306119280
173492931111211
174504395108716
175496722102820
176472200101215
17747048998620
17846771895022
17946723393042
18046520790404
18146217687349
18245910684297
18345826880978
18445579880349
18545330977506
18645260576085
18745326274286
18845204072776
18944565970726
19044303670480
19144452268513
19243854668157
19343677366205
19443441266207
19543358264469
19643359963540
19743166362069
19842951761054
19942780859647
20042688759283
20142589058123
20242477857535
20342286055537
20442276356054
20542037454270
20641875453559
20741693352989
20841307152613
20941261351972
21041142351870
21140919650733
21240679050252
21340865749909
21441212349339
21540770948567
21640607148369
21740321247168
21839999745964
21940018445726
22039840745451
22139741445076
22239922344317
22339888543837
22439710043721
22539715142969
22639597642408
22739495641899
22839185341427
22939272441371
23039222640931
23139049540918
23239111039987
23338894239634
23438813239129
23538454439409
23638359938902
23738695738593
23838862338437
23938475637663
24038384138438
24138232237665
24238236737784
24338026536922
24438017537401
24537929236579
24637858436752
24737700335827
24837685535529
24937641635540
25037538335255
25137266635183
25237107434568
25337038734426
25436933534363
25536896533923
25637171434269
25737133933165
25837048433442
25936952033233
26036904633137
26137197433278
26236683132885
26336657432614
26436660732786
26536513932385
26636553232568
26736427731771
26836395532120
26936293731831
27036248831927
27136204331464
27236120731332
27336030431001
27436031331239
27535636030772
27635464030673
27735662230673
27835615130503
27935612030334
28035592430664
28135559930261
28235154130224
28335419229664
28435558430197
28535543029875
28635302529799
28735249329528
28835294929182
28935177029193
29035200029515
29135098328830
29235027329136
29335027428627
29434976328765
29534931528436
29634866628849
29734466128484
29834525428295
29934627828140

Script

#!/usr/bin/perl

use strict;
use warnings;
use Net::HandlerSocket;

$|++;

#1. establishing a connection
my $args = { host => '192.168.1.20', port => 9998 };
my $hs = new Net::HandlerSocket($args);


#3. main logic
 #fetching rows by id
 #execute_single (index id, cond, cond value, max rows, offset)

my $cnt=10000000;

while ($cnt<300000000) {

print "rows : $cnt\n";

my $ltime=time();

my $hdnl=0;

while ((time()-$ltime)<60) {

#2. initializing an index so that we can use in main logics.
 # MySQL tables will be opened here (if not opened)

my $res = $hs->open_index(0, 'sbtest', 'sbtest', 'PRIMARY',
    'id,c');
die $hs->get_error() if $res != 0;

$res = $hs->execute_single(0, '=', [ int(rand($cnt))+1 ], 1, 0);

die $hs->get_error() if $res->[0] != 0;
shift(@$res);
for (my $row = 0; $row < 1; ++$row) {
  my $id= $res->[$row + 0];
  my $user_c= $res->[$row + 1];
#  print "$id\t$user_c\n";
}

$hdnl++;

}

print "rows: $cnt, handled: $hdnl\n";

$cnt+=1000000;

}

#4. closing the connection
$hs->close();

config

[mysqld]
basedir=/usr/local/mysql/
user=root
server_id=1
local_infile=1
datadir=/mnt/tachion/
tmpdir=/mnt/tachion/
innodb_buffer_pool_size=35G
innodb_data_file_path=ibdata1:10M:autoextend
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=256M
innodb_log_files_in_group=2
innodb_log_file_size=3G
innodb_thread_concurrency=0
innodb_flush_method             = O_DIRECT
innodb_max_purge_lag=100000
innodb_write_io_threads=16
innodb_read_io_threads=16
innodb_io_capacity=500
innodb_flush_neighbor_pages = 0
loose_handlersocket_port = 9998
loose_handlersocket_port_wr = 9999
loose_handlersocket_threads = 32
loose_handlersocket_threads_wr = 1
open_files_limit = 65535
innodb_max_dirty_pages_pct=90
max_connections=3000
query_cache_size=0
skip-name-resolve
table_cache=10000
[mysql]
socket=/tmp/mysql.sock
[client]
socket=/tmp/mysql.sock
 
benchmark/handlersocket/ssd/start.txt · Last modified: 2011/07/17 21:05 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
Contact Us 24 Hours A Day
SupportContact us 24×7
Emergency? Contact us for help now!
Sales North America(888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training(855) 55TRAIN or
(925) 271-5054

 

Share This
]]> ]]>