Open source master data management got a boost on Monday when Talend announced that they acquired Xtentis MDM from Amalto. This product was geared towards creation of repository-style MDM applications, for example a product master data repository or a customer key cross-reference hub.

Xtentis was a Java and XML-based product with an Eclipse UI, so it's a reasonably good technical fit with Talend's tools. While the product information links have been removed from their web site, you can still access the Xtentis product data sheet if you're interested in the functionality and …

Some of you may have run the mysql-test-run tool which is the MySQL test suite. But did you know there are actually multiple suites? If you just run the tool, you don’t get everything!

Check out the mysql-test/suites subdirectory. That’s all the stuff you don’t get when just running the tool normally. If you take a peek at the Makefiles, you will find a target test-bt (build team) which shows the extra calls and parameters for the additional suites.

OurDelta has had some interesting cases where a build that’s otherwise ok would fail when users tried the test suite on their installation. We reckon such a test should definitely pass, and thus we had some more homework to do. So now OurDelta builds with as many tests as exist enabled, on all platforms and architectures. Slow yes, but that’s not an argument to not test something, right? Failing tests are often indicative of other issues, so at the very least …

Reporting queries (I will use this term here) are the queries which summaries and groups data over the certain period of time. For example, in Social Network site we want to know how many messages have been sent for the given period of time, group by region and status (sent, received, etc), order by number of messages sent.

As an example I will take a table which is used to send SMS (text messages).

SQL: select concat('+', substring(region_code,1 ,2), 'xxx') as reg, status, count(*) as cnt
from messages
where submition_date between '2009-01-01' and '2009-04-01' group by reg, status
having cnt>100 order by cnt desc, status limit 100;

This query will do a range scan over the submition_date and perform a filesort. There are common well known approaches which can be used to optimize table (“covered index”, “summary tables”, using external data warehouse, etc). …

At the Open World Forum event in Paris this morning I presented a quick overview of the state of free and open source software in 2009 and a look at the trends shaping FOSS into the next decade. The presentation was just 10 minutes rather than the 20 I had originally understood it to be, so I wanted to use the blog to expand a little on the discussion and my thinking.

War is over (if you want it)
Aside from the ongoing adoption of open source, one of the trends that has defined FOSS in 2009 has been the numerous declarations …

In my old post there is a bug when run in MySQL 5.1.30 and old, because the status variable Queries was added in MySQL 5.1.31. So i change to choose between Queries and Questions status variables, and I think the Queries represent more accurate result.

http://forge.mysql.com/tools/tool.php?id=217

By the way:

# Queries The number of statements executed by the server. This variable includes

Ever wondered exactly *what* was in a Drizzle Table proto? Well, wonder no more. A while back this little utility called table_raw_reader hit the drizzle codebase. It’s a simple command line utility that takes a .proto file as an argument, reads it off disk and then prints out a text representation using the TextFormat class of the protobuf library.

An example:

stewart@willster:~/drizzle/jay-and-stewart-remove-pack_flag$ ./drizzled/message/table_raw_reader ./tests/var/master-data/test/t1.dfe
name: "t1"
engine {
  name: "InnoDB"
}
field {
  name: "id"
  type: INTEGER
  format: DefaultFormat
  options {
    length: 11
  }
}
field {
  name: "padding"
  type: VARCHAR
  format: DefaultFormat
  options {
    length: 800
  }
  string_options { …

(At least in Drizzle)

Brian merged my jay-and-stewart-remove-pack_flag branch and it’s now in trunk. Removing pack_flag was a task for the bell milestone and in true collaborative effort, it took more than one person to unravel its dark mysteries. Hats go off to Jay who bravely ripped more of it out with the aid of excellent Seattle coffee. I finished it off with removing the last remnants and fixing an outstanding bug (and at the same time making us look at the DECIMAL code and shuddering in fear of what it may mean).

With pack_flag gone, we can now do insane things like remove the last bits of TINYINT from the code, as previous to removing pack_flag, if you did that, things …

I use sysbench a lot for performance tests. It is a great tool and on top of that the code is easy to read and modify. I added a few changes to my Launchpad branch. I will describe the changes by the new options:

• --seed-rng -- sets the seed for the random number generator. I used this when running query cache tests to increase the cache hit rate. I ran sysbench twice with the same seed and as a result, most of the queries on the second run match those from the first run and re-use results from the query cache.
• --oltp-point-select-mysql-handler -- apart from having a really long name, this makes sysbench use HANDLER READ statements rather than SELECT …

Recently I decided to build my own forum software so I'm able to better control spam posts and make posting easier than it ever was.

All user accounts including passwords were imported into my new database. Only the name of the permanent cookie has changed so you might have to login once before posting now.

Email addresses are nowhere displayed, except for the settings page where you only see the more compact options, including a checkbox to turn email notification on replies on and off.

I'm going to add some formatting buttons to the posting form, and maybe some pulldown for smilies. Currently you can only post plain text messages, which is sufficient in many cases.

I'm also going to add support for creating Subversion revision URLs, automatically created if you type

r1234

. Same goes for issue ids when you want to refer to a bug report.

I hope you like …

(This note should not go to PlanetMySQL, sorry if it goes).
We again have problem with comments to blog posts. It's technical problem, we did upgrade some components and it seems it affected captcha. We are working on fix.
We are sorry for the inconvenience and thank for reports about the problem.

Entry posted by Vadim | No comment

Add to: | | …