Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL Newsletter January 2005

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

Articles in this newsletter:

Highlights

Products

Tips & Hints

Events

Consulting, Training & Certification

Highlights

MySQL Users Conference 2005 - Register Now, Save $300
Silicon Valley, California
April 18-21, 2005

The MySQL Users Conference 2005 will be the largest gathering of MySQL developers and users. The 2005 Conference will host leading industry keynote speakers, the latest MySQL Open Source technologies, in-depth sessions and tutorials, and an exhibit hall showcasing the latest open source technologies. Highlights include:

  • Sessions and tutorials covering MySQL 5.0, MySQL Cluster, & PHP
  • Learn how to optimize and fine-tune the performance of MySQL
  • Keynotes including Adam Bosworth, Miguel de Icaza, Tim OÕReilly
  • Learn how to migrate from proprietary databases to MySQL
Register Now Before it Sells Out, Save $300 »

Join MySQL at Linux World East for New Announcements
Feb 14-17, 2005 Hynes Convention Center, Boston, MA

Join MySQL and hear about an exciting new offering. Also, Marten Mickos, MySQL CEO, will be a keynote speaker.

Keynote Speaker, Marten Mickos, MySQL CEO
02/16/2005, 02:30 PM - 03:15 PM
"Fear & Loathing in Linux World: Commoditization, Commercialization and the Customer"

Linux World East Conference and Expo »

Case Study: Citysearch Saves Over $1 Million using MySQL

The Citysearch web site receives over 10 million unique visitors each month. As a result of an exponentially growing user base, the front end Oracle system could no longer keep up with the traffic coming from the Web site. By implementing replicated MySQL servers to handle the Web traffic and a terabyte of data, Citysearch was able to deliver an extremely high performance solution and save more than $1 million in database licenses and hardware costs.

