中文名：MySQL的管理“食譜”
作者：丹尼爾施奈勒丹尼爾 Schneller
類型：數據庫
文檔信息：10.5 MB的PDF格式
本書介紹
99 great recipes for mastering MySQL configuration and administration
Set up MySQL to perform administrative tasks such as efficiently managing data and database schema, improving the performance of MySQL servers, and managing user credentials Deal with typical performance bottlenecks and lock-contention problems Restrict access sensibly and regain access to your database in case of loss of administrative
user credentials Part of Packt’s Cookbook series: Each recipe is a carefully organized sequence of instructions
to complete the task as efficiently as possible
本書內容
MySQL is the most popular open-source database and is also known for its easy set up feature.
However, proper configuration beyond the default settings still is a challenge, along with some
other day-to-day maintenance tasks such as backing up and restoring, performance tuning, and
server monitoring. These tasks have not been covered thoroughly in the default documentation.
This book provides both step-by-step recipes and relevant background information on these topics
and more. It covers everything from basic to advanced aspects of MySQL administration and
configuration. One of the things you are really going to love about this book is that all
recipes are based on real-world experience and were derived from proven solutions used in an
enterprise environment.
This book shows you everything you need to know about MySQL Administration. You will learn to
set up MySQL replication to manage load balancing and deal with online backup and fail-over
scenarios. As you consider the benefits of backing up, you might like to back up your database
efficiently with advanced techniques covered in this book.
The book demonstrates how to create, modify, and delete indexes. You will also learn to identify
duplicate indexes, which hinder your MySQL server performance. This book focuses on
administration tasks and will help you as an administrator to optimize the database for
efficiency and reliability.
You will learn to manage data efficiently by inserting data in existing database content and
importing and exporting databases. The sooner you learn about taking advantage of metadata from
this book, the sooner you can start using the space efficiently. Get to know about managing
users and assigning privileges and regaining lost administrative user credentials. Finally,
learn to manage the database schema by customizing it to automate database schema evolution in
the context of application updates.
……
電子書下載： 《MySQL Admin Cookbook》英文版