Mastering MariaDB : debug, secure, and back up your data for optimum server performance with MariaDB / Federico Razzoli ; Karl Moore, cover image.

Format:

Book

Author/Creator:

Razzoli, Federico, author.

Contributor:

Moore, Karl, 1955- cover designer.

Series:

Community experience distilled.

Community Experience Distilled

Language:

English

Subjects (All):

MariaDB.

SQL (Computer program language).

Physical Description:

1 online resource (384 p.)

Edition:

1st edition

Other Title:

Debug, secure, and back up your data for optimum server performance with MariaDB

Place of Publication:

Birmingham, England : PACKT Publishing, 2014.

Language Note:

English

System Details:

text file

Biography/History:

Razzoli Federico: Federico Razzoli is a software developer, database consultant, and free software supporter. He has been working on websites and database applications since 2000 and used MySQL and other relational databases extensively during this period. He is now a MariaDB Ambassador.

Summary:

This book is intended for intermediate users who want to learn how to administrate a MariaDB server or a set of servers. It is aimed at MariaDB users, and hence working knowledge of MariaDB is a prerequisite.

Contents:

Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Understanding the Essentials of MariaDB; The MariaDB architecture; The command-line client; Storage engines; XtraDB and InnoDB; TokuDB; MyISAM and Aria; Other engines; Logs; MariaDB caches; InnoDB data structures; Authentication and security; The information_schema database; The performance_schema database; Compatibility with MySQL and other DBMS; MariaDB resources; Summary; Chapter 2: Debugging; Understanding error conditions in MariaDB; The SQLSTATE value

The error numberThe error message; The custom errors; The SHOW WARNINGS and SHOW ERRORS statements; The diagnostics area; The GET DIAGNOSTICS statement; The error log; The error log format; A troubleshooting example with the error log; System logs; The general query log; The file format of the general query log; The general_log table; Debugging examples with the general query log; Maintenance of the server logs; Flushing logs; Rotating the file-based logs; Rotating the table-based logs; The SQL_ERROR_LOG plugin; Tips on debugging stored programs

Debugging stored programs using the SQL_ERROR_LOG pluginSummary; Chapter 3: Optimizing Queries; The slow query log; The file format of the slow query log; The slow_log table; Explaining the pt-query-digest command from Percona Toolkit; Introducing indexes; Table statistics; Storage engines and indexes; Working with the EXPLAIN statement; Understanding the output of EXPLAIN; Simple SELECT statements; Internal temporary tables or files; The UNION queries; Simple index access methods; Index optimizations of the JOIN clause; Optimization of subqueries; Summary; Chapter 4: Transactions and Locks

The InnoDB locksThe lock modes; Lock types; Diagnosing locks; Locks used by various SQL statements; Reads consistency; The non-repeatable reads; Phantom rows; Consistent reads; Locking reads; Deadlocks; Transactions; The transactions life cycle; Transactions isolation levels; The READ UNCOMMITTED isolation level; The READ COMMITTED isolation level; The REPEATABLE READ isolation level; The SERIALIZABLE isolation level; Transactions access modes; Metadata locks; Summary; Chapter 5: Users and Connections; User accounts; Setting permissions using roles

Connecting MariaDB through Secure Socket LayerAuthentication plugins; Activating the pool of threads; Monitoring the pool of threads; Configuring the threadpool implementation; Configuring the pool of threads on Unix; Configuring the pool of threads on Windows; Tuning the configuration variables; Unblocking a blocked pool of threads; Monitoring connections; States of the process; Aborting connections; Summary; Chapter 6: Caches; InnoDB caches; InnoDB pages; The InnoDB buffer pool; Old and new pages; Buffer pool instances; Dirty pages; The read ahead optimization

Diagnosing the buffer pool performance

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed October 11, 2014).

ISBN:

9781783981557

1783981555

OCLC:

894504414