Hi. Our queries seem well optimized, maybe there are some slow queries in there but sometimes you have no other choice and we are using indexes. Our Key Buffer size is about 16MB (standard).
Thx for helping ... Greetz - Daniel -----Ursprungliche Nachricht----- Von: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 4. Februar 2002 23:53 An: Daniel Backhausen Cc: mySQL Mailingliste Betreff: Re: Which Hardware do I need ? 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
