Java and MySQL are bright spots in the quarter, while Solaris and virtualization sputter. READ MORE

The open-source database leader just had an $81 million quarter, making the $1 billion valuation of acquirer Sun Microsystems start to look like a bargain.

The Linux kernel uses this macro to find the current process. The current macro is defined in include/asm-i386/current.h (line 13) in both 2.6.0 and 2.4.18 kernels. This macro calls another function get_current().

Recently a customer mentioned that they were seeing corruption rarely when they copied InnoDB files using LVM to setup a new slave. Investigating further, it turns out that replication would start, but would then hit a lock wait timeout. This locking issue occurred across restarts causing replication to always fail. They would solve this by taking a new LVM snapshot and resetting it up.

This is a classic case of an XA transaction in a prepared state persisting across restarts and the LVM sometimes taking a snapshot at the exact instant when this can occur.

Most people don't use actually XA transactions, so they may not consider this possibility. However, it can still occur even if you do not use them due to XA being used internally for the binary log and InnoDB. We will be able to identify that case later.

You can tell this …

Wikimedia Foundation is expanding Wikipedia to multimedia with Sun Open Storage Solution and MySQL Database:

Wikipedia receives between 25,000 and 60,000 page requests per second, depending on the time of day. Wikimedia needed to update its infrastructure to handle this huge volume of traffic and ensure that its systems were reliable, highly available, and easily scalable. It also wanted to expand its upload file limit from 20 MB to 100 MB to accommodate rich media (audio and video) content, but before it could do that it needed to expand its storage capacity.

…

Wikimedia Foundation is expanding Wikipedia to multimedia with Sun Open Storage Solution and MySQL Database:

Wikipedia receives between 25,000 and 60,000 page requests per second, depending on the time of day. Wikimedia needed to update its infrastructure to handle this huge volume of traffic and ensure that its systems were reliable, highly available, and easily scalable. It also wanted to expand its upload file limit from 20 MB to 100 MB to accommodate rich media (audio and video) content, but before it could do that it needed to expand its storage capacity.

…

My presentation at LOSUG on tuesday went down like a house on fire - I think it would be safe to say that the phrase for the evening was ‘It’s a cache!’.

For that to make sense, you need to look at the slides, which are now available here.

Attendance was great, but it seems the last minute change of day meant that some people missed the session. We had 151 people register, and about 80 turned up on the night.

« Post 3 | This is the 4th post in my MoFo Futures 2009 blog series

“When I was a child, my mother lectured me on the evils of ‘gossip.’ She held a feather pillow and said, ‘If I tear this open, the feathers will fly to the four winds, and I could never get them back in the pillow. That’s how it is when you spread mean things about people.’ For me, that pillow is a metaphor for Wikipedia.” — John Seigenthaler Sr.

So the future pulled up in her shiny big metaphor and we got in. In the beginning, our road trip made sense, all well-ordered highways and wholesome roadside attractions. Somewhere along the way, we hit bat country and the …

I’ve been asked about this and realized that it may not be obvious to people who are more familiar with Windows than with Ubuntu. So here is a tip.

When learning MySQL on Ubuntu, it is helpful to be able to get to MySQL’s data directory and observe file creation and modification while you are performing database and table creation and modification, index creation and modification, etc. You can find out MySQL’s data directory by running:

show variables like ‘datadir’;

Suppose your datadir is /var/lib/mysql. And suppose you have a database called test. After opening a terminal window and type:

cd /var/lib/mysql/test/

You will likely receive an error like below:
bash: cd: /var/lib/mysql/test/: Permission denied

Now if you try the command below, as it seems logical on Ubuntu

sudo cd /var/lib/mysql/test/

You will likely get this message:

sudo: cd: command …

Executive summary: There is now a MySQL Room on FriendFeed, as well as a identi.ca group for mysql. Community members, developers, dabblers, users, etc. should find these extra avenues useful, in addition to the forums, mailing lists, and even the Forge. Join them now!

There has been a recent uptake of Twitter amongst the MySQL community… Early adopters have been around for ages, even (as we’re slowly approaching Twitter’s third birthday).

However, I’ve been noticing that slowly, …