Dathan Vance Pattishall wrote:
NICE
No matter how big your disks are, the number of spindles and throughput
is your win.
I have RAID 5 with 5 hardisks, so usuable number of spindle will only be 4.
my.cnf 3.5x options
skip-locking
skip-name-resolve
set-variable = tmp_table_size=4096
log-bin=binlog/something make sure binlog is a symlink to a separate
partition / drive
set-variable = key_buffer=4G
set-variable = table_cache=2600 # make sure your OS can handle *2 this
many file descriptors
set-variable = sort_buffer=512M # this is not a common mem pool but a
thread pool
set-variable = record_buffer=512M
set-variable = record_rnd_buffer=512M
set-variable = myisam_sort_buffer_size=512M
set-variable = max_allowed_packet=16M
-->-----Original Message-----
-->From: Mysql List [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 24, 2003 9:38 AM
-->To: [EMAIL PROTECTED]
-->Subject: Huge Server configuration
-->
-->Hello all,
-->
-->I have a server like 8way Intel Pentium 4 Xeon processor with 12GB
RAM
-->and 1TB harddisk space.
-->All the tables size are over 10GB and they have over 100mm records.
-->
-->Could some one help me get an appropriate mysql
configuration(my.conf)
-->file for the machine.
-->
-->I understand ther are lots of factors depends on it to get a steady
-->working configuration.
-->All I need is some model configuration. I think later on I can tune
thar
-->up.
-->
-->Thanx in Advance
-->-Chandra
-->
-->
-->
-->
-->--
-->MySQL General Mailing List
-->For list archives: http://lists.mysql.com/mysql
-->To unsubscribe:
-->http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]