Hello and welcome to my Log Buffer, the weekly review of database blogs. My name is Keith Murphy and I am the editor of MySQL Magazine, a free digital magazine with information for MySQL administrators and developers, released quarterly.  I am also a MySQL database administrator at Pythian.

I am losing count of how many of these Log Buffers I have done. If I recall correctly, this is number three. But then again, it could be number four. You know what they say though—the more the merrier!

This week’s Buffer features a great allegory about a database, some tips, feature requests, and breaking news. It seems that this week, people shared information that was relevant across database servers, so I recommend that no …

Next Thursday (February 5th), we're continuing our series of sessions on MySQL performance measuring and improvements with Allan Packer's presentation titled MySQL Performance and Scalability Project - Issues and Opportunities. Allan works in the Performance and Applications Engineering department at Sun Microsystems, so again, expect to get some deep insights into the inner workings of the MySQL Server.

Allan is based in Australia, so note that this session will take place in the morning (Europe) or evening (APAC), respectively.

For MySQL University sessions, point your browser to this page. You need a browser with a …

With the summer holidays in this part of the world pretty much over, our kids are going back to school. With a bit of luck you still have a job, and professional development is a good thing!

Open Query is keeping its training prices as-is -affordable- and you can, as always, sign up for individual days: you pick what you need, when you need it. Easy!

MySQL Developers/DBAs

• Mon 9 Feb: MySQL Query/Server Performance Analysis and Tuning (AUD 575 + GST)
• Tue 10 Feb: InnoDB Performance Tuning (AUD 575 + GST)

MySQL DBAs

• Mon 16 Feb: …

2009 Starts quite interesantly.

This Monday took place the first Warp Talks, a project of training between employees at Warp Networks. The last Monday of the month will take place a new Warp Talk.

koke and me where the first speakers.

I made an introduction to subversion, and he did a talk about 10 things you might not know about MySQL.

Koke took a camera and recorded our talks at the same time they were being broadcasted at justin.tv. Videos are available at vimeo (spanish):

http://www.vimeo.com/tag:warptalks

Today Giuseppe pointed me to Hot skills: MySQL 5.1, an article in ComputerWeekly.com.

The takeaway from the Gartner report quoted?

• Gartner published a report titled “The Growing Maturity of Open-Source Database Management Systems” in November 2008, and found that there was a 50% increase from 2007 to 2008 in the usage of open source DBMS’s in production.
• “Gartner says the major open source DBMSs are now available for installation as packages, without involving the source code, and include tools to help support administrators and managers.” I’d like to state that, MySQL has always been available in packaged format, and you don’t need to fudge with the source code if you do not want to. In fact, its available on all your distributions as well.
• …

Mozilla, the global community behind the Firefox web browser, has an idea that we need your help with. We want you to help make openness, participation and distributed decision-making common experiences in Internet life.

To do this, millions of people around the world must understand, embrace and share these values. You, me, our families, our neighbor down the street, our political representatives – millions of us from every walk of life in every wired country can help to protect the Net and make it better.

As an experiment working towards this goal, I am coordinating a program that asks people to share short (very, very short – 3 to 12 second) video statements of how the Net has changed their life. We hope that thousands of videos are made by people all over the world and that, through …

I mentioned earlier that IO scheduler CFQ coming by default in RedHat / CentOS 5.x may be not so good for MySQL. And yesterday one customer reported that just changing cfq to noop solved their InnoDB IO problems. I ran tpcc scripts against XtraDB on our Dell PowerEdge R900 server (16 cores, 8 disks in RAID10, controller Perc/6i with BBU) to compare cfq, deadline, noop and anticipatory (last one just to get number, I did not expect a lot from anticipatory).

Here is result (in transactions per minute, more is better):

…

Upload Image to MySQL using PHP As a new-bie to php/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite…

The post Upload Image to MySQL using PHP first appeared on Change Is Inevitable.

We modified the iiBench benchmark to perform deletions as well as insertions, and compared InnoDB to Tokutek's Fractal TreeTM storage engine, both running on MySQL 5.1. I'll post the revised iiBench tarball soon.

Here is what the performance looks like:

The iiBench-with-deletions benchmark works as follows. The benchmark employs a fact table with an autoincremented primary key. First it inserts 250M rows (1000 rows per INSERT statement). Then it treats the fact table as a FIFO: every time it inserts 1000 rows at the end, it deletes 1000 rows from the beginning. The benchmark maintains three indexes as data is inserted and deleted. As usual for iiBench, the three indexes exhibit a lot of entropy (that is, they are essentially random).

In the graph above, the X-axis shows the number of items inserted so far. The Y axis shows the number of insertions per second (insertions/s), where each data point …

I'm in the process of writing an API that relies on (file-)streams to be passed around.

There are situations where a string instead needs to be used, and for these purposes the data: stream wrapper is used. Initially I thought it was only possible to encode the actual string in base64, which I didn't like because of the added footprint.

<?php

$string = "I should have really done some laundry tonight.";

$stream = fopen('data://text/plain;base64,' . base64_encode($string),'r');

echo stream_get_contents($stream);

?>

Quickly checking out the rfc, it turns out that ';base64' can be omitted to just pass along the raw data, which makes a lot …