@sedat: If you change innodb_log_size, you’ll have to remove the old log files manually so MySQL can create new ones. See also http://www.mysqlperformanceblog.com/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/comment-page-1/#comment-390952 Best regards, Jochen
Comment: InnoDB Flushing: Theory and solutions
April 11, 2011 By 23 Comments
Nathan, There is no single rule. You may read http://www.mysqlperformanceblog.com/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/ to get some ideas.
Comment: InnoDB Flushing: Theory and solutions
April 4, 2011 By 23 Comments
Nathan, There is no single rule. You may read http://www.mysqlperformanceblog.com/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/ to get some ideas.
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…file to another MySQL server. If you try to very often you’ll get an error in the log: InnoDB…SIZE in the source code). Let’s take a look at the page header: InnoDB Page Header Name Size…to modify space_id in InnoDB dictionary once than in every InnoDB page. How…: new style: calculated = 0x E4189B9B; …
Comment: How to calculate a good InnoDB log file size
November 24, 2008 By 38 Comments
…’s impact on log file size. Consider a case where innodb_buffer_size is set to 2GB and max_dirty_pages is set to 90%. What it… this 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 data…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…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…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…size forces it to. This goes back to what data you really need to…how hard they have to work on I/O capacity. What does this have to do with InnoDB? Data clustering. InnoDB…log files out of the database. The database is usually the most expensive and hardest-to… fooled into calculating the wrong …
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…for any OLTP workloads they have. back_log is calculated based on max_connections. You’re…innodb_purge_batch_size is a performance enhancement, Should also be used in 5.5 to reduce purge overhead. innodb_open_files…) use, accompanied by more tips about how and when to change the values. This will …
