MySQL

The world's most popular open source database

Contact a MySQL Representative


  • MySQL.com
  • Developer Zone
  • Partners & Solutions
  • Customer Login
  • DevZone
  • Downloads
  • Documentation
  • Articles
  • Forums
  • Bugs
  • Forge
  • Blogs
 
  • Pages

    • About me
    • Bio
    • Press Release: “Kaj Arnö Appointed MySQL VP of Community Relations”
  • Blogroll

    • Ein Finnlandschwede in Bayern
    • En finlandssvensk i Bayern
    • It’s some interesting topic
    • Kaj Arnö blog aggregation
    • No Software Patents!
    • Planet MySQL
  • Recent Posts

    • Berlin Open 09: Social Networking
    • Search the planetary archives, and tag your blog entries
    • SELECTing SELECT statements for Wordpress MU blogging statistics
    • How do MySQL users keep track of digital pictures?
    • Presenting and blogging in Chinese
    • On the Merits of Voting
    • The Future of MySQL
    • The Great Open Cloud Shootout: Videos and other links
    • Karen’s Commitments to the MySQL Community
    • What hasn’t changed with MySQL
    • Andy Bechtolsheim to Keynote MySQL Conference on Thursday
    • The Great Open Cloud Shootout
    • MySQL Campus Tour 2009 — aka Dups on Rails
    • MySQL & Google Summer of Code 2009 — time to get going!
    • Your chance to thank Monty at his farewell dinner tomorrow Friday
  • Tags

    Alexander Arnö Black Swan Blogging Blogs Brazil Business Model Call for Papers Call for Participation CfP Community Contributions David Axmark Dups Event scheduler Football FOSDEM Growth Innovation Ivan Nikitin Language Launch Mårten Mickos Michael "Monty" Widenius Mountains MySQL MySQL 5.1 MySQL AB MySQL Forge MySQL User Conference MySQL Users Conference Nassim Nicholas Taleb Open Source Oracle Paris Partitioning Photography Social Networking South Africa Sun Microsystems Sun Tech Days Thank you Travel Use case Web 2.0 Wordpress
  • Archives



  • Categories

    • Architecture of Participation
    • Connectors
    • Documentation
    • Events
    • Falcon
    • GPL
    • GUI
    • Licensing
    • MySQL
    • MySQL Cluster
    • MySQL Proxy
    • MySQL Server
    • MySQL Users Conferences
    • MySQL Workbench
    • Photography
    • PHP
    • Release Policy
    • Ruby on Rails
    • Running
    • Summer of Code
    • Sun
    • Sun visits
    • Travel
    • Use cases
    • Virtual company
  • Calendar

    July 2009
    M T W T F S S
    « Jun    
     12345
    6789101112
    13141516171819
    20212223242526
    2728293031  
Observations by Kaj Arnö @Sun

Berlin Open 09: Social Networking

June 24th, 2009

Yesterday, I was invited to hold a presentation at the Berlin Open ‘09 Open Source event. This was related to earlier activities, such as the Open Source Yearbook published by professor Berndt Lutterbeck of the Technical University of Berlin. Professor Lutterbeck was also the main organiser behind Berlin Open.

After some, ehh, logistic challenges (a scenic detour over Alexandersplatz), I got to the Marshall House at Messe Berlin and met with the hosts. A well organised event, with lots of twitterings under http://twitter.com/berlinopen, and plenty of good presentations.

My presentation was on the architectures of social networking using MySQL and myself as examples. I started by making some of my favourite points:

  1. Easy wins (by walk-over) are still available for those who mirror their goals and activities into Web 2.0
  2. This goes for companies, Open Source projects, developers, researchers, investors, anyone
  3. The risk of a disadvantageous Internet presence isn’t mitigated by absence (as the description is then left to others, with their own interests and disinterests)
  4. Too much theory at the beginning of such a new phenomenon (as Web 2.0) isn’t beneficial, as it scares us away from Just Doing It — but a too unsystematic approach isn’t good either (so go maintain a decent profile on  Facebook, LinkedIn, Twitter, Slideshare & Co)

I have uploaded the 60-slide presentation (which is partly in German) onto my Slideshare account, which you can access through http://kaj.arno.fi/slideshare. This specific presentation is available at http://www.slideshare.net/kajarno/berlin-open-09-architekturen-sozialer-netzwerke-fallbeispiel-mysql and through clicking on the below picture.

Posted in MySQL | No Comments »

