(Giuseppe Maxia) Some time go, we announced a new release model for MySQL. As all new things, it had some initial hiccups (with MySQL 5.4 we were still getting acquainted with the new model), but now it seems to be in full swing.

(Max Hetrick) I’m not a database guru, so for me, getting into and working with the guts of databases isn’t always easy. For the limited amount of time I have to work with databases, I like using GUI tools to help me complete my tasks. Also, when you use administration tools, there’s often no need t

(Sean Hull) DRBD is a Linux project to provide a real-time distributed filesystem. Although it has some clustering support, it’s not really a true clustered filesystem like OCFS2 or GFS2. What it provides is a mirrored copy of a block device across a network.

(Kerry Osborne) I was in a meeting yesterday and a guy asked if there was a way to track changes to database parameters (sometimes called init.ora parameters by old guys). I thought for a second and said I didn’t think there was any sort of built in mechanism for doing that, no history table that I

(Baron Schwartz) The best overall method of performance optimization is optimization for response time. Users care about response time, not load average or cache hit ratios. The job of a system is to accept some request and do the required work, and deliver a result. The time elapsed between the req

(Shlomi Noach) Here’s a complication of some common and useful time & date calculations and equations. Some, though very simple, are often misunderstood, leading to inefficient or incorrect implementations.

(Peter Zaitsev) I had an interesting case recently. The customer dealing with large MySQL data warehouse had the table which was had data merged into it with INSERT ON DUPLICATE KEY UPDATE statements. The performance was extremely slow. I turned out it is caused by hundreds of daily partitions creat

(Michael McLaughlin) We got away with a bit of lazy in PHP, at least through PHP 5.29. Especially when we worked with LOB columns. All that is at an end with PHP 5.3. You must now call the mysqli_stmt_store_results($stmt); function (line number 9 in the program snippet below) between the execute and

(Mark Callaghan) The Oracle and MySQL RDBMS are very different products. This makes me happy. I used to work on the Oracle RDBMS.

(Shlomi Noach) Following Restore one table from an ALL database dump and Restore a Single Table From mysqldump, I would like to add my own thoughts and comments on the subject.