Giuseppe Maxia speaks at the April 2009 Los Angeles MySQL User Group about MySQL Sandbox and how to use it for simple and complex sandbox scenarios.

Giuseppe Maxia and Sheeri K. Cabral give an introduction to what MySQL is. A PDF of the slides can be downloaded at http://technocation.org/files/doc/2009_04_Tour.pdf (21 Mb). Links referred to in the presentation, or related to the presentation: The MySQL forge can be found at http://forge.mysql.com, which contains the Wiki (http://forge.mysql.com/wiki) as well as the worklog, code snippets and tools for use with MySQL. Planet MySQL is an aggregate of MySQL-related blogs, including Giuseppe's and mine -- http://planet.mysql.com The website for the 2009 MySQL User Conference and Expo is at http://mysqlconf.com. MySQL Camp is a free conference at the same time as the User Conference. The details, including the schedule, are at http://forge.mysql.com/wiki/MySQLCamp2009Sessions. A collection of User Group videos is at http://technocation.org/category/areas/user-group. All the videos, including User Group ones, are  []

Using the Event Scheduler: The Friendly Behind-the-Scenes Helper Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems) Using the Event Scheduler: The Friendly Behind-the-Scenes Helper Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems) Download the PDF slides at http://assets.en.oreilly.com/1/event/21/Using%20the%20Event%20Scheduler_%20The%20Friendly%20Behind-the-Scenes%20Helper%20Presentation.pdf From the official conference description at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7115 The Event Scheduler is a framework for executing SQL commands at specific times or at regular intervals. The basics of its architecture are simple. An event is a stored routine with a starting date and time, and a recurring tag. Once defined and activated, it will run when requested. Unlike triggers, events are not linked to specific table operations, but to dates and  []

At the May 2009 Boston MySQL User Group, Giuseppe Maxia of Sun Microsystems gave a presentation about MySQL 5.4 with use cases and benchmarks to show how it outperforms all other current MySQL releases (including the Percona, OurDelta, and Google releases/patches). The slides are at http://www.slideshare.net/datacharmer/mysql-54-theory-and-practice

A year ago, the outline was being written. A lot of work was crammed into the intervening months, and I am happy and proud to announce that the MySQL Administrator's Bible has been published, and is sitting on the shelf at many major booksellers already. The official publication date is today -- Monday, May 11th, 2009 -- although some stores have had copies for a week, including Amazon.com.The MySQL Administrator's Bible, published by Wiley Press (available on Amazon.com at

If you work with databases long enough, you run into a certain problem. You have a mysqldump file* of a table or a database, and you need to import it into your new database. However, you need to change something in the file first. Maybe the "INSERT" statements need to be changed to "INSERT REPLACE". You fire up "vi "and load the file, but when you go to search and replace, "vi" runs out of memory and doesn't complete the operation. Or maybe the dump file is just so big it won't even load in the first place. What do you do in this situation?Well, one simple solution is to use the "sed" tool to modify the file. Sed actually stands for "stream editor". The "vi "editor would be considered a static editor in that it loads all of the file into memory at once. If you run out of memory, you are out of luck. With  []