On 091111, Robert Klikics wrote:
> Event buffer status: used=822KB(45%) alloc=1801KB(0%) max=0B apply_epoch=7239717/9
> latest_epoch=7239717/9
> I don't know what this means. Any ideas?
Overall picture:
mysqld_1 -> (updates) -> DB -> (triggers) -> mysqld_2 -> binlog/replication
The numbers above are for memory usage by mysqld_2. It buffers an "epoch"
of data (for example for 1 second). The numbers above are fine.
The main topic though is about the tcp/ip connection DB -> mysqld_2
which cannot keep up (Send Buffers overloaded). Logically it must
output as much as the mysqld_1 (which could be several) pumps in.
So it's not really surprising.
--
Pekka Nousiainen, Software Engineer, Sun Microsystems / MySQL
