Thursday Aug 29, 2013

MySQL Connect in 23 Days: Real-World Experiences Sessions

Following my blog on InnoDB sessions, let's focus today on what you will have the opportunity to learn from MySQL users sharing their real-world experiences along with best practices they've developed.

You should obviously not miss our exciting panel on "Current MySQL Usage Models and Future Developments" featuring Davi Arnaut from LinkedIn, Daniel Austin from PayPal, Mark Callaghan from Facebook and Calvin Sun from Twitter.

The conference sessions will include:

MySQL at Twitter - Calvin Sun and Liang Guo, Twitter
Saturday, 11.30 am, Imperial Ballroom A

MySQL@Facebook: Lots and Lots of Small Data - Harrison Fisk, Facebook
Saturday, 1.00 pm, Imperial Ballroom A

Scaling Data Access for Web Front Ends - Nicolai Plum, Booking.com
Saturday, 2.30 pm,  Imperial Ballroom A

Upgrading to MySQL 5.6 - Sheeri Cabral, Mozilla
Saturday, 2.30 pm,  Imperial Ballroom B

Big Fish: Building a Web Recommendation Platform for Casual Gaming - Sean Chighizola and Brian Guthrie, Big Fish Games
Sunday, 8.30 am, Imperial Ballroom A

MySQL 5.6 at Facebook - Yoshinori Matsunobu
Sunday, 10.00 am, Imperial Ballroom A

To Scale Horizontally or Scale Vertically? - Andrew Yee and Hari Tatrakal, Ticketmaster
Sunday, 11.30 am, Imperial Ballroom A

How to Get a Fivefold Performance Increase from MySQL - David Link, Sciencelogic
Sunday, 11.30 am, Union Square 3/4

Managing Your Databases and Sharding Through jetpants - Bob Patterson Jr, Tumblr
Sunday, 1.00 pm, Imperial Ballroom A

Performance-Enhanced MySQL for Data Leverage - Shivinder Singh and Erick Franco, Verizon Wireless
Sunday, 1.00 pm, Imperial Ballroom B

Testing Global Performance with MySQL - Daniel Austin, PayPal
Sunday, 2.30 pm, Imperial Ballroom A

Managing Hundreds of MySQL Servers Efficiently - Sheeri Cabral and Brandon Johnson, Mozilla
Sunday, 4.00 pm, Imperial Ballroom A

Building DBaaS APIs with Python and Delivering High Availability - Diego Narducci and Gabriel Ciciliani, Mercadolibre
Sunday, 4.00 pm, Union Square 3/4

Migrating High-Demand Enterprise Systems to MySQL - Jon Wiggs, Netmotion Wireless
Sunday, 5.30 pm, Imperial Ballroom A


Not registered yet? Sign-up Now to save US$300! And remember you can add a third day of tutorials to your MySQL Connect registration.

Don't let the MySQL Connect opportunity pass you by!

Wednesday Aug 28, 2013

PHP and MySQL for Web Developers

As a first step to developing your websites with MySQL and PHP, take the MySQL and PHP: Developing Dynamic Applications training course where you will learn to:

  • Describe the LAMP architecture
  • Use the basic components of PHP to build a foundation for more complex web applications
  • Understand the basic components of MySQL
  • Use SQL query commands to retrieve data from the MYSQL database
  • Change table data using the SQL Data Manipulation Language (DML) commands
  • Retrieve data from multiple MySQL tables using Joins
  • Create web based forms that interact with the end user and the data within MySQL
  • Use session handling to authenticate and monitor user identities
  • Describe the purpose of template systems

You can take this 4-day Instructor-led training as a:

  • Live-virtual event: Take this event from your own desk - no travel required. Choose from a selection of events on the schedule to suit different timezones.
  • In-class event: Travel to an education center to take this class. Below is a selection of events already on the schedule.

 Location

 Date

 Delivery Language

 Hamburg, Germany

 21 October 2013

 German

Rome, Italy 

4 November 2013 

Italian 

 Warsaw, Poland

 12 November 2013

 Polish 

 Barcelona, Spain

 18 November 2013

 Spanish

 Madrid, Spain

 16 December 2013

 Spanish

 Jakarta Barat, Indonesia

2 September 2013 

  English 

To register for this class, request an additional event, or to learn more about the authentic MySQL curriculum, go to http://oracle.com/education/mysql.

Tuesday Aug 27, 2013

MySQL Connect Only 25 Days Away, Focus On InnoDB Sessions

