Gamingforce
Sun 26th May '02, 3:13pm
We just ordered two servers from Rackspace each with dual P3 Tuatilin 1 GHz procs, 2 GB of memory, and a 3x 18 GB SCSI Raid 5.
The only thing the database server will be running is MySQL and will be connected via 100/1000 Mbits to the web server directly. What kind of my.cnf file should I have? This is what I have so far (thanks to the posts from Eva):
[mysql.server]
user=mysql
basedir=/usr/local/mysql
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
datadir=/usr/local/mysql/data
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=400
set-variable = key_buffer=16M
set-variable = join_buffer=7M
set-variable = record_buffer=7M
set-variable = sort_buffer=10M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
[myisamchk]
set-variable = key_buffer=512M
set-variable = sort_buffer=512M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
For vBulletin, should I use persistent connections or just standard? Also what other speed tweaks are there for the web server? We are using (and have been using) PHP-Accelerator for the past several months along with PHP 4.2.1.
Thanks a lot for your help! :)
The only thing the database server will be running is MySQL and will be connected via 100/1000 Mbits to the web server directly. What kind of my.cnf file should I have? This is what I have so far (thanks to the posts from Eva):
[mysql.server]
user=mysql
basedir=/usr/local/mysql
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
datadir=/usr/local/mysql/data
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=400
set-variable = key_buffer=16M
set-variable = join_buffer=7M
set-variable = record_buffer=7M
set-variable = sort_buffer=10M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
[myisamchk]
set-variable = key_buffer=512M
set-variable = sort_buffer=512M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
For vBulletin, should I use persistent connections or just standard? Also what other speed tweaks are there for the web server? We are using (and have been using) PHP-Accelerator for the past several months along with PHP 4.2.1.
Thanks a lot for your help! :)