Overview

This comprehensive reference manual covers issues at all stages in MySQL use, from installation problems through performance tuning. Included are suggested uses of privileges to enhance security, many performance tips, and a sophisticated guide to error recovery. It also offers a thorough comparison of MySQL with SQL standards and other databases. This version covers MySQL 4.0. Topics covered in this manual range from the hitches you may run in to when first installing MySQL to internals that should help you tune your queries. The manual contains comprehensive reference material for building the product, running administrative utilities, and using various API as well as MySQL's version of SQL. Also included in the book are: a 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 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 timest amp; 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; and a guide to adding new functions to MySQL.

Full Product Details

Author:   MySQL Ab Development Team ,  David Axmark ,  MySQL AB Development Team ,  Paul DuBois
Publisher:   O'Reilly Media
Imprint:   O'Reilly Media
Dimensions:   Width: 17.80cm , Height: 3.60cm , Length: 23.30cm
Weight:   1.136kg
ISBN:  

9780596002657

ISBN 10:   0596002653
Pages:   810
Publication Date:   09 July 2002
Audience:   College/higher education ,  Professional and scholarly ,  Undergraduate ,  Postgraduate, Research & Scholarly
Format:   Paperback
Publisher's Status:   Active
Availability:   To order  
Stock availability from the supplier is unknown. We will order it for you and ship this item to you once it is received by us.

Table of Contents

How MySQL Compares to MSQL; MySQL installation; tutorial introduction; database administration; MySQL optimization; MySQL language reference; MySQL table types; MySQL PHP API; extending MySQL.

Reviews

Author Information

"Michael ""Monty"" Widenius, CTO and Co-founder: Monty Widenius has written 95 percent of the server code in MySQL. His database software programming dates back to 1978, and his working with TCX DataKonsult AB to 1981. Since 1995, he has been the primary force behind MySQL, devoting his time to product development, answering emails, attending conferences and educating MySQL developers. The MySQL team is made up of 15 developers from all over the world. Their goal is to promote the use and development of MySQL worldwide and to make MySQL the best and most-used database in the world. David Axmark, Co-founder: David Axmark is one of the founders of MySQL and worked with the product well before it had a name. He has worked as a consultant and software developer for nearly 20 years. Interested in free software since the early '80s, David has been committed to developing a successful business model through open source software."

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions