tutorial de mysql workbecnch

At the 2008 MySQL Conference and Expo, The Pythian Group gave away "EXPLAIN" cheatsheets. They were very nice, printed in full color and laminated to ensure you can spill your coffee* on it and it will survive.For those not at the conference, or those that want to make more, the file is downloadable as a 136Kb PDF at explain-diagram.pdf* or tea, for

MySQL Sandbox is a tool to install a side server or a replication system in seconds, in complete isolation, without need to remember complex sequence of commands.Administrators, developers, QA and support engineers need to install and test several versions of MySQL database server. Performing this task safely, without affecting existing instances on the same host is not easy. Using MySQL Sandbox, users can: Install a new server in less than 10 seconds, just by pointing to a binary tarball; Install an system of master + slaves in replication in less than 15 seconds; Install 10 independent servers in one minute with just one command; Optionally, install the above items with complex options, using one command, without need of editing configuration files. This presentation explain how to install a server or a replication system with MySQL Sandbox, covering the basics and some advanced  []

Roland Bouman takes the Sakila sample database and explains how to design and load a data warehouse for it, and how to use that to create those reports and charts that make managers smile. Along the way, he'll explain often uttered terms and concepts such as dimensional model, denormalization, star schema, OLAP, data staging, business intelligence, ETL and data integration. Roland's session is titled Starring Sakila - A Data Warehouse Mini-Tutorial.

Roland Bouman takes the Sakila sample database and explains how to design and load a data warehouse for it, and how to use that to create those reports and charts that make managers smile. Along the way, he'll explain often uttered terms and concepts such as dimensional model, denormalization, star schema, OLAP, data staging, business intelligence, ETL and data integration. Roland's session is titled Starring Sakila - A Data Warehouse Mini-Tutorial.

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