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 =)
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?
_________________________________________________________________
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
