1.

Record Nr.

UNINA9910809361203321

Autore

Cabral Sheeri <1978->

Titolo

MySQL administrator's bible [[electronic resource] /] / Sheeri Cabral, Keith Murphy

Pubbl/distr/stampa

Indianapolis, IN, : Wiley Pub., 2009

ISBN

1-118-08058-0

1-282-12221-5

9786612122217

0-470-50661-X

Edizione

[1st edition]

Descrizione fisica

1 online resource (891 p.)

Altri autori (Persone)

MurphyKeith <1970->

Disciplina

005.75/65

Soggetti

Database management

Relational databases

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Includes index.

Nota di bibliografia

Includes bibliographical references and index.

Nota di contenuto

MySQL® Administrator's Bible; About the Authors; Credits; Acknowledgments; Contents at a Glance; Contents; Introduction; Who Should Read This Book; How This Book Is Organized; What's on the Companion Website; Where To Go From Here; Part I: First Steps with MySQL; Chapter 1: Introduction to MySQL; Chapter 2: Installing and Upgrading MySQL Server; Chapter 3: Accessing MySQL; Part II: Developing with MySQL; Chapter 4: How MySQL Extends and Deviates from SQL; Chapter 5: MySQL Data Types; Chapter 6: MySQL Index Types; Chapter 7: Stored Routines, Triggers, and Events; Chapter 8: MySQL Views

Chapter 9: Transactions in MySQLPart III: Core MySQL Administration; Chapter 10: MySQL Server Tuning; Chapter 11: Storage Engines; Chapter 12: Caching with MySQL; Chapter 13: Backups and Recovery; Chapter 14: User Management; Chapter 15: Partitioning; Chapter 16: Logging and Replication; Chapter 17: Measuring Performance; Part IV: Extending Your Skills; Chapter 18: Query Analysis and Index Tuning; Chapter 19: Monitoring Your Systems; Chapter 20: Securing MySQL; Chapter 21: The MySQL Data Dictionary; Chapter 22: Scaling and High Availability Architectures; Appendix A: MySQL Proxy



Appendix B: Functions and OperatorsAppendix C: Resources; Index

Sommario/riassunto

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management-including MySQL's unique approach to basic database features and functions-as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning,