----- Original Message -----
From: "Prasad Budim Ram" <pram@stripped>
Sent: Monday, February 02, 2004 8:01 AM
Subject: benchmarking MySQL for queries per second the server canhandle
> I want to run some test to benchmark MySQL server for the number of
> queries the server can handle per second.
> Do we have any readily available tool/script for this?
the Perl tests in the /mysql/sql-bench subdir are examples of such tests.
You can use them as a model to write tests of your own. I have written
'innotests' based on those.
Note that the Perl interface is rather slow, you can get a 2 X speed with
the C interface to MySQL.
And you can get a 5 X speed by linking the application with the MySQL
Embedded Server Library.
> If not, any suggestions on how best to do it will be welcome :)