Time flies and MySQL Connect is just around the corner...Schedule Builder was launched last week to help you build your own schedule, selecting and pre-enrolling in sessions you plan to attend.

You can check out the program in our content catalog as well as via a new Focus on MySQL Connect document listing all sessions with time and location. If you’d like to expand your InnoDB knowledge, below are the sessions specifically focused on InnoDB (although others such as performance tuning may also of course cover InnoDB topics):

InnoDB New Features in Version 5.6 - Sunny Bains, Oracle
Saturday, 2.30 pm, Union Square Room 3/4

This session covers the new InnoDB features and their benefits, including:
• Resize REDO
• Transportable tablespaces
• Online data definition language (DDL)
• Running InnoDB from read-only media and sharing datafiles
• Full text index
• memcache—using InnoDB as a NoSQL store

InnoDB: Table and Index Data Structures Architecture - Davi Arnaut, LinkedIn
Saturday, 4.00 pm, Imperial Ballroom A

InnoDB is the storage engine behind most busy MySQL databases in the world. How does it store and organize data? How does it manage free space? How does it retrieve rows? This presentation dissects InnoDB’s internal storage format and digs into how data pages are organized, stored, and accessed. It aims to provide an overview of the main on-disk data structures such as tablespaces, indexes, extents, pages, and records. After this session, you will be able to answer questions such as: How many bytes would it take to store rows in a particular schema? How does indexing affect storage? What expected and unexpected inefficiencies might you run into?

The InnoDB Buffer Pool and I/O: How It All Works - Sunny Bains, Oracle
Sunday, 10.00 am, Imperial Ballroom B

How do I tune my InnoDB instance? When and for what should I use a solid-state drive to get the best value? Where should I place the files? What I/O settings should I use for the best throughput? What are various types of flushing? How can I tune and control flushing? What is a checkpoint in InnoDB? What is the relationship between redo logs and the buffer pool? What instrumentation do I need in order to know if my system is properly tuned? If you’ve ever struggled with such questions, this session is for you. Hear InnoDB engineers discuss the I/O architecture and how to use InnoDB to the max.

MySQL As a NoSQL Store with the InnoDB/memcached Plug-in – Jimmy Yang
Sunday, 1.00 pm, Powell

In this session, you will learn how to leverage MySQL/InnoDB as a NoSQL store. The data can be accessed with traditional SQL and also as a key/value store. The presentation focuses on architecture, best practices, and future directions so that users can make use of this flexibility and use a single server for both types of access.The best of both worlds.

InnoDB Full Text Index– Jimmy Yang
Sunday, 2.30 pm, Powell

This session covers the InnoDB full text index in version 5.6. The InnoDB FTS architecture is very different from that of MyISAM. The full text index is implemented on a transactional engine (as compared to other common full text engines). It is better designed for processing and querying big data natively and comes with far better scalability than that of MyISAM. It also comes with some inherited differences from MyISAM. Thus it is important for users to pay attention in order to avoid migration issues. The presentation discusses the ongoing work on and some future plans for the feature.

Birds-of-a-Feather: Meet the InnoDB Team
Saturday, 5.30 pm, Imperial Ballroom B

Join Oracle's InnoDB engineers in this BOF to ask all your questions and discuss any and all InnoDB matters.

Not registered yet? Sign-up now to save US$300! And remember you can add a third day of tutorials to your MySQL Connect registration.

MySQL Connect is going to be an exciting conference, don't miss it!


Thursday Aug 22, 2013

Schedule Builder is Live, Plan Your MySQL Connect Conference

Schedule Builder allows you to effectively plan your conference and pre-enroll in MySQL Connect sessions you want to attend. Go ahead and start building your schedule!

With keynotes and over 85 conference sessions, Hands-on Labs, Birds-of-a-Feather sessions and tutorials, MySQL Connect offers you a unique opportunity to boost your MySQL skills and meet the Oracle engineers driving MySQL innovation. You’ll learn how to build next-generation applications with the leading Web and cloud database, find out about the latest MySQL features and roadmaps, and network with some of the world’s best MySQL professionals.

Not registered yet? Sign up Now to save US$300 over the onsite price!

MySQL Connect Housing Information


Resources to learn more:

MySQL Connect is only 30 days away, don’t miss out on this opportunity and Register Now!

We look forward to seeing you there!

Tuesday Aug 20, 2013

Twitter: New Tweets per Second Record, and How

