Sorry, but our mailserver is down again (Exchange ;), so I had to read via
web
and search my list-archiv for your mailadress.
We tested the system on a Dual-P3-800Mhz-1GB while developing.
Now it's running on a E4500 with 6x400Mhz and 8 Slaves (P3-800).
Our site generates currently 1,5-2 Million PI's per day with rather many
queries to the db's. At the moment we store only european stockdata but in
february (I hope) we will add US-Stocks (about 2 times as much additional
inserts).
I'm confident that mysql will keep running easily. We will see ;)
The main problem is I/O. We had to outsource some tables to extra discarrays
to take some load from the machine.
Regards
On Mon, 22 Jan 2001, Christian Rabe wrote:
>> we use mysql here for our whole site. there are up to 500
>> inserts/second alone from the stockdata-feed and thats only part of
>> our site and about 200-300 selects/second per machine. in
>> combination with replication (3.23.xx) you can near to limitlessly
>> scale (if you have limitless money for slave-machines).
>>
>> we tried oracle and it was far too slow for us. mysql made our test about
30
>> times faster.
>
>That's some serious throughput - what kind of hardware?
---------------------------------------------------------------------
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
