We have already done performance benchmarking of mysql using "setquery" benchmark with 100% reproducible results.
Our objective was to compare the code generated by gcc and icc (intel c++ compiler). Certain points to remember while selecting such a benchmark: 1. The benchmark should preferably be non-insert intensive in order to evaluate the performance of the generated code (avoid i/o) 2. cpu utilization should be close to 100% during the performance test 3. The client and the server machine should be connected through a private network. You may also consider "AS3AP" or Wisconsin (comes with mysql source) benchmark. Hope this helps Barnali -----Original Message----- From: Lasse Laursen [mailto:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 1:24 PM To: [EMAIL PROTECTED] Subject: Performance / Stresstest of MySQL Hi, We are doing some optimization of our MySQL databases (tweaking the my.cnf file) to try to get better performance. We run MySQL 3.23.49 on a FreeBSD 4.5 machine and we are looking for some programs that can stresstest the servers. I have had a look at http://osdb.sourceforge.net/ but it doesn't seem to compile under FreeBSD. What kind of tests do you guys/girls perform to find the best configuration of your systems? Yours -- Lasse Laursen <[EMAIL PROTECTED]> - Systems Developer NetGroup A/S, St. Kongensgade 40H, DK-1264 København K, Denmark Phone: +45 3370 1526 - Fax: +45 3313 0066 - Web: www.netgroup.dk - We don't surf the net, we make the waves. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
