The MySQL May conference keynote videos and presentations files are all posted so you can download the ones you're interested in now. Embedded below is the video and slide deck for my keynote on Thursday.

The gist of this presentation is that business intelligence and analytics are the #1 IT spending priority, BI technology is becoming a commodity, open source BI and DW tools are maturing, and the supporting stats about open source BI and DW adoption.

…

Since writing and speaking a bit more about the “relax! a failure is not an emergency” concept, more and more people approach me with interesting horror stories. I’m scribbling a few backup-related ones here for your enjoyment - and naturally there are important lessons.

Story 1: A place makes backups that get shipped off-site, interstate even. One day a couple of files are lost, and so someone files a request to retrieve said files from the archive. Well, apparently that’s something that should be done as it creates some very stressed responses and a quoted timeline of a few weeks. In the end the issue is resolved through other means and the request stopped - unfortunate, since it would have been very interesting if the requested files would actually ever arrive… clearly a retrieval was not part of the expected process. One also wonders how long a full dataset retrieval would take, or if  it’s even possible!

Peter Zaitsev at Percona has an interesting post today talking about how large companies warp the open source development process, resulting in an increasingly isolationist development model from their corporate benefactors. He rightly highlights one motive driving this behavior, namely the desire of marketing to make a big splash with a critical mass of enhancements/fixes that, when bundled together, become worthy of media attention. He rightly bemoans this situation from the perspective of the developer.

There are a few more factors influencing this process and their root causes are found in the maturation of the project and the demands of both users and the different groups inside a corporation. Much of this can be mapped to the stages defined in the book Crossing the …

Welcome to the 147th edition of Log Buffer, the weekly review of database blogs.

Let’s start this week, with blogs from the SQL Server world, where a number of excellent technical posts appear. Alexander Kuznetsov surprises his readers with this assertion: without ORDER BY, there is no default sort order. “Sounds trivial? Right, but different flavors of this myth still persist.  . . .  Because apparently many visitors agreed with this myth, I decided to post a repro script which demonstrates that this is simply not true.”

In their post on …

First there was LAMP.  But are you using GLAMMP?  You have probably not heard of it because we just coined the term while chatting at work.  You know LAMP (Linux, Apache, MySQL and PHP or Perl and sometimes Python). So, what are the extra letters for?

The G is for Gearman - Gearman is a system to farm out work to other machines, dispatching function calls to machines that are better suited to do work, to do work in parallel, to load balance lots of function calls, or to call functions between languages.

The extra M is for Memcached - memcached is a high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web …

If you often need to create and modify views in your MySQL development you will like dbForge Studio for MySQL in-place query editing feature. This feature allows integration of powerful Query Builder tool with view editor without annoying copy/paste.

Suppose you have previously created view with some SELECT statement. To view and design this statement with Query Builder you need to perform these steps:

1. Open view editor.
2. Right-click on SELECT statement.
3. In pop-up menu select ‘Design SQL…’ command.
4. In opened Query Builder re-design you SELECT statement (See picture below).
5. After you click OK new statement automatically gets pasted into the view  editor.

If you need to design new SELECT statement when you are creating view use ‘Insert SQL…’ …

If you read Yves blog post about waffle yesterday we are seeing some weird gremlins in the system and could use some scoobey doo detective work if you have some ideas. The strange thing is it only exhibits under high load. So it really seems like we may have missed some background cleanup process that accesses or removes pages from disk or the buffer pool without going through the functions we call waffle in (buf_LRU_search_and_free_block & buf_read_page_low ).

One of the idea’s I had was trying to narrow the scope of what’s being pushed and read form Memcached. Even though I am using file per table, system tablespace pages are still making it in and out of memcached. I thought if we missed something maybe it was here ( even though I could not find it in the code ). I mean cleaning up undo or internal data would seem like a logical place to miss something. So I hacked Waffle …

• The Problem with the Relational Database (Part 1 ) –The Deployment Model
• The Problem with the Relational Database (Part 2) – Predictability

The relational database has been the core mechanism for structured data storage and retrieval for the past 30 years.  My career so far has focused around the relational database, whether it be from a development, administrator or investment perspective.  In all this time the RDB has been the best generic option available for developers …

The TokuDB storage engine for MySQL employs Fractal Tree technology.  We’ve been planning to write a white paper explaining how fractal tree indexing works, but haven’t gotten to it yet.  In the mean time, here are links to some academic papers that relate to our technology.

• 
  
• Cache-Oblivious B-Trees by Michael A. Bender, Erik D. Demaine and Martin Farach-Colton in SICOMP 35:2, pp. 341-358, 2005.  An early version of this paper appeared in FOCS in 2000.
  
• The Cost of Cache-Oblivious Searching by Michael A. Bender, Gerth Stlting Brodal, Rolf Fagerberg, Dongdong Ge, Simai He, Haodong Hu, John Iacono, and Alejandro López-Ortiz in FOCS 2003 p. 271.
  
…

Brian Miezejewski at Dallas MySQL Users GroupBrian Miezejewski will be speaking at the Dallas MySQL Users Group meeting June 1st in Dallas. Brian is a top respected MySQL consultant. If Brian is talking about performance tuning MySQL, then any MySQL DBAs in the area should be attending to listen to what he has to say.I'm planning on attending the Dallas MySQL group meeting and listening to