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

Mostrar otras versiones (1)

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.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Razzoli, Federico (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham : Packt Publishing, 2014.
Colección:Community experience distilled.
Temas:
MariaDB.
MariaDB
Database management.
Client/server computing.
Bases de données > Gestion.
Architecture client-serveur (Informatique)
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
Acceso en línea:Texto completo
Texto completo

MARC

LEADER 00000cam a2200000 a 4500
001 EBSCO_ocn892047115
003 OCoLC
005 20231017213018.0
006 m o d
007 cr cnu---unuuu
008 141003s2014 enk o 000 0 eng d
040 |a IDEBK  |b eng  |e pn  |c IDEBK  |d N$T  |d OCLCQ  |d E7B  |d UMI  |d COO  |d DEBBG  |d EBLCP  |d YDXCP  |d OCLCQ  |d OCLCF  |d OCLCQ  |d AGLDB  |d ICA  |d MERUC  |d OCLCQ  |d OCLCO  |d REB  |d D6H  |d VTS  |d CEF  |d NLE  |d UKMGB  |d OCLCQ  |d OCLCO  |d WYU  |d STF  |d UAB  |d AU@  |d M8D  |d UKAHL  |d VT2  |d OCLCQ  |d OCLCO  |d OCLCQ  |d QGK  |d OCLCO 
016 7 |a 018006819  |2 Uk 
019 |a 892239027  |a 894504414  |a 907286308  |a 1259219073 
020 |a 9781783981557  |q (electronic bk.) 
020 |a 1783981555  |q (electronic bk.) 
020 |a 1322158355  |q (electronic bk.) 
020 |a 9781322158358  |q (electronic bk.) 
020 |a 1783981547 
020 |a 9781783981540 
020 |z 9781783981540 
029 1 |a AU@  |b 000055154439 
029 1 |a AU@  |b 000056019198 
029 1 |a AU@  |b 000062539747 
029 1 |a CHNEW  |b 000675319 
029 1 |a CHNEW  |b 000695819 
029 1 |a CHNEW  |b 000695824 
029 1 |a CHNEW  |b 000887853 
029 1 |a CHVBK  |b 374467706 
029 1 |a DEBBG  |b BV042489979 
029 1 |a DEBSZ  |b 434831603 
029 1 |a DEBSZ  |b 484729454 
029 1 |a GBVCP  |b 797805176 
029 1 |a GBVCP  |b 882842110 
029 1 |a UKMGB  |b 018006819 
035 |a (OCoLC)892047115  |z (OCoLC)892239027  |z (OCoLC)894504414  |z (OCoLC)907286308  |z (OCoLC)1259219073 
037 |a CL0500000496  |b Safari Books Online 
050 4 |a QA76.9.D3 
072 7 |a COM  |x 013000  |2 bisacsh 
072 7 |a COM  |x 014000  |2 bisacsh 
072 7 |a COM  |x 018000  |2 bisacsh 
072 7 |a COM  |x 067000  |2 bisacsh 
072 7 |a COM  |x 032000  |2 bisacsh 
072 7 |a COM  |x 037000  |2 bisacsh 
072 7 |a COM  |x 052000  |2 bisacsh 
082 0 4 |a 004/.36  |2 23 
049 |a UAMI 
100 1 |a Razzoli, Federico,  |e author. 
245 1 0 |a Mastering MariaDB :  |b debug, secure, and back up your data for optimum server performance with Maria DB /  |c Federico Razzoli. 
260 |a Birmingham :  |b Packt Publishing,  |c 2014. 
300 |a 1 online resource 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file 
490 1 |a Community experience distilled 
588 |a Print version record. 
505 0 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
520 |a 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. 
546 |a English. 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
590 |a eBooks on EBSCOhost  |b EBSCO eBook Subscription Academic Collection - Worldwide 
630 0 0 |a MariaDB. 
630 0 7 |a MariaDB  |2 fast 
650 0 |a Database management. 
650 0 |a Client/server computing. 
650 6 |a Bases de données  |x Gestion. 
650 6 |a Architecture client-serveur (Informatique) 
650 7 |a COMPUTERS  |x Computer Literacy.  |2 bisacsh 
650 7 |a COMPUTERS  |x Computer Science.  |2 bisacsh 
650 7 |a COMPUTERS  |x Data Processing.  |2 bisacsh 
650 7 |a COMPUTERS  |x Hardware  |x General.  |2 bisacsh 
650 7 |a COMPUTERS  |x Information Technology.  |2 bisacsh 
650 7 |a COMPUTERS  |x Machine Theory.  |2 bisacsh 
650 7 |a COMPUTERS  |x Reference.  |2 bisacsh 
650 7 |a Client/server computing  |2 fast 
650 7 |a Database management  |2 fast 
776 0 8 |i Print version:  |a Razzoli, Federico.  |t Mastering MariaDB : debug, secure, and back up your data for optimum server performance with MariaDB.  |d Birmingham, England : PACKT Publishing, ©2014  |h 363 pages  |k Community experience distilled.  |z 9781783981540 
830 0 |a Community experience distilled. 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781783981540/?ar  |z Texto completo 
856 4 0 |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=854548  |z Texto completo 
938 |a Askews and Holts Library Services  |b ASKH  |n AH27096477 
938 |a EBL - Ebook Library  |b EBLB  |n EBL1706439 
938 |a ebrary  |b EBRY  |n ebr10944000 
938 |a EBSCOhost  |b EBSC  |n 854548 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n cis29835431 
938 |a YBP Library Services  |b YANK  |n 12092495 
994 |a 92  |b IZTAP 

Ejemplares similares