mysql my.ini 4G plesk windows
[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
skip-locking
key_buffer = 512M
join_buffer_size=8M
sort_buffer_size=32M
read_buffer_size=4M
read_rnd_buffer_size=8M
record_buffer=32M
query_cache_size = 512M
query_cache_type=1
table_cache = 1024
max_connections=500
max_user_connections=100
thread_cache_size=32
thread_stack=196608
binlog_cache_size=32768
thread_concurrency=4
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Share:








































