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.

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

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

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

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.

SQL is not meant to generate graphics, for sure; but Shlomi sees some cases where generating non-tabular output can be desirable. He explains the basics of working SQL graphics: it is actually possible to do whatever you like.

Why sharding is not always good

Visual Basic can be very loose with it's data types. If you want to avoid worrying about which type of data is coming from your database, you can simply not specify a datatype when you declare a variable, which defaults the datatype to variant. The variant should be avoided whenever possible, as it can be very CPU and memory intensive. This article demonstrates the different MySQL and VB6 datatypes and how they correlate. (2004-01-22)

Mike Hillyer explains how to work with BLOB columns using the ADO 2.5 stream object. (2003-12-02)

Developers often ask for tools that can be used to convert an Access database to MySQL (or convert an MSSQL database to MySQL), without realizing that there is more to migrating an application to MySQL than simply converting data. This article covers the basics of migrating an application from an Access or SQL Server database to MySQL. You can also discuss migration issues on the beta MySQL Forums.(2004-07-07)