Flylib.com
MySQL AB MySQL Administrator[ap]s Guide
MySQL AB MySQL Administrator[ap]s Guide
ISBN: 782142591
EAN: N/A
Year: 2004
Pages: 138
BUY ON AMAZON
MySQL Administrator s Guide
Table of Contents
Copyright
About this Book
We Want to Hear from You
Chapter 1. General Information
1.1 About This Guide
1.2 Overview of the MySQL Database Management System
1.3 Overview of MySQL AB
1.4 MySQL Support and Licensing
1.5 MySQL Development Roadmap
1.6 MySQL and the Future (the TODO)
1.7 MySQL Information Sources
1.8 MySQL Standards Compliance
Chapter 2. Installing MySQL
2.1 General Installation Issues
2.2 Standard MySQL Installation Using a Binary Distribution
2.3 MySQL Installation Using a Source Distribution
2.4 Post-Installation Setup and Testing
2.5 UpgradingDowngrading MySQL
2.6 Operating SystemSpecific Notes
2.7 Perl Installation Notes
Chapter 3. Using MySQL Programs
3.1 Overview of MySQL Programs
3.2 Invoking MySQL Programs
3.3 Specifying Program Options
Chapter 4. Database Administration
4.1 The MySQL Server and Server Startup Scripts
4.2 Configuring the MySQL Server
4.3 General Security Issues
4.4 The MySQL Access Privilege System
4.5 MySQL User Account Management
4.6 Disaster Prevention and Recovery
4.7 MySQL Localization and International Usage
4.8 The MySQL Log Files
4.9 Running Multiple MySQL Servers on the Same Machine
4.10 The MySQL Query Cache
Chapter 5. Replication in MySQL
5.1 Introduction to Replication
5.2 Replication Implementation Overview
5.3 Replication Implementation Details
5.4 How to Set Up Replication
5.5 Replication Compatibility Between MySQL Versions
5.6 Upgrading a Replication Setup
5.7 Replication Features and Known Problems
5.8 Replication Startup Options
5.9 Replication FAQ
5.10 Troubleshooting Replication
5.11 Reporting Replication Bugs
Chapter 6. MySQL Optimization
6.1 Optimization Overview
6.2 Optimizing SELECT Statements and Other Queries
6.3 Locking Issues
6.4 Optimizing Database Structure
6.5 Optimizing the MySQL Server
6.6 Disk Issues
Chapter 7. MySQL Client and Utility Programs
7.1 Overview of the Client-Side Scripts and Utilities
7.2 myisampack, the MySQL Compressed Read-Only Table Generator
7.3 mysql, the Command-Line Tool
7.4 mysqladmin, Administering a MySQL Server
7.5 The mysqlbinlog Binary Log Utility
7.6 mysqlcc, the MySQL Control Center
7.7 The mysqlcheck Table Maintenance and Repair Program
7.8 The mysqldump Database Backup Program
7.9 The mysqlhotcopy Database Backup Program
7.10 The mysqlimport Data Import Program
7.11 mysqlshow, Showing Databases, Tables, and Columns
7.12 perror, Explaining Error Codes
7.13 The replace String-Replacement Utility
Chapter 8. MySQL Storage Engines and Table Types
8.1 The MyISAM Storage Engine
8.2 The MERGE Storage Engine
8.3 The MEMORY (HEAP) Storage Engine
8.4 The BDB (BerkeleyDB) Storage Engine
8.5 The ISAM Storage Engine
Chapter 9. The InnoDB Storage Engine
9.1 InnoDB Overview
9.2 InnoDB Contact Information
9.3 InnoDB in MySQL 3.23
9.4 InnoDB Configuration
9.5 InnoDB Startup Options
9.6 Creating the InnoDB Tablespace
9.7 Creating InnoDB Tables
9.8 Adding and Removing InnoDB Data and Log Files
9.9 Backing Up and Recovering an InnoDB Database
9.10 Moving an InnoDB Database to Another Machine
9.11 InnoDB Transaction Model and Locking
9.12 InnoDB Performance Tuning Tips
9.13 Implementation of Multi-Versioning
9.14 Table and Index Structures
9.15 File Space Management and Disk IO
9.16 Error Handling
9.17 Restrictions on InnoDB Tables
9.18 InnoDB Troubleshooting
Chapter 10. Introduction to MaxDB
10.1 History of MaxDB
10.2 Licensing and Support
10.3 MaxDB-Related Links
10.4 Basic Concepts of MaxDB
10.5 Feature Differences Between MaxDB and MySQL
10.6 Interoperability Features Between MaxDB and MySQL
10.7 Reserved Words in MaxDB
Appendix A. Troubleshooting Problems with MySQL Programs
A.1 How to Determine What Is Causing a Problem
A.2 Common Errors When Using MySQL Programs
A.3 Installation-Related Issues
A.4 Administration-Related Issues
Appendix B. Environment Variables
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
MySQL AB MySQL Administrator[ap]s Guide
ISBN: 782142591
EAN: N/A
Year: 2004
Pages: 138
BUY ON AMAZON
A+ Fast Pass
Domain 2 Diagnosing and Troubleshooting
Domain 3 Preventive Maintenance
Domain 6 Basic Networking
Domain 1 Operating System Fundamentals
Domain 3 Diagnosing and Troubleshooting
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Local Area Network (LAN) Technologies
Wide Area Network (WAN) Technologies
Internet Protocol (IP) Basics
Internet Control Message Protocol (ICMP)
Internet Information Services (IIS) and the Internet Protocols
The Complete Cisco VPN Configuration Guide
Summary
Summary
New IPsec Troubleshooting Features
PIX and ASA Product Information
ISAKMP/IKE Phase 1 Management Connection
Junos Cookbook (Cookbooks (OReilly))
Setting Router Information for the MIB-II System Group
Configuring Ethernet Interfaces
Using VRRP on Ethernet Interfaces
Viewing the IS-IS Link-State Database
Configuring a Multiarea OSPF Network
Python Programming for the Absolute Beginner, 3rd Edition
Current Working Directory
The Root Page
Wrapping C Environment Calls
Embedding Python
Add Python. Mix Well. Repeat.
Understanding Digital Signal Processing (2nd Edition)
DFT PROCESSING GAIN
Chapter Ten. Sample Rate Conversion
FAST MULTIPLICATION OF COMPLEX NUMBERS
COMPUTING THE INVERSE FFT USING THE FORWARD FFT
Section A.2. ARITHMETIC REPRESENTATION OF COMPLEX NUMBERS
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