I recently changed hardware for my database. I also changed form MySQL 5.6 to Percona 5.6.
I noticed that insertions are much slower, like 10+ times slower. I am using the same database and the same configuration I used before. I only use InnoDB tables.
Is Percona known to be slower for insertions than MySQL?
Here is my.cnf. The server has 32GB RAM.
[mysqld]
innodb_strict_mode = ON
innodb_buffer_pool_size = 24G
innodb_file_per_table = ON
innodb_file_format = Barracuda
innodb_compression_level = 9
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 1G
innodb_log_buffer_size = 128M
innodb_flush_log_at_trx_commit = 1
#innodb_print_all_deadlocks = ON
innodb_thread_concurrency = 8
max_allowed_packet = 1G
tmp_table_size = 1G
max_heap_table_size = 1G
query_cache_type = 0
query_cache_size = 0
log-bin = mysql-bin
binlog-format = ROW
binlog-do-db = xxx
server-id = xxx
expire_logs_days = 30
sync_binlog = 1
log_output = TABLE
slow_query_log = ON
log_error = mysql-error.log
skip-name-resolve