Tuning MySQL 5.6 on Vesta

[Vazze]

I tried my old percona-tuned my.cnf, but it doesnt work on Vesta (strange errors and no start)
So, here are my specs:

Intel Core i7 3770 @ 3.4GHz
16GB DDR3 1333MHz RAM
2 x 3.0TB S-ATA storage.

Running debian 7 (Wheezy) with VestaCP and MySQL 5.6.
1 large database (3GB) running InnoDB and the other 5 databases are MyISAM @ around 100MB/each (more or less)

The config (Vesta included?) is now:

Code: Select all

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

[mysqld_safe]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
explicit_defaults_for_timestamp

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address    = 127.0.0.1

log-error       = /var/log/mysql/error.log

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

Any tuning tips are welcome.

[mephivio]

Have a look here :

https://tools.percona.com/