(Frank Mash) Ever wondered how threads exchange data between themselves?

(Alejandro Gervasio) Welcome to the concluding part of the series “Using SQLite with PHP 5.” As you’ll possibly know, PHP 5 comes equipped with a fully-featured RDBMS called SQLite that definitely can make your life as a PHP developer much easier. It’s particularly helpful if you want to get rid of

(Partha Dutta) There have been a few posts on PlanetMySQL regarding primary keys and the importance of choosing the right one. This is even more important when the table uses InnoDB. You’ve read different posts of why it is so important. Now, I’m all about benchmarks and showing the details. So I’ll

(Frank Mash) The central component of most operating systems is the kernel. The kernel manages the resources of a system. In addition, the kernel facilitates and manages the communication between a system’s hardware and software components.

(Kevin Burton) Relational databases use indexes to speed up their performance usually due to the fact that their underlying storage is inherently slow (which has historically meant disk).

(Xaprb) MySQL’s user variables have interesting properties that enable the useful techniques I wrote about in recent articles. One property is that you can read from and assign to a user variable simultaneously, because an assignment can an r-value (the result of the assignment is the final value of

(Paul McCullagh) I have just committed the initial implementation of foreign keys for the PrimeBase XT storage engine, whew! The implementation is similar to that of InnoDB and supports the RESTRICT, CASCADE and SET NULL options.

(Frank Mash) From time to time I receive requests from friends who are interested in learning more about managing MySQL on Solaris 10. To help them (and myself), I am planning to write about the internals of both MySQL and Solaris.

MySQL 5.1 provides more enterprise-caliber enhancements that greatly assist those wanting to use MySQL for data warehousing and business intelligence, applications having extreme high-availability requirements, and systems needing a powerful but autonomous-running database that requires little atten

(Kaj Arnö) MySQL 4.0 has now reached the final stage of its active development life cycle. As I noted on 12 July 2006 when announcing the MySQL Lifecycle Policy, keeping legacy versions of our software alive is expensive and time-consuming. While we know that database administrators hate to upgrade