Version 0.8 of the Gearman C Server and Library has been released. This includes basic HTTP protocol support, build system improvements, and bug fixes.
Version 0.4.0 of the Gearman PHP Extension has also been released.
If you want to learn more about Gearman, be sure to check out the upcoming Boston MySQL Meetup, MySQL Webinar, or the one of the events at OSCON (tutorial, session, and …
[Read more]
Yesterday I still worked for Sun Microsystems as a Principal
Engineer & MySQL Sr. Architect. Today was my first day of work at
Monty Program, Inc, a subsidiary of a tiny company established by
Monty Widenius in February. Yet I didn't even make the top ten.
If people want not to miss the train they have to hurry up.
Am I happy? Oh, yeah...
No more waking up with the question constantly drilling my mind:
“What am I doing here?” What are all of us, MySQL Server
developers, doing without Monty? Waiting for the time when all
our options are vested? I can't . That's too long for me. I'm
already too old to wait any more.
Besides, we've already lost at least 3 years. We have to do what
we planned to do in 2005. We have to raise the Server to the
level where any RDBMS that claims to be called mature should
be.
So who is newly born? Me? In a way, yes. This is my second
reincarnation for the history of MySQL, …
For the last couple of months, we've been quietly developing a MySQL protocol parser for Maatkit. It isn't an implementation of the protocol: it's an observer of the protocol. This lets us gather queries from servers that don't have a slow query log enabled, at very high time resolution.
With this new functionality, it becomes possible for mk-query-digest to stand on the sidelines and watch queries fly by over TCP. It is only an observer on the sidelines: it is NOT a man in the middle like mysql-proxy, so it has basically zero impact on the running server (tcpdump is very efficient) and zero impact on the query latency. There are some unique challenges to watching an entire server's traffic, but we've found ways to solve those. Some of them are harder than others, such as making sense of a conversation when you start …
[Read more]Sun Microsystems, Inc. today announced that TweetMeme, the innovative online application that tracks the popularity of links sent via Twitter, has subscribed to Sun's MySQL Enterprise database offering in order to keep up with the microblogging service's explosive growth.
Created in 2008 by pioneering Web 2.0 startup Fav.or.it, TweetMeme gives the rapidly expanding Twitter community a means of easily seeing and sorting the most popular links on Twitter. TweetMeme also provides a realtime search facility of fully expanded, qualified and indexed links so that users can get answers to queries about very recent events or news.
As described in “Batching – improving MySQL Cluster performance when using the NDB API“, reducing the number of times the application node has to access the data nodes can greatly improve performance and reduce latency. That article focussed on setting up multiple operatations (as part of a single transaction) and then executing them as a single batch sent by the NDB API library to the data nodes.
The purpose of this entry is to show how a single NDB API operation can access multiple rows from a table with a single index lookup. It goes on to explain the signifficance of this both now and in the future (much faster joins using SQL for MySQL Cluster tables).
There are several operation types to cover table scans and index lookups (refer to the “ …
[Read more]There has been no shortage of lively discussion on open source software licenses with recent shifts in the top licenses, perspectives on the licenses or lack of them for networked, SaaS and cloud-based software, increased prominence of a Microsoft open source license and concern over the openness (or closedness, depending on your perspedtive) of the latest devices. Amid all of it, we’re pleased to present our latest long-form report, CAOS 12 - The Myth of Open Source …
[Read more]With thanks to Patrick Galbraith and his DBD::drizzle 0.200 I am now able to test client benchmarks side by side with MySQL and Drizzle.
For simple benchmarking with clients, generally when I have little time, I use a simple Perl framework mybench. I was able to change just the connection string and run tests.
The diff of my two scripts where:
---
> my $user = $opt{u} || "appuser";
> my $pass = $opt{p} || "password";
> my $port = $opt{P} || 3306;
> my $dsn = "DBI:mysql:$db:$host;port=$port";
---
< my $user = $opt{u} || "root";
< my $pass = $opt{p} || "";
< my $port = $opt{P} || 4427;
< my $dsn = "DBI:drizzle:$db:$host;port=$port";
---
It’s too early to tell what improvement Drizzle will make. Just running my …
[Read more]Quick one here; If you’re thinking to yourself “why can’t I make the MySQL data partition JFS on my RHEL5 server…” here’s a good how to: http://phaq.phunsites.net/2008/02/04/enabling-reiserfs-xfs-jfs-on-redhat-enterprise-linux/
I'm pleased to announce the release of Vertical Partitioning
storage engine version 0.2.
http://launchpad.net/vpformysql
The main changes in this version are following.
- Support MySQL's table partitioning.
MySQL's table partitioning that is only introduced
last release is now supported.
note: After this version, you need to apply a patch
for installing Vertical Partitioning storage engine.
- After this version, the primary key part of InnoDB's secondary
index is effectively used.
You can use the primary key columns with InnoDB's
secondary index by using following statements.
create table tbl_b(
…
Dear community,
The release 0.8 of the opensource backup tool for InnoDB and XtraDB is available for download.
Key features:
tar4ibd is made to be sure that read of InnoDB page is consistent. Before we had some complains what in stream mode some pages are getting corrupted, and we suspect tar can do read of pages in time when they changed. So we patches libtar to make read consistent.
Export is added to support moving .ibd tablespaces …
[Read more]