Raffi Krikorian, VP Platform Engineering at Twitter, blogged about Twitter's New Tweets per second record and how they achieved it:

"Recently, something remarkable happened on Twitter: On Saturday, August 3 in Japan, people watched an airing of Castle in the Sky, and at one moment they took to Twitter so much that we hit a one-second peak of 143,199 Tweets per second...To give you some context of how that compares to typical numbers, we normally take in more than 500 million Tweets a day which means about 5,700 Tweets a second, on average. This particular spike was around 25 times greater than our steady state."

Read the blog to understand how they reached their goals.

To learn more about MySQL at Twitter, register now for MySQL Connect, taking place in San Francisco September 21-23. You'll get the chance to hear the Twitter engineers speak about their MySQL data storage architecture.

And if you're still wondering whether you should attend MySQL Connect, listen to the latest OurSQL podcast hosted by Sheeri and Gerry to find out why you definitely should. Plus, you can win a free pass!

Monday Aug 19, 2013

MySQL Number One Skill for Linux Careers

MySQL is the number one IT skill demanded for Linux related jobs and continues to grow in importance according to the Linux Careers IT Skills Watch update 2013. So boost your career with the authentic MySQL Curriculum.

During the top selling course, the MySQL for Database Administrator, you will learn to install MySQL products, partition data, check and repair tables, perform backups and configure replication, create secured users and enable SSL security, and much more.

You can take this instructor-led course as a:

  • Live-virtual event: Take this course from your own desk, no travel required. Choose from a wide selection of events on the schedule to suit different time-zones.
  • In-class event: Travel to an education center to take this class. Below is a sample of events already on the schedule across the continents.

AFRICA

 Location

 Date

 Delivery Language

 Cairo, Egypt

 26 August 2013

 Arabic

 Nairobi, Kenya

 23 Septembre 2013

 English

 Johannesburg, South Africa

 9 December 2013

 English

AMERICA

 Location

 Date

 Delivery Language

 Sao Paolo, Brazil

 19 August, 2013

 Brazilian Portugese

 Mexico City, Mexico

 21 October 2013

 Spanish

 San Pedro Garza Garcia, Mexico

 9 December 2013

 Spanish

 Belmont Shores, CA, United States

 14 October 2013

 English

ASIA

 Location

 Date

 Delivery Language

 Bangalore, India

 19 Augsut 2013

 English

 Jakarta, Indonesia

 16 September 2013

 English

 Makati, Philippines

 30 September 2013

 English

 Pasig City, Philippines

 27 August 2013

 English

 Bangkok, Thailand

 26 August 2013

 English

EUROPE

 Location

 Date

 Delivery Language

 Brussels, Belgium

 16 September 2013

 English

 London, England

 9 September 2013

 English

 Aix-en-Provence, France

 2 December 2013

 French

 Bordeaux, France

 2 December 2013

 French

 Nice, France

 4 November 2013

 French

 Puteaux, France

16 September 2013 

  French 

Dresden, Germany 

 26 August 2013

 German

 Hamburg, Germany

 16 November 2013

 German

 Munich, Germany

 4 November 2013

 German

 Budapest, Hungary

 4 November 2013

Hungarian 

 Belfast, Ireland

 16 December 2013

 English

 Milan, Italy

 7 October 2013

 Italian

 Rome, Italy

 16 September 2013

 Italian

 Utrecht, Netherlands

 16 September 2013

 English

 Utrecht, Netherlands

 2 December 2013

 Dutch

 Warsaw, Poland

 18 November 2013

 Polish

 Lisbon, Portugal

 16 September 2013

 European Portugese

 Barcelona, Spain

 30 October 2013

 Spanish

 Madrid, Spain

 4 November 2013

 Spanish

 Bern, Switzerland

 27 November 2013

  German 

 Zurich, Switzerland

 27 November 2013

 German

 Istanbul, Turkey

 25 November 2013

 Turkish

To register for this course or to learn more about the MySQL Curriculum, go to http://oracle.com/education/mysql.

Tuesday Aug 13, 2013

MySQL Connect Attendee Toolkit

Are you speaking at MySQL Connect? Attending the conference? Resources such as sample e-mail copies, banners and buttons are at your disposal in our attendee toolkit. Some examples below:


http://www.oracleimg.com/us/dm/h2fy11/183037-mysql-tk-imspeaking-200x200-1951647.gifhttp://www.oracleimg.com/us/dm/h2fy11/183037-mysql-tk-imattending-200x200-1951632.gifhttp://www.oracleimg.com/us/dm/h2fy11/183037-mysql-tk-joinme-200x200-1951668.gif

