Cargando…
MySQL admin cookbook : 99 great recipes for mastering MySQL configuration and administration /
"This book shows you everything you need to know about MySQL Administration. You will learn to set up MySQL replication to manage load balancing and deal with online backup and fail-over scenarios. As you consider the benefits of backing up, you might like to back up your database efficiently w...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, U.K. :
Packt Pub.,
©2010.
|
| Colección: | Quick answers to common problems.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Ia 4500 | ||
|---|---|---|---|
| 001 | EBSCO_ocn659795757 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 100831s2010 enka o 001 0 eng d | ||
| 040 | |a UMI |b eng |e pn |c UMI |d IDEBK |d CEF |d OCLCQ |d E7B |d DEBSZ |d N$T |d CBT |d OCLCQ |d DKDLA |d YDXCP |d OCLCQ |d OCLCO |d OCLCF |d OCLCQ |d MOR |d PIFAG |d OCLCQ |d JBG |d OCLCQ |d U3W |d STF |d WRM |d OCLCO |d VTS |d COCUF |d NLE |d INT |d UKMGB |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d UAB |d M8D |d UKAHL |d HS0 |d UKCRE |d OCLCO |d OCLCQ |d OCLCO | ||
| 016 | 7 | |a 018011698 |2 Uk | |
| 019 | |a 667095892 |a 704518333 |a 764548598 |a 961514712 |a 962635022 |a 988525813 |a 992112970 |a 1037795868 |a 1038568624 |a 1153560906 | ||
| 020 | |a 9781847197979 |q (electronic bk.) | ||
| 020 | |a 1847197973 |q (electronic bk.) | ||
| 020 | |z 1847197965 | ||
| 020 | |z 9781847197962 | ||
| 029 | 1 | |a AU@ |b 000054175744 | |
| 029 | 1 | |a CHNEW |b 000611188 | |
| 029 | 1 | |a DEBBG |b BV043161740 | |
| 029 | 1 | |a DEBSZ |b 355449420 | |
| 029 | 1 | |a DEBSZ |b 372809014 | |
| 029 | 1 | |a DEBSZ |b 42146089X | |
| 029 | 1 | |a HEBIS |b 291519393 | |
| 029 | 1 | |a NZ1 |b 13869832 | |
| 029 | 1 | |a UKMGB |b 018011698 | |
| 035 | |a (OCoLC)659795757 |z (OCoLC)667095892 |z (OCoLC)704518333 |z (OCoLC)764548598 |z (OCoLC)961514712 |z (OCoLC)962635022 |z (OCoLC)988525813 |z (OCoLC)992112970 |z (OCoLC)1037795868 |z (OCoLC)1038568624 |z (OCoLC)1153560906 | ||
| 037 | |a CL0500000074 |b Safari Books Online | ||
| 050 | 4 | |a QA76.73.S67 |b S346 2010 | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.7565 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Schneller, Daniel. | |
| 245 | 1 | 0 | |a MySQL admin cookbook : |b 99 great recipes for mastering MySQL configuration and administration / |c Daniel Schneller, Udo Schwedt. |
| 260 | |a Birmingham, U.K. : |b Packt Pub., |c ©2010. | ||
| 300 | |a 1 online resource (iv, 361 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. | |
| 520 | |a "This book shows you everything you need to know about MySQL Administration. You will learn to set up MySQL replication to manage load balancing and deal with online backup and fail-over scenarios. As you consider the benefits of backing up, you might like to back up your database efficiently with advanced techniques covered in this book. The book demonstrates how to create, modify, and delete indexes. You will also learn to identify duplicate indexes, which hinder your MySQL server performance. This book focuses on administration tasks and will help you as an administrator to optimize the database for efficiency and reliability. A quick step-by-step guide for MySQL users and database administrators to tackle real-world challenges with MySQL configuration and administration"--Resource description page. | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a Cover; Copyright; Credits; About the Authors; About the Reviewers; Table of Contents; Preface; Chapter 1: Replication; Introduction; Setting up automatically updated slaves of a server based on a SQL dump; Setting up automatically updated slaves of a selection of tables based on a SQL dump; Setting up automatically updated slaves; Setting up automatically updated slavesusing data file copy; Sharing read load across multiple machines; Using replication to provide full-text indexing for InnoDB tables; Estimating network and slave I/O load | |
| 505 | 8 | |a Limiting network and slave I/O load in heavy write scenarios using the blackhole storage engineSetting up slaves via network streaming; Skipping problematic queries; Checking if servers are in sync; Avoiding duplicate server IDs; Setting up slaves to report custom information about themselves to the master; Chapter 2: Indexing; Introduction; Adding indexes to tables; Adding a fulltext index; Creating a normalized text search column; Removing indexes from tables; Estimating InnoDB index space requirements; Using prefix primary keys; Choosing InnoDB primary key columns | |
| 505 | 8 | |a Speeding up searches for (sub)domainsFinding duplicate indexes; Chapter 3: Tools; Introduction; Transferring connection settings between different machines using a network share; Sorting MySQL GUI Tools' stored connections; Automatically creating stored connections; Adding custom graphs to MySQL Administrator; Displaying query results page by page and with scrolling using the MySQL command-line client; Extracting information from verbose output using the MySQL command-line client; Specifying a default pager; Using a custom prompt to distinguish connections | |
| 505 | 8 | |a Encrypting a MySQL server connection with SSHCreating an encrypted MySQL console via SSH; Using a PuTTY template connection for SSH secured connections; Chapter 4: Backing Up and Restoring MySQL Data; Introduction; Using MySQL Administrator GUI Tool as a frontend for backups; Copying all data files to a backup location; Creating a SQL dump of all databases; Creating a SQL dump of specific databases; Creating a SQL dump of specific tables; Compressing SQL dumps on-the-fly; Rotating and purging binary logs; Using replication to perform backups without hurting a production system's performance | |
| 505 | 8 | |a Restoring data from a dump to a previously backed-up statePerforming a point-in-time recovery using the binary logs; Chapter 5: Managing Data; Introduction; Exporting data to a simple CSV file; Exporting data to a custom file format; Using stored procedures to export repeatedly; Importing data from a simple CSV file; Importing data from custom file formats; Inserting new data and updating data if it already exists; Inserting data based on existing database content; Deleting all data from large tables; Deleting all but a fragment of a large table's data | |
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 630 | 0 | 0 | |a MySQL (Electronic resource) |
| 630 | 0 | 7 | |a MySQL (Electronic resource) |2 blmlsh |
| 630 | 0 | 7 | |a MySQL (Electronic resource) |2 fast |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a Relational databases. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a Database management. |2 blmlsh | |
| 650 | 7 | |a Relational databases. |2 blmlsh | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 700 | 1 | |a Schwedt, Udo. | |
| 776 | 0 | 8 | |i Print version: |a Schneller, Daniel. |t MySQL admin cookbook. |d Birmingham : Packt Pub., ©2010 |z 9781847197962 |w (OCoLC)643403617 |
| 830 | 0 | |a Quick answers to common problems. | |
| 856 | 4 | 0 | |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=421794 |z Texto completo |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26943008 | ||
| 938 | |a ebrary |b EBRY |n ebr10439359 | ||
| 938 | |a EBSCOhost |b EBSC |n 421794 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n 253488 | ||
| 938 | |a YBP Library Services |b YANK |n 3601820 | ||
| 994 | |a 92 |b IZTAP | ||