With all of the benchmark test I have used the same DB structure, same
TABLE structure, and finally same iterations.
This probably means that Solaris I/O is really poor, or there is some other
explanation (like changing some kernel parameters to get Solaris working
well with DB kind of stuff).
At the moment I am trying to find out exactly what is the problem. It
should not be MySQL itself because the first 2 boxes have different results
from the last 2 boxes. This leads me to the conclusion that Solaris is doing
something weird with the I/O. Unfortunately, I do not have Solaris 8 to test
MySQL in that environment.
Note that all the boxes are running the same MySQL version so that could
not be the problem (3.23.47).
Regards,
Nesh Nenad Mijailovic
Software Engineer
IVSTEL Telecommunications Solutions
_____________________________
-----Original Message-----
From: Sherzod Ruzmetov aka sherzodR [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 5 February 2002 11:14 AM
To: Nesh Nenad Mijailovic
Cc: '[EMAIL PROTECTED]'
Subject: Re: Speed difference
: after timing the program that was targeting MySQL on different
platforms
: the results are (client program running always from the same box that is
not
: hosting MySQL):
:
: Windows NT - 25 sec (Intel P-III)
: Linux - 27 sec (Intel P-III)
: Solaris 2.7 - 1 min 40 sec (Ultra 5)
: Solaris 2.7 - 1 min 32 sec (Ultra 10)
:
: Is there a reasonable explanation why is this happening.
:
Well, even though you run the same benchmark on the same machine several
times, you'll get different results. So we also need to know if adequate
iterations have been performed. So the time difference in the first two
results aren't that much different at all. The same conclusion is true about
the last two, But the slowness of Solaris boxes does impress me.
So I believe (i'm not a solaris dude) Ultra is the processor, right? Then we
could conclude that pentiums are much more faster then Ultras. Do you
aggree?
--
Sherzod Ruzmetov <[EMAIL PROTECTED]> http://www.UltraCgis.com,
Consultant 989.774.6265
01001010010000010101000001001100
+----------------------------------------+
| There is nothing wrong with your tools.|
| But we can make a better one. |
+----------------------------------------+
---------------------------------------------------------------------
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