Would you like to help promote MySQL Connect? Here are others you can also use:

http://www.oracleimg.com/us/dm/h2fy11/183037-mysql-tk-ilikethis-200x200-1951596.gifhttp://www.oracleimg.com/us/dm/h2fy11/183037-mysql-tk-registernow-200x200-1951673.gif

Time flies and MySQL Connect is only about 5 weeks away! Have you registered? If not, sign up now to save US$300 over the onsite price. And, remember you have the opportunity this year to add a third day of tutorials to your registration. Check out the Top 10 Reasons to Attend MySQL Connect to learn more.

We look forward to seeing you at MySQL Connect!

Monday Aug 12, 2013

MySQL Workbench 6.0 - New Design and Many Enhancements

New GUI, 30+ New Features, and Major New Components

Oracle is excited to announce the immediate availability of the production-read, GA release of MySQL Workbench 6.0, available for download under the GPL, as well as part of the Commercial MySQL Standard, Enterprise, and Cluster Carrier Grade Editions with 24x7 global support.

The need by database professionals for management tools has increased with expanding data volumes, web, cloud and mobile computing growth. Improvement and additions in MySQL Workbench helps developers and administrators better manage these dynamic data environments. This latest GA release includes many new features and a modernized user interface that allows users to simplify MySQL database development, design and administration.

Overview
The goal of MySQL Workbench 6.0 is to simplify and improve the workflow in the graphical user interface (GUI) as well as adding new features and functions. The enhanced design in the multi-platform GUI not only increases usability and productivity of the tool, but also offers new database management capabilities. MySQL Workbench 6.0 improves user productivity across the board from database architects to developers to DBAs, by enhancing support for data modeling and SQL development, as well as improving and adding tools for server configuration, user administration, migration, backup, auditing and more.

New Features

  • Redesigned GUI: includes a NEW modernized home screen and a streamlined interface for unified, multi-tasking database management and development.
  • Vertical Query Results Mode: allows query results to be visualized as a column/value pair list, which is ideal for queries that produce few rows but many columns.
  • Cascaded DELETE Statement Generator: automatically performs the tedious task of creating DELETE statements for deleting a row referenced by foreign keys.
  • Improved Visual Entity-Relationship Model Synchronization: with live schemas, making the integrated database modeling tool even more useful for managing schemas.
  • NEW Schema Inspector: provides a suite of detailed views of all objects in the schemas plus access to table maintenance operations such as ANALYZE and OPTIMIZE TABLE.
  • NEW Table Data Search: enables a text search on any number of tables and schemas for rows matching a given pattern.
  • IMPROVED Server Status: provides a quick summary of server status and configuration.
  • Wizard Based Migration Support: for Microsoft SQL Server, Sybase Adaptive Server Enterprise (ASE), PostgreSQL and now NEW additional support for Sybase SQL Anywhere and SQLite.
  • Community Driven Features: MySQL Workbench 6.0 addresses well over 200 ideas and requests from the community.
  • MySQL Workbench 6.0 Enterprise Edition also includes:
    • NEW MySQL Enterprise Backup GUI: now allows setup, run, schedule, and view backups while in progress, as well as automating restores.
    • NEW MySQL Audit Log Inspector: allows users to browse and analyze audit data generated via MySQL Enterprise Audit. With powerful filtering and search capabilities users will be able to more easily assess the audit log content generated via MySQL Enterprise Audit.

Download

Platforms supported by MySQL Workbench include: Windows, Mac OS X 10.6+, Oracle Linux 6, RH 6, Fedora 18, Ubuntu 12.04 and Ubuntu 13.04

MySQL Workbench Community Edition is available free of charge under the GPL and is available for download

  • For Windows - as part of the MySQL Installer for Windows here;
  • For Mac OS X and Linux here.

MySQL Workbench Enterprise Edition which includes DBDoc as well as support for MySQL Enterprise Backup and Audit is available from My Oracle Support today or from Oracle Software Delivery Cloud for trial later.

Summary

MySQL Workbench 6.0 is the best release to date, with more capabilities and enhanced ease of use.

You can review the MySQL Workbench 6.0 documentation, and also ask questions to the development team and community via our the MySQL Workbench forum. We addressed over 200 ideas and requests from our community in this release. To those folks as well as all the Workbench 6.0 beta testers, a BIG thanks goes out to you.

