Stored procedure to add-remove prefix by rename table

A description of the MySQL Cluster startup process and its various phases.

This paper is an introduction to the new 'performance schema' feature, which will be part of the upcoming MySQL 5.5 release. Covering in details every part of the performance schema would require much, much more than a simple article. The pace of this teaser is voluntarily fast, to have a quick overview of the new landscape, and help users already familiar with MySQL to understand by examples what the performance schema provides.

A while back Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to serializing data and just storing it inside TEXT/BLOB columns. It seems that since then, the technique has gotten more popular with Ruby gems now around to do this for you automatically. So when is it a good idea to use this technique?

Insightful report by Linden Labs (the company behind Second Life) on how they prepared to update their central database from MySQL 4.1 to 5.0.

On first glance, it looks like TEXT and VARCHAR can store the same information. However, there are fundamental differences between the way TEXT fields and VARCHAR fields work, which are important to take into consideration.

Sample explanation and code to create data cubes in MySQL using a Gearman UDF and a perl worker. No need to know Perl. This method allows anyone to create crosstabs in SQL, regardless of the programming language used to query the database.

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost everytime LOAD DATA INFILE come into rescue. In this article we will try to understand some of the very common scenarios for loading data into MySQL Database.

InnoDB at 10,000 IOPS

The release of MySQL 5.5 has brought several enhancements. While most of the coverage went, understandably, to the semi-synchronous replication, the enhancements of partitioning were neglected, and sometimes there was some degree of misunderstanding on their true meaning. With this article, we want to explain these cool enhancements, especially the parts that were not fully understood.

Interesting article about some gotchas and things worthwhile knowing about MySQL's built-in replication system.

A useful introduction to using SIGNAL with triggers/stored routines.

This example will show you how to log your MySQL Proxy output to a log file rather than to the terminal.

An in-depth article that explains how to use MySQL replication for high-availability purposes.

An article describing some key aspects to keep in mind when adding more data nodes in order to gain more performance.

An excellent Q&A Session with insightful details about the PBXT Storage Engine

tutorial de mysql workbecnch

Video: Building a MySQL Slave and Keeping it in Sync At the Boston MySQL User Group Sheeri Cabral presented on how to get a consistent snapshot to build a slave, how to use mk-table-checksum to check for differences between masters and slaves on an ongoing basis, and how to use tools such as mk-table-sync and mysqldump to sync the data if there are any discrepancies. This link contains the slides and the videos

Author's announcement that the MySQL Bible, for beginner and intermediate MySQL DBA's, is available. The book is suitable for those completely new to databases, or those that are familiar with another RDBMS (such as Oracle or Microsoft SQL Server) and want to learn how MySQL works.

sar-sql name change, state of the software and road map.