Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 35

Displaying posts with tag: Compiling (reset)

Brisbane Users Group - MySQL Hackfest
+0 Vote Up -0Vote Down

Last night we had a number of keen souls at the Brisbane MySQL User Group. I was very impressed to see the majority of people with laptops at hand.

You can download my slides and code examples at my Articles page.

In our hands on Hackfest tutorial we created the new command SHOW USERGROUPS. Before anybody makes a comment, it was stated in the presentation that this command was made a dummy one, and is a poor candidate for two reasons.

  • The results should be more dynamic, rather then hardcoded into the source tree
  • USERGROUPS is not an ideal name due to comparisions to Users, Groups, Roles etc
  • Still it was productive, here was the outcome of our work for the evening.

    mysql> SHOW USERGROUPS;
    +----------------------+-------------------------+-----------------------------+
    |
      [Read more...]
    Compiling MySQL Tutorial 3 - Debugging Output
    +0 Vote Up -0Vote Down

    Continuing on from Tutorial 2.

    When reviewing the 2.1. C/C++ Coding Guidelines (http://mysql.com/doc/internals/en/coding-guidelines-c.html" target="_blank) for MySQL, you will see that the MySQL Source uses within the C/C++ code DBUG (Fred Fish’s debug library). This is one of the 3rd party open source products that are documented in the Internals 1.4. The Open-source Directories (http://mysql.com/doc/internals/en/guided-tour-osdir.html" target="_blank).

    You will also find some usage in the MySQL Manual E.3 The DBUG Package (http://mysql.com/doc/refman/5.1/en/the-dbug-package.html" target="_blank). So enough talk, how do you use this.

    DBUG

    You get the DBUG output by running a mysqld debug version with the argument –debug. The output for the SHOW AUTHORS commands is:

      [Read more...]
    Compiling MySQL Tutorial 2 - Directly from the source
    +0 Vote Up -0Vote Down


    Should you want to be on the bleeding edge, or in my case, don’t want to download 70MB each day in a daily snapshot (especially when I’m getting build errors), you can use Bit Keeper Free Bit Keeper Client that at least lets you download the MySQL Repository. This client doesn’t allow commits, which is a good thing for those non-gurus in mysql internals (which definitely includes me).

    wget http://www.bitmover.com/bk-client.shar
    /bin/sh bk-client.shar
    cd bk_client-1.1
    make
    

    By placing sfioball in your path you can execute.

    sfioball bk://mysql.bkbits.net/mysql-5.1 mysql-5.1
    

    This took me about 4 mins, which seemed much quicker then getting a snapshot!

    You can then get cracking with my instructions at


      [Read more...]
    Compiling MySQL Tutorial 1 - The Baseline - Update
    +0 Vote Up -0Vote Down

    Just to confirm my earlier confusion about verified snapshots at Compiling MySQL Tutorial 1 - The Baseline.

    “Daily snapshot sources are only published, if they compiled successfully (using the BUILD/compile-pentium-debug-max script) and passed the test suite (using make test). If the source tree snapshot fails to compile or does not pass the test suite, the source tarball will not be published.”

    Seems the fine print at MySQL Database Server 5.1: Beta snapshots also states this. Well, need to take my RTFM pill there.

    Thanks to Lenz for putting the record straight, and helping with my Forum Post. Seems I did uncover a Bug, now recorded as Bug #21463. Just need to get it fixed to continue on my tutorial.

    Compiling MySQL Tutorial 1 - The Baseline
    +0 Vote Up -0Vote Down

    Pre-requisites

    This tutorial is aimed at Linux installations that has the standard development tools already installed. The INSTALL file in the source archives provides good details of the software required (e.g. gunzip, gcc 2.95.2+,make).

    Create a separate user for this development work.

    su -
    useradd mysqldev
    su - mysqldev
    

    Get an appropiate Snapshot

    You can view recent snapshots at http://downloads.mysql.com/snapshots/mysql-5.1/.

    The official statement on snapshots from MySQL AB.
    Daily snapshot sources are only published, if they compiled successfully (using the BUILD/compile-pentium-debug-max script) and passed the test suite (using make test). If the source tree snapshot fails to compile or does not pass the test suite, the source tarball will not be published.

    At


      [Read more...]
    10 Newer Entries Showing entries 31 to 35

    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.