-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
-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
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 testing how
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: what
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
-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
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?
-BEGIN PGP SIGNED MESSAGE
-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
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-
Hash: SHA1
hi there,
hope
-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)
-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
11 matches
Mail list logo