[mysqld]

datadir = /home/mysql

skip-host-cache
join_buffer_size=8M
#safe-show-database
character-sets-dir = /usr/share/mysql/charsets
#default-character-set = cp1251
#init-connect="SET NAMES cp1251"
bind-address = 194.54.83.110
#skip-locking

#init_connect='SET collation_connection = utf8_general_ci'
#init_connect='SET NAMES utf8'
#default-character-set=utf8
#character-set-server = utf8
#collation-server = utf8_general_ci

#default-character-set=utf8
#default-collation=utf8_general_ci
character-set-server=utf8
collation-server=utf8_general_ci
init-connect='SET NAMES utf8'


query_cache_limit=8M
query_cache_size=128M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=512
key_buffer=64M
join_buffer=1M
max_allowed_packet=16M
table_cache=2048
#record_buffer=1M
# old 2M
sort_buffer_size=256K
read_buffer_size=256K
max_connect_errors=10
thread_concurrency=16
myisam_sort_buffer_size=64M
#log-bin=www-bin
server-id=1
local-infile=0

max_heap_table_size=512M
tmp_table_size=512M
#table_open_cache=2048
table_open_cache=4096

innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 5120M
#innodb_buffer_pool_size = 2G
#innodb_data_file_path = ibdata1:4G:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 2
#innodb_log_buffer_size = 8M
#innodb_log_file_size = 64M
#innodb_log_files_in_group = 2
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 50
innodb_flush_method=O_DIRECT
innodb_support_xa = 0


#innodb_buffer_pool_reads = 341
#innodb_buffer_pool_read_requests = 348

transaction-isolation=READ-COMMITTED

#long_query_time=1
#log-slow-queries=/var/log/mysql/log-slow-queries.log

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates
default-character-set=utf8


[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]


[client]
default-character-set=utf8