文件名称:
Packt.MySQL.Admin.Cookbook.2010.pdf
开发工具:
文件大小: 9mb
下载次数: 0
上传时间: 2010-07-23
详细说明： What this book covers Chapter 1, Replication: In this chapter, you will see how to set up MySQL replication, useful for load balancing, online backups, and fail-over scenarios. Advanced replication scenarios using the blackhole engine and streaming slave deployment are discussed beyond the basic topics. Chapter 2, Indexing: You will be shown how to create, drop, and modify indexes, perhaps the most important means of optimizing your MySQL servers' performance. Fulltext indexing, clustered and non-clustered indexes are compared a nd presented with their respective strengths and typical use cases. Moreover, you will learn how to identify duplicate indexes, which can hinder your servers' performance. Chapter 3, Tools: This chapter will get you acquainted with the MySQL Administrator and Query Browser GUI Tools as well as the MySQL command-line client and how to use it in concert with external scripts and tools. You will also see how to create custom diagrams for MySQL Administrator and share connection profiles between multiple computers. Chapter 4, Backing Up and Restoring MySQL Data: In this chapter, we introduce the basic approaches to backing up your database and restoring data again. Advanced techniques like on-the-fly compression, point in time recovery, avoiding extended lock situations, backup in replication scenarios, and partial backup and restore are also covered. Chapter 5, Managing Data: You will learn some tricks beyond the basic SQL commands, which enable you to delete data in a highly efficient manner and insert data based on existing database content, and how to import and export data to and from your database. Chapter 6, Monitoring and Analyzing a MySQL Installation: We present approaches to monitoring table space usage, and how to use database metadata to your advantage. Typical performance bottlenecks and lock contention problems are discussed as well. Chapter 7, Configuring MySQL: This chapter deals with MySQL configuration and how to best leverage available settings to their full potential. Table space management, pool sizing, and logging options are discussed along with platform-specific caveats and advanced installation scenarios, such as multiple instances on one server. Chapter 8, MySQL User Management: Management of MySQL user accounts is discussed in detail throughout this chapter. Typical user roles with appropriate privileges and approaches to restricting access sensibly are proposed. You will also learn how to regain access to your database in case the administrative user credentials are lost. Chapter 9, Managing Schemas: This chapter includes topics such as adding and removing columns to and from tables and choosing a suitable storage engine and character set for individual needs. Another recipe covers a technique to add a new primary key column to a table already filled with data. Ways to manage and automate database schema evolution, as part of a software life cycle are presented as well. And if you have always missed "ADD INDEX IF NOT EXISTS", you will find a solution to this, too. Appendix, Good to Know: In this final part of the book you can find several things that can turn out useful in everyday situations, but did not fit the step-by-step recipe format naturally. Topics range from choosing character sets to getting the most out of 32 bit address space limitations. ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
