Direct play this episode at:
http://tinyurl.com/2guzuk

Download all episodes at:
http://technocation.org/podcasts/oursql/

Subscribe to the podcast at:
http://feeds.feedburner.com/oursql

News:
MySQL signs a 1 million Euro deal with an unnamed European Telco.
http://www.pythian.com/blogs/408/mysql-inks-1m-deal-anyone-know-more-details

MySQL 5.0.37 is out ? it’s an odd release, so it’s a community release, and it’s a full release with binaries and source. This release isa big milestone, as it includes the first patches submitted by the MySQL Community.
…

Today I was doing some pre-release testing of our software and to test it I was needed three separate servers running MySQL. After some thinking I decided to use my “old” workstation (actually it is pretty powerful Sempron with 2Gb of RAM, but now I use my macbook as a primary workstation) and start 3 separate virtual servers there. Of course, as all admins, I’m little bit lazy and installing Debian on all three machines was not appropriate solution ;-). So, I’ve created one machine, installed brand-new Debian Etch there and then begun to look for solution to clone this machine to run it in three copies. After all these operations were done, I’ve decided to spend time I’ve saved with this simple trick to describe here how to clone VmWare …

I've been preparing for my innotop session at the upcoming MySQL conference, and enlisted Giuseppe Maxia's MySQL Sandbox to help me get a bunch of MySQL servers, from 3.23.58 to 5.2.3, running on one machine. It was super-easy and has helped me find some bugs in innotop. I should have done this a long time ago.

The PBXT Storage Engine (http://www.primebase.com/xt/) is getting stable and we decided to benchmark it in different workloads.
This time I tested only READ queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon
(http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1)
The difference is I used new sysbench with Lua scripting language, so all queries were scripted for sysbench.

New sysbench you can get from svn repository:

PLAIN TEXT CODE:

1. svn co https://sysbench.svn.sourceforge.net/svnroot/sysbench

The used LUA script for sysbench
…

By Tim O'Reilly

Paul Tuckfield of YouTube has just joined the keynote lineup at the MySQL User Conference, which will be held April 23-26 at the Santa Clara Convention Center. Paul will be talking about Scaling MySQL at YouTube. Every web 2.0 company is ultimately a database company. Some roll their own, a few, a very few, use proprietary commercial databases. Most are running on MySQL. Given the rapid scaling that YouTube has enjoyed, I'm sure Paul will have a lot of useful advice for other up-and-coming sites. Paul's keynote is part of a general focus on scalability at the conference -- there's an entire track on performance tuning and benchmarks, and another on …

As I write this blog I have over 90 draft blog posts. That’s 9-0. Why do I have so many posts? The main reason is I want to say something, and I’ve either not completed it, or researched it sufficiently to consider the entry complete.

This frustrates me as sometimes I just want to get the word out on something, or of my opinion, or of something great I’ve discovered. I do it for me, I don’t really care if anybody actually reads my stuff, but I’m surprised sometimes when I get comments how people actually get to see my blog.

JotThat is a surprisingly simple yet brilliant idea. It’s quite simply a site for making Jots, making quick notes, making a passing comment, noting a thought, something you want to either remember or something you want to say in a simple Jot form.

What makes JotThat in my eyes? Well it’s simple, …

I was out at lunch with some clients and started discussing properties of database systems and the idea of MySQL not having stored procedures popped up its ugly head again. I explained it did have stored procedures as from 5.0 version, but started a heated debate about whether they were actually of any use any more? Why was there a debate over this issue, I simply said, they are no longer important as they once were.

I put forward the question as to why stored procedures were used and after discussion everyone came to the opinion that they are used primarily for two purposes:

1. A data-level API interface.
2. For encapsulating and abstracting larger, multiple queries or transactions, thus keeping the load on the server, rather than on the network.

Everyone agreed that the second option was still valid, although seemed to be less required now, it was the idea of using stored procedures to maintain an API interface …

I was out at lunch with some clients and started discussing properties of database systems and the idea of MySQL not having stored procedures popped up its ugly head again. I explained it did have stored procedures as from 5.0 version, but started a heated debate about whether they were actually of any use any more? Why was there a debate over this issue, I simply said, they are no longer important as they once were.

I put forward the question as to why stored procedures were used and after discussion everyone came to the opinion that they are used primarily for two purposes:

1. A data-level API interface.
2. For encapsulating and abstracting larger, multiple queries or transactions, thus keeping the load on the server, rather than on the network.

Everyone agreed that the second option was still valid, although seemed to be less required now, it was the idea of using stored procedures to maintain an API interface …

I was out at lunch with some clients and started discussing properties of database systems and the idea of MySQL not having stored procedures popped up its ugly head again. I explained it did have stored procedures as from 5.0 version, but started a heated debate about whether they were actually of any use any more? Why was there a debate over this issue, I simply said, they are no longer important as they once were.

I put forward the question as to why stored procedures were used and after discussion everyone came to the opinion that they are used primarily for two purposes:

1. A data-level API interface.
2. For encapsulating and abstracting larger, multiple queries or transactions, thus keeping the load on the server, rather than on the network.

Everyone agreed that the second option was still valid, although seemed to be less required now, it was the idea of using stored procedures to maintain an API interface …

I was out at lunch with some clients and started discussing properties of database systems and the idea of MySQL not having stored procedures popped up its ugly head again. I explained it did have stored procedures as from 5.0 version, but started a heated debate about whether they were actually of any use any more? Why was there a debate over this issue, I simply said, they are no longer important as they once were.

I put forward the question as to why stored procedures were used and after discussion everyone came to the opinion that they are used primarily for two purposes:

1. A data-level API interface.
2. For encapsulating and abstracting larger, multiple queries or transactions, thus keeping the load on the server, rather than on the network.

Everyone agreed that the second option was still valid, although seemed to be less required now, it was the idea of using stored procedures to maintain an API interface …