Maatkit (formerly MySQL Toolkit) has for some time been released both as a bundle, and as individual tools. It’s too much work to maintain the individual packages, and I don’t think it really benefits anyone much, if at all. While the tools will still be versioned separately, I’m going to discontinue releases of the individual packages, and just release the one uber-package from now on. This will also make it easier for me to manage the name change, but that’s just an extra incentive; I’ve been considering this for a while.

I am so lucky I married an archaeologist. Choosing a new name for MySQL Toolkit has been a hassle. I wanted to avoid a literal name, such as, um, MySQL Toolkit. Short is good. And so on, and so on. All the while, the Phoenix/Firebird/Firefox naming debacle was in my thoughts. I only want to do this once. At first I tried not to stray too much from the current name.

Premature Optimization ... we all know it. The proxy is now in a state were we can start to optimize the code a bit. After getting some complaints about the performance with keepalive I took a deeper look into the problem and came up with:

• a global script-cache with reload on cache
• less GC-runs
• less overhead per lua-script-call

It is all in SVN now, enjoy it.

To test if we make progress I use mysqlslap in its most basic form:

$ mysqlslap --host=127.0.0.1 --port=4040 \
  --create-schema=mysqlslap --iterations=1000 --concurrency=10

which only connects and closes the connection again.

The run-time over 10.000 connects is

proxy, no cache, lua_gc()  11.553s
proxy, cache, lua_gc()      7.065s
proxy, cache, no lua_gc()   6.458s

I just implemented a script-cache for MySQL Proxy and had to learn a bit more about lua internals. As a result I wrote two functions which are generic enough for general consumption:

• luaL_loadfile_factory()
• luaL_loadstring_factory()

They also show how to write a lua_Reader for lua_load().

The #lua channel on freenode was a great help, as always.

LUA provide several loaders:

• luaL_loadstring
• luaL_loadbuffer
• luaL_loadfile

and you can create your own if you have to.

Now, why the need for a new loader ?

The proxy we have

• a global scope caches the scripts
• this cache reloads the scripts if they changed on disk
• each thread executes the same script
• each thread has its own …

Damien Katz and the CouchDB development team are proud to announce:

CouchDB version 0.7.0 is now available.

This release is a major milestone in the project’s history.

Key features include:

• a REST API using JSON instead of XML for data transport,
• a JavaScript view engine based on Mozilla Spidermonkey,
• a GNU Autotools build system supporting most POSIX systems (Noah Slater),
• a built-in …

So, I got my new MacBook 13" - since Apple updated the chipset. That ups the speed to 2.2GHz (it's a Core 2 Duo), has better graphics (apparently, don't think I care too much for that), but most importantly, it can now handle up to 4GB of RAM. Not that you should get the 2x2GB from Apple directly (the other ram upgrades are not that expensive with them actually) but here they decided to ask for a whopping $1250 or so. Daft. Got the memory sticks from elsewhere, of course. The 4GB is glorious! No swapping, very responsive, even with lots of stuff open. Great.
Note that I ordered the MacBook directly from the Apple store, because the local shops in AU didn't have the new model yet (different warehouse apparently).

New Macs come with OS X 10.5 (Leopard). Very shiny. Time Machine is particularly cool, as is the GUI profiler that's part of Xcode. Lots of other little things improved and fixed. Although I'm not sure I like the new …

Welcome to the 71st edition of Log Buffer, the weekly review of database blogs. There were so many blogs covering this week’s Oracle Open World that I could have devoted this entire edition only to that. But that would not be fair to those other DBMSs, all of which are fine DBMSs in their own [...]

Background Knowledge

The MySQL database v4.0.23 is using the default character set of “Latin1″. When the database was created I had no knowledge of character sets other wise it would have been “UTF-8″.
The web pages are using a character set of “UTF-8″.

Problem

Data being queried from a MySQL database that contains French accent characters will not render correctly in the browser even after applying PHP htmlentities().

Example code: $string = htmlentities($string , ENT_QUOTES, “UTF-8″);

Solution

The queried data from the database was inputted using the character set “ISO-8859-1″. I …

Quick... You have to let everyone (boss, biz dev, customer service, and random bean counters) know why everything is moving slowly! Of course, rarely do people define what "everything" is, and what type of slowness is occuring. But, in the face of customer service agents that cannot work because their pages will not render, generally all eyes are on the famed-dba-of-the-minute.So, with 7 people

Use MySQL? On Leopard/OS X 10.5? Yes, the current available packages from dev.mysql.com don’t work very well. I track “mysql” on Twitter, and boy, are there heaps of complaints.

So its nice to see, Dan Benjamin, a member of the MySQL community, stepping up, and creating the amazing Installing MySQL on Mac OS X article. The Preference Pane will obviously still not be there, and I don’t know why he thinks Mantorg (?) will build it, but I believe this is something MySQL needs to fix for the next release.

Tracking mysql#28854 will be useful.

Mark Pilgrim decided that it would be cool to poke fun at OS X, because it “just works” on Ubuntu. While what he …