At 16:10 +0300 07-06-2001, Sinisa Milivojevic wrote: >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? > >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. > Is there a way to tune MySQL for a lot of updates? most performance tunings consider selects not updates. Since the table is in memory, I guess HDD speed is not a factor (on a SunFire280R those are FCAL disks). My guess is that the Cache Memory on the processor speeds things up a lot (UltraSparc III has 8MB), but I'm not sure how 2 CPU's will perform. Also having splitting the updates over multiple treads seems to improve speed a little. -- Thierry Coopman - [EMAIL PROTECTED] My opinions are personal, and have really nothing or nothing to do with Keytrade! #RandomTag --------------------------------------------------------------------- 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
