Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL Newsletter August 2003

Newsletters older than 6 months may have links that are out of date. Please use the Search to check for updated links.

Introduction

  • MySQL 2nd Annual Users' Conference in April 2004
    Coming in April 2004, Orlando, Florida, will host an even bigger Users Conference with an all-inclusive registration package for $695. The package includes all sessions, tutorials, exhibit hall, food, and special evening events. Look for specific details coming soon on the MySQL website at http://www.mysql.com/uc2004/ (http://www.mysql.com/uc2004/)
     
  • MySQL Presentations
    Do you need some material to show your boss about MySQL? Do you need some more indepth information about MySQL? Now you can download the following presentations from http://www.mysql.com/information/presentations/ (http://www.mysql.com/information/presentations/)

    - ACID Transactions in MySQL with InnoDB
    - MySQL Fulltext Search
    - MySQL Replication
    - MySQL, SAP and the Enterprise

    From the URL above you can find also other MySQL presentations.
     
  • Writing for the MySQL Newsletter
    Do you have a story to tell or a tip for other MySQL users in your sleeve? Would you like to share that with the other MySQL users? If you do, please contact us at newsletter@mysql.com.

    For each of your articles that gets published, your name will appear as the author of the article in the newsletter and in the HTML version of the newsletter at www.mysql.com.
     

Products

  • MySQL 4.0.14 has been released
    MySQL 4.0.14, a new version of the popular Open Source/Free Software Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ (http://www.mysql.com/downloads/) and mirror sites.
     
  • MySQL Box is available
    Do you have hard time in downloading the MySQL binaries. Now you can get the MySQL binaries delivered to your home, when you buy the MySQL Box. Note: this product is no longer available
     

Bugs

MySQL Tips & Hints

  • The MySQL SET Datatype
    One of the least commonly used of the MySQL datatypes has to be the SET datatype. The SET datatype is a string type, but is often referred to as a complex type due to the increased complexity involved in implementing them. A SET datatype can hold any number of strings from a predefined list of strings specified during table creation. The SET datatype is similar to the ENUM datatype in that they both work with predefined sets of strings, but where the ENUM datatype restricts you to a single member of the set of predefined strings, the SET datatype allows you to store any of the values together, from none to all of them.

    In his article at http://www.vbmysql.com/articles/mysqlsetdatatype.html
    Mike Hillyer shows, how you can use SET datatype.
     
  • Online Backup with Emic Application Cluster
    You do not have to be a topnotch DBA to understand the need of the proper database backup and restorination procedures. Even when you have adopted a high availability solution like a clustered database system in order keep your database up and running - backup is still needed.
     
  • Foreign key storage in InnoDB
    How (where) does Innodb store information about foreign keys?

    Foreign keys are stored in InnoDB tables SYS_FOREIGN and SYS_FOREIGN_COLS.
     
  • Setting max_allowed_packet
    When a MySQL client or the mysqld server gets a packet bigger than max_allowed_packet bytes, it issues a Packet too large error and closes the connection.

    In MySQL 3.23 the biggest possible packet is 16M (due to limits in the client/server protocol). In MySQL 4.0.1 and up, this is only limited by the amount on memory you have on your server (up to a theoretical maximum of 2G).
     
  • Syncing Memory And Disk
    Is there any way to ensure, that when data is written, it is also really written to disk? I.e. I can sure data in memory and disk are in sync.
     

Events

  • COMDEX Las Vegas 2003
    COMDEX Las Vegas 2003 (comdex.com)
    November 16-20, 2003

    Your business depends on technology and only COMDEX brings it all together. Every part of COMDEX, from exhibits to educational programs to special events, is designed around the seven themes impacting the future of your business. Come to Las Vegas to discover just how exciting the future of technology will be. Register at http://www.comdex.com/lasvegas2003/ today.

    MySQL AB will have a booth at the COMDEX Las Vegas 2003 show in November.
     
  • Novell Brainshare invitation
    Opportunity for MySQL developers to attend Novell BrainShare in Barcelona in September at a 30% discounted price.
     
  • LINUX LUNACY '03
    This year's Linux Lunacy will be held on September 13-20, 2003 at Alaska's Inside Passasge, sailing out of Seattle.
     
  • Come and meet MySQL in Germany and Switzerland
    MySQL will be present at various events in Switzerland and Germany during September. This is your chance to meet experienced MySQL staff an get latest information about MySQL products and services.
     
  • MySQL AB at Industry Events
    MySQL AB founders and employees will be available for meetings and discussions at many industry events. See http://www.mysql.com/events/ (http://www.mysql.com/events/) for a list of coming events.
     

Training

  • MySQL Certification volume discounts now available
    Companies that make use of MySQL and wish to certify many people may now buy volume-discounted certification exams.
     
  • Upcoming MySQL Training
    MySQL AB is holding numerous training courses in the following countries: USA, Germany, Canada, France, UK, Australia, India and Sweden. Check out dates and locations at
    http://www.mysql.com/training/ (http://www.mysql.com/training/)
     

Latest News

  • Latest News
    Sterling Commerce Taps MySQL To Power Gentran Integration Suite For Global 5000 Companies
    http://www.mysql.com/press/release_2003_28.html (http://www.mysql.com/press/release_2003_28.html)

    Pogo Linux and MySQL AB Launch First MySQL Database Appliance
    http://www.mysql.com/press/release_2003_25.html (http://www.mysql.com/press/release_2003_25.html)

    MySQL AB to Re-brand SAP DB "MaxDB"
    http://www.mysql.com/press/release_2003_24.html (http://www.mysql.com/press/release_2003_24.html)

    MySQL AB Partners with VERITAS Software to Provide Enterprise-Class Linux Solutions
    http://www.mysql.com/press/partners/release_399.html (http://www.mysql.com/press/partners/release_399.html)

    MySQL and SGI Partner to Deliver High Performance Database Computing with MySQL on the SGI Altix 3000 Supercluster
    http://www.mysql.com/press/partners/release_398.html (http://www.mysql.com/press/partners/release_398.html)

    Dell Researchers Deem MySQL Replication Cluster Easy, Effective for High Volume Applications
    http://www.dell.com/us/en/biz/topics/power_ps2q03-jaffe.htm

    Cox Communications Powers Massive Enterprise Application with MySQL
    http://www.mysql.com/press/release_2003_21.html (http://www.mysql.com/press/release_2003_21.html)

    Pogo Linux and MySQL AB Announce Partnership to Deliver First MySQL Database Appliance
    http://www.mysql.com/press/release_2003_20.html (http://www.mysql.com/press/release_2003_20.html)

    MySQL Reference Manual Now Available in French
    http://www.mysql.com/press/release_2003_19.html (http://www.mysql.com/press/release_2003_19.html)