If you’ve been using MySQL Workbench for some time, we hope you like the changes and improvements. If you’re new to MySQL Workbench, we look forward to working with you to continue evolving MySQL Workbench. As always please send us your ideas and feedback.

Get Started on the World's Most Trusted Open Source Database

Want to get started on the world's most trusted and depended-on open source database? Sign up for the MySQL for Beginners training course today.

In this 4-day, instructor-led course you will develop an understanding of relational databases and how to design a robust and efficient database. You will harness that power by learning SQL and use it to build databases, populate them with data and query that data through extensive hands-on practices.

You can take this live class as a:

  • Live Virtual Event: Take this class from your own desk, no travel required. Choose from a selection of events already on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to take this class. Below is a selection of events already on the schedule.

 Location

 Date

 Delivery Language

 Brussels, Belgium

 9 September 2013

 English

 London, England

 4 November 2013

 English

 Berlin, Germany

 9 December 2013

 German

 Stuttgart, Germany

 28 October 2013

 German

 Milan, Italy

 23 September 2013

 Italian

 Rome, Italy

 4 November 2013

 Italian

 Riga, Latvia

 26 August 2013

 Latvian

 Utrecht, Netherlands

 9 September 2013

 Dutch

 Warsaw, Poland

 1 October 2013

 Polish

 Barcelona, Spain

 21 October 2013

 Spanish

Madrid, Spain 

 21 October 2013

 Spanish

Petaling Jaya, Malaysia 

 17 September 2013

 English

Nairobi, Kenya 

 9 September 2013

 English

Mexico City, Mexico 

 14 October 2013

 Spanish

Sao Paolo, Brazil 

 7 October 2013

 Brazilian Portugese

To register for this course, to see the full course description or to learn more about the authentic MySQL curriculum, go to http://oracle.com/education/mysql.

Wednesday Aug 07, 2013

Top 10 Reasons to Attend MySQL Connect

MySQL Connect is taking place in San Francisco September 21-23; Counting over 85 sessions and tutorials, the event represents a unique opportunity to boost your MySQL skills and hear from Oracle's MySQL engineers along with customers, partners and MySQL community members.

MySQL Connect Tutorials

Have you signed up yet? If not, you can still save US$300 over the onsite price if you register now!

Here are the top 10 reasons why you should do so:

  1. Better understand Oracle's MySQL strategy. Hear straight from the source how Oracle is driving MySQL innovation, and what are the latest developments and roadmaps.
  2. Learn about real-world experiences from other organizations. Find out about the mistakes you should avoid and the best practices they've developed. You’ll get the chance to hear from MySQL experts at Facebook, Twitter, LinkedIn, PayPal, Verizon Wireless, Booking.com, Ticketmaster, Mozilla, Big Fish Games, Tumblr, MercadoLibre, NetMotion Wireless and others.
  3. Meet the engineers developing and supporting the MySQL products. You’ll have the opportunity to ask them all your questions, which can save you significant time and money.
  4. Acquire in-depth knowledge about InnoDB, best of both worlds "SQL & NoSQL" strategies, the MySQL optimizer, performance and scalability tuning, security and numerous other topics.
  5. Understand how you can leverage the new MySQL Database and MySQL Cluster features to develop your next generation Web, cloud, mobile and embedded applications.
  6. Get hands-on experience about improving performance with the MySQL Performance Schema, using MySQL replication, monitoring MySQL Cluster and more with eight different Hands-On Labs.
  7. Express your ideas, engage into discussions and help influence the MySQL roadmap during six Birds-of-a-Feather sessions about InnoDB, sharding & replication, backup and other topics.
  8. Meet partners and learn about third party tools that could be useful in your architecture.
  9. Immerse yourself in the MySQL universe and network with MySQL experts for several days. The discussions as well as the relationships you will create can be priceless and help you execute on your next projects better and faster.
  10. Add a third day of tutorials to your MySQL Connect registration to go even deeper into key MySQL topics and make the most of the event.
  11. As a bonus to the top 10, an 11th reason to attend MySQL Connect is that you’ll have a lot of fun! The passion and the energy are contagious...and you’ll likely get plenty of new ideas!

Don't miss out on this great opportunity, Register Now to save US$300 over the onsite price! Are you attending or planning to attend Oracle OpenWorld or JavaOne? You can add MySQL Connect to your registration for only US$100!

We'll have parallel tracks so you might consider sending a few team members to make the most of the conference.

We look forward to seeing you at MySQL Connect!

