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

• Record Type: Book
• Further Information: Note: Federico Razzoli.
• Authors: Razzoli, Federico
• 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.
• Publisher Details: Birmingham : Packt Publishing
• Publication Date: 2014
• Extent: 1 online resource
• Subjects: 004/.36; COMPUTERS -- Databases -- General; Database management; Client/server computing; COMPUTERS -- Computer Literacy; COMPUTERS -- Computer Science; COMPUTERS -- Data Processing; COMPUTERS -- Hardware -- General; COMPUTERS -- Information Technology; COMPUTERS -- Machine Theory; COMPUTERS -- Reference; Client/server computing; Database management; COMPUTERS -- Programming Languages -- SQL; Electronic books
• Languages: English
• ISBNs: 9781783981557; 1783981555; 1322158355; 9781322158358; 1783981547; 9781783981540
• Related ISBNs: 9781783981540
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.