Not the answer you need?
Register and ask your own question!

Is INSERT slower in xtradb when compared to innodb?

acerolaacerola ContributorCurrent User Role Novice
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

Comments

  • JerryZhangJerryZhang Entrant Inactive User Role Beginner
    Insersion 10 times slower than innoDB is not a correct expection. I would suggest you run the database on the same hardware configuration and see further results.
  • BlairPageBlairPage Contributor Inactive User Role Beginner
    Could you provide details regarding the hardware changes made along with any other operating system changes that you may be aware of.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.