Managing & Using MySQL, 2nd Edition
Customer Reviews: 2 Average Customer Rating:   Write a Review and tell the world about this title! People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
MySQL is a popular and robust open source database product that supports key
subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use
and costs a small amount for commercial use. Unlike commercial databases, MySQL
is affordable and easy to use. This book includes introductions to SQL and to
relational database theory. If you plan to use MySQL to build web sites or other
Linux or Unix applications, this book teaches you to do that, and it will remain
useful as a reference once you understand the basics. Ample tutorial material
and examples are included throughout.
This book has all you need to take full advantage of this powerful database
management system. It takes you through the whole process from installation
and configuration to programming interfaces and database administration. This
second edition has a greatly enhanced administration chapter that includes information
on administrative tools, server configuration, server startup and shutdown,
log file management, database backup and restore, and database administration
and repair. In addition, a new chapter on security describes data, server, and
client-server security, while a chapter on extending MySQL provides an overview
of MySQL internals and describes the use of MySQL user-defined functions.
If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact
with your MySQL database. In addition, you can embed queries and updates directly
in an HTML file so that a web page becomes its own interface to the database.
Managing and Using MySQL includes chapters on the programming language interfaces,
and it also includes a complete reference section with specific function calls
for each language.
Also included in the reference section are references to the SQL language, and
details of the MySQL system variables, programs, and utilities. New to the second
edition is a reference to the internal MySQL tables, which will be of particular
interest to those who want to work extensively with MySQL security.
Table of Contents
Preface
Part I. Introduction
1. MySQL
Relational Databases
The History of MySQL
MySQL Design
MySQL Features
MySQL Applications
What You Get
2. Installation
Preparation
Unix Installation
Windows Installation
3. SQL According to MySQL
SQL Basics
Database Creation
Table Management
MySQL Data Types
Indexing
Managing Data
Queries
SQL Operators
Advanced Features
4. Database Administration
Configuration
Server Startup and Shutdown
Logging
Backup
Recovery
Table Maintenance and Crash Recovery
Part II. MySQL Administration
5. Performance Tuning
An Approach to Performance Tuning
Application Tuning
Database Server Tuning
Operating System/Hardware Tuning
6. Security
Database Security
System Security
Application Security
7. Database Design
Database Design Primer
Normalization
A Logical Data-Modeling Methodology
Physical Database Design
Part III. MySQL Programming
8. Database Applications
Architecture
Connections and Transactions
Object/Relational Modeling
9. Perl
Introduction to DBI
DBI and CGI
A General Model for Maintainable Perl Programs
10. Python
DB-API
Proprietary Operations
Applied DB-API
11. PHP
Introducing PHP
Installing PHP
Accessing the MySQL DBMS with PHP
Securing User Data
Managing Sessions
Writing Data with PHP
Using the HTML <form> Environment
Where to Find Out More
12. C API
API Overview
The C API in Practice
Advanced Issues
13. Java
The JDBC API
Simple Database Access
Dynamic Database Access
A Guest Book Servlet
14. Extending MySQL
User-Defined Functions
Alternative Character Sets
Part IV. MySQL Reference
15. SQL Syntax for MySQL
Basic Syntax
SQL Commands
16. MySQL Data Types
Numeric Data Types
String Data Types
Date Data Types
Complex Data Types
17. Operators and Functions
Operators
Functions
18. MySQL PHP API Reference
Data Types
Functions
19. C Reference
Data types
Functions
20. The Python DB-API
Module: MySQLdb
Index
Customer Reviews
Customer Reviews: 2 Average Customer Rating: Aug 21, 2003 starbux (starbux@ureach.com) from SC
Certainly not what I needed
This may be a great book for people that want to use Mysql with php, java etc - but IMHO it falls incredibly short in the area of administering Mysql. Perhaps my expectations were set too high from reading other OReilly pubs but this book was worthless to me. I ended up searching the web anyway for more details on topics like: -User administration and privilege management -Security and lockdowns -Operating system interaction, setup and tuning -Administrative tools (mysqladmin etc.) -Detailed installation and troubleshooting. -Basically any real information pertaining to the ADMINISTRATOR (not programmer) of Mysql
This book addresses these topics but with sufficient lack of detail to sucker you into wasting your time.
Aug 17, 2002 Ari Pollak from New Jersey, USA
Excellent!
This is absolutely one of the best O'Reilly books I've ever read. It uses plain English without a lot of the technical cruft present in a lot of related books. The authors assume no previous knowledge of SQL or databases in general, but the entire first chapter can be skipped if the reader already has prior advanced DBMS knowledge. I would recommend this to any system administrator, Computer Science Student, DBA, or anyone just wanting to learn about MySQL and how to make things run more smoothly.
|
