This Thursday (December 11th), Philip Stoev will talk about the Random Query Generator, a new QA tool that generates pseudo-random queries targeted to exercise a specific part of the server being tested. It then executes those queries to check for crashes or assertions or to compare the results returned from two different servers (two versions, two different storage engines, optimizer flags, etc.). It is also able to execute queries against a replication master, constantly checking that the slave is okay and has not diverged.

Towards the end of the session, Philip will share his desktop and show some live examples. Make sure to adjust your volume in case the MySQL Server will utter agonized sounds.

Note that we'll be using a new session address / Dimdim URL:

In a previous blog "disk data counter" I did a couple of measurements how to configure the disk data and what we can expect.

Now I have redone the insert test to put as much load as possible with respect to the disk sub system.

1. Insert 5M records a' 4096B (1 threads, batches of five):
6.3.19: 286 sec (3721.12 QPS)

2. Insert 5M records a' 4096B (5 threads, batches of five):
6.3.19: 286 sec (8315.36 QPS)

At 2) the IO sub-system is quite loaded (98.2%) and I get (periodically,when the DiskPageBufferMemory is checkpointed):

"REDO buffers overloaded, consult online manual (increase RedoBuffer) - code=1221" (this does not matter, as i retry my transactions in the application).
I could increase the RedoBuffer (it is set to 32M), but there is no point as if I …

What would you expect the following to fail with?

CREATE TABLE t1 (a int, b int);
insert into t1 values (100,100);
CREATE TEMPORARY TABLE t2 (a int, b int, primary key (a));
BEGIN;
INSERT INTO t2 values(100,100);
CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) select * from t1;

If you answered ER_DUP_ENTRY then you are correct.

From the manual:

Note

If you use IF NOT EXISTS in a CREATE TABLE ... SELECT statement, any rows selected by the SELECT part are inserted regardless of whether the table already exists.

Does anybody else find this behaviour “interesting”?

The demand for high-tech appliances has been on the rise in the last few years. Their benefits — including high performance, low TCO, rapid time-to-value, and ease of use — have driven adoption in a variety of industries from data warehousing to network and security management, storage, retail, telephony and so on. As the analyst firm, Forrester, noted in a 2008 report:

“Appliances - in all their proliferation - are here to stay and are moving into the mainstream of computing and networking”

It turns out that the database of preference for a growing number of appliance vendors is MySQL. As noted on its appliance page, MySQL’s benefits of low TCO, ease of use, and rapid time-to-value map well to the requirements of appliance offerings.

As appliance markets have matured and competition has increased, there …

For those interested In SSD or Wafflegrid I will be presenting on both topics at the 2009 MySQL User Conference!  I want to keep these fresh, so their will be more then just a rehash of my blog here, but their will be some overlap.  Interested in something I have not talked about yet?  Drop me a line!  Always looking for good ideas.

New features for Planet MySQL.

Lenz has opened a new section for Italian blogs (I should say blogs in Italian, since there are blogs that are hard to classify).

Thanks, Lenz. We'll try to fill it with some good contents.

In the meantime, Dups was creating a new feature for the Planet. MySQL Buzz is a window on living contents about MySQL, from forums to blog posts, to news and videos.

…

We released  ZRM for MySQL 2.1 Community Edition  today.  ZRM 2.1 includes the ability to treat snapshots as backup images. ZRM has supported backup of MySQL databases using storage snapshots using a plugin interface.  LVM (Logical Volume Manager) and Solaris ZFS snapshots are supported plugins in the ZRM Community Edition.
MySQL administrator can perform regular backups (backup images are stored in the ZRM server) or quick backups (snapshots acting as backup images). Quick backups have smaller backup windows and do not consume network bandwidth.  When MySQL database is stored on one or more ZFS filesystems, users can do multiple quick backups in a day (even once every hour) and convert one quick backup image to a …

Just posted on the NetBeans main page - Robin Schumacher is going to do a webinar focused on MySQL 5.1 benefits for OEMs and ISVs

http://www.netbeans.org/servlets/NewsItemView?newsItemID=1320

Just got the news that our talk at the MySQL 2009 User's Conference has been accepted. Here's the abstract.

In this session we’ll be building a PHP+MySQL application that uses the Twitter API and has some AJAX fun with it.

You’ll also get a chance to see what it’s like to build an application in a PHP IDE like NetBeans. Those of you who use ‘vi’ might want to see how the other half lives, and scoff at us under your breath. Or you may actually get turned on to the power of a good IDE and realize hey, I could use some of that.

In this session we will be demonstrating

• Building a PHP+MySQL+web services+AJAX application in NetBeans
• Using the Twitter search API
• Using AJAX-based graphing tools to provide dynamic graphing to your application

The presenters are Justin Bolter, …