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

Percona 5.5 on Xen and KVM - memory issue

gbshousegbshouse EntrantCurrent User Role Beginner

Recently we have found some odd issue related to our environment. We have Percona 5.5 running on various virtual machines (all as slaves). All have the same parameters and use the same config file (from central repository). On Xen and VMware the memory usage is constant but on KVM it's constantly growing up 90%. We have tried to tune it by setting the 'innodb_dict_size_limit' but it didn't help. Any suggestions?



  • przemekprzemek Percona Support Engineer Percona Staff Role

    By the memory usage you mean the mysqld process size? Is the workload the same as Xen and VMware VMs?
    innodb_dict_size_limit matters only if you have large number of tables. The most relevant variables memory wise are InnoDB buffer pool, all the per-session buffers, MyISAM key cache, etc.
    What about memory section of show engine InnoDB status? Can you paste from both example VMs here to compare? Together with my.cnf files.
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.