View Single Post
Old August 9th, 2006, 04:57 PM   #3 (permalink)
DavidMacLean
Member
Verified Customer
 
Join Date: Dec 2002
Posts: 40
1. Dedicated server.

2. Which "config.php" do you refer to please?

3. mysql config as follows:


[mysqld]
datadir=/home/mysql/
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

innodb_flush_log_at_trx_commit=1
innodb_data_file_path = ibdata1:100M:autoextend
set-variable = innodb_additional_mem_pool_size=100M
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=100M
set-variable = innodb_log_buffer_size=100M
set-variable = innodb_buffer_pool_size=85M
set-variable = key_buffer=128M
set-variable = max_allowed_packet=2M
set-variable = table_cache=256
set-variable = sort_buffer=19M
set-variable = record_buffer=21M
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=42M
set-variable = thread_cache=8
set-variable = thread_concurrency=4
set-variable = max_connections=8192
set-variable = max_connect_errors=8192
query_cache_size = 32M
[mysql.server]
user=mysql
basedir=/home/
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Again, this has already been tweaked to reduce the connection failures coming from vbulletin, but I am still getting them from photopost scripts.

Any suggestions much appreciated.

Last edited by DavidMacLean; August 9th, 2006 at 11:46 PM.
DavidMacLean is offline   Reply With Quote