This is a question I was asking myself after looking at some tweaks to a mysql server. I guess the more appropriate question that I wanted to ask was<\/p>\n
\nDoes setting the innodb_log_file_size parameter larger affect runtime performance?\n<\/p><\/blockquote>\n
A quick google led to the well known Mysql Performance Blog<\/a> (highly recommended for understanding mysql internals and optimizations) which had this to say<\/a><\/p>\n
\nIf you\u2019re doing significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it too large will increase recovery time, so in case of MySQL crash or power failure…<\/p>\n
…<\/p>\n
First let me explain what happens on recovery and why large innodb_log_file_size slows down recovery…\n<\/p><\/blockquote>\n
So in general, no it doesn’t HURT performance but recovery time will take longer which is something to consider when trying to bring up a database that has crashed or trying to restore a database from a LVM snapshot that has not had the luxury of being able to have it cleanly shutdown.<\/p>\n","protected":false},"excerpt":{"rendered":"
This is a question I was asking myself after looking at some tweaks to a mysql server. I guess the more appropriate question that I wanted to ask was Does setting the innodb_log_file_size parameter larger affect runtime performance? A quick google led to the well known Mysql Performance Blog (highly recommended for understanding mysql internals […]<\/p>\n","protected":false},"author":703,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[260],"tags":[],"class_list":["post-642","post","type-post","status-publish","format-standard","hentry","category-tech"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/archive.blogs.harvard.edu\/hoanga\/wp-json\/wp\/v2\/posts\/642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/archive.blogs.harvard.edu\/hoanga\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/archive.blogs.harvard.edu\/hoanga\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/hoanga\/wp-json\/wp\/v2\/users\/703"}],"replies":[{"embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/hoanga\/wp-json\/wp\/v2\/comments?post=642"}],"version-history":[{"count":0,"href":"https:\/\/archive.blogs.harvard.edu\/hoanga\/wp-json\/wp\/v2\/posts\/642\/revisions"}],"wp:attachment":[{"href":"https:\/\/archive.blogs.harvard.edu\/hoanga\/wp-json\/wp\/v2\/media?parent=642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/hoanga\/wp-json\/wp\/v2\/categories?post=642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/archive.blogs.harvard.edu\/hoanga\/wp-json\/wp\/v2\/tags?post=642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}