On Mon, Feb 04, 2002 at 11:55:57AM +0100, Daniel Backhausen wrote: > > Hi. > > Does somebody know which server hardware I have to buy to realize my following >problem ? > > I have 3 tables. They are all connected to each other with some queries. > > 1st table has momentary 10.000 and should be upgraded to 50.000 records. > 2nd table has 120.000 records at moment and should be upgraded to 700.000 at time. > 3rd table has 200.000 records and should be upgraded to 1.500.000 records. > > Does somebody have experience with such a huge amount of records in > mySQL ?
That's not huge. :-) We've got one table with over 267 million rows in it and it grows daily. > We have momentary a DUAL 1 GHz Server with 1 GB Ram, but he gets a > load of 40 and restarts after some time. That should be more than sufficient. Are your queries well optimized and using indexes? How large is your key buffer? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 22,638,026 queries (388/sec. avg) --------------------------------------------------------------------- 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