(Baron Schwartz) Finding bad queries is a big part of optimization. A scientific optimization process can be simplified to “can anything be improved for less than it costs not to improve it? – if not, we’re done.”

(Shinguz) A few days ago I had to deal with MySQL Cluster replication. I did not do this for a while so I was prepared to expect some interesting surprises once again.

(Shlomi Noach) A few days ago I published SQL: selecting top N records per group. It just dawned on me that the very same query solved another type of problem I was having a couple years ago.

(Chris Schneider) MySQL Workbench has come a long way and keeps getting better! I honestly don’t think that millage may vary on this one as it is one of the best no-cost GUI tools created for MySQL.

(Peter Zaitsev) I again work with the system which needs high insertion rate for data which generally fits in memory. Last time I worked with similar system it used MyISAM and the system was built using multiple tables. Using multiple key caches was the good solution at that time and we could get ov

(Rob Gravelle) When someone mentions the term “reusable query”, the first thought that comes to mind is usually stored procedures. While they are an integral part of writing reusable code, they are only one ingredient in a bigger pie. Other key players include views and native as well as user-def

(Shlomi Noach) A while back I presented(*) an SQL trick to present with non-aggregated column on a GROUP BY query, without use of subquery or derived tables.

(Mark Callaghan) I did more performance tests with MySQL 5.1.47 unmodified, 5.5.8 unmodified and 5.1.52 with the Facebook patch. Some of the results are interesting so I will document them here for future reference.

(Sean Hull) MySQL has a wonderful facility for capturing slow queries called the slow query log. However if yours is not enabled when trouble occurs, and restarting the database is not an option, you’ll need another solution. This is where a tcpdump can come in handy. It can be used to watch a n

(Vadim) A couple of days ago, Dimitri published a blog post, Analyzing Percona’s TPCC-like Workload on MySQL 5.5, which was a response to my post, MySQL 5.5.8 and Percona Server: being adaptive. I will refer to Dimitri’s article as article [1].