{"id":512,"date":"2005-11-23T10:57:25","date_gmt":"2005-11-23T00:57:25","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=512"},"modified":"2005-11-23T10:57:25","modified_gmt":"2005-11-23T00:57:25","slug":"disk-space-allocation-part-2-examining-your-database-files","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2005\/11\/23\/disk-space-allocation-part-2-examining-your-database-files\/","title":{"rendered":"disk space allocation (part 2: examining your database files)"},"content":{"rendered":"
\r\nmemberdb\/log.MYD:\r\n EXT: FILE-OFFSET      BLOCK-RANGE      AG AG-OFFSET        TOTAL\r\n   0: [0..943]:        5898248..5899191  3 (36536..37479)     944\r\n   1: [944..1023]:     6071640..6071719  3 (209928..210007)    80\r\n   2: [1024..1127]:    6093664..6093767  3 (231952..232055)   104\r\n   3: [1128..1279]:    6074800..6074951  3 (213088..213239)   152\r\n   4: [1280..1407]:    6074672..6074799  3 (212960..213087)   128\r\n   5: [1408..1423]:    6074264..6074279  3 (212552..212567)    16\r\nmemberdb\/log.MYI:\r\n EXT: FILE-OFFSET      BLOCK-RANGE        AG AG-OFFSET        TOTAL\r\n   0: [0..7]:          10165832..10165839  5 (396312..396319)     8\r\n<\/pre>\n
The interesting thing about this is that the log table grows very slowly. This table stores a bunch of debugging output for my memberdb applicaiton. It should possibly be a partitioned ARCHIVE table (and probably will in the future).<\/p>\n
The thing about a file growing slowly over time is that it’s more likely to have more than 1 extent (I’ll examine why in the near future).<\/p>\n
My InnoDB data and log files only have 1 extent.. I think I’ve done a xfs_fsr on my file system though.<\/p>\n","protected":false},"excerpt":{"rendered":"
memberdb\/log.MYD: EXT: FILE-OFFSET BLOCK-RANGE AG AG-OFFSET TOTAL 0: [0..943]: 5898248..5899191 3 (36536..37479) 944 1: [944..1023]: 6071640..6071719 3 (209928..210007) 80 2: [1024..1127]: 6093664..6093767 3 (231952..232055) 104 3: [1128..1279]: 6074800..6074951 3 (213088..213239) 152 4: [1280..1407]: 6074672..6074799 3 (212960..213087) 128 5: [1408..1423]: 6074264..6074279 … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","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_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":[8,14],"tags":[],"class_list":["post-512","post","type-post","status-publish","format-standard","hentry","category-linux-kernel","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-8g","jetpack-related-posts":[{"id":511,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/11\/23\/disk-space-allocation-part-1-seeing-whats-happenned\/","url_meta":{"origin":512,"position":0},"title":"disk space allocation (part 1: seeing what’s happenned)","author":"Stewart Smith","date":"2005-11-23","format":false,"excerpt":"(a little while ago I was writing a really long entry on everything possible. I realised that this would be a long read for people and that less people would look at it, so I've split it up). This sprung out of doing work on the NDB disk data tree.\u2026","rel":"","context":"In "linux-kernel"","block_context":{"text":"linux-kernel","link":"https:\/\/www.flamingspork.com\/blog\/category\/linux-kernel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":749,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/10\/21\/memberdb-a-membership-database-version-05-released\/","url_meta":{"origin":512,"position":1},"title":"MemberDB – A Membership Database – Version 0.5 released","author":"Stewart Smith","date":"2006-10-21","format":false,"excerpt":"MemberDB - A Membership Database Released 0.5. Pretty much the same as 0.4 but with a bunch of bug fixes. As used for the recent(ish) LUV election. This is what will probably be used for the next LA election too.","rel":"","context":"In "linux-aus"","block_context":{"text":"linux-aus","link":"https:\/\/www.flamingspork.com\/blog\/category\/linux-aus\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":291,"url":"https:\/\/www.flamingspork.com\/blog\/2004\/10\/22\/luv-considering-memberdb\/","url_meta":{"origin":512,"position":2},"title":"luv considering MemberDB","author":"Stewart Smith","date":"2004-10-22","format":false,"excerpt":"actively considering MemberDB for Linux Users of Victoria (luv). People seem excited about it...","rel":"","context":"In "MemberDB"","block_context":{"text":"MemberDB","link":"https:\/\/www.flamingspork.com\/blog\/category\/memberdb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":282,"url":"https:\/\/www.flamingspork.com\/blog\/2004\/10\/01\/integrating-memberdb-with-las-look-and-feel\/","url_meta":{"origin":512,"position":3},"title":"Integrating MemberDB with LA’s look-and-feel","author":"Stewart Smith","date":"2004-10-01","format":false,"excerpt":"Well... since LA actually has a look and feel now (thanks to the new website), I have to make good on the \"site look is independent of the actual memberdb code\" statement. It's proving to be sorta-true. A couple more patches into memberdb and it should all be right. Oh,\u2026","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":629,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/03\/31\/memberdb-a-membership-database-04\/","url_meta":{"origin":512,"position":4},"title":"MemberDB – A Membership Database 0.4","author":"Stewart Smith","date":"2006-03-31","format":false,"excerpt":"MemberDB - A Membership Database I released 0.4 today. A rather long awaited release. No doubt there'll be bugs and the need for a 0.4.1 or something - but this is relatively bug free and has a bunch of new cool stuff to chew on. It's also the first real\u2026","rel":"","context":"In "linux-aus"","block_context":{"text":"linux-aus","link":"https:\/\/www.flamingspork.com\/blog\/category\/linux-aus\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":343,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/01\/16\/memberdb-a-membership-database\/","url_meta":{"origin":512,"position":5},"title":"MemberDB – A Membership Database","author":"Stewart Smith","date":"2005-01-16","format":false,"excerpt":"MemberDB - A Membership Database I released 0.3 today. Contains all the election code as used in the LA 2005 Election. Yes, there's known bugs in this release.. check bugzilla for current ones.","rel":"","context":"In "linux-aus"","block_context":{"text":"linux-aus","link":"https:\/\/www.flamingspork.com\/blog\/category\/linux-aus\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=512"}],"version-history":[{"count":0,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/512\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}