… replication loops. I decided to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they…-id on the binary log, and the slaves (included the other master) will replicate them… and write them in their binary log… and then the… loop, the value of Seconds_behind_master will have many randomly looking values. The value of Seconds_behind_master is calculated…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…about background random IO coming from buffer flush activity – which is typically not latency critical and rarely the problem and log writes, …operations – MySQL binary logs are not preallocated as Innodb logs are which means both Data AND metadata have critical changes on each binary log write and …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be …spindles – So your hard drive can do 200 random reads per second and your SSD drive …log write speed is usually minimal. At the same time if reliability is desired it might be good idea to keep Binary Logs…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… When Innodb decides to schedule sequential read-ahead, random read ahead ? HT: InnoDB schedules a sequential… so. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in … commit works again. PZ: You can disable binary logging to get Group Commit back. Though this …
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… files to somewhat random IO – because blocks …of space requirements for MySQL Backups using LVM….account Innodb double write buffer (so writes to Innodb …binary logs, slow query log, general query log etc, if they get any serious traffic. You can use other techniques to get consistent binary logs…
Post: Looking at Redis
August 27, 2009 By 27 Comments
… where Innodb had to write 50MB/sec for about third of throughput and doing a lot of random IO as it was… even more simple than with MySQL as you do not need to deal with snapshot or binary log position. Replication is asynchronous and… intensive with updates being pretty much random single row updates which are hard to batch. With MySQL/Innodb I got server being…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
… explain how it works. MySQL has pluginable architecture which divides work between mysql common code (parser, optimizer…like read by index or sequential read or random read); write_row; update_row; delete_row; At …_log_flush_at_trx_commit=0 or 2 smaller values may make sense. If you have binary log …
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… a disk-based, read-write transactional storage engine that… if Fractal Trees turn random IO into sequential IO…. tested comes in binary form and mysqld binary does not contain …log producing application, it can be from simple apache logs put into mysql, application performance logs to more complex log…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
…list of enhancements: Move to MySQL 5.1.31 Scalability fix… for CPU scale of write-intentional workloads. See benchmark results…. of binlog and InnoDB transaction log could be not same. …random|linear|both] Deb builds for Ubuntu Percona XtraDB 1.0.2-3 (Sapporo) available in source and several binary…
