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=ibda ta1:10M:au toextend
#datadir=/var/lib/mysql
socket=/var/lib/mysql/mysq l.sock
port = 3306
old_passwords=1
#skip-locking
set-variable=max_connectio ns=350
set-variable=max_user_conn ections=25
set-variable=max_allowed_p acket=1M
set-variable=thread_stack= 128K
set-variable=key_buffer=38 4M
set-variable=table_cache=5 12
set-variable=record_buffer =8M
set-variable=back_log=200
set-variable=thread_cache_ size=8
set-variable=thread_concur rency=8
set-variable=myisam_sort_b uffer_size =64M
set-variable=sort_buffer=2 M
set-variable=delayed_inser t_timeout= 150
set-variable=interactive_t imeout=40
set-variable=wait_timeout= 40
set-variable=connect_timeo ut=10
set-variable=net_buffer_le ngth=8K
set-variable=myisam_sort_b uffer_size =8M
[mysql.server]
user=mysql
basedir=/var/lib
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[safe_mysqld]
err-log=/var/log/mysqld.lo g
pid-file=/var/run/mysqld/m ysqld.pid
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=ibda
#datadir=/var/lib/mysql
socket=/var/lib/mysql/mysq
port = 3306
old_passwords=1
#skip-locking
set-variable=max_connectio
set-variable=max_user_conn
set-variable=max_allowed_p
set-variable=thread_stack=
set-variable=key_buffer=38
set-variable=table_cache=5
set-variable=record_buffer
set-variable=back_log=200
set-variable=thread_cache_
set-variable=thread_concur
set-variable=myisam_sort_b
set-variable=sort_buffer=2
set-variable=delayed_inser
set-variable=interactive_t
set-variable=wait_timeout=
set-variable=connect_timeo
set-variable=net_buffer_le
set-variable=myisam_sort_b
[mysql.server]
user=mysql
basedir=/var/lib
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[safe_mysqld]
err-log=/var/log/mysqld.lo
pid-file=/var/run/mysqld/m
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.