Link to home
Create AccountLog in
Avatar of weiterer
weiterer

asked on

MySQL 4.1 good Tuning Config for a Webhost

Does someone know a good and optimized MYSQL config for mostly websites, forums, etc.

If someone could post the config of his current webhost like hostgator or other it would be nice.

I need a optimized and good config for webhosting 100%.

For MYSQL version 4.1. Here is my current config and its a mess as well old. I think im not even using all the functions of the new mysql 4.1 since that i have since version 3.

Here is my current. Fixes and tunes will be appreciated. The server has 2 GB of Ram but its only a Celeron.

I want to use the same config on a Opteron server that as well has 2 GB of Ram and also has mysql 4.1

Thanks:

[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
#datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port            = 3306
old_passwords=1
#skip-locking
set-variable=max_connections=350
set-variable=max_user_connections=25
set-variable=max_allowed_packet=1M
set-variable=thread_stack=128K
set-variable=key_buffer=384M
set-variable=table_cache=512
set-variable=record_buffer=8M
set-variable=back_log=200
set-variable=thread_cache_size=8
set-variable=thread_concurrency=8
set-variable=myisam_sort_buffer_size=64M
set-variable=sort_buffer=2M
set-variable=delayed_insert_timeout=150
set-variable=interactive_timeout=40
set-variable=wait_timeout=40
set-variable=connect_timeout=10
set-variable=net_buffer_length=8K
set-variable=myisam_sort_buffer_size=8M

[mysql.server]
user=mysql
basedir=/var/lib

[mysqldump]
quick
set-variable      = max_allowed_packet=16M


[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
ASKER CERTIFIED SOLUTION
Avatar of rmaranhao
rmaranhao

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer