test-mysql.php

<?php

$host = '127.0.0.1';
$user = 'USER';
$password = 'PASSWORD';

echo 'php version ' . phpversion() . PHP_EOL;

$count = 1000;

echo 'test ' . $count . 'x connect + 1 system query' . PHP_EOL;
$start = microtime(true);
for ($i = 0; $i < $count; $i ++) {
  $pdo = new \PDO('mysql:host=' . $host, $user, $password);
  $pdo->query('SHOW DATABASES');
}
$end = microtime(true);
$dur = $end - $start;

echo 'total time ' . $dur . ' seconds' . PHP_EOL;
echo 'avg ' . ($dur / $count) . ' seconds' . PHP_EOL;


echo 'test 1x connect + ' . $count . 'x system query' . PHP_EOL;
$start = microtime(true);
$pdo = new \PDO('mysql:host=' . $host, $user, $password);
for ($i = 0; $i < $count; $i ++) {
  $pdo->query('SHOW DATABASES');
}
$end = microtime(true);
$dur = $end - $start;

echo 'total time ' . $dur . ' seconds' . PHP_EOL;
echo 'avg ' . ($dur / $count) . ' seconds' . PHP_EOL;