Cargando…
MariaDB Cookbook.
A practical cookbook, filled with advanced recipes, and plenty of code and commands used for illustration, which will make your learning curve easy and quick. This book is for anyone who wants to learn more about databases in general or MariaDB in particular. Some familiarity with SQL databases is a...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Packt Publishing,
2014.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Ma 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_ocn874967022 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr |n||||||||| | ||
| 008 | 140328s2014 xx o 000 0 eng d | ||
| 040 | |a IDEBK |b eng |e pn |c IDEBK |d EBLCP |d MHW |d YDXCP |d DEBSZ |d S4S |d OCLCO |d OCLCQ |d OCLCF |d OCLCQ |d FEM |d ZCU |d XFH |d MERUC |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d ICG |d AU@ |d OCLCQ |d OCLCO |d DKC |d OCLCQ |d UKAHL |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 019 | |a 968110217 |a 969033015 |a 994587686 | ||
| 020 | |a 130653108X |q (ebk) | ||
| 020 | |a 9781306531085 |q (ebk) | ||
| 020 | |a 9781783284405 | ||
| 020 | |a 1783284404 | ||
| 020 | |a 1783284390 | ||
| 020 | |a 9781783284399 | ||
| 029 | 1 | |a CHNEW |b 000886560 | |
| 029 | 1 | |a CHVBK |b 374454795 | |
| 029 | 1 | |a DEBBG |b BV043606763 | |
| 029 | 1 | |a DEBSZ |b 405667973 | |
| 029 | 1 | |a AU@ |b 000062497125 | |
| 035 | |a (OCoLC)874967022 |z (OCoLC)968110217 |z (OCoLC)969033015 |z (OCoLC)994587686 | ||
| 037 | |a 584359 |b MIL | ||
| 050 | 4 | |a QA76.9 .D3 | |
| 082 | 0 | 4 | |a 004 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Bartholomew, Daniel. | |
| 245 | 1 | 0 | |a MariaDB Cookbook. |
| 260 | |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 |2 rda | ||
| 588 | 0 | |a Print version record. | |
| 520 | |a A practical cookbook, filled with advanced recipes, and plenty of code and commands used for illustration, which will make your learning curve easy and quick. This book is for anyone who wants to learn more about databases in general or MariaDB in particular. Some familiarity with SQL databases is assumed, but the recipes are approachable to almost anyone with basic database skills. | ||
| 505 | 0 | |a Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with MariaDB; Introduction; Installing MariaDB on Windows; Installing MariaDB on Linux; Installing MariaDB on Mac OS X; Enabling the Feedback plugin; Switching between InnoDB and XtraDB; Creating a backup user; Making backups with XtraBackup; Making backups with mysqldump; Checking and optimizing tables automatically with mysqlcheck and cron; Using progress reporting in the mysql client; Chapter 2: Diving Deep into MariaDB; Introduction. | |
| 505 | 8 | |a Importing the data exported by mysqldumpUsing SHOW EXPLAIN with running queries; Using LIMIT ROWS EXAMINED; Using INSTALL SONAME; Producing HTML output; Producing XML output; Migrating a table from MyISAM to Aria; Migrating a table from MyISAM or Aria to InnoDB or XtraDB; Chapter 3: Optimizing and Tuning MariaDB; Introduction; Using SHOW STATUS to check if a feature is being used; Controlling MariaDB optimizer strategies; Using extended keys with InnoDB and XtraDB; Configuring the Aria two-step deadlock detection; Configuring the MyISAM segmented key cache; Configuring threadpool. | |
| 505 | 8 | |a Configuring the Aria pagecacheOptimizing queries with the subquery cache; Optimizing semijoin subqueries; Creating an index; Creating a full-text index; Removing an index; Using JOINs; Using microseconds in the DATETIME columns; Updating DATETIME and TIMESTAMP columns automatically; Chapter 4: TokuDB Storage Engine; Introduction; Installing TokuDB; Configuring TokuDB; Creating TokuDB tables; Migrating to TokuDB; Adding indexes to TokuDB tables; Modifying the compression of a TokuDB table; Chapter 5: The CONNECT Storage Engine; Introduction; Installing the CONNECT storage engine. | |
| 505 | 8 | |a Creating and dropping CONNECT tablesReading and writing CSV data using CONNECT; Reading and writing XML data using CONNECT; Accessing MariaDB tables using CONNECT; Using the XCOL table type; Using the PIVOT table type; Using the OCCUR table type; Using the WMI table type; Using the MAC address table type; Chapter 6: Replication in MariaDB; Introduction; Setting up replication; Using global transaction IDs; Using multisource replication; Enhancing the binlog with row event annotations; Configuring binlog event checksums; Selectively skipping replication of binlog events. | |
| 505 | 8 | |a Chapter 7: Replication with MariaDB Galera ClusterIntroduction; Installing MariaDB Galera Cluster; Dropping a node from a MariaDB Galera Cluster; Shutting down a MariaDB Galera Cluster; Chapter 8: Performance and Usage Statistics; Introduction; Installing the Audit Plugin; Using the Audit Plugin; Using engine-independent table statistics; Using extended statistics; Enabling the performance schema; Using the performance schema; Chapter 9: Searching Data using Sphinx; Introduction; Installing SphinxSE in MariaDB; Installing the Sphinx daemon on Linux; Installing the Sphinx daemon on Windows. | |
| 546 | |a English. | ||
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 630 | 0 | 0 | |a MariaDB. |
| 630 | 0 | 7 | |a MariaDB |2 fast |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a Open source software. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Logiciels libres. | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Open source software |2 fast | |
| 758 | |i has work: |a MariaDB cookbook (Text) |1 https://id.oclc.org/worldcat/entity/E39PCXPVvkQrKFRXg9vGbwKY4C |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |z 9781306531085 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=1477489 |z Texto completo |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26849863 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL1477489 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis27827937 | ||
| 938 | |a YBP Library Services |b YANK |n 11721639 | ||
| 994 | |a 92 |b IZTAP | ||