…. We have a montoring tool that states that we often hit the “max_connections” …’ ‘Select_scan’, ’1104831′ ‘Slave_open_temp_tables’, ’0′ ‘Slave_retried_transactions’, ’0′ ‘Slave_running’, ‘OFF’ ‘Slow_launch_threads’,… 32M according to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 …
Post: Why you don't want to shard.
August 6, 2009 By 34 Comments
… architectures to be prematurely complicated. So let me state it: You don’t want to shard. Optimize … database. Too many writes – Either the IO system, or a slave can’t keep up with the amount … busy tables, and move them onto their own MySQL server. Partition-by-function keeps the architecture …
Comment: Implementing Parallel Replication in MySQL
November 16, 2010 By 3 Comments
…development. A fundamental limitation of the MySQL binary log is that it …mix of states in the “full independence” approach. We need replication state to become _…slave, more binlog stream will become pending from the IO thread, increasing the opportunities for parallelisation and helping the slave…
Post: Innodb Double Write
August 4, 2006 By 24 Comments
…other parts remain in their former state. Most typically partial page writes …on the stripe border requiring multiple IO requests. Same happens with Hardware … much does double write buffer affect MySQL Performance ? Even though double write …do not care about your data (ie slaves on RAID0) or if your …
