(Brooks Johnson) Last time I demonstrated a case where stored procedures are slow. There were a few comments that I should include selects in the stored procedure to make the tests more realistic. From experience I already knew the answer so I didn’t go into that level of detail, but since stored

(Leo Hsu and Regina Obe) This article is a bit of a companion to our article on Setting up PostgreSQL as a Linked Server in Microsoft SQL Server 64-bit.

(Shlomi Noach) Installing a single MySQL instance on a linux machine is a very simple operation. It may be as simple as: apt-get install mysql-server

(Augusto Bott) When using Oracle, the data dictionary provides us with tons of tables and views, allowing us to fetch information about pretty much anything within the database. We do have information like that in MySQL 5.0 (and up) in the information_schema database, but it’s scattered through seve

(Peter Gulutzan) This is #7 in a series of blog postings about MySQL Performance Schema.

(Baron Schwartz) I vaguely recall a couple of blog posts recently asking something like “what’s the formula to compute mysqld’s worst-case maximum memory usage?” Various formulas are in wide use, but none of them is fully correct. Here’s why: you can’t write an equation for it.

(Sean Hull) MySQL Replication is some sophisticated and flexible technology. As we discussed in our recent article "Fixing MySQL Replication", it can be made quite reliable and robust if the right tools are used to keep it running smoothly.

(Peter Gulutzan) This is #6 in a series of blog postings about MySQL Performance Schema.

(Baron Schwartz) One of the most common patterns I see in my consulting work is identifiers that are generated by MD5() or UUID(). Many times this is done in an application framework or something similar — not software the client has written. From the application programmer’s point of view, it’s jus

(Peter Gulutzan) This is #5 in a series of blog postings about MySQL Performance Schema.