MySQL 5.0 and higher versions support stored routines that are based on the SQL:2003 standard. The introduction of stored programs in MySLQ 5 has been a significant milestone of the MySQL language. This tutorial will offer a brief overview of the stored program language and focus on how to improve and tune stored programs.
Take advantage of MySQL partitioning to allow your database applications to scale in both size and performance. A practical look at applying partitioning to OLTP database systems.
Do you backup your data periodically? If not, this is your session. Learn about the possible options for backing up your data and how to get it back if you've lost something.
Deadlocks, wait timeouts, and other transaction issues—how to develop transactional applications with InnoDB and what to expect from Falcon.
MySQL 5.1 includes new functionality that allows you to create your own INFORMATION_SCHEMA tables with the new plugin interface. Learn how to implement these along with some real-world examples.
In this session you will learn how to create embedded MySQL applications through a tour of the MySQL embedded library C API.
EXPLAIN is one of MySQL's most-used and least-understood features, and it's not documented fully. This session helps EXPLAIN make sense by showing how it really maps to a query execution plan.
This talk tests Amazon EC2's (Elastic Compute Cloud) suitability for MySQL scale-out applications, including benchmarks and war-stories from active deployments.
Some data, such as user-created content, grows so large so fast it simply can't be stored in one database. This session will present HiveDB, an open source system for horizontally partitioning MySQL.
At some point in every software project involving a database it becomes necessary for the developers who created (or inherited) the project to step back and take a look at their database. Mike Hillyer will guide the audience through the principles of database normalization and review some common normalization scenarios encountered by many application developers.
This session presents the new Online Backup capability. Existing backup options and details of how they compare with the new features will be presented.
This panel will discuss the impact of Open Source Software on Software as a Service (SaaS)companies and their ability to effectively deliver on Service Level Agreements to their clients.
MySQL has created many resources online for opening up contributions from the community. From MySQL Forge, to the DevZone, to code reviews in public, MySQL is primed for more external contributions!
Experience from international customer base and multilingual projects: character set conversion issues, performance impact, limitations, security concerns, and more.
Sphinx is an open source full-text search engine designed for indexing databases and integrated especially well with MySQL. We'll talk about its features, capabilities, and real-world applications.
Bill Karwin has answered questions from SQL users for over ten years. Some techniques have emerged as widely used, but flawed, making them brittle, buggy solutions and create security or scalability risks in your projects. In this tutorial, Karwin describes SQL techniques that should be called antipatterns, illustrates their weaknesses, and offers better solutions.
This presentation will consist of two major blocks: explaining tricky features of stored routine behavior and providing examples of advanced use, such as using dynamic SQL in stored routines.
What enhancements can you expect in the MySQL Server in the next few years? What new tools, services, and software is MySQL going to deliver this year and next to help you deploy and maintain MySQL applications? This session will let you in on all the plans MySQL has for the server, the Enterprise Monitor, the upcoming Load Balancer and Query Analyzer, management tools, and more.
Why would you join a table to itself? It's an elegant solution to many problems beyond the text book example of an employee's table! And if you're brave, you might even solve a Sudoku with one SELECT.
Designed to deliver pointed information on the flaws in the MySQL and PostgreSQL communities, what they can learn from each other and how they both can improve the open source database landscape.
During this tutorial, attendees will get a detailed introduction into the MySQL UDF interface and will learn to write and deploy their own UDFs for both Windows and Linux platforms.