MySQL Newsletter December 2002

Products

• MySQL Product Renaming Refined
  Starting with MySQL 4.0, MySQL AB has introduced a new product naming scheme to offer customers more choice and to have a clearer distinction between the different versions offered for download.
   
• German First Level Support starts 2003
  Beginning in January 2003 customers with a valid MySQL support contract can get German first level support through the MySQL GmbH in Nürtingen, Germany. There is no special agreement necessary.
   
• MySQL Control Center
  MySQL AB has introduced a new graphical administration tool for MySQL. MySQL Control Center is a simple to use GPL multi-platform GUI client tool to manage MySQL Servers.
   

Security

• Security vulnerabilities in MySQL resolved
  MySQL AB announced on Thu, 12 Dec 2002 the availability of MySQL 3.23.54. Apart from fixing several bugs, this release also resolves multiple security vulnerabilities that have been found and reported to us by Stefan Esser from e-matters GmbH, Germany. All users of MySQL 3.23 are advised to upgrade to version 3.23.54. MySQL 4.0 is also affected by this and updated binary packages will be made available shortly.
   

Features

• Which Storage Engine (table handler) to use?
  MySQL 4.0 Standard comes with 3 main Storage Engines, MyISAM, HEAP, and INNODB. We are often asked, which of them is the best choice for particular application. The answer is that mixing storage engines would give best results in most cases.
   
• Hate restarting? One solution is SET Syntax
  You would like to adjust your MySQL settings, but you don't want restart mysqld.
  
  Here is a solution for that for most of the settings.
   
• Using AUTO_INCREMENT keys with Connector/J 3.0
  In this article we show, how you cn use AUTO_INCREMENT keys with Connector/J 3.0. You can read the article in detail at
  http://www.mysql.com/articles/autoincrement-with-connectorj.html
   
• MySQL Tuning and Optimisation: Some Consulting Tips
  Frequently, MySQL users think about optimisation only when their application is about to go live. And when asking for our consulting services, many think that server tuning is all there is to care about. This is a big mistake! Server tuning is just part of the task of optimising your MySQL installation, with query optimisation and indexing being other main areas of focus.
   
• MySQL GmbH launched German newsletter
  MySQL GmbH, the German subsidiary of MySQL AB, launched a German newsletter service. To subscribe please send a message to mailto:info@mysql.de?subject=MySQL_Infobrief_abbonieren
   
• How Calculate btree Index Depth
  Ever wondered, how deep is your index tree? In this article we show, how you can calculate the btree index depth.
   

Events

• MySQL at Industry Events
  MySQL AB founders and employees will be available for meetings and discussions at many industry events worldwide.
   
• Special Early-Bird offer on pre-registrations for the MySQL Users Conference and Expo 2003
  Pre-register today for this fantastic event and save $200 on the Full Three Day Conference Pass! https://order.mysql.com/uc2003/
  
   

Training

• First MySQL AB PHP course with Rasmus Lerdorf a success
  On 9-13 December 2002, the MySQL Training Team was joined up by Rasmus Lerdorf for the first ever MySQL/PHP course held by MySQL AB. For five days, they instructed fifteen LAMP developers close to San Francisco in the course titled "Developing Dynamic Web Applications with MySQL and PHP".
   
• Upcoming MySQL Training courses in December and January
  MySQL AB is holding numerous training courses in the following countries: USA, Germany, France, UK, Australia and Sweden. Check out dates and locations at http:/ /www.mysql.com/training/ Register to a course now and enjoy an immediate 10% discount!
   
• First MySQL Certification Exams Available in Q1 2003
  The first two MySQL Certification exams, Core and Professional, will be available to the general public in Q1 2003. Core Exam Beta tryouts available through Dec. 31st.
   

Latest News

• Latest MySQL News
  MySQL Selects VUE as Testing Services Provider for Upcoming MySQL Certification Program
  http://www.mysql.com/press/release_2002_16.html