Download the Case Study » (http://www.mysql.com/it-resources/case-studies/mysql-citysearch-casestudy.pdf)

Case Study - H&M Rowells Increases Call Center Efficiency

H&M is a major worldwide retailer of fashion and cosmetics. With more than 1,000 stores in 20 countries, the company has over 40,000 employees. By deploying the MySQL-based Cention Contact Center, H&M Rowells has increased the number of e-mails processed per hour by approximately 25% while actually improving the customer perception of H&M service quality.

Download the Case Study » (http://www.mysql.com/it-resources/case-studies/mysql-cention-casestudy.pdf)

MySQL is Hiring!

MySQL has job openings for qualified individuals in software engineering, quality assurance, product management and consulting.

For more information, visit the jobs page » (http://www.mysql.com/jobs/)

Products

New Release of MySQL (4.1.9 Production) is Now Available

This is a maintenance release of the 4.1 production version, mainly fixing recently discovered bugs. This release includes:

  • InnoDB: Do not acquire an internal InnoDB table lock in LOCK TABLES if AUTOCOMMIT=1. This helps in porting old MyISAM applications to InnoDB.
  • Seconds_Behind_Master will be NULL (which means ``unknown'') if the slave SQL thread is not running, or if the slave I/O thread is not running or not connected to master. It will be zero if the SQL thread has caught up with the I/O thread. It no longer grows indefinitely if the master is idle.
  • Numerous Bug Fixes

For detailed information on what is new visit »
Source and binaries are available to download »

New Releases of MySQL Query Browser (1.1.5 Gamma) is Now Available

MySQL Query Browser is a GUI query shell, intended to allow execution of SQL queries from a Web browser alike easy to use interface. This release corrects an issue with queries containing WHERE clauses and some other minor bugs.

Linux and Windows versions are available to download »

New Release of MaxDB (7.5.00.23) is Now Available

This release includes:

  • MaxDB is now available for Linux on PowerPC.
  • The processing of JOIN operations has been optimized.
  • An active timeout handling has been implemented for web sessions.

Download the new version »
Download new client packages »
For the complete list of changes visit »

New Release of MySQL Connector/Net (1.0.4 Production) is Now Available

This is first production quality release of the fully-managed, ADO.Net provider suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0. This release includes numerous bug fixes.

For the complete list of changes visit »
Source and binaries are available to download »

New Release of MySQL Connector/MXJ (1.0.7 Gamma) is Now Available

MySQL Connector/MXJ is a JMX MBean for deploying and managing a MySQL database. This makes it easy for Java developers to deploy applications which require a database by reducing installation barriers for their end-users. New in this release are MySQL v4.1.9 server binaries.

Source and binaries are available to download »

New Release of MySQL Connector/J 3.2.0 is Now Available

Version 3.2.0 is the first ALPHA release of the 3.2 series that is suitable for use with all versions of MySQL, including MySQL-4.1 or MySQL-5.0. Connector/J 3.2.0 is required if you want to use the new batched fetching capability of MySQL-5.0 when using prepared statements.

For a complete list of changes and upgrade information visit »
Source and binaries are available to download »

Tips & Hints

Creating a New Storage Engine for MySQL

The MySQL database server features a distinctive modular architecture. The core "upper level" features of the server, such as the network layer, SQL parser, and query optimizer, are separated from the underlying data storage by a well-defined interface. Most MySQL databases store data either in MyISAM tables or in a transactional InnoDB data store, but the server can include several other storage engines in addition to MyISAM and InnoDB. Adding a storage engine to MySQL is a fairly straightforward task.

Read the article which includes sample source code »

New in MySQL 4.1; All the Little Features

We've covered the major features in 4.1, now we wrap up our 'New in 4.1' series with an article about all of the little features. But don't let their small size fool you, some of these features may be just what you've been needing from your database server.

Read the complete 'All the Little Features' article »
For a complete list of 'New in 4.1' articles, visit »

Events

MySQL Users Conference and Expo: 10 In-depth Tutorials
April 18-21, 2005, Santa Clara, California

Choose from 10 three-hour, classroom-style tutorials that provide you with in-depth knowledge on specific topics including MySQL 5.0, Performance Optimization, PHP, and, Data Warehousing. Tutorials give you quality time both on the topic and with the expert instructor. Register early to ensure availability and bring your laptop to participate in hands-on lessons.

View the all the Tutorials »
Register and save $300 - Limited Time Offer!

Web Seminar: New Features in MySQL 4.1

This Web Seminar gives an overview of the new features available in MySQL 4.1, the current production release. Major new features include:

  • Subqueries
  • Prepared Statements
  • Spacial Data features (GIS)
  • Internationalization Support
  • Online help in the client tools

Register for the Web Seminar »
Monday, January 31, 2005 at 11:00am PST, 2:00pm EST, 20:00 CET

Web Seminar: Disaster Recovery with MySQL

Learn about the available tools and the step-by-step process for restoring MySQL in the event of a datacenter disaster.

Register for the Web Seminar »
Monday, February 7, 2005 at 10:00am PST, 1:00pm EST, 19:00 CET

Community Event: MySQL Meetups
Monday, February 7th, 2005

Meet other MySQL users in your local community. MySQL Meetups are free and informal, face-to-face meetings that happen in hundreds of cities around the world. These meetings are a great opportunity to share your interest over a coffee or a beer.

Find a MySQL Meetup day near you »

Training & Certification

MySQL Data Warehouse Workshop (2 days)

This workshop will provide you with expert insight, best practices, and techniques that will cover the entire life-cycle of your Data Warehouse or Data Mart project. You will learn about requirements definition, modeling, architecture, deployment, and ongoing management. You will also learn to overcome the pitfalls and risks associated with Data Warehouse and Data Mart projects. Learn more about this course and see upcoming dates.

Learn more about this course and see upcoming dates » (http://www.mysql.com/training/workshops/datawarehouse.html)

MySQL Migration Jumpstart (5 days)

In this five-day engagement, a dedicated, on-site MySQL certified consultant will work closely with your team to jumpstart your migration to MySQL from Oracle, Sybase, Microsoft SQL Server, DB2, Informix, and other proprietary databases.

Learn more about this course » (http://www.mysql.com/consulting/packaged/migration.html)