Welcome the the 101st edition of Log Buffer, the weekly review of database blogs.

This edition was originally claimed by Ward Pond for his SQL Server Blog. Unfortunately, Ward is, in his own words, “dealing with the aftermath of a burst appendix,” which is a very good reason not to spend your time at the computer. Ward, heal up soon! We’ll see you on LB before too long.

In lieu of the normal Log Buffer, I throw it open to our readers. Please leave a comment mentioning your favourite database blog items from the week that was, and anything else you care to say about them.

LB will be back to normal next Friday. See you then!

After a period of inactivity I was hacking back on a Drupal project, I had taken a mysql dump from a production platform and imported into my local dev setup, just to have some realistic data.

All of a sudden some forms started failing with the following error:


user warning: There is no 'user'@'nonlocalhost registered query: insert into blah (stuff,morestuff) values (x,y) in /var/vhost/drupal-tree/includes/database.mysql.inc on line 172.


My Drupal data connection was correct and working for selects etc.. only a limited set of inserts failed.

After some debugging I realised that the error was not Drupal related, running the same query on my MySQL console gave the same error.


ERROR 1449 (HY000): There is no 'user'@'nonlocalhost' registered


The error came from a trigger on the table I was inserting data into that had been created on the …

A common misunderstanding seems to be that the only way to increase the available “paper space” for a diagram is by increasing the size of the paper. But there is another way to do that, which is in the Model -> Diagram Size dialog, where you can set the number of pages your diagram has, vertically and horizontally (perhaps it’s not very obvious to first time users, so we’ll be working on making it more easily accessible).

Another recurring issue is that of printing in the community version. Direct printing is …

La registrazione del webinar e le slide sono presenti qui.
Di seguito riporto la sezione di domande e risposte:
Q from Ivo: Tutte le considerazioni sulla scalabilita' fin qui individuate sono valide anche per la versione community di MySQL?
A: si

Q from Alex: Mysql Proxy per la suddivisione delle richieste lettura scittura è ad oggi stabile ?
A: MySQL Proxy e' ancora in fase alfa e non e' consigliato l'utilizzo in produzione.

Q from Massimo: Qual'e' il metodo migliore per il backup incrementale di un db?
A: E' necessario attivara il binary log ed effettuare le operazioni di FLUSH LOG al momento del backup.

Q from Mauro: Ci possono essere applicativi web che inseriscono dei dati nel DB, e che subito rileggono i dati inseriti. Dato  che la replicazione è …

To coincide with EURO 2008, I’m embarking on a virtual European tour, taking a quick look at open source policies and deployment projects in the 16 nations that are competing in the tournament.

According to statistics presented by Roberto Galoppini, 2.4% of visitors to SourceForge are from Poland, a statistic which serves its purpose of being both interesting and pointless at the same time.

Also statistically meaningless in terms of open source adoption, but nonetheless interesting is the …

There's an interesting post from a few weeks back by Guy Kawasaki in an article entitled "How to pickup a VC." While it's a short piece illustrating how boneheaded "attention grabbers" will work against you with VCs, I think it's actually quite a good reminder about effective communications for any IT vendor. I can't count how many times I've sat through a vendor pitch or product presentation and after 20 minutes I'm wondering "Why don't they just tell me what it is that they do?" Instead, I get a lot of discussion about open source freedom, community, business models, licensing... READ MORE

OK, now I know that the GA version of 5.1 is rapidly approaching. PBXT compiles with the latest release of MySQL without any changes!

This has never been the case before. Just search the PBXT code for MYSQL_VERSION_ID, and you will find things like:

#if MYSQL_VERSION_ID < 50114
    XT_RETURN_VOID;
#else
    XT_RETURN(0);
#endif

and, even worse:

#if MYSQL_VERSION_ID < 60000
#if MYSQL_VERSION_ID >= 50124
#define USE_CONST_SAVE
#endif
#else
#if MYSQL_VERSION_ID >= 60005
#define USE_CONST_SAVE
#endif
#endif

The lack of changes that affect pluggable storage engines can only mean that the bug fixes required are diminishing in scope.

And I believe this is a far better gauge of whether GA is close than any other …

Hi,

Today’s MySQL Weekly Seminar is third one, which theme was “MySQL Storage Engines”.  It seems that almost 80% of attendees are using InnoDB for their system.  However, there are actually more storage engines available for MySQL.  This time, Kajiyama; MySQL Technical Evangelist presented variable storage engines along with tips and examples for how to use them.

First, the seminar started with the introduction of popular MySQL storage engines such as MyISAM, InnoDB and Falcon.  He described architectures and features for each storage engine and what storage engine is appropriate for each application.

Then, it went deeper into storage engines details.  Each engine has specific features.  And third-party storage engines’ unique functions and next-generation transactional storage …

I should have written about it a while ago but I never had a change.
I'm speaking at Velocity conference taking place in the Bay Area 23-24 of June.

At the same conference we will have a book signing event for our book High Performance MySQL 2nd Edition which is finally in printing and should start shipping next week.

Entry posted by peter | No comment

Add to: …

MySQL 5.1.24-rc ships with a EXAMPLE storage engine which is basically a dummy storage engine and serves as a useful source to start writing your own custom storage engine.

However, it is not available for use, by default. You can verify this as follows:

mysql> show engines;

+------------+---------+-----------------------------------------------------------+--------------+----+------------+ | Engine     | Support | Comment                                                   | Transactions | XA | Savepoints | +------------+---------+-----------------------------------------------------------+--------------+----+------------+ | …