Hi, A 16MB key buffer seems very small; this is OK for a personal workstation with 64/128MB RAM not for a high performance 1GB server.
If your queries are using indexes, you should check Key_read_requests and Key_reads values, if your query buffer is efficient, Key_read_requests should be MUCH greater than Key_reads. As an example, here are the values from our main MySQL server: | Key_blocks_used | 186985 | | Key_read_requests | 3214556494 | | Key_reads | 183458 | If you want to optimize Key_buffer parameter, you should evaluate the size of all your indexes (check *.MYI sizes) and use this value as a starting point. Regards -- Joseph Bueno NetClub/Trader.com Daniel Backhausen wrote : > > 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) > --------------------------------------------------------------------- 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
