HexaLab | Articles by tag : MySQL

User login

HexaLab Feeds

  • InnoDB with MySQL 5.1

    Before MySQL 5.1, the InnoDB storage engine was included by default when you compiled the sources. Since MySQL 5.1, it is necessary to set the storage engines to compile with MySQL with the parameter "--with-plugins":

    --with-plugins=PLUGIN[[[,PLUGIN..]]]
                        Plugins to include in mysqld. (default is: none)
                        Must be a configuration name or a comma separated
                        list of plugins.
                        Available configurations are: none max max-no-ndb
                        all.
                        Available plugins are: partition daemon_example
                        ftexample archive blackhole csv example federated
                        heap ibmdb2i innobase myisam myisammrg ndbcluster.
    Read more ...
    Posted by Patrick Haederli on 9 April, 2009 - 13:28

  • Nested Sets

    The expression nested sets might not be familiar to you, but the concept behind it is quite common to all of us, it is a hierarchical structure. A hierarchical representation of elements allows the humans to locate them relatively to each other.

    There are several data structures to represent a hierarchy of elements, the one being the topic of this article has different names in fact:

    • Nested sets
    • Modified Preorder Traversal Tree (translation: Route preordonnance modified tree).
    Read more ...
    Posted by Patrick Haederli on 6 March, 2009 - 12:30