> Disk speed and memory is more relevant than CPU speed most times, so
> you should include that info in your comparison.
This is the fun part :). Machine which is the fastest with old mysql
and Debian has IDE HDD and 128 MB RAM, RH7 machine (dual PIII and new
mysql) has SCSI RAID and 512 MB RAM, same with FreeBSD server.
>And how big is your table in bytes (not rows).
Little more than 12 MB
> I would start with comparing the output of mysqladmin variables
Already did this. Machines with new mysql have ALL bigger values
(key-buffer, sort-buffer etc) than this old mysql. And we tested them with
same values too... nothing, still alot slower :(
> Next, compare the output of EXPLAIN for all machines. In any case, it
> should be the same for the same MySQL versions. If it differs for any
> of the test cases, this could cause the speed difference.
Yes, they are same with same versions of MySQL.
Rgds,
Viljo
---------------------------------------------------------------------
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
