Hi,
It may be of interest to anyone running price tapestry on a dedicated server to use the following MySQL database settings I stumbled accross.
To use these settings you need to edit your my.cnf file usually located in /etc/my.cnf on your server.
The new settings are as follows:-
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
skip-networking
skip-locking
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
log-bin
server-id=1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeoutOnce these settings have been copied into your my.cnf file, save the file and logon to root access on your server then restart MySQL using service mysqld restart. The performance of MySQL is increased significantly using these settings.
Hope this helps all Price tapestry users.
Thanks for the sample file. Any variables in this file that may need to be changed to work on different servers?
Bill Whelan
Computer Store