[client]
port                                            = 3306
socket                                          = /var/run/mysqld/mysqld_general_1.sock

[mysqld_safe]
err-log                                         = /var/log/mysql/mysql.err

[mysqld]
character-set-server            = utf8
user                                            = mysql
port                                            = 3306
socket                                          = /var/run/mysqld/mysqld_general_1.sock
pid-file                                        = /var/run/mysqld/mysqld_general_1.pid
log-error                                       = /mnt/mysql_general_1_log/mysqld.err
log-warnings                                    = 2
basedir                                         = /usr
datadir                                         = /mnt/mysql_general_1
table_cache                             = 1024
#sort_buffer_size                       = 512K
net_buffer_length                       = 8K
read_buffer_size                        = 256K
read_rnd_buffer_size            = 8M
myisam_sort_buffer_size         = 8M

thread_cache_size       = 8
max_allowed_packet                      = 16M
query_cache_size        = 256M
key_buffer                                      = 64M
sort_buffer_size                        = 32M

binlog-format = mixed
log-bin = /mnt/mysql_general_1_log/general_1
log-bin-index = /mnt/mysql_general_1_log/general_1.index
relay-log = /mnt/mysql_general_1_log/relay

server-id                                       = 9

expire-logs_days = 7
max_binlog_size = 100M

tmpdir  = /mnt/ram

innodb_buffer_pool_size = 1G
innodb_additional_mem_pool_size = 64M
innodb_data_file_path = ibdata1:10M:autoextend:max:128M
innodb_log_buffer_size = 256M
innodb_log_files_in_group=2
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
innodb_file_per_table
#tuning?
innodb_flush_method = O_DIRECT
#nem tudom mi, elvileg gyorsíthat
innodb_autoinc_lock_mode = 2
# we keep this at around 25% of of innodb_buffer_pool_size
# sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size)
innodb_log_file_size = 256M

slow_query_log = 1
slow_query_log_file = /mnt/mysql_general_1_log/slow-queries.log
long_query_time = 3
max_connections = 2000
max_connect_errors = 10000

#nem kell angol stopword, és 3 betűs kell (ehhez repair kell!)
ft_stopword_file =
ft_min_word_len = 3

[mysqldump]
quick
max_allowed_packet                      = 16M

[mysql]

[isamchk]
key_buffer                                      = 20M
sort_buffer_size                        = 20M
read_buffer                             = 2M
write_buffer                            = 2M

[myisamchk]
key_buffer                                      = 20M
sort_buffer_size                        = 20M
read_buffer                             = 2M
write_buffer                            = 2M

[mysqlhotcopy]
interactive-timeout