Possibly Ubuntu’s fault too for shipping the not-latest un-bugfixed release. But either way, it’s really annoying seeing the “Document Recovery” screen more than the edit text widget.

Copy and Paste slides in Impress is not flakey - it’s damn right crushed to pieces. Occationally it does something useful - like paste and not crash.

update: yes, i am just using it to put together presentations for our upcoming devconf - as well as the user conference. Why these things are so hard to do is beyond me. A simple app that didn’t crash *cough* magicpoint *cough* is looking rather superior at the moment.

update part 2: yes, the title changed. arguably i like this one better. although adding “right under the fingernail” is tempting

While reading planetmysql.org I ran across this Tune a MySQL server in 5 minutes.. I think that entry is really missing a lot in terms of actual tuning for the real world. Also I thought max_user_connections is number of connections per hour. Since I only have 3 minutes I can’t look it up! You probably don’t want to set this with apache.

So here in three minutes are the four variables you really need and some generic guidlines for setting them. This assumes that MySQL is running on it’s own server and has one apache server connecting to it.

Yesterday, I finally installed the MySQL 5.1.7 beta. It took some help from Markus to get it up and running, and this morning, I made a start to update the MySQL information schema diagram that I've been maintaing since june 2005.

To begin with, I just added the new information_schema tables to the original visio diagram. I also reworked the layout to put the tables that are in the same functional category near to each other. (In the previous version, the privilege tables were scattered throughout the diagram).

I put the EVENTS table in same category as TRIGGERS and the ROUTINES, because these all represent MySQL Programmability. I put the PARTITIONS, the ENGINES and the FILES table in a new category, because these all have to do with physical storage of data.

I still need more info on the PLUGINS table to decide where I should put it (it seems …

Everybody who can tune a MySQL server in 5 minutes please raise your hands !

yes that's just a ridiculus blog title to attract traffic ... Rudd-O tells us about 5 variables that might have impact on the performance of your database , but really how long does it take you to do a real analysis of where the problems are lying , and how to fix it.. I bet it's more than 5 minutes.

I just got a Google News Alert that contained the URLs of two great articles on the issue of software patents: one by eWeek’s Steven Vaughan-Nichols and another one on Computerworld.com by Martin Goetz, who in 1968 received the first US software patent ever. Both articles appeared on the occasion of the settlement of the patent dispute over BlackBerry, which I mentioned in my first blog entry here.

There have been plenty of columns on US Web sites that talked about the negative implications of software patents. However, a mistake made by most US columnists (as well as some over here in Europe) is that they falsely believe one could …

Hello -

Many of you have requested that MySQL offer multi-source replication and/or provide built-in replication conflict resolution. I’m happy to tell you that our engineering team is underway with this effort. Our replication leads have asked for customer input on their proposal, and so I would like to solicit your help in reviewing the plan. Please feel free to look at just the broad plan or dive deep into the details. Shoot me a mail at rschumacher@mysql.com, and I’ll forward along their proposal.

Again, it’s through your input and help that we ensure the features we implement meet the needs you have in your daily use of MySQL - thanks for taking the time to assist!

Whenever we poll our users, the topic of performance tuning and optimization always scores the highest interest level. So at the MySQL Users Conference, we have a full track devoted to performance tuning.  (Hey, we're not dummies. Everyone wants a little extra performance!) This includes best practices presentations by some of the elite performance gurus from inside MySQL and among our top users and partners.  This includes talks by people like performance engineer Peter Zaitsev (pictured above), community guy Jay Pipes, Optimization wizard Timour …

Alfredo announced the availability of version 1.0.5 beta of the MySQL Workbench, the latest product in the MySQL GUI tools family (also check out the Administrator, Query Browser and the Migration Toolkit).

I downloaded the RPM for SUSE Linux 9.3, which installed flawlessly on my SUSE 10.0 system. To test the reverse engineering capabilities, I installed the latest version of the Sakila …

I made reference previously to Testing/Trialing new MySQL Releases using VMWare.

Well, I’ve just about completed my own Image for the lastest MySQL 5.0 (given I’m now running MySQL 5.1). I’m interested in sharing my experiences, and even providing some images for users if there is any demand out there.

What I’ve decided on is to use the VMWare supplied Browser Appliance which is Ubuntu 5.10. The great thing is the image autoboots into graphical mode, auto logins and loads a browser. My goal now is to get a suitable startup page describing the MySQL environment, links, manual etc.

The only requirements to run would be the …

I started poking around with the engine inside of Samba last night. Tridge had mentioned it to me at linux.conf.au.

After some hacking of the source to get it to work in our tree, I now have:

mysql> create table a (a int) ENGINE=tdb;
Query OK, 0 rows affected (0.02 sec)

mysql> Bye
[brian@zim sql]$ !ls
ls ~/mysql-builds/example/var/test/
a.frm a.tdb t1.frm t1.MYD t1.MYI t2.frm t2.MYD t2.MYI

Shame I have a flight tomorrow or I would poke at this a bit more and see what a couple more hours would get me :)