[code]root@vm1:~# cat /etc/mysql/my.cnf
# Generated by Percona Configuration Wizard (http://tools.percona.com/) version REL5-20120208
[mysql]

# CLIENT #
# Configure default options for clients
port                           = 3306

[mysqld]

# GENERAL #
# Choose user for execution, default storage engine and location of the PID file
user                           = mysql
default-storage-engine         = InnoDB
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
tmpdir          = /var/lib/mysql/tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
character-set-server = utf8
collation-server = utf8_unicode_ci

# MyISAM #
# Setup MyISAM options with a minimal config, as InnoDB is our default engine
key-buffer-size                = 32M
myisam-recover                 = FORCE,BACKUP

# SAFETY #
# Enforce limits and safety checks
max-allowed-packet             = 16M
max-connect-errors             = 1000000
innodb                         = FORCE

# DATA STORAGE #
# Select location for database files
datadir                        = /var/lib/mysql/

# BINARY LOGGING #
# Enable and setup the binary log
#log-bin                        = /var/lib/mysql/mysql-bin
#expire-logs-days               = 14
#sync-binlog                    = 1
#expire_logs_days        = 10
#max_binlog_size         = 100M

# CACHES AND LIMITS #
# Configure reasonable default limits throughout Percona Server
tmp-table-size                 = 32M
max-heap-table-size            = 32M
query-cache-size               = 32M
max-connections                = 4000
thread-cache-size              = 50
open-files-limit               = 65535
table-definition-cache         = 1024
table-open-cache               = 2048
join_buffer_size = 256K
query_cache_limit = 2M
table_cache = 2048



# INNODB #
# Setup InnoDB/XtraDB engine a 300MB buffer pool and 32MB log file size
#innodb_data_file_path           = ibdata1:128M;ibdata2:128M:max:32G
innodb_data_file_path = ibdata1:32M:autoextend:max:32G
innodb_file_per_table           = 1
innodb-flush-method            = O_DIRECT
innodb-log-files-in-group      = 2
#innodb-log-file-size           = 32M
innodb_log_file_size = 512M
innodb_log_files_in_group = 3
innodb-flush-log-at-trx-commit = 0
innodb-buffer-pool-size        = 15G
innodb_thread_concurrency = 32
innodb_lock_wait_timeout = 30
innodb_autoextend_increment = 32
# LOGGING #
# Setup log file locations for error log and slow log
# Slow log may be disabled on production setups to prevent extra IO
log-queries-not-using-indexes  = 1
long_query_time = 2
log-error=/var/log/mysql-errors.log
log-slow-queries=/var/log/mysql-slow-queries.log
[/code]