{"id":1561,"date":"2009-07-16T03:24:59","date_gmt":"2009-07-16T08:24:59","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=1561"},"modified":"2009-07-16T03:24:59","modified_gmt":"2009-07-16T08:24:59","slug":"some-planet-mysql-changes-over-time","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2009\/07\/16\/some-planet-mysql-changes-over-time","title":{"rendered":"Some Planet MySQL changes over time"},"content":{"rendered":"<p>First up: I normally read <a href=\"http:\/\/planet.mysql.com\/\">Planet MySQL<\/a> from an RSS reader. I am assuming you do too. But in the interest of all the new features that the website itself has, I thought I&#8217;d take some time to talk about them in brief (to respect your time). Needless to say, go forth and check out <a href=\"http:\/\/planet.mysql.com\/\">Planet MySQL<\/a> if you&#8217;ve not been there in a while.<\/p>\n<h3>A change in URL<\/h3>\n<p>We used to go to <a href=\"http:\/\/planetmysql.org\/\">http:\/\/planetmysql.org<\/a> but now it redirects to <a href=\"http:\/\/planet.mysql.com\/\">http:\/\/planet.mysql.com\/<\/a>.<\/p>\n<p>Its also worth noting that from a Google PageRank of 8, Planet MySQL has dropped to a PageRank of 6. One wonders why?<\/p>\n<h3>Voting<\/h3>\n<p><a href=\"http:\/\/www.flickr.com\/photos\/byte\/3725491843\/\" title=\"Planet MySQL voting internal by byte, on Flickr\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/farm3.static.flickr.com\/2551\/3725491843_1c8999c721_o.jpg?resize=88%2C29\" width=\"88\" height=\"29\" alt=\"Planet MySQL voting internal\" align=\"left\" hspace=\"3\" vspace=\"3\" data-recalc-dims=\"1\" \/><\/a>Sometimes, Planet MySQL has got totally unrelated posts. They might be press releases that no one likes, or a post like this, which talks about Planet MySQL. Planet MySQL is after all touted as &#8220;Your blogs, news and opinions&#8221;, so I guess this post is in line with that. So unless I&#8217;m blatantly selling sexually enhancing drugs, or talking about thing that are unrelated to MySQL, I don&#8217;t think one should be voting down such a post. Anyway, I digress.<\/p>\n<p>You get 5 votes per 24-hour period. This is to probably prevent gaming the system. And there&#8217;s visual appeal too, to voting. <a href=\"http:\/\/www.flickr.com\/photos\/byte\/3725490631\/\" title=\"Planet MySQL - voting by byte, on Flickr\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/farm4.static.flickr.com\/3530\/3725490631_0a22677ac5_o.jpg?resize=90%2C28\" width=\"90\" height=\"28\" alt=\"Planet MySQL - voting\" align=\"right\" hspace=\"3\" vspace=\"3\" data-recalc-dims=\"1\"\/><\/a><\/p>\n<p>Anyway, you can see the top voted (last week), and top voted (last month), on the left hand column of planet now. So if you want something to be located prominently, start getting your friends to &#8220;digg&#8221; the site ;)<\/p>\n<h3>Searching<\/h3>\n<p><a href=\"http:\/\/www.flickr.com\/photos\/byte\/3725501963\/\" title=\"searching by byte, on Flickr\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/farm3.static.flickr.com\/2603\/3725501963_d2e2455b48_o.jpg?resize=162%2C134\" width=\"162\" height=\"134\" alt=\"searching\" align=\"right\" hspace=\"5\" vspace=\"5\" data-recalc-dims=\"1\" \/><\/a><br \/>\nA feature that is not talked about often enough&#8230; Everytime the planet crawls your site (:20 minutes off the hour, if I remember correctly), it slurps the entire page. Sure, it displays it as an excerpt (so we don&#8217;t take away Google juices from you), but we do keep a massive <a href=\"http:\/\/planet.mysql.com\/archives\/\">archive<\/a> of all planet postings&#8230; So even if your blog goes away from the Internet, it will always live on in the archives.<\/p>\n<p>Its worth noting its searchable! So maybe you read something that&#8217;s interesting two years ago, but have no idea what its about. You can search, even by tags. Wow! I think this could be a pretty useful feature, if using Google itself, has failed you&#8230;<\/p>\n<h3>Tags<\/h3>\n<p>In WordPress, there are options for &#8220;tags&#8221; and &#8220;categories&#8221;. Tags only came around relatively recently, it was always categories previously. Now, SimplePie reads those tags when it slurps the entire page, and it gets displayed. When logged in, you can even edit the tags. I tried this, but it didn&#8217;t seem to quite work yet, even when logged in. Maybe I just found a bug, let me report it&#8230;<\/p>\n<h3>Buzz<\/h3>\n<p>Have you seen <a href=\"http:\/\/planet.mysql.com\/buzz\">MySQL Buzz<\/a>? Its a dashboard, showing you where people talk about MySQL in its entirety &#8211; voted entries, forums, Google love, and those fabulous word frequency clouds!<\/p>\n<p>Today, I noticed that on Planet, we&#8217;ve seen famous words like: data, database, time, server, innodb, chrome, table, performance. In the Forums, its quite different: string, long, table, null, insert, code. Ha!<\/p>\n<h3>Anything else?<\/h3>\n<p>Go forth and vote for this post, if you&#8217;ve read this far. Next time, I&#8217;ll talk about the <a href=\"http:\/\/dev.mysql.com\/librarian\/\">Librarian<\/a> after I&#8217;ve tried it out. A post like this would never make it there (since this is very community focused), but think of it like a <b>knowledge base\/bank<\/b> and it can be rather powerful.<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20Some%20Planet%20MySQL%20changes%20over%20time&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2009%2F07%2F16%2Fsome-planet-mysql-changes-over-time&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"fc628b6b75\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/07\/16\/some-planet-mysql-changes-over-time?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1561\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/07\/16\/some-planet-mysql-changes-over-time?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1561\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/07\/16\/some-planet-mysql-changes-over-time?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1561\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/07\/16\/some-planet-mysql-changes-over-time?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>First up: I normally read Planet MySQL from an RSS reader. I am assuming you do too. But in the interest of all the new features that the website itself has, I thought I&#8217;d take some time to talk about them in brief (to respect your time). Needless to say, go forth and check out [&hellip;]<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20Some%20Planet%20MySQL%20changes%20over%20time&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2009%2F07%2F16%2Fsome-planet-mysql-changes-over-time&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"fc628b6b75\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/07\/16\/some-planet-mysql-changes-over-time?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1561\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/07\/16\/some-planet-mysql-changes-over-time?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1561\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/07\/16\/some-planet-mysql-changes-over-time?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1561\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2009\/07\/16\/some-planet-mysql-changes-over-time?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[23],"tags":[988],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-pb","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":604,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/08\/06\/planet-mysql-on-twitter","url_meta":{"origin":1561,"position":0},"title":"Planet MySQL on Twitter","date":"6\/8\/2007","format":false,"excerpt":"While it would seem that using Mugshot is for core Linux geeks (it runs on Windows too, you know), I've not seen much adoption of the MySQL Mugshot Group, that was announced back in February. I've always enjoyed getting the Mugshot client running on my desktop informing me of new\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":783,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/keeping-track-of-all-the-web-resources-at-the-mysql-conference","url_meta":{"origin":1561,"position":1},"title":"Keeping track of all the web resources at the MySQL Conference","date":"14\/4\/2008","format":false,"excerpt":"During this week, expect there to be a flood of posts on Planet MySQL. If you're using an offline RSS reader, you might not even get all the RSS feeds (might I suggest something like Google Reader?). If you want to be informed as and when something hits Planet MySQL\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1706,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2010\/03\/03\/mysql-ecosystem-complementary-talks-at-the-conference","url_meta":{"origin":1561,"position":2},"title":"MySQL Ecosystem &#8211; complementary talks at the conference?","date":"3\/3\/2010","format":false,"excerpt":"Its times like this, I want to hear from the greater community - the ones that are reading say, Planet MySQL or Planet MariaDB. MySQL to me, and many others is an ecosystem. We've had for the longest time, complementary technology talks, like for memcached (which have been popular, filled\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":422,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2006\/08\/09\/community-contributed-documentation-tamil-sees-some","url_meta":{"origin":1561,"position":3},"title":"Community Contributed Documentation &#8211; Tamil sees some","date":"9\/8\/2006","format":false,"excerpt":"Open source projects have a lot of documentation. Some professionally written, others community contributed. One thing that community contributed documentation has going for it is the passionate users that write localized content. Localization of documentation is important. While we take it for granted that we all speak\/read\/write\/understand the English language,\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":375,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2006\/03\/05\/mysql-51-ipod-nano-giveaway-winner-1","url_meta":{"origin":1561,"position":4},"title":"MySQL 5.1 iPod Nano giveaway, winner #1","date":"5\/3\/2006","format":false,"excerpt":"Congratulations to Giuseppe Maxia, who's won himself an iPod Nano! Giuseppe has been actively submitting bug reports for MySQL 5.1, plus he's got an interesting blog (syndicated at Planet MySQL), mentioning new features that are available in MySQL 5.1. Of interest, is your performance related post on Partitioning. To add\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":705,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/01\/28\/mysql-miniconf-starts","url_meta":{"origin":1561,"position":5},"title":"MySQL Miniconf Starts!","date":"28\/1\/2008","format":false,"excerpt":"Arjen and Stewart are on stage, and there's an introduction session going on now. We're now, introducing the ex-MySQLers (Arjen), and MySQLers (Stewart, Giuseppe, me). Trent has just walked in, so that makes all the MySQLers that are around at linux.conf.au.Highlights of some of the attendees:A user from LG, who\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1561"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=1561"}],"version-history":[{"count":1,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1561\/revisions"}],"predecessor-version":[{"id":1562,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1561\/revisions\/1562"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=1561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=1561"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=1561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}