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 spee
> Okay, that means, memory is no problem. And disks shouldn't be a
> problem either, because the table fits into memory. (Sorry, don't
> remember the test case anymore. Did it contain INSERTs/UPDATEs?)
No, only one SELECT with 3 joins. Just in case i send this query again:
SELECT f.foto_id, f.im
> 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
Hello,
I encountered following problem: when using older mysql (3.22.23 vs
3.23.33) then older is about 4-6 times faster on the same machine. What
could be the problem? Sytem is Debian 2.2r2, older mysql was from .deb but
newer i built myself. The query looks like this:
SELECT f.foto_id, f.imgna
