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
ERP and Data Warehousing in Organizations: Issues and Challenges
Challenging the Unpredictable: Changeable Order Management Systems
The Second Wave ERP Market: An Australian Viewpoint
Distributed Data Warehouse for Geo-spatial Services
Data Mining for Business Process Reengineering
A Hybrid Clustering Technique to Improve Patient Data Quality
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
Accessing Call Parameters for an Active Call
Configuring Cisco CME Call Processing Features
Managing Cisco IPC Express Systems by Managed Services and Enterprises
Cisco Voice Network Management Solutions
Table vm_greeting
Snort Cookbook
Positioning Your IDS Sensors
Building a Distributed IDS (Encrypted)
Optimizing Logging
Countermeasures from Rules
Detecting Port Scans and Talkative Hosts
Visual C# 2005 How to Program (2nd Edition)
Initializing Objects with Constructors
Method Call Stack and Activation Records
Example: Divide by Zero Without Exception Handling
B.6. Negative Binary Numbers: Twos Complement Notation
G.1. Introduction
Cisco IOS Cookbook (Cookbooks (OReilly))
Creating Command Aliases
Generating a Report of ARP Table Information
Creating an Encrypted VPN Between the LAN Interfaces of Two Routers
DLSw+ Redundancy and Fault Tolerance
Login Password Retry Lockout
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter One Solutions
Chapter Six Defining Pain or Critical Business Issue
Chapter Nine Selling When You re Not First
Chapter Fourteen Getting Started with the Process
Appendix A Value Justification Example
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