NICE No matter how big your disks are, the number of spindles and throughput is your win.
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]
