(Shlomi Noach) INSERT DELAYED may come in handy when using MyISAM tables. It may in particular be useful for log tables, where one is required to issue frequent INSERTs on one hand, but does not usually want or need to wait for DB response on the other hand.

(Mark Callaghan) The explain command in MySQL is very useful. Alas, it has its limits including some related to the use of the LIMIT clause. This is even more reason to do more than EXPLAIN when testing a query.

(Vincent Danen) The de facto system logger on Linux systems is sysklogd, which provides the syslog and klog services that allow system events and application events to be logged and written to standard log files such as /var/log/messages. While sysklogd works well enough, there are other alternative

(Venu Anuganti) When we wanted to quickly process intermediate data by using temporary or heap tables; then its normal tendency to create a table like its source table; so people will simply opt for CREATE TEMPORARY TABLE temp_table LIKE source_table.

(Kedar) Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost everytime LOAD DATA INFILE come into rescue.

For 2010, Business Intelligence (BI) is predicated to be the top tech priority for both small and large companies alike, just as it has been for the past four years. At the heart of every BI system is the database, and as BI has grown, so has usage of MySQL as BI’s back end database and for good rea

(Robin Schumacher) If you’ve wondered whether a MySQL-based column database can hold its own against one of the big, leading row-based databases in a benchmark with terabytes of data and serious queries, well, now you at least have some information to consider. We recently commissioned one of the to

(Mark Callaghan) Assuming this table: create table t1(i int, j int, primary key (i,j)), which form of predicates should you use?

(Jonathan Haddad) Over three years ago I wrote about how you cannot use a stored procedure in a subquery. Well, it’s 2010, and I’m still annoyed by this and a handful of other things.

(Peter Zaitsev) Upgrading MySQL Server is a very interesting task as you can approach it with so much different “depth”. For some this is 15 minutes job for others it is many month projects. Why is that?