{"id":2289,"date":"2012-02-05T08:29:02","date_gmt":"2012-02-05T13:29:02","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=2289"},"modified":"2012-02-05T08:29:06","modified_gmt":"2012-02-05T13:29:06","slug":"optimizing-your-innodb-buffer-pool-usage-by-steve-hardy","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/optimizing-your-innodb-buffer-pool-usage-by-steve-hardy","title":{"rendered":"Optimizing your InnoDB buffer pool usage by Steve Hardy"},"content":{"rendered":"<p>Steve Hardy of <a href=\"http:\/\/www.zarafa.com\/\">Zarafa<\/a>.<\/p>\n<p>Work that has been done to make Zarafa better. Why do you optimise your buffer pool? To decrease your I\/O load. How can you do it? Buy more RAM, page compression, less (smaller) data, rearrange data.<\/p>\n<p>MariaDB or Percona Server allows you to inspect your <a href=\"http:\/\/www.percona.com\/docs\/wiki\/percona-server:features:innodb_buffer_pool_pages\">buffer pool<\/a> (unsure if this is now available in MySQL 5.6). Giuseppe in the audience says this is available in MySQL 5.6, but Steve used this on MariaDB 5.2.<\/p>\n<p>Strategies to fix it: Make records smaller. Remove indexes if you can use others almost as efficiently. Make records that are accessed around the same time have a higher chance of being on the same page. Use page compression. Buy more RAM. Try Batched Key Access (BKA) in MariaDB 5.3+.<\/p>\n<p>Best to view the presentation since there are specific examples that speak about how Zarafa solves their problems like a user trying to sort their email, etc.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Steve Hardy of Zarafa. Work that has been done to make Zarafa better. Why do you optimise your buffer pool? To decrease your I\/O load. How can you do it? Buy more RAM, page compression, less (smaller) data, rearrange data. MariaDB or Percona Server allows you to inspect your buffer pool (unsure if this is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1064,23],"tags":[1332,1348],"class_list":["post-2289","post","type-post","status-publish","format-standard","hentry","category-mariadb-databases","category-mysql","tag-fosdem","tag-steve-hardy"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p4vJD-AV","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2289","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=2289"}],"version-history":[{"count":2,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2289\/revisions"}],"predecessor-version":[{"id":2291,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2289\/revisions\/2291"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}