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 …

“Ban FRM Now!” branch in Launchpad

Now we’re reading part of the table information out of the proto file on disk instead of the frm.

Not everything (yet) but a bit. Good first steps. Had to fix bugs along the way as well (and find weirdness in FRM file format…).

Progress is being made.

Join the North Texas MySQL Meetup on Monday February 2nd at 7:00PM as Said Syed will host an open Forum type discussion on Virtualizing MySQL.

Sun Office
16000 Dallas Pkwy
Suite 700
Dallas, TX 75248

As a storage engine developer you need to take rows of data given by Mysql and interpret the meaning. You also need to take data from your storage engine format and convert this to Mysql format before returning the data to the engine. One important aspect of this is determining which fields have NULL values. Here is how the NULL values work in Mysql internal row format:

There is a table object that is part of the storage engine handler class:

struct st_table *table;

This table object contains a field member, which is an array of fields in the table:

Field **field;

Any individual field within a table has the following members:

uchar* null_ptr;
uchar null_bit;

The null_ptr is used to reference the byte location in the mysql row where the null bit mask for this field is located.

The null_bit is a bit mask for a single byte …

The MySQL Proxy was split into

• a chassis which handles cmdline, service, logging, plugin loading
• a core library for the life-cycle, network handling and protocol decoding
• a lua layer wrapping around the internals
• a set of plugins: proxy, admin, debug, replicant

It also contains a few tools that reuse the above libraries:

• mysql-binlog-dump
• mysql-myisam-dump

We dropped libcheck in favour of glib 2.16's g_test_* functions.

Changelog:

Chassis added support for SIGHUP to reopen logfiles added win32-service support added --basedir added experimental --log-backtrace-on-crash added DTrace probes added a angel to keep the chasses alive added --user option to change the system user the proxy runs as added config-file support …