MariaDB cookbook :: over 95 recipes to unlock the power of MariaDB /
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...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham ; Mumbai :
Packt Publishing,
2014.
|
| Schriftenreihe: | Quick answers to common problems.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | 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. |
| Beschreibung: | Includes index. |
| Beschreibung: | 1 online resource (iv, 268 pages) : illustrations |
| ISBN: | 9781783284405 1783284404 |
Internformat
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn878060831 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 140424s2014 enka o 001 0 eng d | ||
| 040 | |a N$T |b eng |e rda |e pn |c N$T |d UMI |d E7B |d COO |d DEBBG |d YDXCP |d OCLCQ |d OCLCO |d OCLCF |d D6H |d AGLDB |d COCUF |d ICA |d CNNOR |d OCLCQ |d OCLCO |d MOR |d PIFAG |d OCLCQ |d OCLCO |d U3W |d REB |d STF |d VTS |d CEF |d NLE |d INT |d VT2 |d UKMGB |d OCLCQ |d OCLCO |d WYU |d G3B |d TKN |d OCLCQ |d OCLCO |d UAB |d AU@ |d M8D |d HS0 |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 016 | 7 | |a 018006525 |2 Uk | |
| 019 | |a 876830859 | ||
| 020 | |a 9781783284405 |q (electronic bk.) | ||
| 020 | |a 1783284404 |q (electronic bk.) | ||
| 020 | |z 9781783284399 | ||
| 020 | |z 1783284390 | ||
| 035 | |a (OCoLC)878060831 |z (OCoLC)876830859 | ||
| 037 | |a CL0500000414 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.D3 |b B369 2014eb | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 7 | |a 005.75/65 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Bartholomew, Daniel, |e author. | |
| 245 | 1 | 0 | |a MariaDB cookbook : |b over 95 recipes to unlock the power of MariaDB / |c Daniel Bartholomew. |
| 264 | 1 | |a Birmingham ; |a Mumbai : |b Packt Publishing, |c 2014. | |
| 264 | 4 | |c ©2014 | |
| 300 | |a 1 online resource (iv, 268 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a Quick answers to common problems | |
| 588 | 0 | |a Print version record. | |
| 500 | |a Includes index. | ||
| 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 | |
| 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. | ||
| 630 | 0 | 0 | |a MariaDB. |0 http://id.loc.gov/authorities/names/n2011046345 |
| 630 | 0 | 7 | |a MariaDB |2 fast |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 0 | |a Open source software. |0 http://id.loc.gov/authorities/subjects/sh99003437 | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Logiciels libres. | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 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: |a Bartholomew, Daniel. |t MariaDB cookbook |z 9781783284399 |w (OCoLC)875407188 |
| 830 | 0 | |a Quick answers to common problems. |0 http://id.loc.gov/authorities/names/no2015091434 | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=734982 |3 Volltext |
| 938 | |a ebrary |b EBRY |n ebr10851719 | ||
| 938 | |a EBSCOhost |b EBSC |n 734982 | ||
| 938 | |a YBP Library Services |b YANK |n 11721639 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn878060831 |
|---|---|
| _version_ | 1816882268925329408 |
| adam_text | |
| any_adam_object | |
| author | Bartholomew, Daniel |
| author_facet | Bartholomew, Daniel |
| author_role | aut |
| author_sort | Bartholomew, Daniel |
| author_variant | d b db |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 B369 2014eb |
| callnumber-search | QA76.9.D3 B369 2014eb |
| callnumber-sort | QA 276.9 D3 B369 42014EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | 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 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 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 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 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 |
| ctrlnum | (OCoLC)878060831 |
| dewey-full | 005.75/65 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/65 |
| dewey-search | 005.75/65 |
| dewey-sort | 15.75 265 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06038cam a2200661 i 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn878060831</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu---unuuu</controlfield><controlfield tag="008">140424s2014 enka o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">N$T</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="e">pn</subfield><subfield code="c">N$T</subfield><subfield code="d">UMI</subfield><subfield code="d">E7B</subfield><subfield code="d">COO</subfield><subfield code="d">DEBBG</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCF</subfield><subfield code="d">D6H</subfield><subfield code="d">AGLDB</subfield><subfield code="d">COCUF</subfield><subfield code="d">ICA</subfield><subfield code="d">CNNOR</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">MOR</subfield><subfield code="d">PIFAG</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">U3W</subfield><subfield code="d">REB</subfield><subfield code="d">STF</subfield><subfield code="d">VTS</subfield><subfield code="d">CEF</subfield><subfield code="d">NLE</subfield><subfield code="d">INT</subfield><subfield code="d">VT2</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">WYU</subfield><subfield code="d">G3B</subfield><subfield code="d">TKN</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">UAB</subfield><subfield code="d">AU@</subfield><subfield code="d">M8D</subfield><subfield code="d">HS0</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018006525</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">876830859</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781783284405</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1783284404</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781783284399</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1783284390</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)878060831</subfield><subfield code="z">(OCoLC)876830859</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000414</subfield><subfield code="b">Safari Books Online</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield><subfield code="b">B369 2014eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">051170</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.75/65</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Bartholomew, Daniel,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">MariaDB cookbook :</subfield><subfield code="b">over 95 recipes to unlock the power of MariaDB /</subfield><subfield code="c">Daniel Bartholomew.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham ;</subfield><subfield code="a">Mumbai :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2014.</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2014</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (iv, 268 pages) :</subfield><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Quick answers to common problems</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="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.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">MariaDB.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n2011046345</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">MariaDB</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Open source software.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh99003437</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Logiciels libres.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Programming Languages</subfield><subfield code="x">SQL.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Open source software</subfield><subfield code="2">fast</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">MariaDB cookbook (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCXPVvkQrKFRXg9vGbwKY4C</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Bartholomew, Daniel.</subfield><subfield code="t">MariaDB cookbook</subfield><subfield code="z">9781783284399</subfield><subfield code="w">(OCoLC)875407188</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Quick answers to common problems.</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2015091434</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=734982</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10851719</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">734982</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">11721639</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn878060831 |
| illustrated | Illustrated |
| indexdate | 2024-11-27T13:25:55Z |
| institution | BVB |
| isbn | 9781783284405 1783284404 |
| language | English |
| oclc_num | 878060831 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (iv, 268 pages) : illustrations |
| psigel | ZDB-4-EBA |
| publishDate | 2014 |
| publishDateSearch | 2014 |
| publishDateSort | 2014 |
| publisher | Packt Publishing, |
| record_format | marc |
| series | Quick answers to common problems. |
| series2 | Quick answers to common problems |
| spelling | Bartholomew, Daniel, author. MariaDB cookbook : over 95 recipes to unlock the power of MariaDB / Daniel Bartholomew. Birmingham ; Mumbai : Packt Publishing, 2014. ©2014 1 online resource (iv, 268 pages) : illustrations text txt rdacontent computer c rdamedia online resource cr rdacarrier Quick answers to common problems Print version record. Includes index. 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 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 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 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 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 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. MariaDB. http://id.loc.gov/authorities/names/n2011046345 MariaDB fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Open source software. http://id.loc.gov/authorities/subjects/sh99003437 Bases de données Gestion. Logiciels libres. COMPUTERS Programming Languages SQL. bisacsh Database management fast Open source software fast has work: MariaDB cookbook (Text) https://id.oclc.org/worldcat/entity/E39PCXPVvkQrKFRXg9vGbwKY4C https://id.oclc.org/worldcat/ontology/hasWork Print version: Bartholomew, Daniel. MariaDB cookbook 9781783284399 (OCoLC)875407188 Quick answers to common problems. http://id.loc.gov/authorities/names/no2015091434 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=734982 Volltext |
| spellingShingle | Bartholomew, Daniel MariaDB cookbook : over 95 recipes to unlock the power of MariaDB / Quick answers to common problems. 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 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 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 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 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 MariaDB. http://id.loc.gov/authorities/names/n2011046345 MariaDB fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Open source software. http://id.loc.gov/authorities/subjects/sh99003437 Bases de données Gestion. Logiciels libres. COMPUTERS Programming Languages SQL. bisacsh Database management fast Open source software fast |
| subject_GND | http://id.loc.gov/authorities/names/n2011046345 http://id.loc.gov/authorities/subjects/sh85035848 http://id.loc.gov/authorities/subjects/sh99003437 |
| title | MariaDB cookbook : over 95 recipes to unlock the power of MariaDB / |
| title_auth | MariaDB cookbook : over 95 recipes to unlock the power of MariaDB / |
| title_exact_search | MariaDB cookbook : over 95 recipes to unlock the power of MariaDB / |
| title_full | MariaDB cookbook : over 95 recipes to unlock the power of MariaDB / Daniel Bartholomew. |
| title_fullStr | MariaDB cookbook : over 95 recipes to unlock the power of MariaDB / Daniel Bartholomew. |
| title_full_unstemmed | MariaDB cookbook : over 95 recipes to unlock the power of MariaDB / Daniel Bartholomew. |
| title_short | MariaDB cookbook : |
| title_sort | mariadb cookbook over 95 recipes to unlock the power of mariadb |
| title_sub | over 95 recipes to unlock the power of MariaDB / |
| topic | MariaDB. http://id.loc.gov/authorities/names/n2011046345 MariaDB fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Open source software. http://id.loc.gov/authorities/subjects/sh99003437 Bases de données Gestion. Logiciels libres. COMPUTERS Programming Languages SQL. bisacsh Database management fast Open source software fast |
| topic_facet | MariaDB. MariaDB Database management. Open source software. Bases de données Gestion. Logiciels libres. COMPUTERS Programming Languages SQL. Database management Open source software |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=734982 |
| work_keys_str_mv | AT bartholomewdaniel mariadbcookbookover95recipestounlockthepowerofmariadb |