(Roland Bouman) Three months ago, I wrote about a procedure to create MySQL FEDERATED tables.

(Xaprb) This article explains how to do subtraction in SQL over samples that wrap back to zero when they exceed a boundary.

(Charles Wyke-Smith) Before you can store any data in a database, you have to create the tables that will hold the data. In this chapter, the author walks you through the process of using a single table to store a site’s member names and e-mail information. You’ll also learn how to create a database

(Peter Zaitsev) One interesting problem with MySQL Optimizer I frequently run into is making poor decision when it comes to choosing between using index for ORDER BY or using index for restriction.

(Sergey Petrunia) I hope this is my last post about this topic. It seems we’ve resolved all of the issues and I’ll now describe the user-visible consequences.

(Peter Zaitsev) MySQL Replication is asynchronous which causes problems if you would like to use MySQL Slave as it can contain stale data. It is true delay is often insignificant but in times of heavy load or in case you was running some heavy queries on the master which not take time to replicate t

(Julian Hyde) One of the strengths of mondrian’s design is that you don’t need to do any processing to populate special data structures before you start running OLAP queries. More than a few people have observed that this makes mondrian an excellent choice for ‘real-time OLAP’ — running multi-dimen

(Roland Bouman) Some people believe that the ability to commit or rollback multiple statements as a single unit is a defining characteristic of the concept of transactions. They draw the -false- conclusion that enabling autocommit is the same as disabling transactions. It is easy to demonstrate why

(Peter Zaitsev) This week I helped dealing with performance problems (part MySQL related and part related to LAMP in general of system which does quite a bit of content delivery, serving file downloads and images – something a lot of web sites need to do these days. There were quite a bit of mistake

(pabloj) So what, if you are planning a centralized MySQL server and many clients all around the world?