Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = '10.11.12.220';
- $port = 3306;
- $dbname = 'sbtest';
- $table = 'sbtest';
- $index = '`PRIMARY`';
- $user = 'vadim';
- $password = 'icanguessitsnoteasy';
- mt_srand(time());
- $mysqli = new mysqli($host, $user, $password, $dbname);
- if ($mysqli->connect_error) {
- die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
- }
- $openSql = "HANDLER {$table} OPEN AS {$table}_tblh";
- $mysqli->query($openSql);
- $time_end = microtime(true);
- $time_start = microtime(true);
- $req=0;
- while(true) {
- $id=mt_rand(1,50000000);
- $retval = $mysqli->query("HANDLER {$table}_tblh READ {$index} = ({$id})")->fetch_row();
- // print_r($retval[1]."\n");
- $req++;
- if (($req % 10000) == 0) {
- printf("%d, rate %s\n",$req, 10000/($time_end - microtime(true)));
- $time_end = microtime(true);
- }
- }
- unset($mysqli, $retval);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement