High Performance MySQL

£22.80

Jeremy Zawodny and Derek J. Balling; ISBN: 0-596-00306-4

As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics.

Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.

In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.

Topics include:

• A review of configuration and setup options
• Storage engines and table types
• Benchmarking
• Indexes
• Query Optimization
• Application Design
• Server Performance
• Replication
• Load-balancing
• Backup and Recovery
• Security

Managing & Using MySQL, 2nd Edition

£22.80

George Reese,Randy Jay Yarger,Tim King and Hugh E. Williams; ISBN: 0-596-00211-4

MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included throughout.

This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair. In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions.

If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls for each language.

Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security.

MySQL Cookbook

£28.40

Paul DuBois; ISBN: 0-596-00145-2

While MySQL has turned up among high profile users such as Yahoo!, NASA and the U.S. Census Bureau, the rising popularity of this open source database is especially keen among users with little database experience. These days, even a small organization or web site has uses for a database, and MySQL is an obvious choice. Affordable and easy to use, MySQL packs the power, speed and efficiency that enable it to rival expensive, proprietary database solutions. Yet, even if you know the basics, anyone without practical MySQL experience--novices and skilled DBAs alike--might stumble over common database-related tasks. Fortunately, there's a sensible shortcut.

MySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe"--short, focused pieces of code that you can insert directly into your applications. But MySQL Cookbook is more than a collection of cut-and-paste code. You also get explanations of how and why the code works, so you can learn to adapt the techniques to similar situations.

The book covers a lot of ground. Solutions for typical MySQL dilemmas range from simple ways to find all records that contain a given string, to more difficult problems, such as finding matching/non-matching records in two tables. Whether you use MySQL on Unix, Linux, Windows or the Mac OS X platform, the book will show you how to:

• Import data from external sources
• Export data for use by external programs
• Access MySQL from your web server
• Use scripts with MySQL to read queries from a file
• Access MySQL from within client programs that use Perl, PHP, Java, Python and other languages
• Construct queries that solve commonly-occurring questions
• Interact with the server

This learn-as-you-go resource will help users of all levels exploit MySQL more fully. MySQL Cookbook supplies you with an armory of ready-made techniques for specific problems so that, even if you're an experienced MySQL user, you don't have to write everything from scratch.

MySQL Pocket Reference

£5.56

George Reese; ISBN: 0-596-00446-X

If you use MySQL, you know why it's the world's most popular open source database: small, fast, and powerful, and so rich in features that no administrator or programmer can stay familiar with all of them. There are always some little-known commands and clauses that could help you become more efficient in your work if you could just keep them in mind. The problem is, you don't always have time to stop and thumb through an exhaustive reference when you're hard at work. If you need a quick reminder, the MySQL Pocket Reference can lead you straight to the answer you need to know to get the job done.

Easy to take and use anywhere, this little book provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure. A complete reference to the MySQL version of SQL, this pocket guide also serves as a convenient companion to our large, in-depth volume, Managing and Using MySQL. The book covers installation of MySQL and includes a description of SQL commands, data types, operators, and functions. In this small book, you get a handy reference to the enormous feature set of MySQL, the dominant database in the open source world.

O'Reilly's Pocket References have become a favorite among programmers everywhere. By providing important details in a succinct, well-organized format, these pocket-sized books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and need to get to a solution quickly, the new MySQL Pocket Reference is the book you'll want to have.

MySQL Reference Manual

£22.80

Michael "Monty" Widenius,David Axmark and MySQL AB; ISBN: 0-596-00265-3

MySQL is the most popular SQL database in the open source community and is used almost universally by web sites running on open source systems. As powerful and flexible as it is lightweight and efficient, MySQL packs a large feature set into a very small and fast engine that now runs on more than 500,000 servers. This renowned online manual that has supported MySQL administrators and database developers for years is now available in paperback format. This book is an exact reproduction of the MySQL Reference Manual from the MySQL development team's Web site, minus some non-technical appendices. This version covers MySQL 4.0.

Many sophisticated topics appear in this comprehensive manual, ranging from the hitches you may run into when first installing MySQL to internals that will help you tune your queries. MySQL Reference Manual contains all the comprehensive reference material one would expect for building the product, running administrative utilities, and using various API as well as MySQL's rich version of SQL. In addition, you can turn a page and find such unexpected riches as:

A thorough comparison of MySQL with SQL standards and other databases A discussion of privileges and suggested uses of privileges to enhance security Directions for replicating a database and for running several MySQL servers on a single system Directions for initializing a database from a flat file Guidelines for estimating the performance of different queries A far-reaching discussion of optimization, with reference to the implementation of MySQL Investigations of the differences between data types and the pros and cons of each type of number, string, or timestamp An extended inquiry into the effects of using delayed inserts A candid explanation of why various errors occur and how to recover from them Tips for weighted, full-text searches Detailed descriptions of the features, strengths, and weaknesses of available table formats A guide to adding new functions to MySQL

No serious MySQL user should be without this book.

SQL Pocket Guide

£5.56

Jonathan Gennick; ISBN: 0-596-00512-1

This pocket guide presents the most crucial information about SQL in a compact and easily accessible format, covering the four commonly used SQL variants--Oracle, IBM DB2, Microsoft SQL Server, and MySQL. Topics include:

• Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK).
• Common SQL functions (date, numeric, math, trigonometric, string, conversion, aggregate)
• Such topics as literals, NULLs, CASE expressions, datatype conversion, regular expressions, grouping and summarizing data, joining tables, and writing queries (hierarchical, recursive, union, flashback) and subqueries.
• Instead of presenting complex and confusing syntax diagrams, the book teaches by example, showing the SQL statements and options that readers are most like to use. All example data is available on the O'Reilly web site.

"If you need fast, accurate SQL information, with examples for multiple database engines, be sure to check out this book."

--Chris Kempster, Senior DBA and author of SQL Server 2000 for the Oracle DBA, www.chriskempster.com

SQL Tuning

£22.80

Dan Tow; ISBN: 0-596-00573-3

A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications.

There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. SQL Tuning provides answers to these questions and addresses a third issue that's even more important: how to find the optimal execution plan for the query to use.

Author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems."

Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance.

SQL in a Nutshell, 2nd Edition

£25.56

Kevin E. Kline,Daniel Kline, Ph.D. and Brand Hunt; ISBN: 0-596-00481-8

SQL in a Nutshell

applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world.

This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases.

When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell, Second Edition will be the quick reference you'll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it.

Software Portability with imake, 2nd Edition

£18.80

Paul DuBois; ISBN: 1-56592-226-3

imake

is a utility that works with imake to enable code to be compiled and installed on different UNIX machines. imake makes possible the wide portability of the X Window System code and is widely considered an X tool, but it's also useful for any software project that needs to be ported to many UNIX systems. imake also runs under Windows NT.

This handbook is ideal for X and UNIX programmers who want their software to be portable. The book is divided into two sections. The first section is a general explanation of imake, X configuration files, and how to write and debug an Imakefile. The second section describes how to write configuration files and presents a configuration file architecture that allows development of coexisting sets of configuration files. Several sample sets of configuration files are described and are available free over the Net.

New in the second edition:

• Updated to cover the version X11R6.1 of the X Window System

• Discusses using imake for non-UNIX systems such as Windows NT

• Covers some of the quirks about using imake under OpenWindows/Solaris

Transact-SQL Cookbook

£19.96

Ales Spetic and Jonathan Gennick; ISBN: 1-56592-756-7

This unique cookbook contains a wealth of solutions to problems that SQL programmers face all the time. The recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Authors Ales Spetic and Jonathan Gennick, two authorities with extensive database and SQL programming experience, include a discussion with each recipe to explain the logic and concepts underlying the solution.

SQL (Structured Query Language) is the closest thing to a standard query language that currently exists, and Transact-SQL -- a full-featured programming language that dramatically extends the power of SQL -- is the procedural language of choice for both Microsoft SQL Server and Sybase SQL Server systems. The Transact-SQL Cookbook is designed so you can use the recipes directly, as a source of ideas, or as a way to learn a little more about SQL and what you can do with it. Topics covered include:

