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
A Practitioners Guide to Software Test Design
Boundary Value Testing
Pairwise Testing
Use Case Testing
Control Flow Testing
Scripted Testing
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
Working with Pages
Managing Recurring Events Using Single Documents
Obtain the Current Roles Assigned to a User
Add a View Icon and Mood Stamp to an Email
Access Control List Fundamentals
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
Telecommunications Technology Fundamentals
Microwave
The OSI Reference Model and the TCP/IP Reference Model
Multimedia Networking Requirements
5G: Enhanced Data Services
Cultural Imperative: Global Trends in the 21st Century
Culture and Religion
Americanization versus Asianization
Culture and Globalization
Epilogue After September 11
Appendix B Leadership Test
Programming .Net Windows Applications
Start Page
Publish and Subscribe
Form Properties
Termination Buttons
ADO.NET
Understanding Digital Signal Processing (2nd Edition)
THE DFT FREQUENCY RESPONSE TO A REAL COSINE INPUT
Chapter Seven. Specialized Lowpass FIR Filters
REFERENCES
FREQUENCY TRANSLATION WITHOUT MULTIPLICATION
EFFICIENTLY PERFORMING THE FFT OF REAL SEQUENCES
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