(Jay Pipes) Damien Seguy had an interesting observation on my use of self joins for generating rolling sums: What about using a user variable to make the rolling sum from the beginning? Something simple enough like this: set @sum := 159; // to start with the original number of post, or 0 if

(Raja Kishore) Python programming language has moved from the days when it used to be a plumbing tool for web programmers and system administrators. Today it is ubiquitous and is used in practically every application area one can think of! The fact that it is free and Open Source, coupled with the s

(Kristian Köhntopp) One of the major contributing factors to the success of MySQL is the ease and simplicity of its replication. Read-slaves for scaleout and backup-slaves for noninterrupting backups are the norm in any MySQL installation I have seen in the last two years.

(Peter Zaitsev) In my previous post I mentioned you might need to increase net_write_timeout to avoid connection being aborted and now I think I should have better explained that.

(Sergey Petrunia) Our exprience in solving query optimizer problems shows that a good chunk of optimization problems are incorrect choice of join order. The most frequent causes of the problems are –Table engine returns index statistics or records-in-range numbers that are very far from reality;

(Peter Zaitsev) We’re working with web site preparing for massive growth. To make sure it handles large data sets as part of the process we work on generation test database of significant size as testing your application on table with 1000 rows may well give you very dangerous false sense of securit

(Giuseppe Maxia) MySQL is the most popular open source database server in the world. As such, it must be enough to satisfy the needs of most of its users. But users don’t have only needs. They have wishes. And they wish to have a more powerful, more feature rich database server, and that’s why MySQL

(Roland Bouman) Currently I need to move a bit of data around. I like to use Kettle for this type of work rather than writing custom scripts for a number of reasons (which I won’t discuss here).

(Giuseppe Maxia) When users submit a report to the MySQL bug system, many of them believe that they are going to get in direct contact with the developers. Before joining MySQL, every time I submitted a bug report I could not help depicting in my mind the idea of a developer while working at his des

(Peter Zaitsev) What does working with large data sets in mySQL teach you? Of course you have to learn a lot about query optimization, art of building summary tables and tricks of executing queries exactly as you want. I already wrote about development and configuration side of the problem so I will