• Audit logging. In addition to recipes for implementing an audit log, this chapter also includes recipes for: improving performance where large log tables are involved; supporting multiple-languages; and simulating server push.
• Hierarchies. Recipes show you how to manipulate hierarchical data using Transact-SQL.
• Importing data. This chapter introduces concepts like normalization and recipes useful for working with imported data tables.
• Sets. Recipes demonstrate different operations, such as how to find common elements, summarize the data in a set, and find the element in a set that represents an extreme.
• Statistics. This chapter?s recipes show you how to effectively use SQL for common statistical operations from means and standard deviations to weighted moving averages.
• Temporal data. Recipes demonstrate how to construct queries against time-based data.
• Data Structures. This chapter shows how to manipulate data structures like stacks, queues, matrices, and arrays.

With an abundance of recipes to help you get your job done more efficiently, the Transact-SQL Cookbook is sure to become an essential part of your library.

Transact-SQL Programming

£28.40

Kevin E. Kline,Lee Gould and Andrew Zanevsky; ISBN: 1-56592-401-0

Transact-SQL is a procedural language used on both Microsoft SQL Server and Sybase SQL Server systems. It is a full-featured programming language that dramatically extends the power of SQL (Structured Query Language).

The language provides programmers with a broad range of features, including:

• A rich set of datatypes, including specialized types for identifiers, timestamps, images, and long text fields
• Local and global variables
• Fully programmable server objects like views, triggers, stored procedures, and batch command files
• Conditional processing
• Exception and error handling
• Full transaction control
• System stored procedures that reduce the complexity of many operations, like adding users or automatically generating HTML Web pages

In recent years, the versions of Transact-SQL have diverged on Microsoft and Sybase systems; the book explains the differences. It also contains up-to-the-minute information on the latest versions: Microsoft SQL Server versions 6.5 and 7.0 and Sybase version 11.5.

A brief table of contents follows:

PART I: The Basics: Programming in Transact-SQL

1. Introduction to Transact-SQL

2. Matching Business Rules

3. SQL Primer

4. Transact-SQL Fundamentals

5. Format and Style

PART II: The Building Blocks: Transact-SQL Language Elements

6. Datatypes and Variables

7. Conditional Processing

8. Row Processing with Cursors

9. Error Handling

10. Temporary Objects

11. Transactions and Logging

PART III: Functions and Extensions

12. Functions

13. CASE Expressions and Transact-SQL Extensions

PART IV: Programming Transact-SQL Objects

14. Stored Procedures and Modular Design

15. Triggers

16. Views

17. System and Extended Stored Procedures and BCP

PART V: Performance Tuning and Optimization

18. Transact-SQL Code Design

19. Code Maintenance in the SQL Server

20. Transact-SQL Optimization and Tuning

21. Debugging Transact-SQL Programs

PART VI: Appendixes

A. System Tables

B. What's New for Transact-SQL in Microsoft SQL Server 7.0? C. BCP

The book comes with a CD-ROM containing an extensive set of examples from the book and complete programs that illustrate the power of the language.

Web Database Applications with PHP and MySQL, 2nd Edition

£25.56

Hugh E. Williams and David Lane; ISBN: 0-596-00543-1

There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably.

Web Database Applications with PHP and MySQL, Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templates

to give your dynamic web pages a standard look.

But this book goes even further. It shows how JavaScript and PHP can be used in tandem to make a user's experience faster and more pleasant. It shows the correct way to handle errors in user input so that a site looks professional. It introduces the vast collection of powerful tools available in the PEAR repository and shows how to use some of the most popular tools.

Even while it serves as an introduction to new programmers, the book does not omit critical tasks that web sites require. For instance, every site that allows updates must handle the possibility of multiple users accessing data at the same time. This book explains how to solve the problem in detail with locking.

Through a sophisticated sample application--Hugh and Dave's Wine Store--all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. The book introduces PHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use.

This new edition has been redesigned around the rich offerings of PEAR. Several of these, including the Template package and the database-independent query API, are fully integrated into examples and thoroughly described in the text. Topics include:

• Installation and configuration of Apache, MySQL, and PHP on Unix, Windows, and Mac OS X systems
• Introductions to PHP, SQL, and MySQL administration
• Session management, including the use of a custom database for improved efficiency
• User input validation, security, and authentication
• The PEAR repository, plus details on the use of PEAR DB and Template classes
• Production of PDF reports