• Announcing openark kit

    February 25, 2009

    It is my great pleasure to announce the availability of the openark kit, a set of lightweight utilities for MySQL, which eases every day tasks. The available tools are: oak-apply-ri: apply referential integrity on two columns with parent-child relationship. oak-block-account: block or release MySQL users accounts, disabling them or enabling them to login. oak-kill-slow-queries: terminate […]

  • Manually installing multiple MySQL instances on Linux: HOWTO

    February 19, 2009

    Installing a single MySQL instance on a linux machine is a very simple operation. It may be as simple as: apt-get install mysql-server But you cannot use this method to install another MySQL instance. Moreover, if you try to manually install another instance, you may find that some collisions occur. For example, when trying to […]

  • `;`.`*`.`.` is a valid column name

    February 12, 2009

    And the following query: SELECT `;`.`*`.`.` FROM `;`.`*`; is valid as well. So are the following: DROP DATABASE IF EXISTS `;`; CREATE DATABASE `;`; CREATE TABLE `;`.`*` (`.` INT); CREATE TABLE `;`.```` (`.` INT); CREATE TABLE `;`.`$(ls)` (`.` INT);

  • Triggers Use Case Compilation, Part III

    February 2, 2009

    The previous two parts have looked at some solutions offered by triggers. Let's look now at some wishful triggers solutions, which are currently unavailable because of triggers limitations. Triggers Use Case Compilation, Part I Triggers Use Case Compilation, Part II Limitations and wishful features Triggers are slow The overhead of adding triggers is usually an […]

Powered by Wordpress and MySQL. Theme by openark.org