MySQL Query Analyzer is already helping people to drastically improve their application performance. 

Jeff Freund (CTO, Clickability) shares an interesting use case.

MySQL Query Analyzer is already helping people to drastically improve their application performance. 

Jeff Freund (CTO, Clickability) shares an interesting use case.

Commercial Open Source is a game changer, but it is also a game of balances between different interests: the free user and the paying customer, the individual developer and the partner and the corporate developer, short-term adoption and long-term revenue. There are a number of different business models for OpenSource that attempt to navigate these interests and Sun follows a combination of support, services, hardware/systems drag, and Add-Ons.

Three weeks ago, I started my sporadic series of blog posts where I share my experiences improving my online manners through social networking websites, many of which are powered by MySQL. My first target was the traveller site Dopplr, and the second one was Google’s picture sharing site Picasa Web.

This time, I’m taking a look at Facebook. As I said in the first (Dopplr related) blog post, I feel like a slow follower in the discipline of social networking on the web. And Facebook was a true case in point, where “everybody else” was there before me (my team, my boss, my aunt, my nephew, my goddaughter, countless colleagues; you get the picture).

Actually, …

Augmenting Baron's excellent post about existing monitoring/analysis info available through the enhanced builds by Percona and OurDelta... developing these capabilities further is a matter of what as well as how.

So let's discuss the what: let us know what kind of information you would like to get out of the server, and why. Please be as specific, detailed and descriptive as possible, so we get the best possible overview of your needs. To discuss publicly, simple comment on this post - but you may also contact me directly to discuss if you wish. Thanks for your input!

Last weekend I attended the OpenSQL Camp in Charlottesville, VA. There was a great turnout, and Baron did an excellent job organizing it! I saw a few folks I met at OSCON over the summer, along with meeting many new people. What a great group - intelligent, fun, and know how to get things done. I had some great conversations, especially with Brian, Stewart, Arjen, Patrick, Mark, and Jay. The food was great too, I was a bit worried about …

This is a quick informal poll. I’d like to know how much network traffic your server receives (not sends), in bytes per second. Give both avg and max if you have them. I’m especially interested in hearing about big, heavily loaded systems.

I’ll start things off: just by looking at a couple of [...]

If you went “wtf” at The Drizzle Snowman - WIN! - Jay Pipes on PlanetMySQL suddenly ending at “create table”, you should click through and see the unicode character for a snowman.

In other fun, we’ve also created tables with the name of cloud symbol, umbrella symbol and umbrella with rain drops symbol. All of these seem rather appropriate for Drizzle.

Stewart, Brian and myself are having a little fun this morning. One of the niceties of having real UTF8 support in Drizzle is now we can really fun table names. Behold, the glory of Drizzle:

drizzle>> create table ☃ (a int not null);
Query OK, 0 rows affected (0.01 sec)

drizzle>> show create table ☃\G
*************************** 1. row ***************************
       Table: ☃
Create Table: CREATE TABLE `☃` (
  `a` int NOT NULL
) ENGINE=InnoDB
1 row in set (0.00 sec)

Yep, that's a snowman.

MySQL? Well, not so much:

mysql> select @@character_set_system;
+------------------------+
| @@character_set_system |
+------------------------+
| utf8                   | 
+------------------------+
1 row in set (0.00 sec)

mysql> create table ☃ (a int not null);
ERROR …

OpenSQL Camp 2008 has come and gone, and hooray again for Baron who came up with the idea and made most of it happen (but let’s not forget Sheeri!)  Events such as these are always educational, but the most interesting stuff happens outside of the organised sessions (and this being an un-conf, they weren’t that strictly planned anyway

For me (Arjen) a major chunk of the exercise was acquiring jetlag there and back with no days to spare either side, but I feel it was well worth it. I spent most of the time listening and talking with people rather than coding. It was a great opportunity to catch up with Monty, the Percona crew (Baron, Peter, Vadim, Tom, and more - there’s so many of them now!), Brian, Stewart, Jay, Pat, Eric and other Drizzlers, Sheeri, active OurDelta people like Nick and Rob, ex-Brisbanite Ronald, and of course Jim who …