Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL Newsletter December 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 User Conference 2004 - Call for Papers
    The Call for Papers for the 2004 MySQL Users Conference is now officially open. We encourage every MySQL user with something to say - from grey-bearded hackers and peach-fuzzed power users to corporate code wranglers and veteran DBAs - to drop by the online call-for-papers and write up your proposals for great sessions.
     
  • A Guide to Lower Database TCO
    A recent Computerworld article, 'MySQL Breaks Into the Data Center' revealed how MySQL has become the world's most popular open source database and why corporations intent on lowering their cost of operations are using it to further commoditize their IT infrastructure.

    MySQL reduces the Total Cost of Ownership (TCO) of database software by:
    · Reducing database licensing costs by over 90%
    · Cutting systems downtime by 60%
    · Lowering hardware expenditure by 70%
    · Reducing administration, engineering and support costs by up to 50%

    In our white paper we'll show you how. You'll also learn how organizations such as Cox Communications, NASA, Sabre Holdings and Yahoo! have improved database reliability, performance and TCO using MySQL. You'll see how these techniques can apply in your organization.

    Get the full white paper at http://www.mysql.com/tco (http://www.mysql.com/tco)
     

Products

  • MySQL 4.1.1 (alpha) Has Been Released
    MySQL 4.1.1, a new version of the popular Open Source/Free Software database management system, 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 4.0.17 (production) Has Been Released
    MySQL 4.0.17, a new version of the popular Open Source/Free Software Database Management System, 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.
     
  • How to Study MySQL Internals II
    In the previous newsletter we presented ideas how to research MySQL Internals by reading the documentation. Now in this article we will list a group of articles & other content that can be used to further study MySQL internals.
     
  • MySQL Manual in Portuguese
    MySQL AB, developer of the world's most popular open source database, today announced the MySQL® reference manual has been translated into Portuguese and is available online at the MySQL Web site at http://www.mysql.com/documentation/#pt. (http://www.mysql.com/documentation/#pt.)
     

Bugs

MySQL Tips & Hints

  • How can I run Multiple MySQL Servers on a Single Computer?
    How can I run Multiple MySQL Servers on a Single Computer?

    It is possible to run several MySQL servers on the same machine, provided that they don't work with same data. Each mysqld should have its own data directory.
     

  • How to Ensure that Data is Written to Disk?
    How can I ensure that when data is written, it is also really written to disk.

    When MySQL writes data, it gives it to the operating system.
    It is a feature of some operating systems that they use "lazy
    writes." That is, they do not actually write the data immediately,
    but buffer it in memory for a short while. This allows the operating
    system to optimize disk I/O in general. However, it also means that
    data written by MySQL may not actually be written to disk immediately.
     

  • Controlling InnoDB Log Flushing
    If you compare the insert speeds of InnoDB and MyISAM, sometimes there might be quite large performce difference. Generally the
    InnoDB performance, when compared with MyISAM, is affected by the innodb_flush_log_at_trx_commit configuration option.
     
  • Correcting Java Disconnect Errors
    I have a servlet/application that works fine for a day, and then stops working overnight? What can I do?

    MySQL closes connections after 8 hours of inactivity. You either need to use a connection pool that handles stale connections or use the "autoReconnect" parameter (see "Developing Applications with MySQL Connector/J").
     

  • Tips to Achieving Fast Web Response under Peak Loads
    In a web environment, apart from optimizing your queries and your application, what can be done to ensure proper functioning of your system during high load peaks?
     

Events

  • MySQL 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.

     
  • MySQL is Sponsoring a Geekcruise in October
    MySQL is sponsoring a geekcruise on the Eastern Mediterranean in October 10th to 17th 2004.

    You can read more about the geekcruise at http://www.geekcruises.com/top/sql_top.htm
     

  • Seminars in Sweden: Economic Payback of Open Source Databases
    During the week 12th-16th of January 2004 MySQL in Sweden and the partner United Consultants Group will run seminars for managing directors, controllers and IT managers. The seminar will cover the question of what economic payback you can get from using open source databases. The tour will visit Gävle, Uppsala, Stockholm, Linköping, Karlstad, Göteborg and Malmö.

    Contact sara.hendel@ucg.se or phone +46 703 168 833 for more information and participation.
     

Training

  • 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/)
     

Partners' Corner