Authors:
One of the first books to cover MySQL 5 in depth
Foregos reiteration of the basics found in other books, and concentrates on MySQL’s advanced applications in enterprise environments
Doubles as a reference for users interested in having a thorough guide to configuration directives, commands, and features at their disposal
Buy it now
Buying options
Tax calculation will be finalised at checkout
Other ways to access
This is a preview of subscription content, log in via an institution to check for access.
Table of contents (21 chapters)
-
Front Matter
-
Administration
-
Front Matter
-
About this book
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.
About the authors
Bibliographic Information
Book Title: Pro MySQL
Authors: Michael Kruckenberg, Jay Pipes
DOI: https://doi.org/10.1007/978-1-4302-0048-2
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books
Copyright Information: Jay Pipes and Michael Kruckenberg 2005
Softcover ISBN: 978-1-59059-505-3Published: 27 July 2005
eBook ISBN: 978-1-4302-0048-2Published: 22 November 2006
Edition Number: 1
Number of Pages: XXXII, 768
Topics: Database Management, Software Engineering/Programming and Operating Systems