(Alejandro Gervasio) When a database-driven web site grows past a certain size, it requires an internal search engine. If it is a very big site, it may be desirable for visitors to be able to use full-text searches and Boolean operators to find the information they need. This article, the first of a

(Rob Young) Having spent the first 15 years of my IT career in applications development and database administration I can say with utmost confidence that I invested much more time debugging problems and responding to issues than I ever did building new applications. While the teams I worked with imp

(Paul McCullagh) Current plans call for the use of the HTTP protocol to upload and retrieve BLOBs to and from the database. The BLOB Streaming Engine makes this possible by integrating a lightweight HTTP server directly into the MySQL server.

(Charles Cahoon) In my last post I reviewed how to create a test case using multiple connections and it is quickly apparent that keeping track of concurrent connections within test cases is difficult and error prone. Creating a tool to make test case writing easier and more automated is the goal of

(Dathan) Counts, we all love to show counts in our applications. Under a high traffic website, it’s visually appealing to show a big number. But the cost of generating that big number realtime can be very expensive on our mySQL backend.

(cwroblew) What do you do when the Perl CPAN module DBD::MySQL won’t install with a password for root and the Windows MySQL client program I use couldn’t remove the password for root? In the table the password was blank, but when I logged in on the command line, it required the root password I used

(Xaprb) How can a query like “SELECT * FROM tbl WHERE col IS NULL” return a row where the column has a (non-NULL) value? Read on to find out.

(Michele Davis and Jon Phillips) In this conclusion to a three-part series, you will add PEAR into the mix of what you have already learned.

(Peter Zaitsev) As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous versions.

(Kevin Burton) Apparently, there’s been an outstanding bug for nearly two years for MySQL to add support for millisecond storage in DATETIME and TIME data types.