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
ERP and Data Warehousing in Organizations: Issues and Challenges
ERP Systems Impact on Organizations
ERP System Acquisition: A Process Model and Results From an Austrian Survey
The Effects of an Enterprise Resource Planning System (ERP) Implementation on Job Characteristics – A Study using the Hackman and Oldham Job Characteristics Model
A Hybrid Clustering Technique to Improve Patient Data Quality
Relevance and Micro-Relevance for the Professional as Determinants of IT-Diffusion and IT-Use in Healthcare
Metrics and Models in Software Quality Engineering (2nd Edition)
Applying the Seven Basic Quality Tools in Software Development
Reliability Growth Models
The Rayleigh Model Framework
The PTR Arrival and Backlog Projection Model
Collecting Customer Outage Data for Quality Improvement
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Why Project Risk Management?
Identifying Project Scope Risk
Identifying Project Resource Risk
Quantifying and Analyzing Activity Risks
Monitoring and Controlling Risky Projects
Image Processing with LabVIEW and IMAQ Vision
Introduction to IMAQ Vision Builder
Charge-Coupled Devices
Image Distribution
Image Standards
Digital Imaging and Communication in Medicine (DICOM)
Snort Cookbook
Uninstalling Snort from Linux
Upgrading Snort on Linux
Logging to Multiple Locations
Logging to the Windows Event Viewer
Working with Honeypots and Honeynets
Systematic Software Testing (Artech House Computer Library)
Analysis and Design
The Test Organization
The Software Tester
The Test Manager
Appendix C IEEE Templates
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