MySQL Benchmark

Asked 2009-12-28T19:38:14.020

11

I am trying to use MySQL benchmark to test some queries. But, I am running to an error.

SELECT benchmark (10000, (select title from user));

and in return I get this error;

ERROR 1242 (21000): Subquery returns more than 1 row

Does anyone know how to benchmark a query?

Thanks

php mysql benchmarking mysql-error-1242

Edit Report

1 Answer

11

you can use the mysqlslap utility to benchmark queries, see: http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html

answered 2009-12-28T21:50:29.560