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
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
SWT/JFace Mechanisms
Layouts
Tables
Scales, Sliders, and Progress Bars
Drag and Drop and the Clipboard
WebLogic: The Definitive Guide
Session Persistence
Managing Domains
Designing a Domain
Performance, Monitoring, and Tuning
Miscellaneous Extensions
C++ How to Program (5th Edition)
Using const with Pointers
Case Study: A Transaction-Processing Program
Wrap-Up
G.1. ATM Case Study Implementation
G.4. Class Keypad
Microsoft WSH and VBScript Programming for the Absolute Beginner
Getting Started with the WSH and VBScript
Overview of the Windows Script Host
Conditional Logic
Handling Script Errors
Appendix B Built-In VBScript Functions
802.11 Wireless Networks: The Definitive Guide, Second Edition
IEEE 802 Network Technology Family Tree
11i: Robust Security Networks, TKIP, and CCMP
RF Engineering for 802.11
Characteristics of the OFDM PHY
Comparison and Conclusions
Extending and Embedding PHP
The PHP Life Cycle
Building Statically
Opening Streams
Filters
Dealing with Errors
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