On Wed, Sep 19, 2001 at 09:37:57AM -0400, Phillip Spademan wrote:
> Hello:
>
> I am runnin' a mysql DB with about 90mil entries. on a 1Ghz system
> with 1G ram, it takes forever to get anything out, i have even tryed
> selecting the data into a file. Is there any tricks/tips anyone can
> give me for managing large DB's? It also likes to crash tables every
> month or so to =)
Okay.... First, make sure you're running a recent MySQL version. And
try to use the binary distributions available on the mysql.com web
site.
> I was reading in the manual that u could up some of the cache sizes,
> /usr/local/mysql/bin/safe_mysqld --user=mysql -O key_buffer=64M -O
> table_cache=256 \
> -O sort_buffer=4M -O record_buffer=1M &
>
> would making any of these bigger help at all?
They will help A LOT if your queries use indexes. Make sure your
queries are using indexes.
I have a 1GB machine and set the key buffer to either between 256MB
and 384MB most of the time. And I often use a record_buffer of 16MB
or so.
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 14 days, processed 255,374,790 queries (210/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
