One of MySQL 5.1 main features is the event scheduler, a portable way of executing SQL commands at given times or at scheduled intervals. Using the event scheduler you can organize your work regardless of the operating system you work with. This session presents the basics of the event scheduler, common tasks, tips and tricks.

Long the domain of ArcSDE, Oracle, and other proprietary database back ends, MySQL can compete as a reliable open-source database solution in the rapidly expanding world of Web Mapping Services (WMS). This presentation will demonstrate the utility and flexibility of MySQL's geo-spatial features and how these can be combined with other technologies to publish data into open WMS standards.

MySQL Cluster is unique among the selection of MySQL storage engines in that's not exclusively dependent on a MySQL server. The result is that a cluster can be accessed just as any other MySQL database or directly with the native NDB API. This session will cover application development with MySQL Cluster and Java using NDB/J.

Do you use replication? Would you like to improve your data protection and recovery capabilities? If you do, chances are you would also like to improve your ability to recover from failures faster. In this session, we will show you how you can use backup to enhance your replication capabilities.

There is a lot of buzz about Memcached and MySQL 5.1 and what it can do for your website. But how exactly do you go about setting it all up and write your code to make use of memcached? In this session, Adam Donnison will take you step by step through implementing memcached using real world examples in PHP from the MySQL.com website infrastructure.

Do you like to tinker? Would you like to see how MySQL? If you’d like to get your hands dirty (or watch others work their developer magic), stop by this session and learn how to take a simple desktop system running MySQL into a fully functional time based backup system that you can connect to any server and get up to the minute recovery capability.

In this session we will build a PHP+MySQL application in NetBeans that uses the Twitter API to find and graph a "meme" in Twitter.

Feeling the pressures of data warehousing? Costs growing non-linearly? Are data growth, ad-hoc queries and near real-time data availability requirements threatening to take your DW system past the event horizon? Let us show you how to create a scalable, open source, low cost data warehouse with MySQL & the Calpont storage engine.

This presentation explores what cloud computing means beyond being a buzz-word and touches upon the various scenarios where MySQL and Pentaho Data Integration (Kettle) can be deployed on a large number of hosts to process data in parallel.

Connector/J has a wealth of under-promoted performance features. Come to this session to learn about bulk data loading, load balancing, batch rewriting and the "reckless but really fast" options that C/J has.

Indexes are known to speed up retrievals, but do you know that sometimes looking at the indexes is sufficient to get the data you need ? This session will help you understand the principles of covering indexes, their benefits and the situations where you should avoid them.

Many of the characteristics that make MySQL so successful also apply to GlassFish and NetBeans. This talk will demonstrate how MySQL, GlassFish, and NetBeans can be used together to create quick and powerful web applications. It shares tips to boost web application development when using all of them together.

DTrace is breakthrough tool for on-demand tracing and analysis of any software. As MySQL internals are open, it is possible to extract incredibly valuable information about database work - without performance overhead or even need to restart a server. This talk covers and merges knowledge and practice from both DTrace and MySQL worlds - and explains why D in DTrace means 'dynamic'.

The InnoDB storage engine has been modified to use memcached as a level 2 cache, the InnoDB buffer pool being the level 1. Important reduction of the disk load and performance boost has been observed. This opens a new way of scaling out MySQL.

This session will give an overview of the new set of static DTrace probes introduced in MySQL 6.0 with examples on how to use them in real-life monitoring and performance tuning tasks.

A tour of External Language Stored Procedures for MySQL and how they overcome the challenges involved when using MySQL's UDFs and SQL stored procedures.

The Falcon Storage Engine is designed to take advantage of multi-core computers. It is reaching GA at a time when computer performance is being increased mostly by adding more cores. Falcon's unique characteristics will be explained and contrasted with InnoDB and other MySQL storage engines.

A case study of the evolution of MySQL usage, as a company moved from a scrappy startup - with the goals of finding a cheap, quick, and simple database solution - to a mature enterprise - with high availability and horizontal scalability as key requirements.

Have a look at how Big Fish Games and thePlatform are using MySQL Enterprise Monitor 2.0 now to help tune and troubleshoot their applications.

Query analysis can help highlight issues in the SQL in your application, but there are many ways of getting that information. Obvious choices are explain and the slow-query log, but newer solutions, such as live query monitoring, mysql proxy and DTrace provide additional benefits.