Small but good interaction with Bill Karwin of Zend, Taso Du Val of Fotolog and others during the MySQL Camp session on mysqlnd native PHP driver that I’ve blogged about earlier.
Ulf Wendel of MySQL will soon be posting a survey on the new API calls to mysqlnd, so stay tuned for that.
google, google tools, mysql tools, mysql utilities, mysqlcamp tools
Chip Turner, been @ Google approximately 1.5 years.
http://code.google.com/p/google-mysql-tools
Right now you have to click “source” and then browse the subversion tree’s trunk.
These are tools written at Google that are frequently used, and perhaps useful for other folks.
So what’s there, how does Google use the code, …
[Read more]google, google tools, mysql tools, mysql utilities, mysqlcamp tools
Chip Turner, been @ Google approximately 1.5 years.
http://code.google.com/p/google-mysql-tools
Right now you have to click “source” and then browse the subversion tree’s trunk.
These are tools written at Google that are frequently used, and perhaps useful for other folks.
So what’s there, how does Google use the code, …
[Read more]I'm taking notes from the MySQL core kernel talk:
The core has an architecture like:
Parser Optimizer Storage Layer The storage layer has a Handler and Handlerton. Handlers are the real storage engines but Handlerton is new in MySQL 5.1.
On startup MySQL calls main() and then a plugin init.
The plugin has a UDF handler for user defined functions. It also has a fulltext handler which was originally written for CNET. The fulltext handler allows one to parse out all BLOBs sent to the database. This seems like a cool way to add Lucene support to any type of MySQL storage engine.
There's a new super cool plugin named Daemon which one can use to embed daemons within MySQL. For example someone embedded Apache as a Daemon plugin so that you could get "show processlist" as XML via HTTP. The were going to call this raw but it was too …
[Read more]Here’s a very rough pre-release of NdbObject, an ORM mapping for python that maps Objects to NDB directly with no SQL code.
At MySQL Camp (over 200 registered participants!), one of the first sessions was lead by Jay and themed “Measuring the MySQL Community”.
The purpose of having MySQL community metrics is to know how MySQL is serving its community. At which rate is it growing? Or is it shrinking? Ideally, we would be able to say “in October 2006, the number of installations of MySQL grew by 3,2 % from 10 340 455 to 10 671 350 installations” and “the community activity index grew from 10,4 to 10,8“.
There are built-in problems with this, though. While we know that we have over 10M yearly downloads, we don’t know how many of those are in active use. And we know many get their MySQL packages from distributions.
Sheeri Kritzer proposed making a the server “scorebord” public. Basically, SHOW STATUS information would be aggregated as a service …
[Read more]When Jeremy left yahoo a lot of people were left wondering “who would be the next Jeremy?” some people thought it would be me. Since then I have been asked several times why I’m not going to take a turn in the ivory tower. Now that things are in place the secret can be let out. Jeremy’s startup Proven Scaling is not just Jeremy’s startup but our startup. We have decided to take our MySQL skills and apply them to the problems of several companies.
Eric Bergen
MySQL Geek / Owner
Proven Scaling L.L.C.
eric@provenscaling.com
I am sitting in JD Duncan's session "Introducing mod_ndb, a REST
Web Services API for MySQL Cluster" as it is really interesting.
I kind of wanted to attend the SolidDB storage engine session and
the community session happening concurrently, but the mod_ndb
stuff is pretty cool.
I am going to try to get the presentation files hopefully from
JD.
In case you are wondering, NDB = Network Database.
The HTTP Database uses HTTP instead of SQL. He is planning to
create a good HTTP database in the future.
How to get mod_ndb:
(If you are at Google) http://192.168.22.214/code
otherwise: jdd at mysql dot com
Random Notes:
If you are a "PHP shop" its beneficial to use
multithreading.
"sort merge join is better than nested loop join" …
Like everyone else, I am very excited to be at Google
headquarters attending MySQL Camp. There are more than 200
attendees at the camp, which is really exciting. During the last
couple of days, the number participants literally doubled. Folks
from YouTube,
Google,
Yahoo and of
course MySQL
are all here.
So far I have met Jay
Pipes, Jeremy
Cole, Eric Bergen, Paul Tuckfield (YouTube and PayPal:paul at
tuckfield), Kaj Arno and …