RSS

My.CNF MYISAM Configuration File (Best Used One)

10 Nov

[mysqld]


datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb    # (if you don’t want to use INNODB Tables)
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1


[mysqld_safe]

err-log=/var/log/mysqld.log
open_files_limit = 8192

[mysqldump]

quick
max_allowed_packet = 16M

[myisamchk]

key_buffer = 64M

sort_buffer = 64M

read_buffer = 16M

write_buffer = 16M

[mysql.server]

user=mysql

Advertisements
 
Leave a comment

Posted by on November 10, 2009 in Database Administration, linux, MySql

 

Tags: ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: