Hi. Opens: ~4000 - 20000 Queries p/s avg: 10 till 60
Thx for helping Greetz Daniel -----Ursprüngliche Nachricht----- Von: Egor Egorov [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 4. Februar 2002 18:38 An: [EMAIL PROTECTED] Betreff: Which Hardware do I need ? Daniel, Monday, February 04, 2002, 12:55:57 PM, you wrote: DB> Does somebody know which server hardware I have DB> to buy to realize my following problem ? DB> I have 3 tables. They are all connected to each other DB> with some queries. DB> 1st table has momentary 10.000 and should be upgraded to DB> 50.000 records. DB> 2nd table has 120.000 records at moment and should be DB> upgraded to 700.000 at time. DB> 3rd table has 200.000 records and should be upgraded to DB> 1.500.000 records. DB> Does somebody have experience with such a huge amount of DB> records in mySQL ? DB> We have momentary a DUAL 1 GHz Server with 1 GB Ram, but DB> he gets a load of 40 and restarts after some time. Tell us about the number of connections open and number of average simultaneous queries. Then we wil try to help. DB> - Daniel Backhausen -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
