(Mike Hillyer) Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simpl
Tag: Open Source
Open Source to the Rescue
(Cathleen Moore) Who says open source can’t measure up to commercial software for mission-critical applications? Far from being a mere quick fix or low-cost alternative, open-source software is helping real-world companies solve their most pressing IT problems.
MySQL’s Enterprise Ecosystems Continues To Expand
(Vance McCarthy) MySQL cemented its position as one of the core hubs for enterprise-driving Open Source activity at this week’s MySQL Users Conference in Santa Clara. A wide array of commercial and Open Source software providers lined up to add their capabilities to MySQL’s 2005 push to deliver
The State of the Dolphin at the MySQL Users Conference 2005
(Daniel H. Steinberg) Much has changed in the decade since the first code was written for MySQL. The machines we carry with us are many times more powerful and the number of nodes on the network has exploded in the years since 1995.
MySQL 5.0 Stars at Users Conference
(Lisa Vaas) Oh, if only the whole despicable idea of software patents would crumble as quickly as the fudge cake that MySQL users scarfed down at the third users conference (and 10-year birthday bash) for the database here.
MySQL Optimization, part 2
Currently, MySQL supports table-level locking for ISAM, MyISAM, and MEMORY (HEAP) tables, page-level locking for BDB tables, and row-level locking for InnoDB tables.
MaxDB performance tuning primer
A history of more than three decades has made MaxDB by MySQL a very mature database with a rich tool set for performance monitoring and analysis. Aside from an activity overview screen and the EXPLAIN SQL statement a SQL logger sophisticated monitoring tools are shipped with MaxDB for free. In a sma
Subversion Delivers Version Control that CVS Can’t
(Wellie Chao) The designers of Subversion have created an open-source version control tool that fixes the flaws and addresses shortcomings in the popular Concurrent Versions System (CVS) version control system. The following are the most significant and visible CVS flaws that Subversion rectifies:
Can mySQL/LAMP Challenge Oracle, Microsoft, and Sybase?
(Stephen L. Michel) MySQL Version 5.0 promises more features that make it much more palatable for database traditionalists, and likely making it more welcome in IT departments, alongside Oracle, Microsoft SQL Server, and Sybase SQL Anywhere. A conference in Santa Clara, CA this week should shed more
Backing up and restoring MySQL databases: a 3-step method
If you’re a Web site administrator charged with maintaining server uptime, you already know that there’s only one thing scarier than the smell of your server overheating, and that’s the sound of your disks crashing. It’s even worse when those disks contain critical data, like user passwords or conte