Flylib.com
MySQL Administrators Guide and Language Reference (2nd Edition)
MySQL Administrators Guide and Language Reference (2nd Edition)
ISBN: 0672328704
EAN: 2147483647
Year: 2006
Pages: 141
Authors:
MySQL AB
BUY ON AMAZON
MySQL Administrator s Guide and Language Reference
Table of Contents
Copyright
Preface
Preface
Chapter 1. General Information
Section 1.1. About This Manual
Section 1.2. Conventions Used in This Manual
Section 1.3. Overview of MySQL AB
Section 1.4. Overview of the MySQL Database Management System
Section 1.5. Overview of the MaxDB Database Management System
Section 1.6. MySQL Development Roadmap
Section 1.7. MySQL Information Sources
Section 1.8. How to Report Bugs or Problems
Section 1.9. MySQL Standards Compliance
Chapter 2. Installing and Upgrading MySQL
Section 2.1. General Installation Issues
Section 2.2. Standard MySQL Installation Using a Binary Distribution
Section 2.3. Installing MySQL on Windows
Section 2.4. Installing MySQL on Linux
Section 2.5. Installing MySQL on Mac OS X
Section 2.6. Installing MySQL on NetWare
Section 2.7. Installing MySQL on Other Unix-Like Systems
Section 2.8. MySQL Installation Using a Source Distribution
Section 2.9. Post-Installation Setup and Testing
Section 2.10. Upgrading MySQL
Section 2.11. Downgrading MySQL
Section 2.12. Operating SystemSpecific Notes
Section 2.13. Perl Installation Notes
Chapter 3. Using MySQL Programs
Section 3.1. Overview of MySQL Programs
Section 3.2. Invoking MySQL Programs
Section 3.3. Specifying Program Options
Chapter 4. Database Administration
Section 4.1. Overview of Server-Side Programs
Section 4.2. mysqldThe MySQL Server
Section 4.3. The mysqld-max Extended MySQL Server
Section 4.4. MySQL Server Startup Programs
Section 4.5. mysqlmanagerThe MySQL Instance Manager
Section 4.6. Installation-Related Programs
Section 4.7. General Security Issues
Section 4.8. The MySQL Access Privilege System
Section 4.9. MySQL User Account Management
Section 4.10. Backup and Recovery
Section 4.11. MySQL Localization and International Usage
Section 4.12. MySQL Server Logs
Section 4.13. Running Multiple MySQL Servers on the Same Machine
Section 4.14. The MySQL Query Cache
Chapter 5. Replication
Section 5.1. Introduction to Replication
Section 5.2. Replication Implementation Overview
Section 5.3. Row-Based Replication
Section 5.4. Replication Implementation Details
Section 5.5. How to Set Up Replication
Section 5.6. Replication Compatibility Between MySQL Versions
Section 5.7. Upgrading a Replication Setup
Section 5.8. Replication Features and Known Problems
Section 5.9. Replication Startup Options
Section 5.10. How Servers Evaluate Replication Rules
Section 5.11. Replication FAQ
Section 5.12. Comparison of Statement-Based Versus Row-Based Replication
Section 5.13. Troubleshooting Replication
Section 5.14. How to Report Replication Bugs or Problems
Section 5.15. Auto-Increment in Multiple-Master Replication
Chapter 6. Optimization
Section 6.1. Optimization Overview
Section 6.2. Optimizing SELECT and Other Statements
Section 6.3. Locking Issues
Section 6.4. Optimizing Database Structure
Section 6.5. Optimizing the MySQL Server
Section 6.6. Disk Issues
Chapter 7. Client and Utility Programs
Section 7.1. Overview of Client and Utility Programs
Section 7.2. myisamchkMyISAM Table-Maintenance Utility
Section 7.3. myisamlogDisplay MyISAM Log File Contents
Section 7.4. myisampackGenerate Compressed, Read-Only MyISAM Tables
Section 7.5. mysqlThe MySQL Command-Line Tool
Section 7.6. mysqlaccessClient for Checking Access Privileges
Section 7.7. mysqladminClient for Administering a MySQL Server
Section 7.8. mysqlbinlogUtility for Processing Binary Log Files
Section 7.9. mysqlcheckA Table Maintenance and Repair Program
Section 7.10. mysqldumpA Database Backup Program
Section 7.11. mysqlhotcopyA Database Backup Program
Section 7.12. mysqlimportA Data Import Program
Section 7.13. mysqlshowDisplay Database, Table, and Column Information
Section 7.14. mysql_zapKill Processes That Match a Pattern
Section 7.15. perrorExplain Error Codes
Section 7.16. replaceA String-Replacement Utility
Chapter 8. Storage Engines and Table Types
Section 8.1. The MyISAM Storage Engine
Section 8.2. The InnoDB Storage Engine
Section 8.3. The MERGE Storage Engine
Section 8.4. The MEMORY (HEAP) Storage Engine
Section 8.5. The BDB (BerkeleyDB) Storage Engine
Section 8.6. The EXAMPLE Storage Engine
Section 8.7. The FEDERATED Storage Engine
Section 8.8. The ARCHIVE Storage Engine
Section 8.9. The CSV Storage Engine
Section 8.10. The BLACKHOLE Storage Engine
Chapter 9. MySQL Cluster
Section 9.1. MySQL Cluster Overview
Section 9.2. Basic MySQL Cluster Concepts
Section 9.3. Simple Multi-Computer How-To
Section 9.4. MySQL Cluster Configuration
Section 9.5. Process Management in MySQL Cluster
Section 9.6. Management of MySQL Cluster
Section 9.7. MySQL Cluster Replication
Section 9.8. Using High-Speed Interconnects with MySQL Cluster
Section 9.9. Known Limitations of MySQL Cluster
Section 9.10. MySQL Cluster Development Roadmap
Section 9.11. MySQL Cluster FAQ
Section 9.12. MySQL Cluster Glossary
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
MySQL Administrators Guide and Language Reference (2nd Edition)
ISBN: 0672328704
EAN: 2147483647
Year: 2006
Pages: 141
Authors:
MySQL AB
BUY ON AMAZON
Project Management JumpStart
Building the Foundation
Initiating the Project
Defining the Project Goals
Planning and Acquiring Resources
Closing the Books
Absolute Beginner[ap]s Guide to Project Management
Developing the Project Schedule
Common Budget Challenges
Managing Project Deliverables
Typical Quality-Related Challenges
Leading a Project
Image Processing with LabVIEW and IMAQ Vision
Introduction to IMAQ Vision Builder
Charge-Coupled Devices
Other Image Sources
Image Processing
Pixel Value Analysis
Systematic Software Testing (Artech House Computer Library)
Detailed Test Planning
Test Implementation
The Test Manager
Some Final Thoughts…
Appendix D Sample Master Test Plan
The Java Tutorial: A Short Course on the Basics, 4th Edition
Questions and Exercises
Questions and Exercises
What Is an Exception?
Summary
Appendix C. Collections
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Retail Logistics: Changes and Challenges
Temperature-Controlled Supply Chains
Rethinking Efficient Replenishment in the Grocery Sector
The Development of E-tail Logistics
Enterprise Resource Planning (ERP) Systems: Issues in Implementation
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