Search the planetary archives, and tag your blog entries

June 9th, 2009

A particular blog entry usually feels relevant and topical when fresh, at least to the author. So let’s say a blog entry even carries some non-zero long-term value. How do you find it after a while? And more importantly, how will your readers find your blog entry?

Descriptive subjects go a long way. But your readers may be searching for “development model” when your header says “release plan”. And even if you anticipate the search words used by your readers, you can only pick one wording for your header.

Full-text search also helps. There’s now a brand new Search field in the top left corner of Planet MySQL. Chances are you’ll find what you look for, no matter if search for “Chinese”, “DRBD”, “development” or “PHP”. You may even search for several words, such as “Chinese, UTF”.

Easy searchability calls for yet a bit more, namely tagging. Tags are a great way for the author (or for the reader!) to underline key aspects of a blog post (or Flickr picture or Slideshare presentation or any item you post on the Web, of course).

And next to searching, tagging is the second area where PlanetMySQL has lately been improved, by Dups, as announced in his blog entry last week.

Four key points:

  1. Tags are displayed under the blog header. We import the tags originally written by the blogger.
  2. When you click on the tags, you’ll find blog posts with that tag across individual blogs. Example: http://planet.mysql.com/?tag_search=169 has all PHP tagged posts, on any blog aggregated to Planet MySQL.
  3. You can also search for (multiple) tags in the search field. Example: “Tag: PHP, development”.
  4. The community may edit tags (when logged in to MySQL.com). The wisdom of individual community members can thus be shared by others.

For more, go read Dups’s blog!

P.S. UPDATE: I got a question on what the numbers in the picture are. They’re “numeric tags” in the Firefox browser, as appearing with the “Mouseless Browsing” add-on. They enable me to “click” on links from the keyboard without moving my hand to the mouse.

Posted in MySQL | No Comments »

SELECTing SELECT statements for Wordpress MU blogging statistics

May 14th, 2009

Sometimes I miss the coding I did last century. Today I was reminded of some of the fun, when I had set my mind to doing some statistics on my blogging.

In a blog entry on http://blogs.arno.fi/isit/2009/05/14/home-made-blog-statistics-from-wordpress-mu/ I describe what I did.

The blog entry may be of interest for those who use WordPress and are set back by the huge amounts of tables it generates. I happen to host 18 blogs and with each blog requiring 8 tables, that’s a total of 144 tables. Add the 9 top-level blogs and I’ve got 153 tables to navigate.

The blog entry I wrote 

  • identifies the key fields
  • shows how to do stats on individual blogs
  • creates a statistics table into which I aggregate relevant entries from individual blog tables
  • uses SELECT to generate SELECT statements
  • and ends up with some statistics on the 253 blog entries in my WordPress.

I also studied the wp_n_comments tables, and came to the conclusion that I’ll need to use some global DELETEs to clean up spam comments that have found their way to my site.

I found out that, strangely enough, I haven’t approved a single comment that includes the character string “viagra”

select comment_approved,count(*)
 from wp_4_comments
 where comment_content like "%viagra%"
 group by comment_approved;

The same applies to “cialis“.

So I issued

delete from wp_4_comments 
 where comment_content like "%cialis%";
delete from wp_4_comments
 where comment_content like "%viagra%";

but I still have quite a bit of cleaning up to do, since despite deleting first 759 cialis entries and then 411 viagra entries, I still have 3683 unapproved comments to clean up (and I suspect there are less than 10 real comments that have slipped my attention in my inbox, when I’ve got notification of them).

At any rate, I got my statistics and had more efficient and fun (albeit incomplete) spam cleaning than ever before!

Posted in MySQL | No Comments »

How do MySQL users keep track of digital pictures?

May 12th, 2009

On my non-MySQL blog, I just wrote a blog post called “Photo Manager: How do you keep track of your pictures?“. I’m looking for Open Source Software that helps me keep track of my 100,000+ digital pictures. I wrote specs on dreamt-up software called “Robfat” (for rename, order, backup, find, archive, tag) as I want to remove excess fat from my HDs (and CD/DVD cabinets).

And then I thought this may have a MySQL dimension:

What if we had an “EXIF Storage Engine”? What if we could update EXIF tags directly from the MySQL command line, with UPDATE statements, and SELECT picture file names based on tags and other file characteristics?

But beyond this technical aspect, I think many, many MySQL users are avid photographers and may have input about the specs themselves, or even know of existing software that satisfied the needs.

So please go to the blog post and comment!

Posted in MySQL, Photography, Use cases | No Comments »

Presenting and blogging in Chinese

May 6th, 2009

Travelling to Hongkong and Taipei has made such an impression on me, that I couldn’t help but add two new blogs to my homepage kaj.arno.fi:

  • http://blogs.arno.fi/guanxi/ is (or pretends to be) in Simplified Chinese, written on the Chinese mainland
  • http://blogs.arno.fi/yilingyi/ is (or pretends to be) in Traditional Chinese, written here in Taiwan

Guanxi means “relations”, as in “Community Relations”. It’s also a very common word describing how to get things done in China. It even has its own English language Wikipedia entry.

Yi-ling-yi means one-oh-one, as in Taipei 101. This number sequence also means “special” in Chinese. Taipei 101 is the world’s highest completed skyscraper. Needless to say, that merits another Wikipedia entry, not to mention a blog entry in Traditional Chinese.

Tomorrow, I’ll make another attempt at giving a short MySQL speech in Mandarin. Well, technically speaking, it’s already today, as it’s 3:30am in Taipei. My internal clock has gone awry.

Posted in MySQL, Sun, Sun visits, Travel | No Comments »

On the Merits of Voting

April 28th, 2009

Just before the MySQL User Conference, Dups implemented a small little feature for Planet MySQL: “voting”. We wanted to see what a voting system might mean to you, our PlanetMySQL readers.

The question is now how to improve the voting mechanism to make it more useful. The goal is for everyone to see what you and your peers think are the best PlanetMySQL entries over a given week.

Here are some of the options:

1. Open up voting to everyone regardless of whether they are logged in or not. Currently you can only vote if you are logged in with a MySQL.com account. Let’s face it, a login gives a barrier to entry even as much as it gives us the security of knowing we won’t get spammed.

One option is to allow all to vote, within the constraints of spam control of some kind. Another option is to have voting for non-logged in users to count, but count less than those who login. This gives voters the incentive to login and magnify their voice, but allows anyone to have a vote if they choose not to login. An example would be to have a logged in vote worth 1 and a non-logged in vote worth 0.1

The problem, of course, is that we would be setting an artificial “quality” judgement on your vote.

2. We add voting links into the RSS Feed itself, so you can tell the world what you think of blog posts from within your RSS reader. We could also automate a posting of the Top voted entries on PlanetMySQL at the end of each week in case you decide not to come to the web site at all (though we hope you do come by once in a while).

3. We leave it as is!

Now it’s your turn to tell us what you think! Remember the intent of all this is for good posts to not just disappear as the feeds scroll by with ever more content.

We’ve also been asked whether there is any conspiracy to throw posts up and down by us manipulating votes. Let me answer categorically: No. We do not manipulate the votes in any way. What you vote is what you see.

Posted in Architecture of Participation, MySQL | 3 Comments »

The Future of MySQL

April 26th, 2009

What is the future of MySQL? This is a question that interests many.

To be specific: Will there be significant performance improvements? Code contributions? Bug fixes? New features? Open Source licensed documentation? Will the users be happy with the Monthly Rapid Updates now released for the MySQL Community Server?

On another, more competitive level: Will there be successful forks? What will the MySQL AB founders do? What is Percona’s next move?

Julian Cash, known for his visionary photography, extended his scope during a Wednesday session at the MySQL Conference. Hard work during his predictive session gave me insight. I now know the answers.

However, I’m afraid I cannot share the revelations on this blog. What I can do, though, is to point to Julian Cash’s site “The Human Creativity Project”, and to the visible results of his other sessions on Wednesday.

Thank you Julian!

Links:

  • The Human Creativity Project: http://www.humancreativity.com/
  • Julian Cash’s visionary sessions on Wednesday at the MySQL Conference: http://www.flickr.com/photos/juliancash/sets/72157617184626249

Posted in MySQL, MySQL Users Conferences, Photography | 2 Comments »

The Great Open Cloud Shootout: Videos and other links

April 23rd, 2009

Today’s Great Open Cloud Shootout was great fun — at least for me! I had the pleasure to tease these distinguished gentlemen with cloudy questions:

  • Lew Tucker, Cloud CTO, Sun Microsystems
  • Monty Taylor, MySQL Drizzle Geek, Sun Microsystems
  • Jeremy Zawodny, MySQL hacker, craigslist
  • Chander Kant, CEO, Zmanda
  • Thorsten von Eicken, CTO, RightScale
  • Prashant Malik, Cassandra Dude, Facebook
  • Mike Culver, Evangelist, Amazon Web Services

