Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 2

Displaying posts with tag: Blog Replies (reset)

The Future of MySQL (EU Crunch Time)
+2 Vote Up -5Vote Down

You’ve probably seen Monty’s post Help Saving MySQL. This is about

  • Development (will Oracle put significant effort into MySQL, actually innovating)
  • Brand (”MySQL” has a huge footprint), the trademark owner can enforce this – there have already been issues with companies offering MySQL related services via Google AdWords not being able to use the word MySQL in their ad text even though it was correctly used as an adjective.
  • Forking is fine, but still has to deal with the branding. For MySQL, that’s possibly the most significant issue of any OSS product ever encountered. You’re not competing against a company, but against an existing brand footprint that you (because of the trademark) have to steer clear of. So “just fork it”
  •   [Read more...]
    On partial indexes for string columns
    +1 Vote Up -0Vote Down

    After reading Fernando Ipar’s interesting post on partial indexes for string columns, there were two things I wanted to note:

    First, this trick works quite well, but only if your like clauses only ever use the wildcard on the right hand side (or not at all). MySQL will not be able to use the index if the like contains a wildcard on the left.

    Consider the following table definition:

    mysql> show create table people\G
    *************************** 1. row ***************************
    Table: people
    Create Table: CREATE TABLE `people` (
    `person_id` int(15) NOT NULL default '0',
    `username` varchar(255) default NULL,
    `email` varchar(255) default NULL,
    PRIMARY KEY (`person_id`),
    KEY `people_username` (`username`(5))
    ) ENGINE=MyISAM








      [Read more...]
    Showing entries 1 to 2

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.