The past week has brought a surge of Gearman related releases. They include:
C Server
and Library
Perl Server and Modules
Gearman::XS Perl Module (based on C library)
PHP
Extension (based on C library)
PHP Extension Documentation
Drizzle
UDFs
PostgreSQL UDFs
MySQL UDFs
Some of …
[Read more]About a month ago I blogged about the debug console I was adding to drizzled. I finished this work up and it’s now in the trunk and latest release. This is implemented using the Client and Listen plugin points (which are heavily modified versions of MySQL’s Protocol class), and can be enabled using the ‘–console-enable’. For example:
hades> drizzled --datadir=/Users/eday/drizzle.data --console-enable InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use GCC atomic builtins. 090928 15:22:07 InnoDB: highest supported file format is Barracuda. 090928 15:22:07 InnoDB Plugin 1.0.3 started; log sequence number 46409 Listening on :::4427 Listening on 0.0.0.0:4427 ./drizzled/drizzled: Forcing close of thread 0 user: '(null)' ./drizzled/drizzled: ready for connections. Version: '2009.09.1144' Source distribution (trunk) drizzled> show tables in information_schema; …[Read more]
Ever wondered exactly *what* was in a Drizzle Table proto? Well, wonder no more. A while back this little utility called table_raw_reader hit the drizzle codebase. It’s a simple command line utility that takes a .proto file as an argument, reads it off disk and then prints out a text representation using the TextFormat class of the protobuf library.
An example:
stewart@willster:~/drizzle/jay-and-stewart-remove-pack_flag$ ./drizzled/message/table_raw_reader ./tests/var/master-data/test/t1.dfe
name: "t1"
engine {
name: "InnoDB"
}
field {
name: "id"
type: INTEGER
format: DefaultFormat
options {
length: 11
}
}
field {
name: "padding"
type: VARCHAR
format: DefaultFormat
options {
length: 800
}
string_options { …[Read more]
(At least in Drizzle)
Brian merged my jay-and-stewart-remove-pack_flag branch and it’s now in trunk. Removing pack_flag was a task for the bell milestone and in true collaborative effort, it took more than one person to unravel its dark mysteries. Hats go off to Jay who bravely ripped more of it out with the aid of excellent Seattle coffee. I finished it off with removing the last remnants and fixing an outstanding bug (and at the same time making us look at the DECIMAL code and shuddering in fear of what it may mean).
With pack_flag gone, we can now do insane things like remove the last bits of TINYINT from the code, as previous to removing pack_flag, if you did that, things …
[Read more]
The present in my RSS feed this morning was an article by Peter
Zaitsev on :
http://www.mysqlperformanceblog.com/2009/09/20/guidance-for-mysql-optimizer-developers/
One of the changes made recently to Drizzle, is a redesign of our executioner.
This was done by Padraig. MySQL inherited a design where the parser
uses one Global Lex Structure to fill in the members of the query
for later use. This structure has members in it for every form of
query that can be executed. The structure is also assigned an
ENUM that will be used later for determining if the query is a
SELECT, INSERT, etc... via a switch/case dispatcher.
This of course creates a number of limitations in the design,
especially for Drizzle …
I didn’t take many photos at the Drizzle Meeting, although I did take a couple at the end at the Hopvine (just down the road from Brian’s place).
A good read is Brian’s wrap up of the meeting.
But we have (courtesy of Brian):
and a couple I took at the Hopvine:
[Read more]Before I even start this post I am going to repeat our view that Oracle is well aware that it has little to gain from killing off MySQL and that we expect MySQL to become the scale-out database for non-transactional web applications and to compete with SQL Server in departmental deployments.
That said there has been some interesting discussion on Twitter
this week in response to the European Commission’s investigation
of Oracle-Sun about whether Oracle could - in theory - kill off
MySQL. Here’s a Q+A explaining my view as to how Oracle could
kill MySQL but probably won’t, and why MySQL AB’s choice of dual
licensing and the GPL has come back to haunt Monty
Widenius.
Q. Oracle can’t kill MySQL even if it wants to, because its open
source. Right?
A. …
[Read more]Sign up today for OpenSQL Camp 2009! The space is confirmed so go ahead and make your travel arrangements. The event is free and will be taking place in Portland, OR on November 14-15th, 2009. If you are interested in leading a session or presenting a talk, be sure to add it to the session ideas page. Also, we are still looking for sponsors! Please visit the sponsors page if you or your company/organization might be interested. All donations are tax deductible.
We should have representatives from many open source database (and database-related) projects. PostgreSQL, MySQL, Drizzle, memcached, and Gearman, just to name …
[Read more]As I outlined in Part 1 MySQL Proxy can be one tool for performing SQL analysis. The impact with any monitoring is the art of monitoring will affect the results, in this case the performance. I don’t recommend enabling this level of detailed monitoring in production, these techniques are designed for development, testing, and possibly stress testing.
This leads to the question, how do I monitor SQL in production? The simple answer to this question is, Sampling. Take a representative sample of your production system. The implementation of this depends on many factors including your programming technology stack, and your MySQL topology.
If for example you are using PHP, then defining MySQL proxy on a production system, and executing firewall rules to redirect incoming 3306 traffic to 4040 for a period of time, e.g. 2 …
[Read more]It appears that little MySQL has just become a disproportionally big player in the Oracle-Sun takeover deal…. article by Associated Press: EU probes Oracle’s bid to buy Sun notes:
EU Competition Commissioner Neelie Kroes said Thursday that regulators needed to examine the effect of a deal “when the world’s biggest proprietary database company proposes to take over the world’s leading open-source database company.”
Ah, Neelie Kroes. Dutch lady from the liberal (that’s seriously right-wing in NL, my American friends party, formerly minister for infrastructure in NL, long time ago.
So what can happen now? The EU can (and I’m skipping a few steps for brevity here) force the MySQL part of Sun to be auctioned separately, to allow the remainder of the detail to go through. One thing is fairly …
[Read more]