Some trick : how to generate/use a table of (not necessarily sequential) numbers from a mysql server.

Several methods to generate 4 billion records quickly

How to create one million records from a set of NULL values. And several alternative methods to achieve the same result

An example showing how to use Sphinx when MySQL Full Text Search limitations show up.

An useful collection of places where you can find data available for benchmarks

good tips on how to solve this problem.

Includes: the link to the playlist for all 11 videos plus 11 individual links to each video: Spider: Sharding for the Masses - Giuseppe Maxia A Better mysqltuner - Sheeri Cabral (my session!) Getting acquainted with Apache Derby - Kristian Wagaan New kid on the block: The BlackRay Data Engine — Felix Schupp MySQL High Availability Solutions — Lenz Grimmer Bringing Master/Slave into the 21st Century using Tungsten Database Clustering — Linas Virbalas PBXT: Technology trends that affect your database — Vladimir Kolesnikov MySQL Proxy: a MySQL toolbox - Architecture and concepts of misuse — Jan Kneschke Galera Replication, multi-master synchronous replication for MySQL — Seppo Jaakola Panel Discussion: The OSS Toolshed Shootout Speakers and technologies: Sheeri K. Cabral - MySQL; Holger Klemt - Firebird; Felix Schupp - BlackRay;  []

A useful article explaining how to identify bottlenecks in a system by using iostat.

A book review by Baron Schwartz.

Examples of bad queries from Sarah S., MySQL trainer.

Watch out for hostname changes with replication! a blog post with facts and figures

In the words of Sheeri: "At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning. The slides are available at http://www.technocation.org/files/doc/2009_01_Partitioning.pdf Notes: The partitioning part of the MySQL Manual is at: http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html. The functions that are not allowed in partitioning expressions are listed at: http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html We also had an interesting development — according to the manual, an INSERT to a partitioned table that includes values that do not have a partition should insert all values up to the failure point. The example I used (and  []

MySQL now provides server snapshots (nightly builds). What criteria do they meet? What should they be used for? This article clearly explains.

MySQL 5.1.38 includes the InnoDB plugin. This article shows how to install the plugin, using MySQL Sandbox and the binary snapshots.

Creating a MySQL-plugin that can be used to create a function which can in turn be used in stored procedures.

There are several ways to backup MySQL, since online backup hasn't made its way into production releases yet, so this is good roundup of what is available now.

Debugging/monitoring MySQL by reading the process memory

Generate ascii pie charts using SQL only, based on any generic query.

The PBXT storage engine for MySQL is nearing a stable release. What’s so special about PBXT, anyway?

What do you need at least to build an application with a build in mysql server that can be installed, configured and run just using an installer.