In order to really check what currently has made it into 5.4(there has been rumors...) I wanted to branch the code and see for myself.

Couldn't find it at first in our internal code repository since it's actually not named 5.4 there yet. Fortunately it's also pushed out to launchpad, that means you can easily get a copy of the code using bazaar

$> bzr branch lp:mysql-server/5.4

There is of course also tar balls available from our download page
http://dev.mysql.com/downloads/mysql/5.4.html#source

Anyone curious about what our internal name is? :)

The Oracle User Community's big yearly event, Collaborate 09 in Orlando begins this week. This is going to be a hot conference bringing together the Oracle user communities top technology experts and industry leaders together. During this time of dynamic change it is an invaluable experience to bring get Oracle's top industry leaders for a week of meetings, presentations, discussions and

Second Life Presentation on Sun Solaris Campus This virtual world presentation will be delivered at the Sun Microsystems Islands on the Solaris Campus. Up above, I'm chilling at the Solaris Campus on one of the Sun virtual islands.Second Life Presentation on Sun Solaris Campus The MySQL open source database continues to increase in popularity with usage estimated at 12 million

Second Life Presentation on Sun Solaris Campus May 5, 2009 9:00 am PDT This virtual world presentation will be delivered at the Sun Microsystems Islands on the Solaris Campus. Up above, I'm visiting the Solaris Certification Center.Demystifying MySQL for Solaris Administrators George Trujillo (Ty Valdez) and Steve Jones will be presenting a Demystifying MySQL for Solaris

After the morning and afternoon tutorials today by Andrew Eddie (Joomla dev lead), tomorrow is Joomla Day - Brisbane Joomla Users Group where I’ll be doing talk as well.

I’ve already noticed that Joomla users are a slightly different crowd. Joomla is a pretty powerful CMS with many modules/extensions, just like Drupal which runs the Open Query web site. I’m not sure the two even compete directly although there might be some overlap. It occurred to me that Joomla might be what I would call an “enabling technology” on the web, just like PHP and MySQL have been since 1995. It has a very easy entry, which of course is both good as well as bad. Again that’s quite similar to the M and the P…. love it or hate it.

I’m kinda agnostic on the subject of CMSses, there’s quite a few out there and I think that most of the …

now also support table/index scan as root node, i.e tree = [ scan ] ? [ lookup ] *
still with the limitations:
- a child may only be dependent on immediate parent
- still only left outer join.

i also completed the parameterized scan-filter inside tup but does not yet support this in spj or ndbapi.

currently working on
- the parameterized scan-filer in spj (and a tiny bit in the ndbapi).
- result set correlation

currently thinking on
- arena based allocator for spj-requests, (compare mysqld mem-root concept)

discussed with frazer what spj "really is", concluded that it probably is some kind of "data-flow-engine"...should probably find some hip acronym/term for it...

note:
current mental capacity is limiting spj to only one scan in a tree.
this limitation can of course be lifted...but not now, or my brain will fry. …

I’ve developed a MySql manager back in 2000 for MySql 3.23 using Borland Delphi. The software was used internally in a company. I’ve decided to switch completely to web based application development. I found ExtJS and I was amazed! … Then I thought what application to develop in order to get some ExtJS experience, so […]

With a lot of talks around 5.4 I decided to check how it works in our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB buffer_pool) and tested it on our Dell PowerEdge R900 box (16 cores, 32GB of RAM, RAID 10 on 8 SAS 2.5" 15K RPM disks). For comparison I took XtraDB-release5 and 5.0.77-highperf percona release.

For raw results you can check my Google Spreadsheet (it is also being update with my next CPU benchmarks, and benchmark on SSD & FusionIO), also I post graph there:

Results are in TPM (transactions per minute, more is better).

So I can confirm that MySQL team did great job with 5.4 and it shows the best results.
Some more results you can find on Dimitri's blog, one of Sun Performance Engineers.

…

We have an Admin plugin for the MySQL Proxy, but people started asking how to use it. I only found one example, thanks to Giuseppe, but people wanted more.

While the admin plugin is somehow limited, it already provides some nice features. One of the use cases is to give access to information to only authorized users. The Admin plugin uses its own username and password to authenticate users. This is not related to any user on your MySQL server.

The example.

I went ahead and put two scripts together in about an hour. They are basic, but should give you more of an idea of what you can do.

Number of queries …