(Peter Zaitsev) This is pretty simple approach I often use called to optimize web application performance if problem happens with few pages. If we have “everything is slow” problem looking at slow query logs may be better start.

(DarkLizener) This tutorial explains what a User Defined Function (UDF) is, what it does, and why/when it is useful.

(Michael S. Hines) Performance Analysts and Capacity Planners catalog and retrieve lots of data – cpu time busy, memory use, disk space use, disk subsystems performance, tape use, tape subsystem performance, network use, and network subsystem performance is just a short list. We frequently ‘throw th

(Kristian Nielsen) Is there anyone using partitioned archive tables in MySQL 5.1 for storing logs (or other voluminous data)?

This chapter provides a brief overview of the command-line programs provided by MySQL AB and discusses the general syntax for specifying options when you run these programs. Most programs have options that are specific to their own operation, but the option syntax is similar for all of them. Later c

(Franco Martinig) More and more developers are using development tools produced by the open source community like JUnit, MySQL, Eclipse, PHP or JBoss. A recent poll asked to compare the quality of open source and commercial software development tools. And the winner is… not obvious ;o)

In this chapter, we will examine what makes a database system, particularly a relational one like PostgreSQL, so useful for real-world data. We will start by looking at spreadsheets, which have much in common with relational databases but also have significant limitations. We will learn how a relat

Database administration serves a number of important functions from improving the performance of your database to avoiding a disaster that would result in lost data or costly system downtime. This article will describe some of the fundamental tools and practices programmers, as well as DBAs and SysA

(Mark Pryce-Maher) I have been looking at Microsoft’s Enterprise Library for .NET Framework 2.0 and I wondered how difficult it would be to extend the Data Access Application Block to include MySQL as one of the databases.

(Bruce Momjian) Constraints keep user data constrained, thereby helping to prevent invalid data from being entered into the database. Defining a data type for a column is a constraint in itself. For example, a column of type DATE constrains the column to valid dates.