MySQL基准 [英] MySQL Benchmark

问题描述

我正在尝试使用MySQL基准测试一些查询.但是，我遇到了一个错误.

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?

谢谢

推荐答案

select title from user

这将返回多行，将不起作用.

This returns multiple rows, which won't work.

请参阅此链接: http://dev.mysql.com/doc/refman /5.0/zh-CN/information-functions.html#function_benchmark

您传递的表达式必须返回标量结果.

The expression you pass must return a scalar result.

您需要更改查询，以使其返回单行: 例如:

You need to change the query such that it returns a single row: ex:

select title from user where user_name = 'some_user'

这篇关于MySQL基准的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！