Our performance tuning guide is now available at infinidb.org.  Subjects touched on  include:
  How are hash joins implemented with InfiniDB?    How is work parallelized across multiple cores, and optionally multiple servers? 
  What "rules of thumb" change with InfiniDB's column storage?
  What is the fastest way to load data with InfiniDB?  
  What is a Batch Primitive Step (BPS)?  

- JRead More...

Wanting to learn Drizzle? My friend Kent is doing just that, and documenting everything as he goes. It’s a great time to learn, as we head up to the bell milestone (which will be awesome) and big user visible changes are certainly slowing.

So, head on over to Learning Drizzle and learn Drizzle with Kent. Should be awesome.

Yesterday's MySQL University session on Gearman for MySQL had a rough start. After I had assigned Giuseppe presenter status we found out that Dimdim (our conferencing system) now turns on video when it discovers a web cam on the presenter's computer. That's not a bad thing in general, but you can't turn it off, which \*is\* a bad thing when your network bandwidth is less than superior. As a consequence, Giuseppe's voice came over very choppy, and the presentation stopped altogether after a few minutes.

For that reason, we decided to restart the session from scratch. This time Giuseppe turned off his camera before becoming presenter, and the session worked flawlessly. For those of you who've given up because of bad sound quality, the recording is here, and it looks and sounds good. You can find it on the MySQL University session page: …

Yesterday's MySQL University session on Gearman for MySQL had a rough start. After I had assigned Giuseppe presenter status we found out that Dimdim (our conferencing system) now turns on video when it discovers a web cam on the presenter's computer. That's not a bad thing in general, but you can't turn it off, which \*is\* a bad thing when your network bandwidth is less than superior. As a consequence, Giuseppe's voice came over very choppy, and the presentation stopped altogether after a few minutes.

For that reason, we decided to restart the session from scratch. This time Giuseppe turned off his camera before becoming presenter, and the session worked flawlessly. For those of you who've given up because of bad sound quality, the recording is here, and it looks and sounds good. You can find it on the MySQL University session page: …

I know a lot of people don’t like registering to download programs (even free ones), but in this case I would like people to register on the site with a valid email address so that I can notify users of new upgrades, security fixes, etc. I’ve had several support requests to fix items that have [...]

Some good changes in this release as usual. There have been some more additions to the analytics, some speed up of the UI and login process, and some long awaited fixed for form Vtypes. In addition to those items, I’m a particular fan of the new Analytics Export tab that lets you grab all of [...]

I am happy to announce today the release of FuseGuard Web Application Firewall for ColdFusion!

FuseGuard 2.0 is the new name for Foundeo Web Application Firewall, but we did a bit more than just change the name!

The biggest new features added to version 2 are the Web Based manager, and the database logger. The web manager main function is to provide reporting for the attacks against your server, but it also allows you to view configuration, and manage users.

Here are some screen shots:

   

    …

In the next week, I'll be interviewing Paul McCullagh, the architect behind the PBXT storage engine. If you have any questions for Paul, please post them here by Monday 16th November.

Note: The idea for this interview was inspired by a previous interview with Heikki Tuuri - creator of InnoDB. You can see the answers here and here.

Entry posted by Morgan Tocker | …

Answering questions asked on the site.

Maxym asks:

Inverting date ranges is an interesting article.

I had the same problem, and I solved it almost the same way in PostgreSQL. Your solution is great! The problem is to implement it on MySQL :) And of course performance there.

Do you have any idea how to transform this query for MySQL?

The query in question regards inverting contiguous non-overlapping date ranges: transforming them so the the gaps become the ranges and the ranges become the gaps.

The following set:

Usually, it's a bad idea to allow elements in a tree to be parents of themselves, because that creates problems with trying to add other children to those elements, or even listing out the tree's structure.But, sometimes things have to be their own parent. For example, if you want to report details of an element's children to the parent element, what happens at the top level of the tree? You can't outright exclude a tree element from the reporting, you can't create a placeholder element because that would skew the tree, and you can't add in a special case in your code base for that single item.Well, you could, but you don't want to. You'd rather have a simple and elegant solution that doesn't require lots of special cases for tree levels, and that doesn't require maintenance. So what do you do? ...