如何在phpmyadmin中多次运行查询? [英] How can I run a query multiple times in phpmyadmin?

问题描述

我想要一种能够对1,000,000次查询进行基准测试的方法.最简单的方法是什么?目前，我已经搜索了多次发出查询的方法，但没有弹出任何提示.

I want a way to be able to benchmark a query like 1,000,000 times. What's the easiest way to do this? Currently I've searched for a way to issue a query multiple times but nothing pops up.

我也遇到了可以在mysql命令行中运行的Benchmark()命令，但是它似乎有一些限制，我似乎无法使其正常工作.

I've also come across the benchmark() command that can be run in mysql command line, but it seems to have some limitations and I can't seem to get it to work.

推荐答案

这并不是phpMyAdmin的工作，phpMyAdmin是MySQL初学者的GUI.

This isn't really the job of phpMyAdmin, a GUI for MySQL beginners.

将查询放入运行1,000,000次的循环脚本中.

Put the query in a script, in a loop that runs 1,000,000 times.

尽管那不是任何东西的很好基准.如果您要模拟真实需求，则需要进行一些 concurrent 活动，而不是一次发出并返回一个查询的1,000,000个查询.

Though that's not a very good benchmark of anything. If you're trying to simulate real demand, you need to have some concurrent activity, not just 1,000,000 queries issued and returned one at a time.

这篇关于如何在phpmyadmin中多次运行查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！