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

InnoDB wite activity is too high.

Serge ShakhovSerge Shakhov EntrantCurrent User Role Beginner
Hello Everybody.

I suspect that something weird is happening in my system (Percona 5.5 on CentOS 6).
Disk write activity is constantly much higher than expected.
Amazon Cloudwatch Write Bandwidth up to 8Mb/s (expected 3Mb/s)
Amazon Cloudwatch volume Write Throughput up to 300 Ops/s (expected 100 Ops/s)
Innodb_pages_written value up to 200 pages/s (expected 65 pages/s)

How do I know what to expect? I have separate system to compare with the same hardware (AWS instances) similar number of concurrent users and user activity.
We're using replication so I know that generated bin-logs size is the same, DB growth is the same in terms of both records and size.

Could you recommend some key parameters I need to check to compare configurations of two systems which can cause this problem?

Comments

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.