Yes, I increased this to 512M, as suggested in another answer, and the perfomance improved dramatically. Thanks for the tip.
Jeremy Zawodny wrote: >On Mon, Sep 23, 2002 at 07:25:17AM -0500, Chris Stoughton wrote: > > >>Joseph, >> >>Thanks for the quick answer. >> >>Very nice to know that adding an index forces a rebuild of all indices! >>(Side note -- I was going to configure the database with a minimal set >>of indices, and then watch to see how people use the database, and then >>add indices on popular columns.) >> >>I did not notice a lot of i/o activity, but will run vmstat for a while >>and gather statistics >> >>The machine has 1GB of RAM. >> >>Here is the configuration: >>bash-2.04$ more /etc/my.cnf >>[mysqld] >>datadir=/data/dp14.a/data/mysql >>socket=/var/lib/mysql/mysql.sock >> [mysql.server] >>user=mysql >>basedir=/var/lib >> >>[safe_mysqld] >>err-log=/var/log/mysqld.log >>pid-file=/var/run/mysqld/mysqld.pid >> >> >>There is NO SETTING for key_buffer_size -- what value do you suggest? >> >> > >Ack! You're using the default, which is very small (compared to 1GB). > >Start with 512M and work from there. > >Jeremy > > --------------------------------------------------------------------- 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
