(Baron Schwartz) It seems that a lot of people want to try to improve MySQL performance by focusing on server status counters and configuration variables. Looking at counters, and “tuning the server,” is better than nothing, but only barely. You care first and foremost about how long it takes to exe

(Rob Gravelle) HeidiSQL is a free and easy-to-use GUI client for MySQL. It’s favored by many Web developers and database administrators of small to medium-sized businesses to manage persistent storage of data. Version 4.0 of “the program with the odd name” was released just a few days ago on April 3

(Darren Cassar) Recently I needed to replicate between MySQL and another database technology. You might say, why on earth would you want to do something like that, but believe me there are reasons and definitely not (to go away from MySQL to some other DB technology like Oracle or SQL server). Unsur

(Barry Leslie) The PBMS BLOB repositories can now be backed up with mysqldump.

(Bradley) Yesterday, I (Zardosht) posted an entry introducing clustering indexes. Here, I elaborate on three differences between a clustering index and a covering index: –Clustering indexes can create indexes that would otherwise bounce up against the limits on the maximum length and maximum n

(Leo Hsu and Regina Obe) One thing that is pretty neat about windowing functions in PostgreSQL 8.4 aside from built-in windowing functions (row_number(), rank(), lead(), lag(), dense_rank(), percent_rank(), cume_dist(), first_value, last_value, nth_value) as documented in the manual Windowing Functi

(Anders Karlsson) I have seen this question more than once, and I have answered it more than once, but let me get you the facts here, so you know what to look for:

(Leo Hsu and Regina Obe) One thing that is pretty neat about windowing functions in PostgreSQL 8.4 aside from built-in windowing functions (row_number(), rank(), lead(), lag(), dense_rank(), percent_rank(), cume_dist(), first_value, last_value, nth_value) as documented in the manual Windowing Functi

(Bradley) In this posting I’ll describe TokuDB’s multiple clustering index feature. (This posting is by Zardosht.)

(Diego Medina) A couple of weeks ago I wrote a lua script to use with the MySQL Proxy that transforms the Proxy into a key=>value lookup dictionary.