Search Images Maps Play YouTube News Gmail Drive More »
My library | Help | Advanced Book Search | Web History | Sign in

Books

MySQL Administrator's Bible

 (Google eBook)
Front Cover
0 Reviews
John Wiley & Sons, Mar 4, 2011 - Computers - 888 pages
With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.
  

What people are saying - Write a review

We haven't found any reviews in the usual places.

Related books

High Performance MySQL: Optimization, Backups, Replication, and More
High Performance MySQL: Optimization, Backups, Replication, and More
Baron Schwartz,Peter Zaitsev,Vadim Tkachenko,Jeremy D. Zawodny,Arjen Lentz,Derek J. Balling
Limited preview - 2008
MySQL Administrator's Guide
MySQL Administrator's Guide
MySQL AB
Limited preview - 2004
MySQL High Availability: Tools for Building Robust Data Centers
MySQL High Availability: Tools for Building Robust Data Centers
Charles Bell,Mats Kindahl,Lars Thalmann
Limited preview - 2010
All related books »

Selected pages

Contents

Acknowledgments
ii
Installation
Accessing MySQL
How MySQL Extends and Deviates from
MySQL Data Types
MySQL Index Types
Stored Routines Triggers and Events
MySQL Views
User Management
Partitioning
Logging and Replication
Measuring Performance
Monitoring Your Systems
Examining Open Source Monitoring
Securing MySQL
The MySQL Data DictionaLy

Transactions in MySQL
MySQL Server Tuning
Storage Engines
Caching with MySQL
Backups and Recovery
Scaling and High Availability Architectures
MySQL Proxy
Functions and Operators
Resources
Copyright

Common terms and phrases

affected 0.00 sec ALTER TABLE backup binary log BTREE buffer bytes Chapter character set checksum clause client command configuration file connection CREATE TABLE data type database administrator DATETIME default value defined DELETE disk Equivalent error event example execution expr field file system first_name foreign key GLOBAL INFORMATIONiSCHEMA database INSERT installation lastiname lnnoDB lock log files master memcached memory MERGE table MyISAM MyISAM tables MySQL Cluster MySQL Enterprise MySQL server mysql—proxy NULL operating system optimizer option output package parameters partition password performance phpMyAdmin plugin PRIMARY KEY privileges query cache Query OK query optimizer replication result set Returns row in set rows affected 0.00 sakila script SHOW CREATE slave specified sql_mode sqlimode status storage engine stored procedure stored routine string syntax system view tablespace temporary table thread transaction trigger UPDATE VARCHAR Warning

Bibliographic information

QR code for MySQL Administrator's Bible
TitleMySQL Administrator's Bible
AuthorsSheeri K. Cabral, Keith Murphy
PublisherJohn Wiley & Sons, 2011
ISBN1118080580, 9781118080580
Length888 pages
Subjects ›  › 

Computers / Databases / General
  
Export CitationBiBTeX EndNote RefMan