Hello,
On Tue, 27 Mar 2001, Benjamin Pflugmann wrote:
> Could you try a binary from www.mysql.com at least for one of the slow
> machines and see if it makes a difference?
Well, it took some time, but at last i've found some time and tested it on
BSD machine. Binary from mysql.com has same speed as it is with
own-compiled-version :(. Maybe 2 secs faster. Something like 1 min 13 sec
with own-compiled and 1 min 11 sec with mysql.com binary. Why this is
soooo slow with BSD we still don't know (like i said in my first mail,
same query was 3 secs or ~20 sec on Linux)
> To be true, I am running out of ideas. On the other hand, the test
> environments have too much differences to easily guess which
> difference causes the performance hit. :-/
Well, the last test was made on same machine, only thing different was
mysql version. Speed was same :(
> Just to be sure: the machines
> were not used in another way during the tests, were they?
No, well, i tested this query several times and results were the same and
there wasn't any hard processing background anyway.
Rgds,
Viljo (already ran out of ideas)
---------------------------------------------------------------------
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