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

Last modified onSunday, 14 October 2012 04:07

Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 169

Notice: Only variables should be assigned by reference in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 478
back to top