These tools are available in the mysql/sql-bench (if your MySQL was configured --with-bench):
mysql-test-run is the standard test and is what MySQL AB uses for regression testing
crash-me is, well, what it sounds like. you can use it to find the limits of your mysql installation.
run-all-tests is a comprehensive single threaded benchmark suite
You can also download a multithreaded benchmark called mysqlsyseval from www.wiley.com/compbooks/pachev, which was written by Alexander. All in all, I highly recommend you get that book. I've only had it for a few days and it's already become an invaluable reference.
- Gabriel
On Monday, October 13, 2003, at 07:07 AM, Hanno Fietz wrote:
Hello,
I would like to examine with as much detail as possible the following aspects of my queries:
- How’s the total execution time distributed between disk reads / writes
and cpu / memory usage?
- How’s the total execution time distributed between index search and
actually reading data?
- Among all the queries in my application, which queries / operations
are the most load-intensive ones?
If possible, I'd like to log my results for some time, while the system
is in use. So far, I've used EXPLAIN, the manual section on optimisation
and the OS load statistics ('top') as well as some simple scripts of my
own for a rough estimation of what I'm doing. I've come a long way
compared to my first steps but I'll be damned if I can't get it faster
still, since my results are not yet what I believe MySQL can do. I'm
about to start learning how to use the benchmark suite and I would be
happy about any suggestions and instructions on how to perform a
detailed analysis of what MySQL is doing when my queries are processed.
Are there any tools? Would it be a good idea to write my own
benchmarking program? Any good suggestions for that?
Thanks, Hanno
----------------------------------------------------------------------- -
------------
Hanno Fietz
dezem GmbH
Lohmeyerstr. 9
10587 Berlin
Tel.: 030 / 34 70 50 22
Fax: 030 / 34 70 50 21
www.dezem.de
----------------------------------------------------------------------- -
------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
