(Jan Stafford) Pinpointing performance bottlenecks is a problem on any database — proprietary or open source, said veteran database administrator (DBA), database book author and MySQL executive Robin Schumacher. In this interview, he identifies the biggest hassles that DBAs face and the advantages

(Arjen Lentz) As I’m sure you’re aware, MySQL 5.0 is currently in its beta phase. It may appear obvious, but software does not magically become stable (production quality) just by waiting a while! Next to our crack QA (Quality Assurance) Team, the QA process relies on you, the many users of the

(Dick Wall) Originally, I was planning to use this article to cover use of Java Studio Creator for simple Web apps that could be used on a mobile phone, but I realized that this and other articles I was planning to write about would require data in something a little more complete than the pointbase

With the popularity of MySQL rising, more corporations are beginning to explore how best to migrate existing systems to the MySQL platform. Understanding the reasons for migrating to MySQL and how such migrations, whether large or small, are performed successfully, can help you fully leverage the be

(Sean Michael Kerner) Sleepycat Software launched a new version of Berkeley DB Java Edition and is offering the catnip of performance and usability improvements with this release.

(Jennifer LeClaire) Regardless of which vendor you pick in the open-source database horse race, open source itself is a good bet, according to Yankee Group analyst Dana Gardner. Gardner told LinuxInsider that open-source databases generally hold a lot of promise, and there is room for multiple playe

(Russell Dyer) One of the difficulties with a large and active MySQL database is making clean backups without having to bring the server down. Otherwise, a backup may slow down the system and there may be inconsistency with data, since related tables may be changed while another is being backed up.

(Peter Gulutzan) A MySQL full-text query returns rows according to relevance. But what is relevance? It is a floating-point number based on formulas. Researchers have shown that these formulas produce results that real users want. I will disclose how MySQL 4.1 uses them, with a bit of arithmetic and

(Ravi Kumar) LAMP stands for Linux, Apache, MySQL and PHP, an open-source Web development platform that uses Linux as the operating system, Apache as the Web server, MySQL as the RDBMS and PHP as the scripting language.

(Ian Gilfillan) MySQL 5 offers a number of new storage engines (previously called table types). In addition to the default MyISAM storage engine, and the InnoDB, BDB, HEAP and MERGE storage engines, there are four new types: CSV, ARCHIVE, FEDERATED and EXAMPLE, as well as a new name for the HEAP sto