Re: INTEL vs. SPARC

2004-07-08 Thread Dan Nelson
In the last episode (Jul 08), mac said: > to keep you up to date: > > we tested with a simple dd-read on different machines and mount-points: > > 400MB file (created with "dd if=/dev/urandom of=file100Mb bs=512 > count=80" on the intel-linux-box): BTW - a 512-byte blocksize is basically test

Re: INTEL vs. SPARC

2004-07-08 Thread mac
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi there, to keep you up to date: we tested with a simple dd-read on different machines and mount-points: 400MB file (created with "dd if=/dev/urandom of=file100Mb bs=512 count=80" on the intel-linux-box): reading the file with dd to /dev/null on

Re: INTEL vs. SPARC

2004-07-08 Thread mac
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05.07.2004, at 15:51, JOUANNET, Rodolphe wrote: do you use innodb or myisam tables ? myisam tables. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (Darwin) iD8DBQFA7P39vkHn/oGTPXURAs+EAJ9dV7ZOQWolUHQcO/CF9UHTx/XhAgCffhfY 73za73KJJjTaGsz1vHxVoqg=

Re: INTEL vs. SPARC

2004-07-06 Thread Egor Egorov
mac <[EMAIL PROTECTED]> wrote: >> Are you running Linux or Solaris on these servers? > sparc: solaris 9 > intel: debian-linux (2.4.21-kernel) To achieve best performance, you better get the Official MySQL binaries from http://www.mysql.com rather then compiling by yourself. This is due to glibc p

Re: INTEL vs. SPARC

2004-07-06 Thread Egor Egorov
mac <[EMAIL PROTECTED]> wrote: > does the speed of mysql depends more on things like the processor than > other resources? Disk speed & memory size are much more important then the CPU. Processor is used to calculate while MySQL is a database. And databases move data back and forth. > if so:

Re: intel vs sparc?

2004-07-03 Thread Andrew Pattison
Solaris 9 on an AMD box versus the Linux version on the same machine. I may be talking jibberish however! Cheers Andrew. - Original Message - From: "mac" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 03, 2004 3:10 PM Subject: Re: intel vs sparc? &

Re: intel vs sparc?

2004-07-03 Thread mac
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi bas, You did not provide details on your harddisk in your message, you might want to know that MySQL performance is highly related to your diskconfiguration. If you want to speed it up you could do a softwareraid 0 over as much disks that fit in y

Re: INTEL vs. SPARC

2004-07-02 Thread mac
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi andrew, I don't have a vast experience of MySQL on Solaris, but I suspect this is more down to the operating system than any hardware issues. Which version of Solaris are you running on the SPARC box? it's Solaris 9 - SunOS 5.9 64bit. the mysql is

Re: INTEL vs. SPARC

2004-07-02 Thread mac
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi andrew, Are you running Linux or Solaris on these servers? sparc: solaris 9 intel: debian-linux (2.4.21-kernel) with regards klaus -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (Darwin) iD8DBQFA5acJvkHn/oGTPXURAlG4AJ9iAHBuX3n/RhCFzN9uj1ssC2VRAg

Re: INTEL vs. SPARC

2004-07-02 Thread Andrew Pattison
Are you running Linux or Solaris on these servers? Andrew. - Original Message - From: "mac" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, July 02, 2004 4:42 PM Subject: INTEL vs. SPARC > -BEGIN PGP SIGNED MESSAGE

INTEL vs. SPARC

2004-07-02 Thread mac
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi there, hope this haven't been discussed in that kind of detail in older topics: the facts in short: - - we have the same mysql-version (4.0.18) for an intel-machine and a sparc-machine. - - we have a table with about 5,500,000 rows - - we do a "real