Woohoo, I finally got a bit of spare time to blog — my first blog post ever! I chose to talk about a technique I used at a client’s site to report the topmost space-wasting objects in an Oracle database. I was looking for a way to detect these objects without having to run some expensive [...]

Microsoft recently announced that they are removing the Entity Framework and tools from Visual Studio "Orcas" and will, instead, ship them as an update in the first half of 2008.  It's pretty easy to see this as YAMM (Yet Another Microsoft Miss) but I instead look at this as a very positive sign of things changing.

Microsoft is accelerating many of the development timelines and embracing the "release early, release often" methodology.  It seems that almost every Microsoft product these days comes out as a CTP about a million times even before it his beta stage.  This just means greater awareness and better adoption.  MS is even releasing alot more code as open source as they recently announced a Dynamic Language Runtime (DLR) that supports languages such as Python and Ruby.  They are releasing it under …

We now have Developer support for Cool Stack (or Solaris + AMP).  This dedicated online support service for developers provides technical
assistance for code support, diagnostic advice, and programming
questions that may include:

• Sanity Checks
• Code level support
• Best practice guidance
• Workarounds when available
• And other forms of technical assistance

Sun Developer Expert Assistance Service is available to all developers,
with a cost of $49 (USD) per request or unlimited requests for an
annual subscription cost of $249 (USD).

Check out the details at http://developers.sun.com/services/expertassistance/

  …

For years Slashdot trolls would just complain that MySQL was nothing more then an interface to the filesystem.

So what does someone go off and do?

Create exactly that.

http://code.google.com/p/mysql-filesystem-engine/

The engine was written by Google's Chip Turner and can process any file that the database has access too (though exactly how the parsing works I am unsure about, I've only read the code related to the actual engine). The example given is this:

mysql> CREATE TABLE LoadAverage (
load1 DECIMAL(3, 2),
load5 DECIMAL(3, 2),
load15 DECIMAL(3, 2),
active_processes VARCHAR(12),
lastpid INTEGER) ENGINE=FILESYSTEM connection="file:///proc/loadavg";
Query OK, 0 rows affected (0.00 sec)

mysql> select * from LoadAverage;
…

The conference is over, and it was a great week but pretty exhausting! From what I saw, and from what I have heard the sessions were of a very high standard this year. I have come back with a number of new ideas and quite a few things I would like to implement in PBXT. One of these is new online backup API for MySQL which will enable you to make a snapshot backup of data stored by all engines, and do point in time recovery.

For me the week started off with the BoF on scalable BLOB streaming on Tuesday evening. The BoF was well attended and there was significant interest in the topic. I will be reporting on some of the issues discussed soon.

On Wednesday morning I presented: PrimeBase XT - Design and Implementation of a Transactional Storage Engine. I was pleased with the number …

Just a quick note to let everyone know that the new MySQL 6.0 alpha is now available for download. At last week’s MySQL User’s Conference, all the Falcon sessions were packed so there is definitely a lot of interest about our new transactional storage engine. Do note the version number change - previous alpha’s were labeled 5.2, but we’ve now made the decision to move to 6.0 for the Falcon release of the MySQL Server.

The latest alpha contains bug fixes, performance improvements, and the first cut of the new diagnostic/performance views (contained inside the INFORMATION_SCHEMA database) that helps DBA’s get insight into how well Falcon is performing and the resources it’s using:

mysql> show tables like 'FAL%';
+-------------------------------------+
| Tables_in_information_schema (FAL%) |
+-------------------------------------+
| FALCON_RECORD_CACHE_SUMMARY         |
| FALCON_SYSTEM_MEMORY_DETAIL         |
| …

Always remember, if you’re using MyIsam tables, KEEP THE INDEX AS SMALL AS POSSIBLE. That means, your full text index will be huge and you don’t want to keep them together with other types of index for faster queries. Simply create another table to have the text fields and full text indexes and left join. It works [...]

Over at mysql.bkbits.net you can also get the “telco” (commonly known as CGE or “Carrier Grade Edition”) source trees of MySQL Cluster.

I think it’s exciting that we now have the source trees up here. You can use the freely available bk client to pull the sources or the commercial bitkeeper.

Since I just got back from the US for the MySQL UC (which was rather awesome) I don’t quite have the energy to go into the difference between normal mysql 5.1 and the telco trees… so wait for part 2 :)

SugarCRM has their Global Developers Conference later this week.  It's their first ever and it should be a fun event.  I'll be speaking there on Thursday morning.  There's a developer track as well as an IT Manager track as well as some excellent training sessions.  The conference is in San Jose May 3-5.  If you're using SugarCRM or even thinking about it, this is a bargain event.

• SugarCRM: Global Developers Conference, …

From the “I wish I attended this talk” department. When I attended Dathan’s talk about Federation at Flickr, he did mention that the next day there was going to be a really interesting talk by John Allspaw, who is an Engineering Manager at Flickr. John has posted up his slides, which I might add, are quite an interesting read (look at the speaker notes, they sort of give a heads up as to what you missed).

Its a pity no one made notes of this on Planet MySQL, so if anyone did attend the talk and you did take notes, please do place them online! This talk isn’t so much teaching you about capacity planning, its really more about all the pointers you can take away, about …