{"id":446,"date":"2005-08-03T17:41:11","date_gmt":"2005-08-03T07:41:11","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=446"},"modified":"2014-10-08T09:19:42","modified_gmt":"2014-10-07T23:19:42","slug":"fancy-shortcuts-to-mysql-bugs","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2005\/08\/03\/fancy-shortcuts-to-mysql-bugs\/","title":{"rendered":"Fancy shortcuts to MySQL Bugs"},"content":{"rendered":"<p>So Elliot Murphy is talking about <a href=\"http:\/\/web.archive.org\/web\/20061104111550\/http:\/\/raraavisresearch.com\/memo\/archives\/2005\/08\/03\/quicksearch-shortcut-for-bugsmysqlcom\/\">QuickSearch shortcut for bugs.mysql.com<\/a> which is quite useful if you use <a href=\"http:\/\/www.mozilla.org\/en-US\/\">Firefox<\/a>.<\/p>\n<p>However, I&#8217;m using <a href=\"https:\/\/projects.gnome.org\/epiphany\/\">Epiphany<\/a> (which is based on the same rendering engine, but is a bit more GNOMEy &#8211; and besides, i&#8217;ve been using it for a while, i have all my bookmarks and saved passwords etc there).<\/p>\n<p>So, a quick <a href=\"http:\/\/www.php.net\">PHP<\/a> script later, and I have a nice little command line version of the same script.<\/p>\n<p><code><br \/>\n#!\/usr\/bin\/php<br \/>\n< ?php\nsystem('sensible-browser '\n  .'http:\/\/bugs.mysql.com\/search.php?'\n  .'cmd=display\\&amp;limit=10\\&amp;'\n  .'status=All\\&amp;search_for='\n  .urlencode(implode(' ',array_slice($argv,1))));\n?><br \/>\n<\/code><\/p>\n<p>Useful! Usage is like:<\/p>\n<p><code><br \/>\n$ mybug 10950<br \/>\n$ mybug ndb<br \/>\n<\/code><\/p>\n<p>hope it helps.<\/p>\n<p>maybe i&#8217;ll switch to firefox one day&#8230; when it&#8217;s faster.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So Elliot Murphy is talking about QuickSearch shortcut for bugs.mysql.com which is quite useful if you use Firefox. However, I&#8217;m using Epiphany (which is based on the same rendering engine, but is a bit more GNOMEy &#8211; and besides, i&#8217;ve &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2005\/08\/03\/fancy-shortcuts-to-mysql-bugs\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/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":[14],"tags":[],"class_list":["post-446","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-7c","jetpack-related-posts":[{"id":973,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/01\/11\/memberdb-speed-improvements\/","url_meta":{"origin":446,"position":0},"title":"MemberDB speed improvements","author":"Stewart Smith","date":"2008-01-11","format":false,"excerpt":"So I finally installed the xdebug PHP extension and started doing some performance analysis of MemberDB using xdebug and kcachegrind. The upshot of which is a number of commits to the bzr tree that dramatically improve performance in several key areas. The answer? Caching. I'm not even talking using memcached\u2026","rel":"","context":"In &quot;linux-aus&quot;","block_context":{"text":"linux-aus","link":"https:\/\/www.flamingspork.com\/blog\/category\/linux-aus\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1161,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/08\/05\/good-adventures-with-opensolaris\/","url_meta":{"origin":446,"position":1},"title":"Good adventures with OpenSolaris","author":"Stewart Smith","date":"2008-08-05","format":false,"excerpt":"First of all, thanks to everyone who commented on my previous OpenSolaris entry (which wasn't really positive at all). I recently tried again - this time starting with an ISO of build 93. I'd recommend completely ignoring the 2008.05 release and going straight for the build 93 image. Installed easily\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":3661,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/02\/03\/past-present-and-future-of-mysql-and-variants-part-1-ghosts-of-mysql-past\/","url_meta":{"origin":446,"position":2},"title":"Past, Present and future of MySQL and variants Part 1: Ghosts of MySQL Past","author":"Stewart Smith","date":"2014-02-03","format":false,"excerpt":"You can watch the video of my linux.conf.au 2014 talk here: http:\/\/mirror.linux.org.au\/linux.conf.au\/2014\/Wednesday\/28-Past_Present_and_future_of_MySQL_and_variants_-_Stewart_Smith.mp4 But let's talk about things in blog form rather than video form :) Back in 1979, there was UNIREG. A text UI to records (rows) in a database (err, table). The reason I mention UNIREG is that it\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":639,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/04\/06\/doxygen-loves-the-ram\/","url_meta":{"origin":446,"position":3},"title":"doxygen loves the RAM","author":"Stewart Smith","date":"2006-04-06","format":false,"excerpt":"Why when running doxygen over the mysql tree (5.0 or 5.1) do I have a process with 590MB of RSS memory? Not exactly inspiring confidence. Although I guess I'm lucky because I have the RAM to do that in (on any box around here I actually use frequently). The output\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":1163,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/08\/06\/firefox-on-opensolaris-fixed\/","url_meta":{"origin":446,"position":4},"title":"Firefox on OpenSolaris fixed (and installed bzr)","author":"Stewart Smith","date":"2008-08-06","format":false,"excerpt":"Thanks to Glynn for pointing me to the right thread on opensolaris.org (in a comment on my Good adventures with OpenSolaris post). The package verification thingy (pkg verify -v -f SUNWfirefox) did actually throw an error (indicating some sort of problem). So that's pretty neat. The fact that it got\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":463,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/09\/04\/memberdb-election-results-performance-on-new-laptop\/","url_meta":{"origin":446,"position":5},"title":"MemberDB election-results performance on new laptop","author":"Stewart Smith","date":"2005-09-04","format":false,"excerpt":"So I picked up my new laptop on friday. It's an ASUS V6V - nice and fast, light, good resolution screen and lots of disk and RAM (it came with 1GB, I've got 2GB). Anyway, the transfer of data from my PowerBook went fine. I waited for xfsdump to dump\u2026","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":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/446","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=446"}],"version-history":[{"count":3,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/446\/revisions"}],"predecessor-version":[{"id":3863,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/446\/revisions\/3863"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}