Thierry Coopman writes:
> Hi,
>
> I was wondering where the limits of MySQL are.
>
> I need >2000 updates per second on a table with +-200000 rows.
>
> I was wondering what the ideal hardware to accustom that would be.
> For the moment a SunFire 280R with 1 CPU and the table in memory
> (heap) seems to be able to handle 1800 updates a second.
>
> Is there a way to gain more speed, to update even more ??
>
> Would a second CPU help?
>
>
>
> --
> Thierry Coopman - [EMAIL PROTECTED]
> My opinions are personal, and have really nothing or nothing to do
> with Keytrade!
>
> #RandomTag
Hi!
Yes, the above is quite possible.
You should normalize your schema, optimize queries, tune up MySQL and
make a perfect choice of hardware / OS and you can obtain better
results then the one you expect.
Regards,
Sinisa
For technical support contracts, goto http://order.mysql.com
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
