» Einfaches MySQL Benchmark PHP Skript (SELECT BENCHMARK)

<?php
$link = mysqli_connect("localhost", "root", "");

/* check connection */
if (mysqli_connect_errno()) {
	printf("Connect failed: %s\n", mysqli_connect_error());
	exit();
}

/* prepare benchmark profiling */
$query = "SET profiling = 1;";
$result = mysqli_query($link, $query);
if (mysql_errno()) { die( "ERROR " . mysql_errno($link) . ": " . mysql_error($link) ); }

/* benchmark query */
$query = "SELECT BENCHMARK(100000000, 'foo' = \"foo\")";
$result = mysqli_query($link, $query);
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
mysqli_free_result($result);

/* obtain execution time */
$query = "SELECT query_id, SUM(duration) FROM information_schema.profiling GROUP BY query_id ORDER BY query_id DESC LIMIT 1;";
$result = mysqli_query($link, $query);
if (mysql_errno()) { die( "ERROR " . mysql_errno($link) . ": " . mysql_error($link) ); }
$row = mysqli_fetch_array($result);
mysqli_free_result($result);

echo "<p>Query executed in " . $row[1] . ' seconds';

/* close mysql connection */
$mysqli->close();
?>

Mach mit!