I tried to provoke the panelists with questions around some areas I had thought out:
  • So, what is a cloud anyway?
  • Who is the cloud for?
  • Why use the cloud?
  • Cloud adoption barriers
  • Are there cloud standards?
  • Cloud Business Opportunities
  • Cloud Competition
  • Databases & Clouds
UPDATE: Here is a list of web resources on the shootout:
  • Zack Urlocker’s blog on Infoworld: http://www.infoworld.com/d/open-source/cloud-panel-mysql-conference-840
  • Zack Urlocker’s YouTube-video (8:31): http://www.youtube.com/watch?v=eHHJaqON6Ow
  • Full video on blip.tv: http://mysqlconf.blip.tv/file/2026246/
  • Full video by O’Reilly Media on YouTube: http://www.youtube.com/watch?v=R2xsQV72pSo
  • Duncan Davidson’s pictuers on Photoshelter: http://pa.photoshelter.com/c/duncandavidson/gallery-img-show/MySQL-Conference-Expo-2009/….
  • Arun Gupta’s blog: http://weblogs.java.net/blog/arungupta/archive/2009/04/mysql_users_con_2.html
  • Original plan in the schedule / conference program: http://www.mysqlconf.com/mysql2009/public/schedule/detail/8871
  • The Great Open Cloud Shootout on Flickr http://www.flickr.com/photos/x180/3465814071/
  • Slides on SlideShare: http://www.slideshare.net/kajarno/the-great-open-cloud-shootout-1343906
  • Twitter comments on #mysqlconf and #cloud: http://search.twitter.com/search?q=%23mysqlconf+%23cloud

