My.cnf plesk

From Help system
Jump to: navigation, search


[mysqld]
datadir=/var/lib/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).
skip-locking
skip-bdb
skip-networking
set-variable = innodb_buffer_pool_size=512K
set-variable = innodb_additional_mem_pool_size=128K
set-variable = innodb_log_buffer_size=128K
set-variable = innodb_thread_concurrency=2
safe-show-database
query_cache_limit=64K
query_cache_size=128K
query_cache_type=1
max_user_connections=100
max_connections=200
thread_cache_size=64
key_buffer = 16K
join_buffer=16K
max_connect_errors=20
max_allowed_packet=1M
table_cache=64
record_buffer=64K
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
thread_concurrency=2
myisam_sort_buffer_size=8M
server-id=1
collation-server=utf8_unicode_ci
default-character-set=utf8

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

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-locking
skip-bdb
skip-networking
safe-show-database
query_cache_limit=64K
query_cache_size=128K
query_cache_type=1
max_user_connections=100
max_connections=200
thread_cache_size=64
key_buffer = 16K
join_buffer=16K
max_connect_errors=20
max_allowed_packet=1M
table_cache=64
record_buffer=64K
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
thread_concurrency=2
myisam_sort_buffer_size=8M
server-id=1
collation-server=utf8_unicode_ci
default-character-set=utf8

set-variable = innodb_buffer_pool_size=512K
set-variable = innodb_additional_mem_pool_size=128K
set-variable = innodb_log_buffer_size=128K
set-variable = innodb_thread_concurrency=2

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

[client]
default-character-set=utf8
Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox