Pro MySQL (Expert's Voice in Open Source)

Pub. Date: July 2005 |Publisher: Apress L. P. |Format: pdf |Series: Expert's Voice in Open Source Series |ISBN-13: 9781590595053 |ISBN: 159059505X | Size: 8mb www.woebooks.com

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 you're a database expert searching for a fast-paced introduction to MySQL's advanced features, this book is for you.

See inside the book Click me www.woebooks.com

Download Links www.woebooks.com

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.

Table of Contents

Pt. 1 Design and development

Ch. 1 Analyzing business requirements 3

Ch. 2 Index concepts 39

Ch. 3 Transaction processing 69

Ch. 4 MySQL system architecture 105

Ch. 5 Storage engines and data types 153

Ch. 6 Benchmarking and profiling 189

Ch. 7 Essential SQL 235

Ch. 8 SQL scenarios 299

Ch. 9 Stored procedures 349

Ch. 10 Functions 375

Ch. 11 Cursors 405

Ch. 12 Views 419

Ch. 13 Triggers 443

Pt. 2 Administration

Ch. 14 MySQL installation and configuration 469

Ch. 15 User administration 497

Ch. 16 Security 533

Ch. 17 Backup and restoration 555

Ch. 18 Replication 585

Ch. 19 Cluster 617

Ch. 20 Troubleshooting 645

Ch. 21 MySQL data dictionary 669