{"id":71,"date":"2003-03-19T22:10:46","date_gmt":"2003-03-20T03:10:46","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=71"},"modified":"2003-03-19T22:10:46","modified_gmt":"2003-03-20T03:10:46","slug":"reading-all-about-how-to-store-stuff-for-reading","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2003\/03\/19\/reading-all-about-how-to-store-stuff-for-reading\/","title":{"rendered":"reading all about how to store stuff for reading"},"content":{"rendered":"<p>Otherwise titled: A day of reading about Filesystems.<\/p>\n<p>I&#8217;m managing to continually find stuff I haven&#8217;t already read. I think this is a good thing. I&#8217;m clearly now going to have to do some more research into how RDMBS do things.<\/p>\n<p>The idea of Snapshots sound interesting, and may prove an interesting way to help avoid having to do journalling. I&#8217;ve been thinking that journalling could be a real issue if we allow large transations, so maybe a snapshot like idea could be good. Although, this could limit the number of transactions we work on concurrently if it&#8217;s implemented the WAFL way.<\/p>\n<p>So looking at how RDBMS do concurrent transactions would be useful. I guess we do have the advantage of having PostgreSQL and MySQL code to peer at but I do hope there are some nice papers out there to read :)<\/p>\n<p>I&#8217;ve collected a large array of useful papers to read. I&#8217;m going to try and wade through them sometime soon, but will have to do more coursework soon.<\/p>\n<p>I&#8217;m thinking tomorrow might contain a bit of coursework &#8211; need to do more POVRAY\/OpenGL stuff as well as study more of the Pattern Recognition stuff. Oh, and look at the Info Security assignment &#038; exercise for this week.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Otherwise titled: A day of reading about Filesystems. I&#8217;m managing to continually find stuff I haven&#8217;t already read. I think this is a good thing. I&#8217;m clearly now going to have to do some more research into how RDMBS do &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2003\/03\/19\/reading-all-about-how-to-store-stuff-for-reading\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"","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":[4],"tags":[],"class_list":["post-71","post","type-post","status-publish","format-standard","hentry","category-hons-project"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-19","jetpack-related-posts":[{"id":63,"url":"https:\/\/www.flamingspork.com\/blog\/2003\/03\/13\/transactions\/","url_meta":{"origin":71,"position":0},"title":"transactions","author":"Stewart Smith","date":"2003-03-13","format":false,"excerpt":"I'm thinking that I can easily do multiple FS ops in one transaction with some careful structuring of the journal. The only problem with this is the old problem of journal size. Unlike a normal journaled FS, with user transactions, we may be dealing with a lot more data in\u2026","rel":"","context":"In &quot;hons-project&quot;","block_context":{"text":"hons-project","link":"https:\/\/www.flamingspork.com\/blog\/category\/hons-project\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2168,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/10\/25\/storage-engine-api-state-graph\/","url_meta":{"origin":71,"position":1},"title":"Storage Engine API state graph","author":"Stewart Smith","date":"2010-10-25","format":false,"excerpt":"Drizzle still has a number of quirks inherited from the MySQL Storage Engine API (e.g. BLOBs, row buffer, CREATE SELECT and lack of DDL transaction boundaries, key tuple format). One of the things we fixed a long time ago was to have proper methods for StorageEngines to be called for:\u2026","rel":"","context":"In &quot;code&quot;","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"State transitions for a transaction. Transaction can be empty OR have one or more statements","src":"https:\/\/i0.wp.com\/www.flamingspork.com\/blog\/wp-content\/uploads\/2010\/10\/edge30-300x163.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":745,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/10\/19\/rusty-on-lca-talks-and-other-stuff\/","url_meta":{"origin":71,"position":2},"title":"Rusty on LCA talks and other stuff&#8230;","author":"Stewart Smith","date":"2006-10-19","format":false,"excerpt":"As email is *sooo* non-\"Web 2.0\", i reply in blog form.... Rusty's Bleeding Edge Page talks about a \"Writing an x86 hypervisor: all the cool kids are doing it!\" session that sounds really cool (better not be on at the same time as my talk... :) I don't (currently) intend\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3664,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/02\/04\/ghosts-of-mysql-past-part-2\/","url_meta":{"origin":71,"position":3},"title":"Ghosts of MySQL Past: Part 2","author":"Stewart Smith","date":"2014-02-04","format":false,"excerpt":"This continues on from my post yesterday and also contains content from my linux.conf.au 2014 talk (view video here). Way back in May in the year 2000, a feature was added to MySQL that would keep many people employed for many years - replication. In 3.23.15 you could replicate from\u2026","rel":"","context":"In &quot;drizzle&quot;","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4861,"url":"https:\/\/www.flamingspork.com\/blog\/2023\/09\/08\/personal-finance-apps\/","url_meta":{"origin":71,"position":4},"title":"Personal Finance Apps","author":"Stewart Smith","date":"2023-09-08","format":false,"excerpt":"I (relatively) recently went down the rabbit hole of trying out personal finance apps to help get a better grip on, well, the things you'd expect (personal finances and planning around them). In the past, I've had an off-again-on-again relationship with GNUCash. I did give it a solid go for\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":357,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/02\/11\/helping-in-public-forums\/","url_meta":{"origin":71,"position":5},"title":"helping in public forums","author":"Stewart Smith","date":"2005-02-11","format":false,"excerpt":"So, what's my deal with helping out in public forums? we seem to all be a helpful lot at mysql... hanging out in the web based forums at dev.mysql.com (for some obscure reason, some people actually like web based forums. give me usenet anyday), or on the lists (like the\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"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\/71","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=71"}],"version-history":[{"count":1,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":2608,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/71\/revisions\/2608"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}