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
Certified Ethical Hacker Exam Prep
Digital Signatures
Steganography
Trojans and Backdoors
Exam Simulation
Contacting Que Certification
Adobe After Effects 7.0 Studio Techniques
Extending a Track with Expressions
Virtual Cinematography
Camera Blur
Heat Distortion
All Hail Reference
Building Web Applications with UML (2nd Edition)
Summary
XML
Activities
Controlled Controllers Pattern
Analysis Model Classes
The Java Tutorial: A Short Course on the Basics, 4th Edition
Code Samples
Questions and Exercises
General Programming Problems
Applet Problems
Operator Precedence
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
IDS and IPS Architecture
Internet Security Systems RealSecure
Data Correlation
Laws, Standards, and Organizations
Security Business Issues
Cultural Imperative: Global Trends in the 21st Century
From 2,000,000 B.C. to A.D.2000: The Roots and Routes of Culture
Cultural Black Holes
Empires Past, Present, and Future
Epilogue After September 11
Appendix A Cultural Categorization Characteristics
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