ID='abc123')
This leaves one major question. How much data can MySQL push out? Can MySQL
handle 12.5 megabytes (not megabits) per second of data? Will MySQL handle
20 queries per second?
I know a lot of this also determined by OS/hardware. MySQL would be running
on a 2-CPU Sun box.
Any
Sorry, I do not have much experience with MySQL on Suns (at least not
in pushing it to the limits). On an Athlon 700Mhz selecting 1
random rows out of 6, I get over 330MB/sec (1000 queries/sec) on
localhost and about 5.5MB/sec via a 100MBit TCP connection using the
mysql command line
The government has a white paper on this.
Just !google benchmark MySQL
-Original Message-
From: Benji Spencer [mailto:ben.spencer;moody.edu]
Sent: Thursday, October 31, 2002 9:36 AM
To: Benjamin Pflugmann
Cc: [EMAIL PROTECTED]
Subject: Re: How much data can MySQL push out?
Sorry, I
They've been using Replication for a long time at Slashdot.
Really? If I were to go by their Alexa traffic rating of 1390, I'd think
it would not even be necessary. Our traffic ranking is 859 and we don't
need to do anything like that. Maybe Alexa is not a good measure. :( I
like our ranking
