It's going to be good, just look at the schedule! If you're not signed up yet, why? Just ask yourself that. And if you don't have a very good reason, just register and go meet lots of other MySQL users as well as many of my colleagues. It's educational (which means you can make your boss pay for it), it's fun, and yes it can even be a tad geeky if you want.

I won't be there myself this year (oh hail the absence of jetlag), but don't let that deter you in any way. Jay Pipes has been doing a great job organising this year's program.

For instance... it's fantastic that Eben Mogen is doing a keynote. Last year someone from EFF already did a talk on "what not to put in your database schema, and why" which was admittedly an obscure title, but it covered the content nicely. It's important stuff. Eben will explain all. You want to be there.
…

Inside of MySQL we do a "MySQL University" which is basically a "someone shows up and talks on a topic".

Tomorrow at 8AM PST I am going to do one on the general plugin architecture. I am told that these will eventually be put up as podcasts (and if I get a chance I will just record mine tomorrow on my own).

The slides for the talk can be found here:

http://krow.net/talks/plugins.pdf

It is a punch of pointers into the code that I will be explaining. Have fun with the slides :)

Open Solutions Alliance announces board. ITerating launches wiki software guide. EnterpriseDB shares Q1 successes. (and more)

Open Solutions Alliance Gets Down to Business - Publishes Interoperability Roadmap, Announces First Major Project and Board of Directors, Open Solutions Alliance (Press Release)

Announcing ITerating.com, The First Wiki-Based Guide to Commercial, Open Source and Hosted Software, ITerating (Press Release)

EnterpriseDB Posts Record First Quarter Results, Rounds Out Executive Team, EnterpriseDB (Press Release)

Canonical Ltd. Joins the GNOME Foundation?s Advisory …

I’ve come into a situation where I require to have BBCode parsed, this includes the standard tags supported by PEAR package HTML_BBCodeParser and custom BBCode tags I’ve added myself.

My problem is this, I’ve discovered that when an value has a space within the value the value is truncated at the first occurrence of the space. This applies to a URL, image file names and any additional attribute values (alt, style, etc.). This issue is present in the stable release and latest release in CVS for HTML_BBCodeParser. Here is some examples.

Before BBCode Parser
   [url=http://www.somedomain.com/Foo World?str=1]Foo World
After BBCode Parser
   <a …

The Users Conference and Expo is approaching fast. As a last minute assignment, I will be speaking about Stored routines for MySQL administration. The session will cover the basics of stored routines and their specifics for administration.

Some words in advance...

Recently I wrote about multi-threading problems with java.util.Calendar and java.text.DateFormat. The last sentence was So maybe it is time to search your code for all static usages of the Calendar and various ...Format classes, before you start getting strange errors.

Searching code is not very practical, especially if you do it manually. Everyone knows you can look at code for hours, without seeing an problem - and as soon as it has reached production systems it starts breaking up in various ways :-)

Fortunately smart and reknown people have devised ways of making the computer look for bugs automatically. Amongst others, …

Some words in advance...

Recently I wrote about multi-threading problems with java.util.Calendar and java.text.DateFormat. The last sentence was So maybe it is time to search your code for all static usages of the Calendar and various ...Format classes, before you start getting strange errors.

Searching code is not very practical, especially if you do it manually. Everyone knows you can look at code for hours, without seeing an problem - and as soon as it has reached production systems it starts breaking up in various ways :-)

Fortunately smart and reknown people have devised ways of making the computer look for bugs automatically. Amongst others, …

Wow!

[brian@zim memcache_engine]$ ~/tangent/bbench/network_run.sh
/home/brian/mysql-builds/example/bin/mysqlslap: Cannot run query INSERT INTO t1 VALUES (uuid(),1233983202,789373855,'jdtPbBILRQyiu7nZN3RdI96aQOP4Y0z7dlO4wbQF1OpvYdLnggGrqMP8mjCAjB9CwQHk1jruzhhXA2BibRZPqrPSQdX9gYDTyWDr5xdxWJSgDXEozg5hNW1pzYqgx3','9nQEfN38KZRh5hCCL3sRkFpm4pAuL7pWvFcQXgar52O3bdFwY7FHE53ImD47LtT81xaYT8Fb2YWd1lQZshqyelGOzCNCxsCyimMBmWep28IvlkSTIJRw4bDvnczlLB','bvpq6cCdH6db1NCTsWgKIdvXOb0OKDRn8HdEthjAnLdochAS3qgMJclk3d0FqR2ykY5dDof119pdqz6mie816ld9NdO55R4pr9J4pq5rrnSieQSK5SEB5rLKTlQQ4M') ERROR : Can't write; duplicate key in table 't1'

That should not be possible. I actually hit a duplicate key while using uuid() as the primary key.

Freaky weird...

So what does this mean?

It means I have found a bug... because that is a hell of a lot more likely...

Our next version of Connector/Net will include support for Compact Framework 2.0.  One thing that's been challenging is how to test our provider in this environment.  We have a NUnit test suite that we use with the normal provider but so far I haven't found any good way to run it under the compact framework.  I know about CFNUnitBridge but I needed something that could also work with compact framework 1.0.

So, I decided to write my own.  After two days of hacking I now have an application that does just what I want.  It loads my test suite and implements all the NUnit framework junk that I use.  I gave it a reasonable UI similar to what is seen in NUnit's GUI runner.  You can select a single test to run and have it run all the tests.  It also keeps track of exception messages and stack traces per test failure.  Here's a shot of …

There are various tools available for gathering and monitoring mysql performance data, but it’s not always clear what they mean, what is important, and what can be tuned. I’m not going to try to post a comprehensive mysql tuning manual here. This post is about taking a snapshot profile of a mysql instance that will allow you to define what type of instance you are dealing with, and give you some idea about whether the current configurations are stable or not.

I’ll be using a script that I’ve designed for daily reporting on the mysql instances that we monitor. This script will be available in a follow-up post, but for now, you can see the output of the report itself and a break-down of the more important sections.

To start with, let’s look at an example report:
Sample Report 1

Global engine stats: 13 [InnoDB] 183 …