On Fri, 15 Jun 2001, Jeremy Zawodny wrote:
> 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
Just for kicks, I bumped my record_buffer up to 64MB; I don't know how
much of an effect this will have though. Do you know what buffers are used
in indexing?
Also, is it faster to insert a load of data, then index, or index as it is
being inserted?
Cheers,
-robin
> --
> 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
>
---------------------------------------------------------------------
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
