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]
