By now, I’m sure you have all heard about Free VMware Player allowing easy and quick access to see, view and use other OS’s easily. For those Windows users out there, now is your chance to trial MySQL under Linux with no impact to your system, why wait.

See the MySQL Virtual Machine details on the VMware site. On closer inspection this effectively pushes you to the VMware Technology Network (VMTN) page within the MySQL website.

The MySQL guys needs to update their site to reflect new reference to the free player, rather then a trial version of Workstation. Even VMware Server is free (could be mentioned). You can read more about the offerings etc at a …

I must admit I’d given up trying to get MySQL Workbench working under Linux. I guess I’d spent at least 4 or 5 days full time at it, and it was just out of my league, with GTK and C++ errors. It had seemed like a loosing battle, I’ve had 3 detailed documented goes at 1.0.0. Last Post 19th Jan, and 2 with 1.0.1 Last Post 31st Jan.

Anyway, the good news is I now have MySQL Worbench working under Linux. I’ve been working with MySQL AB on a number of specific problems and you should expect a release from MySQL AB soon to address these. Here is a summary of my experience.

• 1.0.1 removes the requirements for java dependancies
• 1.0.1 provides a README.linux with configuration requirements, and a subset list of minimum library …

Here’s a great thing for those who need to work with multiple platforms, VMware today announced that they are dropping VMware Server GSX and replacing it with the free (as in beer) VMware Server.

A press release on the change can be found at http://www.vmware.com/news/releases/server_beta.html

A product page for VMware Server is available at http://www.vmware.com/products/server/

VMware Server is the second offering from VMware, the first being VMware Player.

As with VMware Player, VMware Server is available for Windows and Linux host machines, with VMware Server able to run able to operate on one machine and be managed from another.

While the VMware Server is a bit of overkill for …

One of my favorite things about working at MySQL is that we are a distributed company. We have developers spread across dozens of countries, and most of them work from home offices. Before joining MySQL, I spent many years working for companies which forced the developers to work in centralized “development centers”, big office buildings located in various parts of the world. My one-year anniversary of working at MySQL is coming up in a couple of months, and I’m still amazed at how much better the communication is here than it was at those big companies with all the developers jammed into the same building.

At any time of day, I can log onto the internal MySQL IRC channels and discuss an idea or a problem with a MySQL core developer in some part of the world - in real time! We also make extensive use of VoIP technology, and so I end up communicating with my colleagues at MySQL much more regularly and efficiently than I ever imagined …

The title of this post come from a phrase I heard used by one of the AIX kernel developers when discussing techniques for debugging system crashes or bugs without having to ask the customer to reproduce a problem that occurred on a production. Even though it would be totally unacceptable to take a customers car and try to make the brakes fail “with a debug build”, developers often ask similar things of customers running software in production systems. At the time I heard this quote, I felt frustrated as a developer because there was not much that we could change in the software project I was building to avoid ever having to ask a customer to “re-crash the car”. The best thing that was offered up was coming up with some kind of unified set of error messages in the code base. A good idea, but far from actually solving the problem. At that time, the best system available was Windows crashdumps - but they only helped to find crashes, not with …

I’ve never used Federated. I’m waiting for the JDBC version capabilities so I can connect to a non MySQL Server (specifically Oracle). In reading the docs, I see that the syntax includes a CONNECTION String.


CREATE TABLE federated_table (
id INT(20) NOT NULL AUTO_INCREMENT,
name VARCHAR(32) NOT NULL DEFAULT '',
other INT(20) NOT NULL DEFAULT '0',
PRIMARY KEY (id),
INDEX name (name),
INDEX other_key (other)
)
ENGINE=FEDERATED
DEFAULT CHARSET=latin1
CONNECTION='mysql://root@remote_host:9306/federated/test_table';


I’m surprised in the state of the syntax for two reasons.

• First, there are hardcoded variables in the string, this sort of breaks the rules of seperating syntax from authentication specifics
…

We had the privilege of Brian Aker Director of Architecture for MySQL speaking at the Brisbane MySQL Users Group this week (28 th Jan 2006). After the initial discussions on various topics, Brian got into his discussion on MySQL 5.1. I was surprised that only 2 people (myself being one of them) had 5.1 installed and being used in any way.

Here were some of the highlights of the talk. Should have taken some more notes.

MySQL 5.1 Features

Partitioning Will include Range, Hash, List and Key handling and Subpartitioning. …

Let’s review the problem. I’ve got this on a number of occasions and different libraries. Here are some typical error conditions.

./mysql-workbench-bin: /usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.5' not found (required by ./mysql-workbench-bin)
Error: Missing Dependency: libstdc++.so.6(GLIBCXX_3.4.6) is needed by package glibmm24

Special thanks to my new Guru friend Alfredo who put me on the path.

$ su -
$ cd /src/rpm
$ wget ftp://rpmfind.net/linux/fedora/extras/4/SRPMS/libsigc++20-2.0.11-1.src.rpm
$ rpmbuild --rebuild libsigc++20-2.0.11-1.src.rpm
$ cd /usr/src/redhat/RPMS/i386/
$ rpm -Uvh libsigc++20*.rpm
Preparing...                ########################################### [100%]
   1:libsigc++20            ########################################### [ 50%]
   2:libsigc++20-devel      ########################################### [100%]

Woot! It was that simple, download the rpm source, …

The following is a little SQL challenge I have so far been unable to complte myself. Lets say I have a table with transactions for different products.

CREATE TABLE transactions (
  product_id int(11) NOT NULL,
  transaction_id int(11) NOT NULL,
  price decimal(18,2) NOT NULL
);

The transaction_id's increase with time. In reality there is a transaction_date column, but I wanted to keep the DDL as portable as possible for this example. Here is some sample data.

INSERT INTO transactions VALUES (1, 1, '2.00');
INSERT INTO transactions VALUES (1, 2, '3.00');
INSERT INTO transactions VALUES (1, 4, '3.00');
INSERT INTO transactions VALUES (1, 5, '1.00');
INSERT INTO transactions VALUES (2, 6, '3.00');
INSERT INTO transactions VALUES (2, 7, '5.00');
INSERT INTO transactions VALUES (2, 8, '3.00');
INSERT INTO transactions VALUES (2, 9, '3.00');

Now a query to get the last price for each product could look like …

Following my earlier post of MySQL Workbench 1.0.1 for Linux and logging a MySQL Bug, I’ve had the Bug verified, and the a further update of a compiler success. Details of compile from Bug #16880

Compiled with:

- glibmm-2.8.1
- gtk+-2.8.8
- libsigc++-2.0.11


I’ve got:


libsigc++-2.0.17
glib-2.6.6
glibmm-2.6.1
atk-1.9.0
pango-1.8.2
gtk+-2.6.9
gtkmm-2.6.5
lua-5.0.2


So starting with the obvious downgrading of libsigc++


$ su -
$ cd /src
$ wget http://ftp.gnome.org/pub/GNOME/sources/libsigc++/2.0/libsigc++-2.0.11.tar.gz
$ tar xvfz libsigc++-2.0.11.tar.gz
$ cd libsigc++-2.0.11
$ ./configure …