Judging from the nods and agreements between the panelists, the term “shootout” may have been a tad more aggressive than necessary to describe the discussion. But that didn’t seem to disturb twitterers. I’m very glad to have got positive Twitter comments such as
  • andygrove73: Excellent cloud shootout at the MySQL conference. Would have liked to hear discussion about sharding on the #cloud though.
  • imsplitbit: RT @LenzGr: Great #cloud discussion at #mysqlconf, @sheeri is next. I agree, that was the best shootout I have been to.
  • imsplitbit: If you are at #mysqlconf and are not at the Cloud Panel discussion you are missing out! Not to mention LAME! #cloud
  • LenzGr: “Cloud not suitable for money laundry” (Monty Tailor in the #cloud shootout at #mysqlconf)
  • sheeri: RT @LenzGr: Love the pictures in Kaj’s slide deck of the #cloud panel discussion #mysqlconf 
I’m grateful to Steve Curry for coming up with the idea to this keynote. Thank you! 
I also wanto to extend a big Thank you to all our panelists, and to the audience — I hope you had as fun as I did!
Here are some more of Zack Urlocker’s pictures (the first picture on top, in the rain-protective hat, is by Duncan Davidson): 

Posted in MySQL, MySQL Users Conferences | 3 Comments »

Karen’s Commitments to the MySQL Community

April 21st, 2009

A new start always provides an opportunity to reassess your way of doing things:

  • “Am I doing the right things with my life?”
  • “Which habits could I change — in order to be a better neighbour?” 

Since Karen Tegan Padir took over the MySQL product from Mårten Mickos, we at Sun have taken a thorough look in the mirror.  The result of this introspection allows us to publish our conclusions and new community commitments this week in conjunction with the MySQL Conference & Expo in Santa Clara. 

For those who don’t yet know Karen, let me state a few facts: 

  • Karen is VP of Sun’s newly-founded MySQL & Software Infrastructure group
  • She describes herself as a geek and a straight-shooter, and I can attest to both 
  • She was deeply involved in Sun’s decision to acquire MySQL, as well as the subsequent integration work throughout 2008 

Karen Tegan PadirIn my previous blog, ”MySQL Culture and Business Philosophy Goes Mainstream at Sun“, I stressed that the key point to remember is that Sun is completely committed to building a big open source-based business, and very much supportive of the various communities that Sun is engaged in. That may sound a bit abstract, so I have worked with my new boss, Karen, to spell out for the MySQL community what it actually means in practice: 

First: We shall now start releasing MySQL Community Server binaries as frequently as we release the MySQL Enterprise Server. We want everyone – community and customers — to get the best bits first from us. This is why future Monthly Rapid Updates of MySQL 5.1 will remain available for the community. Moreover, future MRUs of MySQL 5.0 will also become available for the community. 

Second: We shall focus even more on our traditional core product values of stability, Performance and Ease of Use. Like you, we hate bugs, we hate slow, we hate waiting for fixes, and we hate awkward usability — even more than we love new functionality. The MySQL 5.4 performance release, which is considerably faster than MySQL 5.0 or 5.1 in most use cases, is a case in point.

Third: We shall allocate additional resources to the health and well-being of the MySQL Community. We focus both on users and developers. We shall now devote a greater portion of our internal MySQL Engineering Team resources to reviewing and eventually merging architecturally-compatible features written by external contributors, even if those features weren’t on our own roadmap.

Finally, fourth: We shall do more to improve our internal software engineering practices. We will brush our teeth every morning and evening, exercise several times a week, and eat (mostly) healthy food. Some of us may at times still take a vodka shot, but if so, then only to be social and to provide an excuse for singing badly, but not while writing code. 

In the spirit of open-ness, please give us ideas on how we can implement these changes. Let the MySQL community team know what you think. For those at the show this week, stop Karen in the halls and introduce yourself. Above all, enjoy!

Posted in Architecture of Participation, MySQL, MySQL Server, Sun | 4 Comments »

What hasn’t changed with MySQL

April 21st, 2009

Jetlagged from transatlantic travel, I woke up in the middle of the Californian night thinking about what has changed since I arrived at the MySQL Conference in Santa Clara on Sunday evening. I was pondering all the questions MySQL users and Sun colleagues were asking at the event, and what the user base was thinking out loud on Twitter yesterday.

What has changed is obviously that Sun Microsystems and Oracle announced they have entered into a definitive agreement under which Oracle will acquire Sun.

What further changes we will see as a result of that is a different story. Evidently, I don’t sit in with a crystal ball predicting what will happen next. Nor do I have insight into Oracle’s plans for MySQL, once the deal is closed. Nor am I even in a position to comment upon the acquisition, so I won’t do it.

However, what I do know and what I can say is what has not changed with MySQL:

  1. There still is a huge base of MySQL users out there. They have economic interests that are independent of whoever owns MySQL. The users in the MySQL community come in all flavors, ranging from casual users to those who intimately know the inner workings of MySQL and have contributed to the code base.
  2. There still is a huge talent pool of MySQL experts in Sun Microsystems, in Support, in Consulting, in Training, in Engineering, in other parts of Sun. They have a strong loyalty towards the MySQL users they have served over many years.
  3. MySQL is still licensed under the GPL. The GPL license used to form a safety net for the users not certain about whether MySQL AB would follow the spirit of Open Source. It continued to be so with Sun Microsystems. And the Open Source license continues to provide a safety net for its user base, regardless of the owner of MySQL.
  4. MySQL has founders, one in particular, who still haven’t fallen off the face of the planet. Moreover, their passion for MySQL and its users continues.
  5. Sun Microsystems still is a separate legal entity, practising what’s known as “business as usual“. This is familiar to MySQLers from the time between Sun’s acquisition of MySQL was announced mid-January 2008 to the closing at the end of February 2008. During the period between announcement and closing, we continue to behave as separate entities, even competing with each other.
  6. Part of Business as Usual is a number of product announcements at the MySQL Conference this week. I’m looking forward to these!

While I cannot and will not personally speculate about what happens next, nor about Oracle’s intentions with MySQL, I think our users are looking to what the names most inimately associated with MySQL are saying — even if they no longer work for Sun Microsystems:

  • First, Mårten Mickos, MySQL AB’s former CEO and long-time SVP at Sun, has several positive comments in his Forbes interview “Why Oracle Won’t Kill MySQL”.
  • Second, Michael “Monty” Widenius, MySQL AB’s co-founder, also finds many positive things to say in his blog statement “To be (free) or not to be (free)“.

My humble suggestions: Keep using MySQL! Follow the announcements from the MySQL Conference this week! Keep helping each other within the MySQL community!

Go MySQL!

Posted in Architecture of Participation, Events, GPL, Licensing, MySQL, MySQL Users Conferences, Sun | 3 Comments »

« Previous Entries

Observations by Kaj Arnö @Sun is proudly powered by WordPress MU running on Blogs.mysql.com.
Entries (RSS) and Comments (RSS).