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 -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 49 days, processed 1,042,150,139 queries (242/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