High Performance MySQL: Optimization, Backups, Replication, and More
High Performance MySQL: Optimization, Backups, Replication, and More
ISBN: 0596101716
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 188
Pages: 188
- Main Page
- Table of content
- Copyright
- About the Author
- About the Technical Reviewers
- Acknowledgments
- First Edition
- Second Edition
- Tell Us What You Think
- Introduction
- Why Choose MySQL?
- Already Running Another RDBMS?
- Tools Provided with MySQL
- What You Can Expect from This Book
- Road Map to This Book
- How to Read This Book
- Versions of Software Covered in This Book
- Conventions Used in This Book
- Additional Resources
- Part I: General MySQL Use
- Chapter 1. Getting Started with MySQL and SQL
- How MySQL Can Help You
- A Sample Database
- Basic Database Terminology
- A MySQL Tutorial
- Tips for Interacting with mysql
- Where to Now?
- Chapter 2. Working with Data in MySQL
- MySQL Data Types
- MySQL Column Types
- Working with Sequences
- Character Set Support
- Choosing Column Types
- Expression Evaluation and Type Conversion
- Chapter 3. MySQL SQL Syntax and Use
- MySQL Naming Rules
- Selecting, Creating, Dropping, and Altering Databases
- Creating, Dropping, Indexing, and Altering Tables
- Getting Information about Databases and Tables
- Retrieving Records from Multiple Tables
- Multiple-Table Deletes and Updates
- Performing Transactions
- Foreign Keys and Referential Integrity
- Using FULLTEXT Searches
- Writing Comments
- Features That MySQL Does Not Support
- Chapter 4. Query Optimization
- Using Indexing
- The MySQL Query Optimizer
- Column Type Choices and Query Efficiency
- Loading Data Efficiently
- Scheduling and Locking Issues
- Optimization for Administrators
- Part II: Using MySQL Programming Interfaces
- Chapter 5. Introduction to MySQL Programming
- Why Write Your Own MySQL Programs?
- APIs Available for MySQL
- Choosing an API
- Chapter 6. The MySQL C API
- General Procedure for Building Client Programs
- Client 1Connecting to the Server
- Client 2Adding Error Checking
- Client 3Getting Connection Parameters at Runtime
- Processing Queries
- Client 4An Interactive Query Program
- Writing Clients That Include SSL Support
- Using the Embedded Server Library
- Miscellaneous Topics
- Chapter 7. The Perl DBI API
- Perl Script Characteristics
- Perl DBI Overview
- Putting DBI to Work
- Using DBI in Web Applications
- Chapter 8. The PHP API
- PHP Overview
- Putting PHP to Work
- Part III: MySQL Administration
- Chapter 9. Introduction to MySQL Administration
- Overview of Administrative Duties
- General Administration
- Security
- Database Repair and Maintenance
- Chapter 10. The MySQL Data Directory
- Location of the Data Directory
- Structure of the Data Directory
- Relocating Data Directory Contents
- Chapter 11. General MySQL Administration
- Securing a New MySQL Installation
- Arranging for MySQL Server Startup and Shutdown
- Managing MySQL User Accounts
- Maintaining Log Files
- Additional Server Configuration Topics
- Running Multiple Servers
- Setting Up Replication Servers
- Updating MySQL
- Chapter 12. Security
- Internal Security: Preventing Unauthorized File System Access
- External Security: Preventing Unauthorized Network Access
- Setting Up Secure Connections
- Chapter 13. Database Backups, Maintenance, and Repair
- Coordinating with the Server
- Preparing for Disaster
- Table Repair and Data Recovery
- Part IV: Appendixes
- Appendix A. Obtaining and Installing Software
- Obtaining the sampdb Sample Database Distribution
- Obtaining MySQL and Related Software
- Installing MySQL on UNIX
- Installing MySQL on Windows
- Appendix B. Column Type Reference
- Numeric Types
- String Types
- Date and Time Types
- Appendix C. Operator and Function Reference
- Operators
- Functions
- Appendix D. SQL Syntax Reference
- SQL Statements
- SQL Variables
- Comment Syntax
- Appendix E. MySQL Program Reference
- Specifying Program Options
- libmysqld
- myisamchk and isamchk
- myisampack and pack_isam
- mysql
- mysqlaccess
- mysqladmin
- mysqlbinlog
- mysqlbug
- mysqlcheck
- mysql_config
- mysqld
- mysqld_multi
- mysqld_safe
- mysqldump
- mysqlhotcopy
- mysqlimport
- mysql_install_db
- mysql.server
- mysqlshow
- safe_mysqld
- Appendix F. C API Reference
- Compiling and Linking
- C API Data Types
- C API Functions
- Appendix G. Perl DBI API Reference
- Writing Scripts
- DBI Methods
- DBI Utility Functions
- DBI Attributes
- DBI Environment Variables
- Appendix H. PHP API Reference
- Writing PHP Scripts
- Functions
- Appendix I. Internet Service Providers
- Getting Ready to Shop for an ISP
- Assessing an ISPGeneral Considerations
- Assessing an ISPMySQL-Specific Considerations
- Index
- Index SYMBOL
- Index A
- Index B
- Index C
- Index D
- Index E
- Index F
- Index G
- Index H
- Index I
- Index J
- Index K
- Index L
- Index M
- Index N
- Index O
- Index P
- Index Q
- Index R
- Index S
- Index T
- Index U
- Index V
- Index W
- Index X
- Index Y
High Performance MySQL: Optimization, Backups, Replication, and More
ISBN: 0596101716
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 188
Pages: 188
Similar book on Amazon