MySQL Connector/C 6.1.1 has been released

Dear MySQL users,

MySQL Connector/C 6.1.1, a new version of the C API for client/server communication for the MySQL database management system, has been released. This version of Connector/C provides full support for MySQL 5.6 protocol. Connector/C is compatible with the client libraries (libmysql).

It includes all the features in the MySQL client library shipped with MySQL servers 5.6 as well as prior versions. You can recompile existing code linked with Connector/C 6.1.0 without any code changes. You can use Connector/C to run and build client applications which communicate with MySQL server versions from 4.1 to 5.6 without a need to do a complete server installation. The release is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/connector/c/

For information on installing, please see the documentation at http://dev.mysql.com/doc/connector-c/en/connector-c-installation.html

Changes in MySQL Connector/C 6.1.1

Functionality Added or Changed

  • The C API libmysqlclient shared-library .so files now have version 18.1.0 (up from version 18.0.0 used in 6.1.0). (Bug #16809055)

Bugs Fixed

  • The mysql_options4 symbol was missing from libmysql.dll. (Bug #69204, Bug #16797982)

Monday Aug 05, 2013

Tap into the 5 Nines of MySQL Cluster with Oracle Training

With its distributed, shared-nothing architecture, MySQL Cluster has been designed to deliver 99.999% availability ensuring resilience to failures and the ability to perform scheduled maintenance without downtime.

With the MySQL Cluster training course, in 3 days, you learn important clustering concepts as well as how to install and configure MySQL Cluster and manage cluster nodes. 

Below is a selection of events already on the schedule.

 Location

 Date

 Delivery Language

 Bordeaux, France

 6 November 2013

 French

 Strasbourg, France

 4 September 2013

 French

 Berlin, Germany

 16 December 2013

 German

 Munich, Germany

 2 September 2013

 German

 Stuttgart, Germany

 30 September 2013

 German

 Budapest, Hungary

 4 December 2013

 Hungarian

 Rome, Italy

 16 September 2013

 Italian

 Seoul, Korea

 6 August 2013

 Korean

To register for this course, to register your interest in additional events, or to learn more about the authentic MySQL curriculum, go to http://oracle.com/education/mysql.

Friday Aug 02, 2013

MySQL Connector/J 5.1.26 has been released

MySQL Connector/J 5.1.26, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.26 is suitable for use with many MySQL server versions, including 4.1, 5.0, 5.1, 5.4, 5.5 and 5.6. It is already available for download on the My Oracle Support (MOS) website. The eDelivery download will be available on it's own regular schedule. As always, we recommend that you check the "CHANGES" file in the download archive to be aware of changes in behavior that might affect your application.

MySQL Connector/J 5.1.26 includes the following general bug fixes and improvements, also available in more detail here

Functionality Added or Changed:

  • Added a toString() method to the PreparedStatementWrapper class to help debug prepared statements. (Bug #42267, Bug #11751418)

Bugs Fixed :

  • Connector/J silently ignored calls to ResultSet.updateRow when  the cursor was on the insert row. This fix ensures that an SQLException is thrown with those calls, as described in the JDBC specification. (Bug #45757, Bug #11754192)
  • The results returned by the method DatabaseMetaData.getIndexInfo() were not sorted in the order described in the JDBC specification (NON_UNIQUE, TYPE,   INDEX_NAME, and ORDINAL_POSITION). (Bug #68098, Bug #16224299)
  • DatabaseMetaData.getColumns() threw an  MySQLSyntaxErrorException if the schema contains tables with  ANSI quoted names with leading and trailing back quotes (`).    When those names were passed as parameters in unquoted form, Connector/J treated them as quoted because of the back quotes, and thus the error. This fix adds the behavior that when the connection property pedantic was set to true, methods like DatabaseMetaData.getColumns() treat all parameters as unquoted. (Bug #65871, Bug #14598704).
  • An out of memory error occured when the compression protocol was enabled with the connection option useCompression=true. This fix stops the memory leak that caused the error by making sure that CompressedInputStream releases its reference to the  connection object when the input stream closes. (Bug #68400, Bug #16478043)

We greatly appreciate your feedback / comments. Please post it in forums or bugdb.

About

Get the latest updates on products, technology, news, events, webcasts, customers and more.

Twitter


Facebook

Search

Archives
« August 2013 »
SunMonTueWedThuFriSat
    
1
3
4
6
8
9
10
11
14
15
16
17
18
21
23
24
25
26
30
31
       
Today