Pro MySQL / Edition 1

Pro MySQL / Edition 1

5.0 1
by Jay Pipes, Michael Kruckenberg
     
 

Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the world’s most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or youre a database expert searching for a fast-paced introduction to MySQL’s advanced features, this book is

See more details below

Overview

Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the world’s most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or youre a database expert searching for a fast-paced introduction to MySQL’s advanced features, this book is for you.

The first part of this book discusses topics related to design and development. Topics include transaction processing and indexing theory, benchmarking and profiling, and advanced coverage of storage engines and data types. The authors also delve deep into the MySQL source code and system architecture at a level you won’t find anywhere else. Essential advanced SQL is also covered, with discussion of subqueries, derived tables, and joins. These concepts are demonstrated in a range of situation-specific examplesfrom dealing with hierarchical data to performing geographic information system (GIS) examples with just MySQL. This section also covers MySQL 5's new enterprise features like stored procedures, triggers, and views.

The latter part of this book devotes itself to administration topics. Topics include MySQL installation and upgrading, user administration, database backups, replication, and clustering. You’ll also learn about the new data dictionary features available in MySQL 5.

Read More

Product Details

ISBN-13:
9781590595053
Publisher:
Apress
Publication date:
07/27/2005
Series:
Expert's Voice in Open Source Series
Edition description:
2005
Pages:
768
Sales rank:
1,469,873
Product dimensions:
1.51(w) x 7.50(h) x 9.25(d)

Related Subjects

Table of Contents

Pt. 1Design and development
Ch. 1Analyzing business requirements3
Ch. 2Index concepts39
Ch. 3Transaction processing69
Ch. 4MySQL system architecture105
Ch. 5Storage engines and data types153
Ch. 6Benchmarking and profiling189
Ch. 7Essential SQL235
Ch. 8SQL scenarios299
Ch. 9Stored procedures349
Ch. 10Functions375
Ch. 11Cursors405
Ch. 12Views419
Ch. 13Triggers443
Pt. 2Administration
Ch. 14MySQL installation and configuration469
Ch. 15User administration497
Ch. 16Security533
Ch. 17Backup and restoration555
Ch. 18Replication585
Ch. 19Cluster617
Ch. 20Troubleshooting645
Ch. 21MySQL data dictionary669

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >