I've made more improvements to the duplicate index checker. I addressed a MySQL bug Roland Bouman mentioned to me, added more tests to the suite, and made changes so it considers more types of indexes now (HASH, BTREE, SPATIAL). I made no changes to the foreign key checking.

At the recent EuroOSCON 2006 conference in Brussels, I was both a keynoter and a session speaker. I have meanwhile uploaded my presentation slides for my keynote, New Innovation Models, Policy-Making and Lobbying, and for my additional speech, EU Software Patents Reloaded, to this Web site (as PDF files).

Unfortunately, there was some confusion on the part of the organizers, due to which I only had my slides available for the keynote but not for the session on software patents. The organizers had to admit later that I had provided …

Some vulnerabilities have been reported in OpenSSL, which can be exploited by malicious people to cause a DoS (Denial of Service) and compromise a vulnerable system. To fix this problem we released an upgrade package for the Linux version of XAMPP.

This upgrade is primary for those people who a using XAMPP in a public or semi public environment, like a local network or the Internet.

You can get the upgrade from the usual place (there you also find an explanation how to install the upgrade). More information about the vulnerability: here

Taking into account 4.1 tree is still popular and is used on many production servers we
decided to make backport of patch to slow-log queries. The patch allows to specify time of slow queries in microseconds and is very helpful in a fight with problematic queries. 4.1 Patch is available here (The original patch was developed by Georg Richter georg at php net)

Dolphin SCI

Cybersite Consulting is pleased to announce that they are a reseller partner for Dolphin Internconnect Inc. hardware in Australia. The Dolphin product which implements the international SCI standard for fast speed connections offers our clients a range of benefits to suit cluster and high-availability setups.

The Dolphin SCI connections have been used throughout Europe in setting up MySQL clusters for markets such as telecoms, communications and statistical analysis. The products work well in a Linux setup and implement a specialised software connection method that bypasses the tcp/ip stack. This allows for faster access to data across the machines by reducing latency by more than 50 percent.

If you are interested in finding out more about this technology and what it c

read more

Dolphin SCI

Cybersite Consulting is pleased to announce that they are a reseller partner for Dolphin Internconnect Inc. hardware in Australia. The Dolphin product which implements the international SCI standard for fast speed connections offers our clients a range of benefits to suit cluster and high-availability setups.

The Dolphin SCI connections have been used throughout Europe in setting up MySQL clusters for markets such as telecoms, communications and statistical analysis. The products work well in a Linux setup and implement a specialised software connection method that bypasses the tcp/ip stack. This allows for faster access to data across the machines by reducing latency by more than 50 percent.

If you are interested in finding out more about this technology and what it c

read more

The obvious follow-up post to the Guide to Incompatibilities when Upgrading MySQL to Version 4.1
is a look at the incompatibilities when moving to version 5.0.

Again, I emphasize the importance of being educated about how upgrading MySQL may affect your application. These are the obvious, flagged items, but I recommend reading all of the 5.0 release notes.

Here are the items from the MySQL 5.0 release notes that are marked Warning: Incompatible change:

• 
  

• C API change: mysql_shutdown() now requires a second argument. This is a source-level incompatibility that affects how you compile client programs; it does not affect the …

I’ve made more improvements to the duplicate index checker. I addressed a MySQL bug Roland Bouman mentioned to me, added more tests to the suite, and made changes so it considers more types of indexes now (HASH, BTREE, SPATIAL). I made no changes to the foreign key checking. The bug Roland mentioned is a problem with SHOW CREATE TABLE that causes MySQL to show an index as type HASH when it’s really a BTREE.

It's been nine months since partition pruning code has been pushed into MySQL 5.1. Another available optimization, partition selection, has been in the main tree for even longer. There haven't been any bugs reported for some time, so the code should be reasonably stable now.

And if you're interested in what's under the hood, a rather detailed description of partitioning optimizations is now available here:

http://dev.mysql.com/doc/internals/en/partitioning-optimizations.html

It is a part of the internals manual, but I tried to write it so it doesn't
require any knowledge of MySQL source code. (and don't be scared away by my English - the text in the manual has passed the scrutiny of the documentation team :)

Hi! My name is Sergey Petrunia and I'm one of the developers in MySQL Query Optimizer team. If you don't have a habit of leafing through the commits list, you probably don't hear much about what we're doing, and we don't have your feedback on it.
This blog is my attempt to rectify this situation a bit. Let's see if it will succeed.