Here is my info...
I am running slackware 8 (linux 2.2.19)
Mysql Ver. 3.23.40 (install via source)
System AMD T-Bird 1Gig / 1 512MB Ram
Here is my cnf
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
log-bin
server-id = 1
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
And i Start it with this cmd line
/usr/local/mysql/bin/safe_mysqld --user=mysql --memlock -O key_buffer=256M
-O table_cache=512 \
-O sort_buffer=32M -O record_buffer=8M &
Thanx!
>On Wed, Sep 19, 2001 at 04:37:03PM -0400, Phillip Spademan wrote:
> > Hello All.
> >
> > I am working with a rather large MySQL DB, it seems that it likes to
> > swap ALOT, even after the operations are done, i have bumped up my
> > cache sizes, i have tones of .bin files in my var dir, any ideas?
>
>What OS are you running on? If Linux 2.4.x, you might be running into
>some of the same problems I saw with the VM subsystem. I posted a
>note about a week ago describing the problems I've seen. It has since
>migrated to the linux-kernel mailing list where folks are still trying
>to tune things correctly.
>
>If not, tell us which OS, how much RAM you have, and send along your
>my.cnf file. Then we can make some informed suggestions.
>
>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,376,155 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
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---------------------------------------------------------------------
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
