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,
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!

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

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.


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.


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.

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,, 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!


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




« August 2013 »