mysql mycnf 4g centos 5.7 plesk sb panel

[mysqld]
bind-address=127.0.0.1
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

 

 

[MySQLD]

port=3306

basedir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL

datadir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\Data

default-character-set=latin1

default-storage-engine=INNODB

skip-locking

key_buffer = 500M

join_buffer_size=8M

sort_buffer_size=32M

read_buffer_size=4M

read_rnd_buffer_size=8M

myisam_sort_buffer_size = 128M

record_buffer=32M

query_cache_size = 512M

query_cache_type=1

table_cache = 256

innodb_additional_mem_pool_size=2M

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=1M

innodb_buffer_pool_size=16M

innodb_log_file_size=10M

innodb_thread_concurrency=8

max_connections=600

old_passwords=1

max_user_connections=30

thread_cache_size=4

thread_stack=196608

binlog_cache_size=32768

net_read_timeout=30

net_retry_count=10

net_write_timeout=30

thread_concurrency=10

open_files_limit=0

[client]

port=3306