InnoDB wite activity is too high.
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?
Subject
Views
Written By
Posted
InnoDB wite activity is too high.
1635
July 31, 2013 06:18PM
687
August 01, 2013 08:08PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.