MYSQL Ver 8.23 Distrib 3.23.54, sun-solaris2.8 [binary install] Sun E4500 Hi we have some seriously bad benchmarks for MYSQL performance on a new cluster - The problem seems to be IO, but the box is doing nothing:
The first set of results are the benches the second results are from my new mysql server. =================================================================== Testing server 'MySQL 3.23.29a gamma' at 2000-12-17 3:56:45 Wisconsin benchmark test Time for create_table (3): 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU) Inserting data Time to insert (31000): 21 wallclock secs ( 2.12 usr 2.82 sys + 0.00 cusr 0.00 csys = 4.94 CPU) Time to delete_big (1): 1 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU) Running actual benchmark Time for wisc_benchmark (114): 9 wallclock secs ( 3.67 usr 2.50 sys + 0.00 cusr 0.00 csys = 6.17 CPU) Total time: 31 wallclock secs ( 5.79 usr 5.32 sys + 0.00 cusr 0.00 csys = 11.11 CPU) =================================================================== Testing server 'MySQL 3.23.54' at 2003-02-19 15:54:11 Wisconsin benchmark test Time for create_table (3): 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU) Inserting data Time to insert (31000): 242 wallclock secs ( 2.47 usr 3.29 sys + 0.00 cusr 0.00 csys = 5.76 CPU) Time to delete_big (1): 1 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU) Running actual benchmark Time for wisc_benchmark (114): 10 wallclock secs ( 3.76 usr 2.65 sys + 0.00 cusr 0.00 csys = 6.41 CPU) Total time: 253 wallclock secs ( 6.25 usr 5.94 sys + 0.00 cusr 0.00 csys = 12.19 CPU) =================================================================== -- David Campbell :: Granada Sport and Interactive Email :: [EMAIL PROTECTED] Direct :: +44(0)20 7578 4415 Support :: +44(0)20 7578 4392 ********************************************************************** Please visit the official Granada website at www.granadamedia.com for the latest company news. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] Thank you. ********************************************************************** --------------------------------------------------------------------- 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
