(Raymond Camden) A user asked me if it was possible to backup and restore a MySQL database from ColdFusion.

(Xaprb) MySQL statement-based replication is widely discussed, but I haven’t seen much about how to design a replication setup for low downtime and easy administration. Statement-based replication has inherent shortcomings experienced MySQL users know to avoid, but rarely write about. This article e

(Lucas Green) MySQL Server is the most widely used database management system in the world, primarily because it is open source and free.

(Alex Gorbachev) At the end of my last MySQL post I mentioned strange behavior with GROUP BY and DISTINCT. In Oracle such constructions are not valid and produce an error.

(Peter Zaitsev) We all know disk based temporary tables are bad and you should try to have implicit temporary tables created in memory where possible, do to it you should increase tmp_table_size to appropriate value and avoid using blob/text columns which force table creation on the disk because MEM

(Lenz Grimmer) One of the new features in upcoming MySQL 5.1 Server will be the Event Scheduler. This feature was implemented by Andrey Hristov within the scope of a master’s thesis for the University of Applied Sciences in Stuttgart. We incorporated his contribution into our code base – you can rea

(Dru Lavigne) There are nearly 60 licenses which have been approved as meeting the Open Source definition. In today’s post I’ll talk about the originating philosophies behind two of the better known licenses, the BSD and GPL.

(Alejandro Gervasio) If learning how to incorporate creational design patterns into your own PHP 5 applications is a high-priority topic for you, then this set of comprehensive articles might be what you’re looking for. Welcome to the concluding installment of the series “Using Bridge Classes with P

(Peter Zaitsev) What is often underestimated is impact of MySQL Performance by complex queries on large data sets(ie some large aggregate queries) and batch jobs. It is not rare to see queries which were taking milliseconds to stall for few seconds, especially in certain OS configurations, and on lo

(Guy Harrison) At the MySQL Mini Conference in Sydney this week we discussed how to use EXPLAIN EXTENDED to view the rewrites undertaken by the MySQL optimizer. IN particular, to see if MySQL performs a merge of the query into the view definition, or if it creates a temporary table.