Results

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