Error: I'm afraid this is the first I've heard of a "trackback" flavoured Blosxom. Try dropping the "/+trackback" bit from the end of the URL.

Mon, 30 Jan 2006

MySQL in-depth: Architecture Type Questions

1. What is the lost update problem and how does MySQL solve it?
2. What is a deadlock? Does it happen with a SQL approach to the lost update problem?
3. How can you solve it without logical units of work?
4. Discuss relation normalization and denormalization
5. What is a primary key and for InnoDB tables discuss how the physical ordering of data relates to the primary key