I took the chance today to order some books from Amazon today to add to the library. Of course I’m still reading 2 current books Spring in Action and the MySQL Certification Study Guide in order to site the second MySQL Professional Certification Exam.

As with most things, you start off looking or reading on the web for something and you end up completely somewhere else. In this case, it was looking at Linux Software Labs (Australia) at the price of their Linux Distribution CD’s, which lead me to the book Beyond Java listed on their site. …

Is it possible to break the referential integrity when a foreign key constraint is set on an InnoDB table? The answer is an (unfortunate?) yes.

A little example demonstrates this:

mysql> CREATE TABLE t1 (
    ->   id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
    ->   ) ENGINE = InnoDB;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO t1 (id) VALUES
    ->   (1), (2), (3);
Query OK, 3 rows affected (0.02 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> CREATE TABLE t2 (
    ->   id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    ->   id_t1 INT NOT NULL,
    ->   FOREIGN KEY (id_t1) REFERENCES t1(id))
    ->   ENGINE = InnoDB;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO t2 (id_t1) VALUES
    ->   (3), (2), (2), (3), (1);
Query OK, 5 rows affected (0.00 sec)
Records: 5  Duplicates: 0 …

A friend of mine was getting the following error and called me up. After telling him how to fix it, I decided to post it here too. Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) The solution was simple, just start MySQL :)

--
Did you know you can help educate the world through your bookmarks? Join my alpha project featuring social media tools (OpenEncyclopaedia.com) and share your bookmarks while educating the world.

The virtual doors have opened for registration for the 2006 MySQL Users Conference. This annual event is an unmatched opportunity for database developers, DBAs, users, and vendors to gather together and share the latest information on MySQL and open source technology. The theme for the 2006 conference is Discover. Connect. Succeed. Scale Your Business with MySQL. The conference brings over 1,000 MySQL and open source enthusiasts to Santa Clara, California during April 24-27.

As I just told, my new job requires me to do a lot of work with PostgreSQL, which is relatively new to me, since I have done almost all of my database work with MySQL so far.

I also told that this will give me a wider perspective on RDBMS in general and I would like to use this opportunity to discuss about how features are implemented in MySQL and how in PostgreSQL.

Don't worry, this will not end up in a MySQL vs. PostgreSQL fight. As I know MySQL much better than PostgreSQL, I do understand that this position doesn't allow me to make representative judgements on which database system is better (most people would naturally prefer the one they know better). I also believe that both of them are great RDBMS and none of them deserves to be involved in a "A rulez, B suckz" struggle (I love MySQL and I try to fall in love with …

This Monday, I started my new job at a web & software developing company.

Most of the time, the first week on a new job is very tough - everything is unfamilar, you don't know everybody and everything seems strange. I know that from the time when I started another job in 1996 in a Controlling departement (something very different, business stuff). There was a lot of frustration in those days, but not this time. I could describe my feelings best to simply call it "excited".

However, it's still tough, but not because of the job itself, but for the fact that the company resides about 60 kilometers from my hometown (that are 120 km/day, 600 km/week). Where I live, weather is often very bad in winter, roads are slippery, much wind, much snow and most of the time I have to drive in the dark (just the last few minutes before I arrive in the morning it's lightening up). It's sometimes quite dangerous and requires careful …

I've just got an email that I was accepted as a presenter for the MySQL Users Conference 2006. My 45 minute session is devoted to "Dynamic SQL in Stored Procedures", which I honestly know little about, except that I implemented the feature.

I'm glad I'm coming again this year, although I'm a bit nervous as the talk is dedicated to DBAs, and my DBA experience is quite modest. The idea of the session is to show how to move DBA's existing scripts into a database and use DSQL for some routine administration tasks, such as optimizing tables, truncating logs, etc. Dynamic SQL is the key component here because it allows DBAs to first query their database metadata, and then construct administrative commands in accordance with it. That can't be done with basic stored procedures functionality.
5.1 …

Builder.au has selected MySQL 5.0 as the editor's choice in their recent road test of databases comparing MySQL, SQL Server, DB2 and Oracle.  Hat's off to the MySQL development team for making this happen.  We're very proud of all of the new capabilities in MySQL 5.0 and it's nice to see the hard work recognized, especially when compared to some pretty stiff competition.  Here are a few select quotes:

• "Release 5.0 of MySQL is really taking it to the Oracle and DB2 with advanced features such as cluster support and fault tolerance and in most other departments the features run head to head with the competition. Non-SQL junkies can take heart with the GUIs dramatically reducing the reliance on the CLI, bringing administration and configuration within the realms of the novice. MySQL V5.0 is a compelling product and it is hard to argue against its nomination for the …

Yay! Can't wait for March 2006 to come :). There is a little problem though, the evergrowing list of bugs :( We made the numbers for our team go under 100 last month only to see it grow back to 120 while me and Dmitri were on vacation :(

Yes we're still swimming in the nearly 250 submissions for the MySQL Users Conference.
You will have seen some people scribble about already being accepted, and of course the conference site is now live for registration with all 10 tutorials listed and a number of speakers.

If you made a submission, and haven't heard anything yet, please don't dispair. No news is... no news!
We will get back to you! And many of you will find an "accepted" note in your mailbox. But even if you get a "declined", know that your submission was probably still really good...
In such cases, it could become an article for the MySQL Developer Zone or another online or paper magazine, a whitepaper or case study, or perhaps be used at another conference in the coming year.
Really, we don't want all those excellent proposals go to …