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
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
Cisco CME Call Processing Features
Configuring and Monitoring Via Network Management Systems Using the Cisco CME AXL/SOAP Interface
Missing Transfer Patterns
Troubleshooting Cisco CME and Cisco UE Integration
The main.aef Script
Developing Tablet PC Applications (Charles River Media Programming)
Math and Random Number Functions in VB .NET
Tablet PC Full Screen Utility
Pong Game
Using Third-Party Engines
Tablet Fax
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Part I - The Underpinning Theory
Team change
Organizational change
Leading change
Mergers and acquisitions
Cisco IOS Cookbook (Cookbooks (OReilly))
Disabling RIP on an Interface
Connecting VLAN Trunks with ISL
Disabling Link Up/Down Traps per Interface
Routing Multicast Traffic with DVMRP
QoS over MPLS
Competency-Based Human Resource Management
Why a Focus on Jobs Is Not Enough
A Need for Implementing Competency-Based HR Management
Competency-Based HR Planning
Competency-Based Employee Development
The Transformation to Competency-Based HR Management
Special Edition Using Crystal Reports 10
Understanding Data and Data Sources
Creating Effective Summaries
Crystal Enterprise and Proxy Servers
Advanced Scenarios with the Crystal Enterprise Object Model
Scheduling to a Specific Format
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