Buy Percona ServicesBuy Now!

InnoDB Flushing: Theory and solutions

 | April 4, 2011 |  Posted In: Benchmarks, Insight for DBAs, Insight for Developers, MySQL

I mentioned problems with InnoDB flushing in a previous post. Before getting to ideas on a solution, let’s define some terms and take a look into theory. The two most important parameters for InnoDB performance are innodb_buffer_pool_size and innodb_log_file_size. InnoDB works with data in memory, and all changes to data are performed in memory. In […]

Read More

Performance or Stability ???

 | April 1, 2011 |  Posted In: Insight for DBAs, MySQL

Sometimes the question is put like are you looking for Performance OR Stability, which I believe is a strange way to put it. In real life systems you care both about Performance AND Stability. I would even say Stability is a not the best world here, I would day you care about your minimal performance […]

Read More