(Alex Gorbachev) This is actually a follow up on my previous post. Developers tried to rewrite all statements and even overdid it. As we say in Russia – “teach fool how to pray and he will break his forehead”.

(Paul Moen) Filesorts and temp tables are a necessary evil in MySQL, used when MySQL must sort the data before returning the output to the user. They are the most common issue with slow queries in MySQL, the main reason being that if the output is too large, you can kiss goodbye in-memory performanc

(Il Corra) In my last post (see it for details) about stored procedure replication I was wrong. I’m using 5.0.30 and, in fact, CALL statements are not written to the binlog. My knowledge about SP replication was before 5.0.12. This morning I read carefully the manual 🙂

(Jeremy Kirk) Open-source database maker MySQL AB will soon release the alpha version of its Falcon storage engine, designed for high-volume Web server environments, a company executive said this week.

(Il Corra) If we have a replication architecture and we are using stored procedures, we need to pay attention to the use of rand() inside the SPs.

(Peter Zaitsev) To check for query performance improvements followed indexing/query changes or MySQL configuration changes our customers often decide to run the query and see if there is any significant improvement.

(Alex Gorbachev) Today is the first time I had to look at MySQL performance. Tiny database as web application back-end was having significant performance issues with spikes of CPU workload. After identifying problematic queries, I found a pile of statements using IN subqueries.

(Vadim Tkachenko) Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth that MyISAM is faster than

(Guy Harrison) I wrote recently about using events and the new processlist table in MySQL 5.1 to keep track of the number of connected processes. Although having the PROCESSLIST available as an INFORMATION SCHEMA table is usefull, it seemed to me that having SHOW GLOBAL STATUS exposed in a similar

(Barry Railton) Many companies have data scattered across several databases that are often maintained by proprietary software. For example, we might have a computer inventory in a specialized application that keeps track of assets, an office phone list in a Word document, employee locations in an Ex