{"id":698,"date":"2006-05-11T23:56:59","date_gmt":"2006-05-11T13:56:59","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/2006\/05\/11\/more-shwag-at-the-swag-report\/"},"modified":"2013-12-18T08:41:25","modified_gmt":"2013-12-17T22:41:25","slug":"more-shwag-at-the-swag-report","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2006\/05\/11\/more-shwag-at-the-swag-report\/","title":{"rendered":"More Shwag at The Swag Report"},"content":{"rendered":"<p><a href=\"http:\/\/web.archive.org\/web\/20130306010051\/http:\/\/swagreport.com\/\">The Swag Report<\/a><\/p>\n<p>I&#8217;ve posted more there, check it out. Some from the recent MySQL UC, some from linux.conf.au, some from wherever.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Swag Report I&#8217;ve posted more there, check it out. Some from the recent MySQL UC, some from linux.conf.au, some from wherever.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_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}},"categories":[6,14,16],"tags":[],"class_list":["post-698","post","type-post","status-publish","format-standard","hentry","category-linux-aus","category-mysql","category-photos"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-bg","jetpack-related-posts":[{"id":655,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/04\/19\/the-swag-report-%c2%bb-auug2005-shwag-for-speakers\/","url_meta":{"origin":698,"position":0},"title":"The Swag Report \u00c2\u00bb AUUG2005 Shwag for Speakers","author":"Stewart Smith","date":"2006-04-19","format":false,"excerpt":"The Swag Report \u00c2\u00bb AUUG2005 Shwag for Speakers I've started writing some stuff over at the Swag report. My first one is about this pen I got at AUUG2005 for being a speaker:","rel":"","context":"In &quot;cool gadgets&quot;","block_context":{"text":"cool gadgets","link":"https:\/\/www.flamingspork.com\/blog\/category\/cool-gadgets\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2313,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/03\/03\/undocumented-alter-table-that-does-nothing\/","url_meta":{"origin":698,"position":1},"title":"Undocumented ALTER TABLE that does *nothing* (useful)","author":"Stewart Smith","date":"2011-03-03","format":false,"excerpt":"(at least since MySQL 5.1.42) alter table t1 force; Pretty neat huh? In fact, in Drizzle this will end up doing a copying alter table. Not useful. There's an over four year old bug report in MySQL (Bug#24091). I'm just going to remove that bit from the parser in Drizzle\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":855,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/06\/27\/ndb_mgm-pr0n\/","url_meta":{"origin":698,"position":2},"title":"ndb_mgm pr0n","author":"Stewart Smith","date":"2007-06-27","format":false,"excerpt":"ndb_mgm> all report MemoryUsage Node 1: Data usage is 11%(632 32K pages of total 5440) Node 1: Index usage is 22%(578 8K pages of total 2592) Node 2: Data usage is 61%(3331 32K pages of total 5440) Node 2: Index usage is 40%(1039 8K pages of total 2592) ndb_mgm> Oh,\u2026","rel":"","context":"In &quot;mysql&quot;","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":3235,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/03\/05\/mysql-code-size\/","url_meta":{"origin":698,"position":3},"title":"MySQL code size over releases","author":"Stewart Smith","date":"2013-03-05","format":false,"excerpt":"As the start of a bit of a delve into the various MySQL branches and patch sets that have been around, let's start looking at the history of MySQL itself. This is how big MySQL has been over all of the major releases since the beginning (where beginning=3.23). (edit: These\u2026","rel":"","context":"In &quot;code&quot;","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"increase in MySQL source code size over version","src":"https:\/\/docs.google.com\/spreadsheet\/oimg?key=0Ar7e3-N2Y32IdHFGRWI2ODk4ZUY4TkhrclJSVC1mb3c&oid=1&zx=5h67vlc175bd","width":350,"height":200,"srcset":"https:\/\/docs.google.com\/spreadsheet\/oimg?key=0Ar7e3-N2Y32IdHFGRWI2ODk4ZUY4TkhrclJSVC1mb3c&oid=1&zx=5h67vlc175bd 1x, https:\/\/docs.google.com\/spreadsheet\/oimg?key=0Ar7e3-N2Y32IdHFGRWI2ODk4ZUY4TkhrclJSVC1mb3c&oid=1&zx=5h67vlc175bd 1.5x"},"classes":[]},{"id":3765,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/06\/03\/1-million-sql-queries-per-second-mysql-5-7-on-power8\/","url_meta":{"origin":698,"position":4},"title":"1 million SQL Queries Per Second: MySQL 5.7 on POWER8","author":"Stewart Smith","date":"2014-06-03","format":false,"excerpt":"I've previously covered MySQL 5.6 on POWER (with patch), MySQL 5.6 Performance on POWER8 (spoiler: new performance record) and MySQL 5.7 on POWER. Of course, The postings on this site are my own and don\u00e2\u20ac\u2122t necessarily represent IBM\u00e2\u20ac\u2122s positions, strategies or opinions. Also, these numbers should be considered preliminary, but\u2026","rel":"","context":"In &quot;code&quot;","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1199,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/09\/08\/building-mysql-on-windows-mysql-forge-wiki\/","url_meta":{"origin":698,"position":5},"title":"Building MySQL on Windows &#8211; MySQL Forge Wiki","author":"Stewart Smith","date":"2008-09-08","format":false,"excerpt":"Building MySQL on Windows - MySQL Forge Wiki This one covers running mysqld in the VisualStudio debugger, which can be useful. I have no special ndb_mgmd.exe or ndbd.exe in debugger instructions or wisdom (running them from mysql-test-run.pl at least). I've attached debugger to already running (started by mysql-test-run.pl) ndb processes,\u2026","rel":"","context":"In &quot;mysql&quot;","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\/698","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=698"}],"version-history":[{"count":1,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/698\/revisions"}],"predecessor-version":[{"id":3550,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/698\/revisions\/3550"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=698"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}