Advertisement
Guest User

Untitled

a guest
Jul 9th, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.87 KB | None | 0 0
  1. <?php
  2. $host = '10.11.12.220';
  3. $port = 3306;
  4. $dbname = 'sbtest';
  5. $table =  'sbtest';
  6. $index = '`PRIMARY`';
  7. $user = 'vadim';
  8. $password = 'icanguessitsnoteasy';
  9.  
  10. mt_srand(time());
  11.  
  12. $mysqli = new mysqli($host, $user, $password, $dbname);
  13. if ($mysqli->connect_error) {
  14.     die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
  15. }
  16.  
  17. $openSql = "HANDLER {$table} OPEN AS {$table}_tblh";
  18.  
  19. $mysqli->query($openSql);
  20.  
  21. $time_end = microtime(true);
  22. $time_start = microtime(true);
  23. $req=0;
  24.  
  25. while(true) {
  26.     $id=mt_rand(1,50000000);
  27.     $retval = $mysqli->query("HANDLER {$table}_tblh READ {$index} = ({$id})")->fetch_row();
  28.     // print_r($retval[1]."\n");
  29.     $req++;
  30.     if (($req % 10000) == 0) {
  31.         printf("%d, rate %s\n",$req, 10000/($time_end - microtime(true)));
  32.         $time_end = microtime(true);
  33.     }
  34. }
  35.  
  36. unset($mysqli, $retval);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement