October 12, 2007

Managing Slave Lag with MySQL Replication

Posted by peter

The question I often get is how far MySQL may fall behind and how to keep replication from lagging.

The lag you will see will vary a lot from application to the application and from load to load. Plus what is the most important within same application the lag will likely have spikes - most of applications would have typical lag within few milliseconds while there will be rare cases when replication lags behind several seconds or even longer.
[read more...]

Posted by peter @ 12:18 pm :: replication :: 9 comments
Print This Post Print This Post book mark Managing Slave Lag with MySQL Replication in del.icio.usdel.icio.us :: submit Managing Slave Lag with MySQL Replication to digg.comdigg

MyISAM Scalability and Innodb, Falcon Benchmarks

Posted by Vadim

We many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several times in synthetic benchmarks but never in production, that’s why we did not escalate MyISAM scalability question. This time working on the customer system we figured out that box with 1 CPU Core is able to handle more queries per second than identical box, but with 4 CPU Cores.
[read more...]

Posted by Vadim @ 5:01 am :: Innodb, bugs, falcon, myisam, production :: 10 comments
Print This Post Print This Post book mark MyISAM Scalability and Innodb, Falcon Benchmarks in del.icio.usdel.icio.us :: submit MyISAM Scalability and Innodb, Falcon Benchmarks to digg.comdigg