On Fri, Jun 15, 2001 at 12:53:04PM -0600, Chris Bolt wrote:
> > Is this machine basically dedicated to MySQL? If so, I'd try bumping
> > up the record_buffer to 16 or 32MB and see what that does. I've got it
> > set at 32MB on a server with 1GB of RAM.
>
> I'm looking at my-huge.cnf included with mysql 3.23.39 and it has a
> record_buffer of 1M. Are the example configs included with mysql
> conservative, and if so, do you have any other suggestions for
> configurations with lots of ram (768MB in my case)?
I don't know that they're conservative. They are good starting points
which are optimized for the general case. Most folks aren't going to
do lots of heavy indexing as much as they are SELECT queries
(hopefully on indexed columns).
I don't have any other suggestions at the moment...
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 1 days, processed 8,464,357 queries (85/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
