(Peter Zaitsev) The problem of MySQL Replication unable to catch up is quite common in MySQL world and in fact I already wrote about it. There are many aspects of managing mysql replication lag such as using proper hardware and configuring it properly. In this post I will just look at couple of quer

(Mark Callaghan) There are some cases when I want to know the plan for a running query. These include:

(Baron Schwartz) When optimizing queries for customers, the first thing I do with a slow query is figure out what it’s trying to do. You can’t fully optimize a query unless you know how to consider alternative ways to write it, and you can’t do that unless you know what the query “means.” I frequent

(Patrick Galbraith) To have online backups of MySQL, We recently bought a license for InnoBase/Oracle’s InnoDB Hot Backup Tool, ibbackup. This tool, used in conjunction with innobackup, has worked great in creating a nightly backup, with no downtime during the backup. Not even nagios messages!

(Guilhem Bichot) The MySQL project switched from Bitkeeper to another revision control system, Bazaar, in June 2008. My colleague Daniel Fischer wrote an excellent article describing how to get MySQL’s code by using Bazaar, and how to compile a MySQL server binary from this. Here I am going to build

(Garry Robinson) Last year we took on an elderly, undocumented Access 97 database linked to a MySQL back-end. The task was to fix existing problems, upgrade to Access 2007 and Vista, and bring the functionality in line with current business practices. It would involve an independent re-build (mainly

(Giuseppe Maxia) Talking with users at OSCON 2008, the biggest fear with new features was table corruption with partitioning. Until recently, this fear was substantiated by bug#20129, which reported inability of repairing corrupted partitions. The initial “fix” for this bug was to disable the offend

(Robin Schumacher) Unless youve been on a desert island lately, you probably know that the area of data warehousing/analytics/business intelligence (BI) is going gangbusters these days. Not many years ago, when industry analyst groups polled CIOs on their top priorities, BI was #10. Then it jumped t

(Kevin Burton) The output from SHOW INNODB STATUS isnt very pretty or easy to use. Seriously, other than Heikki who thinks in 16k block sizes? 🙂

(Ronald Bradford) While working for a client, I had need to produce canned results of certain different criteria, recording the result in a table for later usage, and keep the position within each result.