Flylib.com
High Performance MySQL: Optimization, Backups, Replication, and More
High Performance MySQL: Optimization, Backups, Replication, and More
ISBN: 0596101716
EAN: 2147483647
Year: 2003
Pages: 188
Authors:
Baron Schwartz
,
Peter Zaitsev
,
Vadim Tkachenko
,
Jeremy Zawodny D.
,
Arjen Lentz
,
Derek J. Balling
BUY ON AMAZON
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
Year: 2003
Pages: 188
Authors:
Baron Schwartz
,
Peter Zaitsev
,
Vadim Tkachenko
,
Jeremy Zawodny D.
,
Arjen Lentz
,
Derek J. Balling
BUY ON AMAZON
Similar book on Amazon
Data Structures and Algorithms in Java
MySQL High Availability: Tools for Building Robust Data Centers
Learning MySQL
Effective MySQL Optimizing SQL Statements (Oracle Press)
Understanding MySQL Internals
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Localizing Client-Side Data in a Web Forms Application
Displaying an Image from a Database in a Web Forms Control
Binding a Windows DataGrid to Master-Detail Data
Loading a Windows PictureBox with Images Stored by Access as OLE Objects
Getting a SQL Server Query Plan
MySQL Stored Procedure Programming
Conclusion
Calling a Stored Procedure from PHP
Conclusion
Transactions and Locks
Options for Using MySQL with PHP
High-Speed Signal Propagation[c] Advanced Black Magic
Dielectric Effects
Necessary Mathematics: Input Impedance and Transfer Function
RC Region
Extra Fries, Please
IBIS: Issues with Interpolation
SQL Tips & Techniques (Miscellaneous)
Understanding SQL Basics and Creating Database Files
Working with Queries, Expressions, and Aggregate Functions
Creating Indexes for Fast Data Retrieval
Performing Multiple-table Queries and Creating SQL Data Views
Working with Comparison Predicates and Grouped Queries
Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)
The Challenges of Web Application Development
Managing Business Logic with Struts
Building a Data Access Tier with ObjectRelationalBridge
Templates and Velocity
Creating a Search Engine with Lucene
Sap Bw: a Step By Step Guide for Bw 2.0
Creating an InfoArea
Creating InfoObject Catalogs
Creating an Application Component
Using a Variable to Access a Hierarchy Node Directly
Business Content
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies