During the MySQL Users Conference late April, I had the pleasure of being interviewed by Scott Mace in his ITConversations series. The podcast is now available online.

In his commentary to my podcast, Scott says

Open-source database management software is in millions of hands. Find out how MySQL profitably blazed this trail, and how Kaj Arnö of MySQL is helping define GPL 3.0, and how MySQL lives with the complexity of software patents and multiple storage engines. Kaj also discusses how MySQL both competes and cooperates with Oracle. Also, …

I just noticed that the crawlers finished on the RSS from the last seven day window:

Word: Linux Seen: 5588
Word: PHP Seen: 2131
Word: MySQL Seen: 1191
Word: Perl Seen: 1063
Word: Apache Seen: 1043
Word: Ruby Seen: 890
Word: APR Seen: 848
Word: Python Seen: 842
Word: Asterisk Seen: 113

Slight upticks in most of the counts. I was asked about the count in APR in person this week, aka "Why is it so high?". The answer is that the OPML file from Planet Apache is pulled and parsed. So anyone whom Planet Apache thinks is "of worth" gets added. I only pull at this time 47 OPML files at this time.

And no, Planet MySQL is not pulled, since it lacks an OPML file (hint, hint, hint...).

For the social sites:

Word: MySpace Seen: 929
Word: Slashdot Seen: 606
…

The new MySQL Cluster NDB API Documentation is now available.

San Mateo and Cupertino, Calif. â?? Jigsaw Data Corp., the online global marketplace for buying and trading business contact information, announced that it has selected MySQL, the world's most popular open source database software, to power its popular online user-generated database of over 3.3 million business contacts at more than 360,000 companies.

We continue were we left off.
Using the basic structure from the last example where we implemented a simple query, let's have a look at how to do inserts, deletes, and updates based on the primary key.

First of all, use the same table structure as last time:

> mysql -u root test
and create the following table in the test database:


create table t1 ( a integer primary key, b integer, c char(20)) engine=ndb;
insert into t1 values(1, 1, 'hello');
insert into t1 values(2, 2, 'hello again');


Insert operation - insert into t1 values (3, 1, 'good bye');

Before we do the actual insert, let us prepare the data of the tuple we should insert:

int pk_a =3 ; //primary key
int b=1;
char * string = "good bye";

char c[20];
memset(c,32,sizeof(c)); // mysql requires chars to be space padded. …

Hello,

We are conducting a webinar this Thursday @ 10 PST titled "High Availability Solutions for MySQL". We will be exploring the following topics:

• MySQL Replication
• MySQL Cluster
• MySQL Cluster & Replication
• Linux Heartbeat & MySQL Replication
• Linux Heartbeat, DRBD & MySQL
• Load Balancing & MySQL
• MySQL w/ Shared-Storage & Clustering Agents
• Other HA Solutions for MySQL

It is not too late to sign up:

http://www.mysql.com/news-and-events/web-seminars/

Hope you can join us,

Jimmy Guerrero
Sr Product Manager
MySQL

I will be talking about Falcon storage engine at the next Bulgarian user groups meeting in August. If you have some data that could help, please feel free to e-mail me. I am giving a bottle of beer for good link and/or information.

Maybe is good idea to focus on:

Goals of Falcon

What is Falcon

What Falson is not

Falcon is not Cluster SE

When the Falcon will be released

I will prepare my session using public information. This is step 2 of my expreriment to track information and how this information goes to the communities.

Bet you didn't think "Unisys" when you read that subject line, but it's true, all the same. Unisys has done a great job reinventing itself and extending its brand and expertise into new territory, most recently open source software. The firm has strong and growing relationships with MySQL and JBoss, and will increasingly be seen as one of the primary go-to partners for open source.

Julie Giera of Forrester has an interesting report on Unisys' open source services. The report deals primarily with Unisys, but also has interesting things to say about the larger open source services market.

On Unisys she says:

Unisys has announced a set of service offerings, called OASIS, for companies with open source platforms. It is the first time that a major IT service provider has offered a fully integrated set of services - including …

One of the projects I completed last week was the upgrade of the house phone system to the latest version of Trixbox (aka asterisk, aka defunct Asterisk@Home, more to come on that later).

I rarely answer my home phone line though. To even get to my extension you have to know what it is ahead of time, since the message you get when you dial my home phone line is "go away". If you know my extension though you can still get to me, which most likely means you will get my voicemail. All voicemail from the house line is sent to me as email, unlike my cell phone where it sits and rots.

If you can navigate my home phone system, I probably want to hear from you. With the upgrade I wanted my phone system to push data to me. To do this I wanted to integrate it into Laslow (and yes this is the next generation of Wolsal for those who remember it).

Laslow is an AIM bot that I run.

Why AIM? When my …

Many people asked me to publish a walk through SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this info to improve MySQL Performance.

To start with basics SHOW INNODB STATUS is command which prints out a lot of internal Innodb performance counters, statistics, information about transaction processing and all kinds of other things. In MySQL 5 number of Innodb performance counters were exported and now available in SHOW STATUS output. Most of them are same as you previously could find in SHOW INNODB STATUS, there are however few which were not available before.

In SHOW INNODB STATUS many values are per second. If you're planning to use these values make sure they are sampled over decent period of time. In the very start of printout Innodb will print:

PLAIN TEXT CODE:

…