Description |
1 online resource |
|
text file |
Series |
Community experience distilled |
|
Community experience distilled.
|
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. |
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. |
Language |
English. |
Subject |
MariaDB.
|
|
MariaDB |
|
Database management.
|
|
Client/server computing.
|
|
Bases de données -- Gestion. |
|
Architecture client-serveur (Informatique) |
|
Client/server computing |
|
Database management |
Other Form: |
Print version: Razzoli, Federico. Mastering MariaDB : debug, secure, and back up your data for optimum server performance with MariaDB. Birmingham, England : PACKT Publishing, ©2014 363 pages Community experience distilled. 9781783981540 |
ISBN |
9781783981557 (electronic bk.) |
|
1783981555 (electronic bk.) |
|
1322158355 (electronic bk.) |
|
9781322158358 (electronic bk.) |
|
1783981547 |
|
9781783981540 |
|