I have been helping customer today to resolve his lockups in production by downgrading from MySQL 5.1.25 to 5.0 We have other customers (and our own projects as well) which run on MySQL 5.1 successfully but I can't it is on par with MySQL 5.0 stability yet.

This given customer was running MyISAM on FreeBSD with quite basic queries, so may be there are some issues with FreeBSD and MySQL 5.1 still ?

Entry posted by peter | 11 comments

Add to: | | …

I was sitting in a train in the middle of rainy Ireland when I received a mail that Nokia has bought Symbian and is releasing it as Open Source. I didn't believe a word of it. But the web was full of news about it, so it was true. This is an amazing turn of events that I didn't anticipate at all. (You may or may not know that in my previous job I was heavily involved with Symbian programming. Ironically, one reason I left just 6 months ago is that I wanted to work in an Open Source environment :-)

read more

Blogs are good for many things. One of them is not easy aggregation. So I decided to make this digest blog of the 71 blog entries I’ve written so far in 2008.

The first category is Sun-MySQL acquisition and integration. To be specific, the first blog entry in this category didn’t even touch upon Sun; on 7 January 2008, I noted that nearly all of us 400 MySQLers met in Orlando, Florida. Then and there, on 16 January, we announced that Sun acquires MySQL. The same day, I spoke to the MySQL founders Monty and David on their Sun feelings, and bragged that we “ …

So how do I start explaining about decision tables? Well, its an interesting subject..

Introduction

What does wikipedia say ?
"Decision tables are a precise yet compact way to model complicated logic. Decision tables, like if-then-else and switch-case statements, associate conditions with actions to perform. But, unlike the control structures found in traditional programming languages, decision tables can associate many independent conditions with several actions in an elegant way."

Decision tables, for me, seem to make sense in that they model logic into an understandable table-diagram that can be checked easily.


…

Over the past few years, Oracle has bought nearly every enterprise software company in existence, but comparatively few database-related vendors (Sleepycat, InnoDB, etc.). This hasn't mattered, however, as it's gargantuan applications business is helping to drive its database business, now climbing to 44 percent of the enterprise market....

In October 2003, Mick Carney (the first MySQLer in Sales in France) convinced us to choose Véronique Loquet and her company Al’x Communication as MySQL’s French PR agency.

And what an excellent choice it was! Véronique and her Paris team have been with us now for nearly five years. Her contacts are excellent, as are her organising skills. She practically embodies PR for les logiciels libres (Free and Open Source Software) in France.

Véronique has visited the MySQL Users Conference in Santa Clara several times, and of course introduced us to numerous French journalists, fixing plenty of meetings for Mårten, Zack, myself and others.

Being acquired by Sun Microsystems does have many more ups than it has downs, but one …

I?ve spent the past three weeks profiling open source policies and adoption projects at the 16 nations competing in EURO 2008. Congratulations are due to Spain, which deservedly won the football championship on Sunday with a 1-0 win over Germany.

Just for fun I thought I?d also declare a 2008 Tour of Europe Open Source Champion. In deciding the winner I decided to follow the same organizational structure as the football, so read on to find out which eight nations made it out of the group stages and how I whittled it down to an eventual champion.

If you disagree with any of my decisions feel free to add a comment explaining why, but remember: the referee?s decision is final. Although the football has finished, I?ll also be …

When using MySQL in batch mode, you may often find it useful to use the UNIX shell commands along with the SQL queries. This is a demo script showing how you can achieve that:

# Mixing shell commands and SQL queries in batch mode- demo script

use test;

#INSTALL PLUGIN example SONAME 'ha_example.so'; #Ignore statement

system cp /tmp/mysqld.trace logs/init.trace # Shell commands prefixed with a 'system'

create table new4(num integer) engine=EXAMPLE;

system cp /tmp/mysqld.trace logs/after_create.trace # Shell commands prefixed with a 'system'

system diff logs/init.trace logs/after_create.trace # Shell commands prefixed with a 'system'
 

This script makes use of the 'system' command:

system  (\!)    Execute a system shell command.

Note that this is available only on UNIX systems.

When using MySQL in batch mode, you may often find it useful to use the UNIX shell commands along with the SQL queries. This is a demo script showing how you can achieve that:

# Mixing shell commands and SQL queries in batch mode- demo script

use test;

#INSTALL PLUGIN example SONAME 'ha_example.so'; #Ignore statement

system cp /tmp/mysqld.trace logs/init.trace # Shell commands prefixed with a 'system'

create table new4(num integer) engine=EXAMPLE;

system cp /tmp/mysqld.trace logs/after_create.trace # Shell commands prefixed with a 'system'

system diff logs/init.trace logs/after_create.trace # Shell commands prefixed with a 'system'
 

This script makes use of the 'system' command:

system  (\\!)    Execute a system shell command.

Note that this is available only on UNIX systems.

Because of some weird bug my RSS feeds were broken ever since I’ve upgraded to WP 2.5. Today they were fixed and I hope they’ll have some new posts there soon Stay tuned.