mysqlconf, mysqlconf07, presentation video

For folks to know — to create the page with links to conference material, I took the slides from the O?Reilly official page, combines it with the myriad of ?here are my slides? posts to Planet MySQL, and links to Baron, Kevin and Mike?s audio and video as well as the video and audio I processed (Because Baron made statements about bandwidth, I downloaded the .ogg files and technocation.org is hosting them, whereas Kevin and Mike?s files are linked to).

I know I hate going to 20 places to find everything I want. There?s no need for folks to have to go to more than one site, just because the content …

This is a drawing for my ideas on the future of opentaps, namely:
1. A set of core opentaps ERP + CRM applications for transacting business day throughout the enterprise
2. Bringing in analytics and search tools
to help make better sense of the data
3. Integrating with devices of all stripes, for mobile phones to robots to shop floor machinery, and of course the desktop.
4. Pulling all of these components together into a unified front end.
5. Supporting it with documentation and context sensitive help.

The big unknowns are what that front end will be and how it will be developed. Would the user interface of the future be the desktop, the browser, a mobile phone, or something else entirely different? Or would there simply be more choice of how we interact with …

MySQL Connector/Net 5.1.1 a new version of the all-managed .NET driver for MySQL has been released.

This is a big release and represents a change in how we package our products. Until now, we've shipped our core provider and the Visual Studio integration bits as separate downloads. This has become a bit of a problem. Often we would fix a bug that involved changing code both in the VS package and in the core provider. This provided a versioning problem where users would need to upgrade both products to see the benefit of the bug fix. To solve this, we've decided to discontinue Tools for Visual Studio as a separate product and have, instead, integrated it into a new Connector/Net installer. We hope this provides a better "out of box" experience for our users.

All previous versions of Tools for Visual Studio should be uninstalled prior to installing this product.

Version 5.1.1 works with all …

On Saturday, June 16 2007, Ibuildings and Zend Technologies are organizing the Dutch PHP Conference 2007. The event is intended for professional PHP developers and will be held in the RAI in Amsterdam.

The program is mostly in English, offering about 15 speakers and three separate tracks: Frameworks, Case studies and a separate data-oriented/database track. I will be speaking there about MySQL stored routines, and how …

Sheeri, a good friend of mine has been working very hard to record, process and then publish hours and hours of MySQL conference videos. She has published the recordings on Technocation.

One request that I wanted to make to everyone is that if you download videos or presentations from Technocation, please consider giving a little back in form of a donation. All that goes in Technocation is ultimately for the benefit of the community. And remember, every little bit counts.

Kristian is currently talking about the new NdbRecord API for the NDBAPI and how it relates to ha_ndbcluster (the mysql storage engine, which uses ndbapi to talk to the cluster nodes) and how it can be used by ndbapi applications.

It looks like we’re getting a really neat API that avoids so much mess and makes it possible to write incredibly efficient mappings between what comes over the wire from data nodes and whatever internal structures the application wants to fill out.

Talking about this and Monty Taylor’s ORM mapping stuff could be very interesting.

A few days ago, I received a MySQL Chart from Bob Stein of VisiBone and immediately hung it on the wall.

And just a minute ago, I used it for the first time to check the syntax of an INSTR() command I couldn’t get to work. Sure enough, there’s a small “bomb” icon next to it to make me aware that the order of the arguments may not be what you expect.

Even though the poster is large (61cmx85cm / 24″x33″), there’s a lot of information that’s been stuck on there and it takes a few minutes to learn to navigate it properly. But once you get it, it’s a great tool to quickly look up syntax and other information.

There’s a lot of small icons beside each command and function giving some hints about best usage, things to be aware of, etc. — Including a black circle to tell you that …

Today is Fotolog's 5th birthday. For a quick history of Fotolog, see John Borthwick (CEO) and Adam Seifer's (co-founder) posts.

From Peter Z's Blog: http://www.mysqlperformanceblog.com/2007/05/22/wishes-for-mysqldump/

I noticed this:

Parallel restore This is absolutely required if time is the issue as serious systems may perform much better in such case.


In 5.1 I added the following option to mysqlimport "--use-threads".

With it you can now tell mysqlimport to use multiple threads while doing an import of a backup made with mysqldump where you specified dumping the database in tab format. I don't believe I have a graph anywhere showing the speedup, but its pretty damn impressive.

Oh, and what is especially nifty about this?

Just take a copy of mysqlimport from the 5.1 distribution and use it on your previous versions of MySQL. I can't promise it will work with …

Here are some random thoughts, notes, observations, etc.

Jay Pipes - he made the conference possible

• Friendster uses Bugzilla internally. Yes they’re still alive, even though MySpace and so forth are around and kicking. Had to Google them (I wanted to find their old talk about their storage engine), and found MySQL Customers - Friendster, instead. From 2005, Dathan’s (now at Flickr) presentation. Never did find the storage engine stuff, beyond random bits in the press.
• Probably the best blog post that hit Planet MySQL, as opposed to the session summaries and so on, comes from …