I posted some code to the MySQL Forge at:

http://forge.mysql.com/snippets/view.php?id=52

Basically I gather some stats on my webservers in a very crude way. It runs a bunch of commands on the commandline (I run it every 5 minutes from a cron script). Please note that it adds to the load of the database server by running these commands, and it connects a few times to the database, so it actually increases things like “total # of connections” by the sheer fact that it runs.

This should run on most Unix machines, running most versions of MySQL. Please comment to this entry if you find something wrong or an incompatibility.

An explanation of the code follows:

This script will produce a string that looks like this:
(’value’,'value’,'value’,123,’value’),
and all you have to do is add a line at the …

I posted some code to the MySQL Forge at:

http://forge.mysql.com/snippets/view.php?id=52

Basically I gather some stats on my webservers in a very crude way. It runs a bunch of commands on the commandline (I run it every 5 minutes from a cron script). Please note that it adds to the load of the database server by running these commands, and it connects a few times to the database, so it actually increases things like “total # of connections” by the sheer fact that it runs.

This should run on most Unix machines, running most versions of MySQL. Please comment to this entry if you find something wrong or an incompatibility.

An explanation of the code follows:

This script will produce a string that looks like this:
(’value’,'value’,'value’,123,’value’),
and all you have to do is add a line at the …

Monty is sitting next to me and he noted that online ALTER TABLE will be available in MySQL 5.3 for adding columns and indexes. Is nice! This has been a feature in Microsoft SQL server for a while now.

NDB has this now in 5.1 (beta) for ALTER TABLE when adding new indexes.

I recently tested innotop on Microsoft Windows. There was one slight glitch, but I changed a couple lines of code, and now it runs out of the box under ActivePerl. Version 0.1.156 contains those changes for Windows compatibility. How to install I installed it under ActivePerl 5.8.8 build 819: Download and install ActivePerl After installation, open the Perl Package Manager from Start/Programs/ActivePerl 5.8.8 Build 819. Select Time-HiRes, DBD-mysql, and install them.

So, in going around the room at mysqlcamp this morning, only one person mentioned having using another database (SQL Server & Sybase). Another mentioned Access…..but that’s not a “real” database.

But many people mentioned connections to Oracle — be it “used to work for Oracle” or “used to use Oracle”. I think this speaks to how similar Oracle and MySQL are. Now, there are PLENTY of differences. But compared to Sybase, Microsoft SQL Server, Ingres, Postgres and IBM DB2, it sounds like MySQL and Oracle are closer to each other than MySQL and any other database.

So, in going around the room at mysqlcamp this morning, only one person mentioned having using another database (SQL Server & Sybase). Another mentioned Access…..but that’s not a “real” database.

But many people mentioned connections to Oracle — be it “used to work for Oracle” or “used to use Oracle”. I think this speaks to how similar Oracle and MySQL are. Now, there are PLENTY of differences. But compared to Sybase, Microsoft SQL Server, Ingres, Postgres and IBM DB2, it sounds like MySQL and Oracle are closer to each other than MySQL and any other database.

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, …

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, …

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 …