Quite often, people try to solve problems using a cursor. But do you really need one? What is the performance impact of using a cursor anyway? Learn these things and more.

Most people manage to write a single CURSOR loop. But what if you want to nest CURSOR loops? Read this article and learn how.

Cursors are typically traversed using a loop. MySQL syntax to traverse a cursor is quite often misunderstood. This article will learn you how to loop through MySQL cursors.

Learn how to use dynamic SQL using the PREPARE syntax

There is a popular myth about the SQL GROUP BY clause. The myth holds that 'standard SQL' requires columns referenced in the SELECT list of a query to also appear in the GROUP BY clause, unless these columns appear exclusively in an aggregated expression. MySQL is often accused of violating this standard. In this article I will attempt to debunk this myth, and to provide a more balanced view regarding MySQL's treatment of GROUP BY at the same time. To do that, I will first demonstrate that MySQL can be instructed to only accept GROUP BY clauses that include all non-aggregated expressions referred to in the SELECT list, thus making MySQL's behaviour conform more to that of other well-known rdbms-products. Second, I will show that it is very important to clearly define which version of the SQL-standard is being referred to. The two most recent versions use a rather sophisticated way of  []

Tutorial about MySQL partitions at the MySQL conference 2009. How to create them, what they are about, use cases, benchmarks tips, and tricks.

Communities, their power, and how they work, seen from the inside.

Insightful presentation giving an overview over MySQL HA Solutions.

The best way to performance tune a system is to find out what your bottlenecks are, and attacking those first. In the first part of this session, I'll be looking at some of the issues faced with common database workloads. From there, I'll then be showing how you can get more information out of MySQL and your Operating System to find out about your workload. This session is designed for beginner to intermediate MySQL users.

On the front cover of MySQL Administrator’s Bible is a sentence that reads: “The book you need to succeed!” I must say, I do agree.

Roland takes the reader through a fascinating path of optimization, explaining many interesting and not immediately evident points

"Princess Ruruna, of the Kingdom of Kod, has a problem. Her parents, the King and Queen, have left to travel abroad. Ruruna has been left to manage the nations fruit business. Much is at stake, Kod is known as "The Country of Fruit." Ruruna is not happy though, as she is swamped by paperwork and information overload. A mysterious book, sent by her father, contains Tico the fairy. Tico, and the supernatural book are going to help Princess Ruruna solve her problems with the power of the database. This is the setting for all that takes place in The Manga Guide to Databases"

the motivation for the cloud and its democratic technology

Tomas Ulin, MySQL Server Director, explains the new MySQL release model which has just recently been announced.

The Open SQL Camp 2009, European edition, is hosted at FrOScon 2009

Ed Ort, Senior Staff Information Engineer, Sun Microsystems talk with Mark Matthews, Architect, Enterprise Tools, Sun Microsystems about MySQL and Java best practices

A presentation about MySQL HA solutions by Lenz Grimmer, presented at FOSDEM 2009 in Brussels, Belgium

Video of Lenz Grimmer, speaking about the virtual organization at the next09 conference in Hamburg, Germany

A quick demo of MySQL Sandbox

Introduction to MySQL, as given to the Open Communities Forum in Madrid, on June 17, 2009