The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

InnoDB operations significantly slower after upgrade to MariaDB 10x

I recently upgraded my servers from 5.5.34 to 10x. For my hosts running CentOS 6x I went with 10.1.24 and hosts running CentOS 7x I went with 10.2.8.

I have noticed a slow down in certain innodb operations on both 10.1.24 and 10.2.8.

For example, I have a replication master that is running 5.5.34 and a delete operation took 20 seconds. When it replicated to the 10.2.8 slave, it took 70 seconds. Some additional details:

• Both servers had been rebooted and all caches flushed. • No other connection activity was happening, so not a potential concurrency issue. • Both CentOS 7.3 configured the same (swapiness = 1, numa-interleaving enabled, etc). • Hardware is identical • my.cnf(s) are the same except on the 10.2.8 slave commented out: innodb_additional_mem_pool_size -- thread_cache_size -- thread_concurrency

Are there any config settings in 10x I can tweak that address this kind of performance issue?

Answer Answered by Ian Gilfillan in this comment.

I suggest reporting as a bug, where you can give more details and someone can see if they can replicate the issue, as well as make suggestions on how to resolve.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.