(Falko Timme) mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM’s snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and

(Duleepa Wijayawardhana) There’s any number of ways to integrate your application with Memcached to take advantage of Memcached’s power. Here’s a list of some of them (and because I am most familiar with PHP in this case so that’s what I’ve listed, and by no means is it exhaustive):

(Anders Karlsson) If you are using MySQL with the InnoDB Storage Engine, you know and probably use FOREIGN KEYs. There are some who dislikes the use of these, saying the are bad for performance, but I tend to disagree, if the price of keeping my data consistent is a slight performance degradation, t

(George J. Trujillo Jr.) MySQL provides a number of different tools for tuning SQL statements. Some of the key SQL tuning tools include: –EXPLAIN – Displays execution plans generated by the MySQL Cost Based Optimizer. –Status Variables – Contains statistics on SQL run time activity. –Profili

(Paddy) MySQL 5.1 is generally available for production use. One of the key features of MySQL 5.1 is partitioning. Table partitioning can help in improving performance and usability. Tables can be partitioned based on range (column values in a given range), list (column values matching a set of valu

(Shlomi Noach) The REPLACE [INTO] syntax allows us to INSERT a row into a table, except that if a UNIQUE KEY (including PRIMARY KEY) violation occurs, the old row is deleted prior to the new INSERT, hence no violation.

(Peter Zaitsev) How much space would empty MyISAM table take ? Probably 8K for .frm file, 1KB for .MYI file and 0 for MYD file. .MYI file can be larger if you have many indexes.

(Lachlan Mulcahy) I have seen a few people now ask about using MySQL’s FULLTEXT indexing with asian languages such as Chinese, Japanese and Korean (herein referred to as CJK.), however, there doesn’t seem to be a good centralised article that covers it.

(Paul McCullagh) I have created a new tool, called xtstat, for analyzing the performance of the PBXT storage engine.

(Shlomi Noach) Theres a lot of buzz around memcached. memcached is widely used, and has clients for many programming languages and platforms. TangentOrg have developed a memcached client in the form of MySQL UDFs (User Defined Functions).