Mastering MariaDB : debug, secure, and back up your data for optimum server performance with Maria DB / Federico Razzoli.

Print version record.

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.

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.

eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - Worldwide