Welcome to the 160th edition of Log Buffer, the weekly review of database blogs.

MySQL

Blame it on MyISAM, says Mark Callaghan of High Availability MySQL, on considering sql_mode and type coercion. “I think that MyISAM has its place,” writes Mark. “It does fast table scans, but InnoDB is much faster on just about everything else. I am just not thrilled with the impact it has had on MySQL.”

Not that those other engines are without flaw. Peter Zaitsev reports on an InnoDB performance gotcha with larger queries.

Here on the …

Background Knowledge

With the use of Samba we are able to share files through a local network and make it appear as if the files are on the Mac OS X locally. The instructions below will step you through step by step on how to access files from the Mac OS X to a Windows XP/Vista™ system through the network.

NOTE: Instructions to unblock network traffic through a software/hardware firewall are not provided. Refer to your software/network manual or support web site for details.

NOTE: These instructions will not allow for sharing via the Internet.

Solution

Setting up a file share in Windows XP

1. Open Windows Explorer/My Computer (press Windows Key+E) or go to the Windows Start Menu -> Programs -> Accessories -> Windows Explorer.
2. Browse to a folder you wish to share and right mouse click on it and left mouse click on “Properties”. …

So we all know about the good old LAMP stack... Linux, Apache, MySQL, and PHP. It's a beautiful thing. I recently just started early development on a web application and instead of using Tomcat, Struts, Spring, Hibernate, or any of the Java-based frameworks that I am familiar with I've decided to take a step back to my programming past and use PHP with MySQL. Except this time, I'm using a Mac...

Let's start with my setup. I have a MacBook with OS X 10.5 (Leopard) so if you are running anything older this may not apply. Apache 2 and PHP 5 are shipped with 10.5 and I will talk about enabling them later.

The only piece we are missing is MySQL, and lucky us, they now make Mac binaries that you can find at www.mysql.com. Download the binary for the Mac (if you want to build the source get the tar.gz) and do the normal Mac install procedure. Once …

Yesterday evening, a friend of mine had some issues with installing DBD::mysql, and asked if I had encountered the same issue. The problem, as the output from make test showed, was that certain symbols was missing:

#     Tried to use 'DBD::mysql'.
#     Error:  Can't load '/Users/westerlund/src/perl/DBD-mysql-4.008/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/westerlund/src/perl/DBD-mysql-4.008/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Symbol not found: _is_prefix

Fair enough, this is related to a 64-bit issue with MySQL—at least with my Perl version, which is now:

Summary of my perl5 (revision 5 version 10 subversion 0) configuration:
  Platform:
    osname=darwin, osvers=9.5.0, archname=darwin-thread-multi-64int-2level

If you try to link to a x86_64 version of MySQL, then you get the above mentioned error. So, I downloaded an x86 version of MySQL and tried again. The …

As you probably know, or at least heard, we are currently porting Workbench to Linux. Generally speaking the porting process is split in several stages. The first one is to compile non-GUI Back-End which represents about 80% of the total application code. The next stage is to ensure that unit-tests are run correctly for the ported stuff. The third is to create user interface and to bind it to the back-end/core. After that we will have alpha version of Workbench for Linux.
Regarding tests, actually a portion of unit-tests are already passed. These are 121 of 122 going well. At the moment we are working on non-GUI back-end, and core part is compiled and run, so now the modules and plugins are in progress. I must admit that process of porting is pretty smooth, most of the code has already been prepared with Linux/OS X ports in mind. I will be posting our progress on the porting efforts frequently, please keep checking our blog.

Apple announced, as expected, a release date for Mac OS 10.5 Leopard. The date is October 26th, 2007 in case you missed it. Since everyone on the internet is a guru, and therefore, so am I, I will give you plebes reasons to upgrade to Leopard. But, first let me qualify myself worthy of such preachery (gurus can make up words).

1. I’ve been using Leopard since January 2007, since I’m an ADC Member, and I have early access.
2. I’ve been using it on my primary work machine since September 2007.
3. This is the internet, and somehow you found this post to read, therefore you don’t know any better..

I’m going to assume that the build shipped to us ADC members, has been updated and will not be the build that will be released to the masses, there are still bugs in my release, but it’s leaps and bounds ahead of the August release, and very close to stable.

…