add it to /etc/mysql/my.cnf

MySQL_tunning

[mysqld]
# Increase available RAM memory size for MySQL server
# Default: 135M
innodb_buffer_pool_size = 1G
# Split memory pool by multiple instance
# Default: 1
innodb_buffer_pool_instances = 8
# Increase size of redo log file
# Default: 50M
innodb_log_file_size = 256M
# Increase size of buffer for transactions (before COMMIT)
# Default: 16M
innodb_log_buffer_size = 32M
# Disable cache for queries
# Default: 16M
query_cache_size = 0
# Set how to save WRITES to the file on the disk (from buffer)
# When set 2 - MySQL will save all data from the buffer to disk EVERY second
# Default: 1
innodb_flush_log_at_trx_commit = 2