…InnoDB status. Baron once wrote an article on how to…file descriptor numbers and in the 7th column there are the file sizes. This makes it obvious that InnoDB status has to be under file…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… OLTP workloads they have. back_log is calculated based on max_connections….innodb_purge_batch_size is a performance enhancement, Should also be used in 5.5 to reduce purge overhead. innodb_open_files…log when using row-based logging. Both of those are good and I recommend them after reading about how…
Comment: How to calculate a good InnoDB log file size
November 24, 2008 By 38 Comments
…good. I had a query about innodb_max_dirty_pages parameter and it’s impact on log file size. Consider a case where innodb_buffer_size is set to…problem before? Is parameter (innodb_max_dirty_pages*innodb_buffer_size) even used in calculating log file size? If not then how does MySQL recover unflushed…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…a fair chance they will talk about how hard they have to work on I/O capacity. What does this have to do with InnoDB…log files out of the database. The database is usually the most expensive and hardest-to…a good look. I had the chance at OpenSQL Camp to talk to…
