1.5GB is much nicer than 768MB. Makes running MySQL cluster tests a lot easier (doesn’t hit swap).<\/p>\n
the same apps still hog memory though (and for no real good reason).<\/p>\n
Yes, i’m looking at you Evolution.<\/p>\n","protected":false},"excerpt":{"rendered":"
1.5GB is much nicer than 768MB. Makes running MySQL cluster tests a lot easier (doesn’t hit swap). the same apps still hog memory though (and for no real good reason). Yes, i’m looking at you Evolution.<\/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":[1,7],"tags":[],"class_list":["post-382","post","type-post","status-publish","format-standard","hentry","category-general","category-work-et-al"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-6a","jetpack-related-posts":[{"id":3302,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/04\/20\/the-memory-storage-engine\/","url_meta":{"origin":382,"position":0},"title":"The MEMORY storage engine","author":"Stewart Smith","date":"2013-04-20","format":false,"excerpt":"I recently wrote about\u00c2\u00a0Where are they now: MySQL Storage Engines\u00c2\u00a0and\u00c2\u00a0The MERGE storage engine: not dead, just resting\u00e2\u20ac\u00a6. or forgotten.\u00c2\u00a0Today, it's the turn of the MEMORY storage engine - otherwise known as HEAP. This is yet another piece of the MySQL server that sits largely unmaintained and unloved. The MySQL Manual\u2026","rel":"","context":"In "drizzle"","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":3903,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/11\/13\/volatile-considered-harmful\/","url_meta":{"origin":382,"position":1},"title":"volatile considered harmful","author":"Stewart Smith","date":"2014-11-13","format":false,"excerpt":"While playing with MySQL 5.7.5 on POWER8, I came across a rather interesting bug (74775 - and this is not the only one... I think I have a decent amount of auditing and patching to do now) which made me want to write a bit on memory barriers and the\u2026","rel":"","context":"In "code"","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":704,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/05\/30\/i-heart-valgrind-or-an-early-patch-integrating-the-mysql-mem_root-stuff-with-valgrind\/","url_meta":{"origin":382,"position":2},"title":"I heart valgrind (or: an early patch integrating the MySQL MEM_ROOT stuff with valgrind)","author":"Stewart Smith","date":"2006-05-30","format":false,"excerpt":"Everybody knows that valgrind is great. Well, I was observing a problem in some MySQL code, it looked like we were writing over some memory that we weren't meant to be (as the structure hadn't been initialised yet). But, seeing as this was memory that had been allocated off a\u2026","rel":"","context":"In "mysql"","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2160,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/10\/25\/ubuntu-10-10-biggest-mistake-shotwell\/","url_meta":{"origin":382,"position":3},"title":"Ubuntu 10.10 biggest mistake: shotwell","author":"Stewart Smith","date":"2010-10-25","format":false,"excerpt":"This is meant to replace f-spot. It just isn't ready. I do not have what I would consider a large photo collection. It's about 77GB on disk, maybe 30,000 images. Importing from f-spot is horrendously slow for what is essentially a few INSERT..SELECT statements. It does not copy your photos\u2026","rel":"","context":"In "GNOME"","block_context":{"text":"GNOME","link":"https:\/\/www.flamingspork.com\/blog\/category\/gnome\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1931,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/05\/26\/blobs-in-the-drizzlemysql-storage-engine-api\/","url_meta":{"origin":382,"position":4},"title":"BLOBS in the Drizzle\/MySQL Storage Engine API","author":"Stewart Smith","date":"2010-05-26","format":false,"excerpt":"Another (AFAIK) undocumented part of the Storage Engine API: We all know what a normal row looks like in Drizzle\/MySQL row format (a NULL bitmap and then column data): Nothing that special. It's a fixed sized buffer, Field objects reference into it, you read out of it and write the\u2026","rel":"","context":"In "drizzle"","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.flamingspork.com\/blog\/wp-content\/uploads\/2010\/05\/rect28161-300x67.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":854,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/06\/27\/run-backup-run\/","url_meta":{"origin":382,"position":5},"title":"Run Backup, Run!","author":"Stewart Smith","date":"2007-06-27","format":false,"excerpt":"Over the past N weeks\/couple of months, we've been making a number of improvements to how backups are done in MySQL Cluster. Once you get to large data sets, you start to really care about how long a backup takes. Traditionally, MySQL Cluster has been in-memory only. The way to\u2026","rel":"","context":"In "mysql"","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"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\/382","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=382"}],"version-history":[{"count":0,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/382\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}