I got an email yesterday about a user experiencing problems when using memcached UDF for MySQL, so today I spent some time trying to recreate the problem. It turned out that the bug was caused by using uninitialized memory, so I guessed it could be a good blog documenting how I found it...

The first thing I did was to compile and install libmemcached and the udf:

trond@opensolaris> ./config/bootstrap
trond@opensolaris> ./configure --prefix=/opt/memcached --enable-dependency-tracking --enable-debug --without-memcached
trond@opensolaris> gmake all install
trond@opensolaris> ./config/bootstrap
trond@opensolaris> ./configure --prefix=/opt/memcached --with-mysql=/usr/mysql/bin/mysql_config --with-libmemcached=/opt/memcached CFLAGS=-g
trond@opensolaris> gmake all install

The next thing to do is to instruct MySQL to look in /opt/memcached/lib for dynamic libraries by …

Last night's talk at University of Western Ontario was a resounding success due in no small part to Kyle Charbonneau the Sun Campus Ambassador who worked very hard to make it happen.

I presented my new 20 minute intro to MySQL and open source which is probably more PR than technical but geared at making people go "wow". Once the tour is done I'll post it up, but right now I don't want to spoil it for those that come to the next presentations.

But the meat of the time is spent in questions and answers and talking about the Tech industry in general. Yes there were the questions about rumours and Sun and you know we can't comment, even if I had something to comment, which I don't. But I will let you know now that I'm sure that I had heard down the grapevine that Sun was setting up it's own country in the Bahamas (how I wish I could get that rumour to reality somehow :D)

So some of the questions: Innodb, how …

In a Financial Times report today about RedHat's quarterly earnings, Sam Ramji of Microsoft takes note of MySQL and its influence as a key component in the general move towards open-source software:

Larger deployments of open-source to firms that already run the technology in a small way might be the most that happens, due to the fact that recessions make IT managers worry about risk. For the same reasons, a recession is not the time to switch a workforce to a new technology.

Microsoft is counting on that, while accepting that every leading company will soon be running at least some open-source software.

“It’s a heterogeneous world,” said Microsoft’s Sam Ramji. While Microsoft continues to warn about the legal and economic perils of relying on Linux and similar systems, Mr Ramji’s role is to make sure …

Welcome to the 141st edition of Log Buffer, the weekly review of database blogs. The Oracle bloggers were especially chatty this week, so let’s start with them.

Rob van Wijk wrote a fine post about choosing between SQL and PL/SQL, defending his choice of straight-up SQL for logic. Naturally, this triggered a lot of discussion, as well as a few responses from other blogs. Chen Shapira framed her response in a question about code life-cycle: would you rather maintain SQL or PL/SQL?

H. Tonguç …

Sun's Open Cloud Vision unveilled: Open Cloud Platform, an open infrastructure powered by Java, MySQL, OpenSolaris, and Open Storage software technologies.  Open APIs, Open formats and Open source.

On March 18th, at CommunityONE aka CloudONE, Sun unveiled the open cloud platform for powering public and private clouds. We also  announced that we are building our own Public Cloud. This will include a Storage and Compute Cloud. Our Cloud will be compatible with Amazon S3 and EC2 at the API level. Meaning, we will provide S3 and EC2 compatibility APIs in addition to our own, hence enabling an easy migration from Amazon services to Sun Cloud. All clouds - public, private or hybrid, built on Sun's Open Cloud platform will be interoperable and there will be minimal vendor lockin given the cloud platform will be built on open …

Sun's Open Cloud Vision unveilled: Open Cloud Platform, an open infrastructure powered by Java, MySQL, OpenSolaris, and Open Storage software technologies.  Open APIs, Open formats and Open source.

On March 18th, at CommunityONE aka CloudONE, Sun unveiled the open cloud platform for powering public and private clouds. We also  announced that we are building our own Public Cloud. This will include a Storage and Compute Cloud. Our Cloud will be compatible with Amazon S3 and EC2 at the API level. Meaning, we will provide S3 and EC2 compatibility APIs in addition to our own, hence enabling an easy migration from Amazon services to Sun Cloud. All clouds - public, private or hybrid, built on Sun's Open Cloud platform will be interoperable and there will be minimal vendor lockin given the cloud platform will be built on open …

A few interesting KPIs about certified people and their current location (the fact that many people travel from one country to the other for work is very popular these days especially in the IT sector): Before starting to read, I am hereby assuming the MySQL list of MCDBAs is on a residence basis not citizenship. There are [...]

Franck Leveneur gave a nice tutorial on MySQL stored procedures and functions at Yahoo! on Tuesday and the slides are now in: HTML, PDF. Navicat and ZManda offered license and discounts to attendees, and since we didn’t have a bowl … Continue reading →

Continuing my series on the Violin Memory 1010 I am turning my attention to the DBT2 benchmark which simulates an OLTP workload. I started with my typical “waffle” workload which is a 20 warehouse setup ( about 2.5 GB ) with a 768M buffer pool and I compared it to a 5G buffer pool with the same setup.  The ultimate goal or the nirvana state of any system is to have the performance of the storage system be as fast as having everything all in memory. The closer we can get the better off we are. The sad thing is even with the fastest of flash solutions we see times in the 70-300 microsecond response time range,  which is very  far off the nano second response time delivered by memory. That being said lets see how close we can get to a fully cached database:

I am including the Intel #’s for perspective here and to show just how close we can get full in memory speeds. The fact is I am comparing a potentially …

In a Financial Times report today about RedHat's quarterly earnings, Sam Ramji of Microsoft takes note of MySQL and its influence as a key component in the general move towards open-source software:

Larger deployments of open-source to firms that already run the technology in a small way might be the most that happens, due to the fact that recessions make IT managers worry about risk. For the same reasons, a recession is not the time to switch a workforce to a new technology.

Microsoft is counting on that, while accepting that every leading company will soon be running at least some open-source software.

“It’s a heterogeneous world,” said Microsoft’s Sam Ramji. While Microsoft continues to warn about the legal and economic perils of relying on Linux and similar systems, Mr Ramji’s role is to make sure …