( Amit Kumar Saha) This post describes how you can obtain the traces that MySQL server leaves behind for you if you ask it to. Once you have the traces, you can use it for: –Debugging – It can help you to find out which source file is the server crashing, for eg. –Learn- learn more about whic

(Hubert Lubaczewski) Every now and then I see people ask the question – how to create table if it doesnt exist yet, how to drop it, but only if it does exist and so on.

(Parvesh Garg) Few days back, one of my colleagues posted a good question. It sounds something like this; “Temporary tables are session based that means under different sessions we can create temporary tables with similar names. Now since slave thread is singleton, how does it manage to keep the

(Gevik Babakhani) Using sequences are common practice in order to have auto numbering in a PostgreSQL database. The easiest way to create an auto numbered identity field is to use the SERIAL data type macro.

(Alex Gorbachev) Its been a while since the MySQL Management Plug-in 0.42 was released. Since then, I quietly updated it to version 1.0. The changes were very few; the biggest news was that the plug-in was certified by Oracle and added to OTN Oracle 10g Grid Control Extensions Exchange (see at the b

(Johan Andersson) This blog presents a new toolkit to assist in Dimensioning of MySQL Cluster.

(Robert Hamel) Simple auditing, i.e., knowing what changed recently, can save you tons of time while troubleshooting.

(Dathan) Now some details that are usually missed. GROUP BY does sorting unless you tell mysql not to. GROUP BY has two optimization methods, loose index scan, and tight index scan.

(Robert Treat) The other day we were discussing the alter table add foreign key implementation, and Tom Lane made this observation… We’ll never be able to match the performance of not having transactions, either, but the community has never for a moment considered having a “no transactions” m

(Peter Gulutzan) MySQLs TRUNCATE statement will evolve over the next few years, as we fix bugs or strange behaviours, and as we try to make storage engines more consistent with each other. Equally interesting are the aspects that will remain the same, as we confirm that our behaviour conforms to sta