While optimization is possible with limited knowledge of your system or application, the more you know about your system, the better your optimization will be. This article, the first of two parts, covers some of the different points you will need to know for optimizing MySQL.

(Elizabeth Millard) With new features in the latest version of MySQL, like subqueries and a new binary format, the company has become a stronger competitor against much larger companies, and seems poised to bite into their revenues. Even more importantly, MySQL might actually spark some fundamental

(Paul DuBois) This chapter provides an overview of the naming conventions and other syntax necessary to work in MySQL. Going through this chapter will also help you to get started in SQL by teaching you various commands and shortcuts that will help the SQL beginner.

(Ian Gilfillan) I recently arranged for the developers at our company to get MySQL certified. From the employer’s point of view, it was not the piece of paper I was after. Rather, the improved productivity that properly-trained MySQL users could provide. The benefits have been noticeable. The number

(Paul DuBois) Virtually everything you do in MySQL involves data in some way or another because the purpose of a database management system is, by definition, to manage data. This chapter will help you get started working with data in SQL.

(Ziran Sun) The first part of this article illustrated how to install and configure the MySQL Database Server, install and use the MySQL Administrator, create a new database, and create and populate a new sample table with some sample data.

(Paul Krill) ActiveGrid will announce an early-access release of its open source enterprise application platform that will leverage PC-based computing grids and will include an application server not based on Java.

(Nathan Valentine) An often overlooked but essential ingredient of any smooth-running IT environment is reliable data backup and restore capabilities. Thankfully, the free software/open source community has provided several centralized over-the-network backup and restore solutions. Dan Langille cove

(Mauricio Cuenca) This article shows some examples of how to use the date/time features with MySQL and PHP including the UNIX timestamp and the PHP date_diff() function.Some time ago working with dates and times was a pain for me. In several of my projects I had to calculate a person’s age based on

(Neil McAllister) When you think of enterprise Web applications, it’s only natural to think of J2EE and .Net. After all, these are the technologies most developers choose when implementing mission-critical apps. But as Friendster found out, the open-source LAMP platform is a mature alternative that