(Giuseppe Maxia) If you need to combine two scripts with MySQL Proxy you have three choices. –You can manually rewrite the two scripts (good luck!) –you can use the load-multi module to load scripts on demand; –or you can use the proxy chaining technique.

(Baron Schwartz) A while ago I wrote about how to make MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this: if a slave is stopped (or crashed) while a temporary table is open and is then restarted, the temporary table doesn’t exist anymore, and the slave will

(Ronald Bradford) I was contacted this week by a previous client regarding a failure of processing data. This was a Contact, Financial and Media Management system I developed for a non-for-profit organization a LAMJ stack, and I’ve had to do nothing since deployment in the past 3 years, no bug fixes

(Baron Schwartz) Much has been written about the new InnoDB pluggable storage engine, which Innobase released at the MySQL conference last month. We’ve written posts ourselves about its fast index creation capabilities and the compressed row format, and how that affects performance. One of the nice

(Peter Gulutzan) This book is for longtime MySQL users who want to know “what’s new” in version 5. The short answer is “stored procedures, triggers, views, information_schema”. The long answer is the “MySQL 5.0 New Features” series, and this book is the first in the series. This is the revised edit

(Peter Zaitsev) I’m not big fan on flow control functions like IF or CASE used in MySQL Queries as they are often abused used to create queries which are poorly readable as well as can hardly be optimized well by MySQL Optimizer.

(Dathan) So imagine you have a table and for every row it contains an INT that represents a user, a medium int that represents an activity number, and a ENUM that represents state.

(Peter Zaitsev) Sometimes due to programming error or due to very complex query you can get your PHP script running too long, well after user stopped waiting for the page to render and went browsing other sites.

(Dan Wellman) With the abundance of communication between the browser and a server in these days of AJAX and JSON data interchange, there has never been a better time to get your own development web server set up so that you can test all those dynamic scripts you’re writing. This article will show y

(Leo Hsu and Regina Obe) In this article we shall continue where we left off by adding paging functionality to our Adobe Flex REST grid client.