Verfügbarkeit: High performance MySQL

High performance MySQL: [optimization, backups, and replication ; covers version 5.5]

Gespeichert in:

Bibliographische Detailangaben
Hauptverfasser:	Schwartz, Baron (VerfasserIn), Zaitsev, Peter (VerfasserIn), Tkačenko, Vadim P. (VerfasserIn)
Format:	Buch
Sprache:	English
Veröffentlicht:	Beijing [u.a.] O'Reilly 2012
Ausgabe:	3. ed.
Schlagworte:	MySQL Lastteilung Datenreplikation Sicherungskopie Benchmark
Online-Zugang:	Inhaltsverzeichnis
Beschreibung:	Hier auch später erschienene, unveränderte Nachdrucke
Beschreibung:	XXVIII, 793 S. Ill., graph. Darst.
ISBN:	9781449314286

Internformat

MARC


LEADER	00000nam a2200000 c 4500
001	BV040145189
003	DE-604
005	20160422
007	t
008	120521s2012 ad\|\| \|\|\|\| 00\|\|\| eng d
015			\|a 08,N18,0058 \|2 dnb
020			\|a 9781449314286 \|9 978-1-449-31428-6
035			\|a (OCoLC)796233927
035			\|a (DE-599)BVBBV040145189
040			\|a DE-604 \|b ger \|e rakwb
041	0		\|a eng
049			\|a DE-1050 \|a DE-473 \|a DE-Aug4 \|a DE-20 \|a DE-11 \|a DE-384 \|a DE-Aug7
084			\|a ST 271 \|0 (DE-625)143639: \|2 rvk
084			\|a 004 \|2 sdnb
100	1		\|a Schwartz, Baron \|e Verfasser \|4 aut
245	1	0	\|a High performance MySQL \|b [optimization, backups, and replication ; covers version 5.5] \|c Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko
250			\|a 3. ed.
264		1	\|a Beijing [u.a.] \|b O'Reilly \|c 2012
300			\|a XXVIII, 793 S. \|b Ill., graph. Darst.
336			\|b txt \|2 rdacontent
337			\|b n \|2 rdamedia
338			\|b nc \|2 rdacarrier
500			\|a Hier auch später erschienene, unveränderte Nachdrucke
650	0	7	\|a MySQL \|0 (DE-588)4559381-4 \|2 gnd \|9 rswk-swf
650	0	7	\|a Lastteilung \|0 (DE-588)4323960-2 \|2 gnd \|9 rswk-swf
650	0	7	\|a Datenreplikation \|0 (DE-588)4742677-9 \|2 gnd \|9 rswk-swf
650	0	7	\|a Sicherungskopie \|0 (DE-588)4513560-5 \|2 gnd \|9 rswk-swf
650	0	7	\|a Benchmark \|0 (DE-588)4144457-7 \|2 gnd \|9 rswk-swf
689	0	0	\|a MySQL \|0 (DE-588)4559381-4 \|D s
689	0	1	\|a Benchmark \|0 (DE-588)4144457-7 \|D s
689	0		\|5 DE-604
689	1	0	\|a MySQL \|0 (DE-588)4559381-4 \|D s
689	1	1	\|a Datenreplikation \|0 (DE-588)4742677-9 \|D s
689	1	2	\|a Sicherungskopie \|0 (DE-588)4513560-5 \|D s
689	1	3	\|a Lastteilung \|0 (DE-588)4323960-2 \|D s
689	1		\|5 DE-604
700	1		\|a Zaitsev, Peter \|e Verfasser \|4 aut
700	1		\|a Tkačenko, Vadim P. \|e Verfasser \|4 aut
856	4	2	\|m HBZ Datenaustausch \|q application/pdf \|u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025002029&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA \|3 Inhaltsverzeichnis
999			\|a oai:aleph.bib-bvb.de:BVB01-025002029

Datensatz im Suchindex

_version_	1804149165743144960
adam_text	Titel: High performance MySQL Autor: Schwartz, Baron Jahr: 2012 Table of Contents Foreword...................................................................xv Preface....................................................................xvii 1. MySQL Architecture and History........................................... 1 MySQL s Logical Architecture 1 Connection Management and Security 2 Optimization and Execution 3 Concurrency Control 3 Read/Write Locks 4 Lock Granularity 4 Transactions 6 Isolation Levels 7 Deadlocks 9 Transaction Logging 10 Transactions in MySQL 10 Multiversion Concurrency Control 12 MySQL s Storage Engines 13 The InnoDB Engine 15 The MylSAM Engine 17 Other Built-in MySQL Engines 19 Third-Party Storage Engines 21 Selecting the Right Engine 24 Table Conversions 28 A MySQL Timeline 29 MySQL s Development Model 33 Summary 34 2. Benchmarking MySQL.................................................. 35 Why Benchmark? 35 Benchmarking Strategies 37 What to Measure 38 Benchmarking Tactics 40 Designing and Planning a Benchmark 41 How Long Should the Benchmark Last? 42 Capturing System Performance and Status 44 Getting Accurate Results 45 Running the Benchmark and Analyzing Results 47 The Importance of Plotting 49 Benchmarking Tools 50 Full-Stack Tools 51 Single-Component Tools 51 Benchmarking Examples 54 httpjoad 54 MySQL Benchmark Suite 55 sysbench 56 dbt2 TPC-C on the Database Test Suite 61 Percona s TPCC-MySQL Tool 64 Summary 66 3. Profiling Server Performance............................................69 Introduction to Performance Optimization 69 Optimization Through Profiling 72 Interpreting the Profile 74 Profiling Your Application 75 Instrumenting PHP Applications 77 Profiling MySQL Queries 80 Profiling a Server s Workload 80 Profiling a Single Query 84 Using the Profile for Optimization 91 Diagnosing Intermittent Problems 92 Single-Query Versus Server-Wide Problems 93 Capturing Diagnostic Data 97 A Case Study in Diagnostics 102 Other Profiling Tools 110 Using the USER_STATISTICS Tables 110 Using strace 111 Summary 112 4. Optimizing Schema and Data Types......................................115 Choosing Optimal Data Types 115 WholeNumbers 117 RealNumbers 118 String Types 119 iv I Table of Contents Date and Time Types 125 Bit-Packed Data Types 127 Choosing Identifiers 129 Special Types ofData 131 Schema Design Gotchas in MySQL 131 Normalization and Denormalization 133 Pros and Cons of a Normalized Schema 134 Pros and Cons of a Denormalized Schema 135 A Mixture of Normalized and Denormalized 136 Cache and Summary Tables 136 Materialized Views 138 Counter Tables 139 SpeedingUp ALTER TABLE 141 Modifying Only the irm File 142 Building MylSAM Indexes Quickly 143 Summary 145 5. Indexing for High Performance..........................................147 Indexing Basics 147 Types of Indexes 148 Benefits of Indexes 158 Indexing Strategies for High Performance 159 Isolating the Column 159 Prefix Indexes and Index Selectivity 160 Multicolumn Indexes 163 Choosing a Good Column Order 165 Clustered Indexes 168 Covering Indexes 177 Using Index Scans for Sorts 182 Packed (Prefix-Compressed) Indexes 184 Redundant and Duplicate Indexes 185 Unused Indexes 187 Indexes and Locking 188 An Indexing Case Study 189 Supporting Many Kinds of Filtering 190 Avoiding Multiple Range Conditions 192 Optimizing Sorts 193 Index and Table Maintenance 194 Finding and Repairing Table Corruption 194 Updating Index Statistics 195 Reducing Index and Data Fragmentation 197 Summary 199 Table of Contents \| v Query Performance Optimization........................................201 Why Are Queries Slow? 201 Slow Query Basics: Optimize Data Access 202 Are You Asking the Database for Data You Don t Need? 202 Is MySQL Examining Too Much Data? 204 Ways to Restructure Queries 207 Complex Queries Versus Many Queries 207 Chopping Up a Query 208 Join Decomposition 209 Query Execution Basics 210 The MySQL Client/Server Protocol 210 The Query Cache 214 The Query Optimization Process 214 The Query Execution Engine 228 Returning Results to the Client 228 Limitations of the MySQL Query Optimizer 229 Correlated Subqueries 229 UNION Limitations 233 Index Merge Optimizations 234 Equality Propagation 234 Parallel Execution 234 Hash Joins 234 Loose Index Scans 235 MINO and MAX() 237 SELECT and UPDATE on the Same Table 237 Query Optimizer Hints 238 Optimizing Specific Types of Queries 241 Optimizing COUNT0 Queries 241 Optimizing JOIN Queries 244 Optimizing Subqueries 244 Optimizing GROUP BY and DISTINCT 244 Optimizing LIMIT and OFFSET 246 Optimizing SQL_CALC_FOUND_ROWS 248 Optimizing UNION 248 Static Query Analysis 249 Using User-Defined Variables 249 Case Studies 256 Building a Queue Table in MySQL 256 Computing the Distance Between Points 258 Using User-Defined Functions 262 Summary 263 vi \| Table of Contents Advanced MySQL Features..............................................265 Partitioned Tables 265 How Partitioning Works 266 Types of Partitioning 267 How to Use Partitioning 268 What Can Go Wrong 270 Optimizing Queries 272 Merge Tables 273 Views 276 Updatable Views 278 Performance Implications of Views 279 Limitations of Views 280 Foreign Key Constraints 281 Storing Code Inside MySQL 282 Stored Procedures and Functions 284 Triggers 286 Events 288 Preserving Comments in Stored Code 289 Cursors 290 Prepared Statements 291 Prepared Statement Optimization 292 The SQL Interface to Prepared Statements 293 Limitations of Prepared Statements 294 User-Defined Functions 295 Plugins 297 Character Sets and Collations 298 How MySQL Uses Character Sets 298 Choosing a Character Set and Collation 301 How Character Sets and Collations Affect Queries 302 Full-Text Searching 305 Natural-Language Full-Text Searches 306 Boolean Full-Text Searches 308 Full-Text Changes in MySQL 5.1 310 Full-Text Tradeoffs and Workarounds 310 Full-Text Configuration and Optimization 312 Distributed (XA) Transactions 313 Internal XA Transactions 314 External XA Transactions 315 The MySQL Query Cache 315 How MySQL Checks for a Cache Hit 316 How the Cache Uses Memory 318 When the Query Cache Is Helpful 320 How to Configure and Maintain the Query Cache 323 Table of Contents \| vii InnoDB and the Query Cache 326 General Query Cache Optimizations 327 Alternatives to the Query Cache 328 Summary 329 Optimizing Server Settings.............................................331 How MySQL s Configuration Works 332 Syntax, Scope, and Dynamism 333 Side Effects of Setting Variables 335 Getting Started 337 Iterative Optimization by Benchmarking 338 What Not to Do 340 Creating a MySQL Configuration File 342 Inspecting MySQL Server Status Variables 346 Configuring Memory Usage 347 How Much Memory Can MySQL Use? 347 Per-Connection Memory Needs 348 Reserving Memory for the Operating System 349 Allocating Memory for Caches 349 The InnoDB Buffer Pool 350 The MylSAM Key Caches 351 The Thread Cache 353 The Table Cache 354 The InnoDB Data Dictionary 356 Configuring MySQL s I/O Behavior 356 InnoDB I/O Configuration 357 MylSAM I/O Configuration 369 Configuring MySQL Concurrency 371 InnoDB Concurrency Configuration 372 MylSAM Concurrency Configuration 373 Workload-Based Configuration 375 Optimizing for BLOB and TEXT Workloads 375 Optimizing for Filesorts 377 Completing the Basic Configuration 378 Safety and Sanity Settings 380 Advanced InnoDB Settings 383 Summary 385 Operating System and Hardware Optimization............................ 387 What Limits MySQL s Performance? 387 How to Select CPUs for MySQL 388 Which Is Better: Fast CPUs or Many CPUs? 388 CPU Architecture 390 viii I Table of Contents Scaling to Many CPUs and Cores 391 Balancing Memory and Disk Resources 393 Random Versus Sequential I/O 394 Caching, Reads, and Writes 395 What s Your Working Set? 395 Finding an Effective Memory-to-Disk Ratio 397 Choosing Hard Disks 398 Solid-State Storage 400 An Overview of Flash Memory 401 Flash Technologies 402 Benchmarking Flash Storage 403 Solid-State Drives (SSDs) 404 PCIe Storage Devices 406 Other Types of Solid-State Storage 407 When Should You Use Flash? 407 Using Flashcache 408 Optimizing MySQL for Solid-State Storage 410 Choosing Hardware for a Replica 414 RAID Performance Optimization 415 RAID Failure, Recovery, and Monitoring 417 Balancing Hardware RAID and Software RAID 418 RAID Configuration and Caching 419 Storage Area Networks and Network-Attached Storage 422 SAN Benchmarks 423 Using a SAN over NFS or SMB 424 MySQL Performance on a SAN 424 Should You Use a SAN? 425 Using Multiple Disk Volumes 427 Network Configuration 429 Choosing an Operating System 431 Choosing a Filesystem 432 Choosing a Disk Queue Scheduler 434 Threading 435 Swapping 436 Operating System Status 438 How to Read vmstat Output 438 How to Read iostat Output 440 Other Helptul Tools 441 A CPU-Bound Machine 442 An I/O-Bound Machine 443 A Swapping Machine 444 An Idle Machine 444 Summary 445 Table of Contents I ix 10. Replication.......................................................... 447 Replication Overview 447 Problems Solved by Replication 448 How Replication Works 449 Setting Up Replication 451 Creating Replication Accounts 451 Configuring the Master and Replica 452 Starting the Replica 453 Initializing a Replica from Another Server 456 Recommended Replication Configuration 458 Replication Under the Hood 460 Statement-Based Replication 460 Row-Based Replication 460 Statement-Based or Row-Based: Which Is Better? 461 Replication Files 463 Sending Replication Events to Other Replicas 465 Replication Filters 466 Replication Topologies 468 Master and Multiple Replicas 468 Master-Master in Active-Active Mode 469 Master-Master in Active-Passive Mode 471 Master-Master with Replicas 473 Ring Replication 473 Master, Distribution Master, and Replicas 474 Tree or Pyramid 476 Custom Replication Solutions 477 Replication and Capacity Planning 482 Why Replication Doesn t Help Scale Writes 483 When Will Replicas Begin to Lag? 484 Plan to Underutilize 485 Replication Administration and Maintenance 485 Monitoring Replication 485 Measuring Replication Lag 486 Determining Whether Replicas Are Consistent with the Master 487 Resyncing a Replica from the Master 488 Changing Masters 489 Switching Roles in a Master-Master Configuration 494 Replication Problems and Solutions 495 Errors Caused by Data Corruption or Loss 495 Using Nontransactional Tables 498 Mixing Transactional and Nontransactional Tables 498 Nondeterministic Statements 499 Different Storage Engines on the Master and Replica 500 x \| Table of Contents Data Changes on the Replica 500 Nonunique Server IDs 500 Undefined Server IDs 501 Dependencies on Nonreplicated Data 501 Missing Temporary Tables 502 Not Replicating All Updates 503 Lock Contention Caused by InnoDB Locking Selects 503 Writing to Both Masters in Master-Master Replication 505 Excessive Replication Lag 507 Oversized Packets from the Master 511 Limited Replication Bandwidth 511 No Disk Space 511 Replication Limitations 512 How Fast Is Replication? 512 Advanced Features in MySQL Replication 514 Other Replication Technologies 516 Summary 518 11. Scaling MySQL........................................................521 What Is Scalability? 521 A Formal Definition 523 Scaling MySQL 527 Planning for Scalability 527 Buying Time Before Scaling 528 Scaling Up 529 Scaling Out 531 Scaling by Consolidation 547 Scaling by Clustering 548 Scaling Back 552 Load Balancing 555 Connecting Directly 556 Introducing a Middleman 560 Load Balancing with a Master and Multiple Replicas 564 Summary 565 12. High Availability......................................................567 What Is High Availability? 567 What Causes Downtime? 568 Achieving High Availability 569 Improving Mean Time Between Failures 570 Improving Mean Time to Recovery 571 Avoiding Single Points of Failure 572 Shared Storage or Replicated Disk 573 Table of Contents \| xi Synchronous MySQL Replication 576 Replication-Based Redundancy 580 Failover and Failback 581 Promoting a Replica or Switching Roles 583 Virtual IP Addresses or IP Takeover 583 Middleman Solutions 584 Handling Failover in the Application 585 Summary 586 13. MySQL in the Cloud....................................................589 Benefits, Drawbacks, and Myths of the Cloud 590 The Economics of MySQL in the Cloud 592 MySQL Scaling and HA in the Cloud 593 The Four Fundamental Resources 594 MySQL Performance in Cloud Hosting 595 Benchmarks for MySQL in the Cloud 598 MySQL Database as a Service (DBaaS) 600 Amazon RDS 600 Other DBaaS Solutions 602 Summary 602 14. Application-Level Optimization.........................................605 Common Problems 605 Web Server Issues 608 Finding the Optimal Concurrency 609 Caching 611 Caching Below the Application 611 Application-Level Caching 612 Cache Control Policies 614 Cache Object Hierarchies 616 Pregenerating Content 617 The Cache as an Infrastructure Component 617 Using HandlerSocket and memcached Access 618 Extending MySQL 618 Alternatives to MySQL 619 Summary 620 15. Backup and Recovery..................................................621 Why Backups? 622 Defining Recovery Requirements 623 Designing a MySQL Backup Solution 624 Online or Offline Backups? 625 Logical or Raw Backups? 627 xii \| Table of Contents What to Back Up 629 Storage Engines and Consistency 632 Replication 634 Managing and Backing Up Binary Logs 634 The Binary Log Format 635 Purging Old Binary Logs Safely 636 Backing Up Data 637 Making a Logical Backup 637 Filesystem Snapshots 640 Recovering from a Backup 647 Restoring Raw Files 648 Restoring Logical Backups 649 Point-in-Time Recovery 652 More Advanced Recovery Techniques 653 InnoDB Crash Recovery 655 Backup and Recovery Tools 658 MySQL Enterprise Backup 658 Percona XtraBackup 658 mylvmbackup 659 Zmanda Recovery Manager 659 mydumper 659 mysqldump 660 Scripting Backups 661 Summary 664 16. Tools for MySQL Users................................................. 665 Interface Tools 665 Command-Line Utilities 666 SQL Utilities 667 Monitoring Tools 667 Open Source Monitoring Tools 668 Commercial Monitoring Systems 670 Command-Line Monitoring with Innotop 672 Summary 677 A. Forks and Variantsof MySQL............................................679 B. MySQL Server Status...................................................685 C Transferring Large Files................................................715 D. Using EXPLAIN........................................................719 Table of Contents \| xiii E. Debugging Locks..................................................... 735 F. Using Sphinx with MySQL.............................................. 745 Index.....................................................................771 xiv \| Table of Contents
any_adam_object	1
author	Schwartz, Baron Zaitsev, Peter Tkačenko, Vadim P.
author_facet	Schwartz, Baron Zaitsev, Peter Tkačenko, Vadim P.
author_role	aut aut aut
author_sort	Schwartz, Baron
author_variant	b s bs p z pz v p t vp vpt
building	Verbundindex
bvnumber	BV040145189
classification_rvk	ST 271
ctrlnum	(OCoLC)796233927 (DE-599)BVBBV040145189
discipline	Informatik
edition	3. ed.
format	Book
fullrecord	<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02053nam a2200505 c 4500</leader><controlfield tag="001">BV040145189</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20160422 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">120521s2012 ad\|\| \|\|\|\| 00\|\|\| eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">08,N18,0058</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781449314286</subfield><subfield code="9">978-1-449-31428-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)796233927</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV040145189</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1050</subfield><subfield code="a">DE-473</subfield><subfield code="a">DE-Aug4</subfield><subfield code="a">DE-20</subfield><subfield code="a">DE-11</subfield><subfield code="a">DE-384</subfield><subfield code="a">DE-Aug7</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">004</subfield><subfield code="2">sdnb</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Schwartz, Baron</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">High performance MySQL</subfield><subfield code="b">[optimization, backups, and replication ; covers version 5.5]</subfield><subfield code="c">Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">3. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing [u.a.]</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2012</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXVIII, 793 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Hier auch später erschienene, unveränderte Nachdrucke</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">MySQL</subfield><subfield code="0">(DE-588)4559381-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Lastteilung</subfield><subfield code="0">(DE-588)4323960-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenreplikation</subfield><subfield code="0">(DE-588)4742677-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Sicherungskopie</subfield><subfield code="0">(DE-588)4513560-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Benchmark</subfield><subfield code="0">(DE-588)4144457-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">MySQL</subfield><subfield code="0">(DE-588)4559381-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Benchmark</subfield><subfield code="0">(DE-588)4144457-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">MySQL</subfield><subfield code="0">(DE-588)4559381-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">Datenreplikation</subfield><subfield code="0">(DE-588)4742677-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="2"><subfield code="a">Sicherungskopie</subfield><subfield code="0">(DE-588)4513560-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="3"><subfield code="a">Lastteilung</subfield><subfield code="0">(DE-588)4323960-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Zaitsev, Peter</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Tkačenko, Vadim P.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025002029&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-025002029</subfield></datafield></record></collection>
id	DE-604.BV040145189
illustrated	Illustrated
indexdate	2024-07-10T00:18:42Z
institution	BVB
isbn	9781449314286
language	English
oai_aleph_id	oai:aleph.bib-bvb.de:BVB01-025002029
oclc_num	796233927
open_access_boolean
owner	DE-1050 DE-473 DE-BY-UBG DE-Aug4 DE-20 DE-11 DE-384 DE-Aug7
owner_facet	DE-1050 DE-473 DE-BY-UBG DE-Aug4 DE-20 DE-11 DE-384 DE-Aug7
physical	XXVIII, 793 S. Ill., graph. Darst.
publishDate	2012
publishDateSearch	2012
publishDateSort	2012
publisher	O'Reilly
record_format	marc
spelling	Schwartz, Baron Verfasser aut High performance MySQL [optimization, backups, and replication ; covers version 5.5] Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko 3. ed. Beijing [u.a.] O'Reilly 2012 XXVIII, 793 S. Ill., graph. Darst. txt rdacontent n rdamedia nc rdacarrier Hier auch später erschienene, unveränderte Nachdrucke MySQL (DE-588)4559381-4 gnd rswk-swf Lastteilung (DE-588)4323960-2 gnd rswk-swf Datenreplikation (DE-588)4742677-9 gnd rswk-swf Sicherungskopie (DE-588)4513560-5 gnd rswk-swf Benchmark (DE-588)4144457-7 gnd rswk-swf MySQL (DE-588)4559381-4 s Benchmark (DE-588)4144457-7 s DE-604 Datenreplikation (DE-588)4742677-9 s Sicherungskopie (DE-588)4513560-5 s Lastteilung (DE-588)4323960-2 s Zaitsev, Peter Verfasser aut Tkačenko, Vadim P. Verfasser aut HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025002029&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis
spellingShingle	Schwartz, Baron Zaitsev, Peter Tkačenko, Vadim P. High performance MySQL [optimization, backups, and replication ; covers version 5.5] MySQL (DE-588)4559381-4 gnd Lastteilung (DE-588)4323960-2 gnd Datenreplikation (DE-588)4742677-9 gnd Sicherungskopie (DE-588)4513560-5 gnd Benchmark (DE-588)4144457-7 gnd
subject_GND	(DE-588)4559381-4 (DE-588)4323960-2 (DE-588)4742677-9 (DE-588)4513560-5 (DE-588)4144457-7
title	High performance MySQL [optimization, backups, and replication ; covers version 5.5]
title_auth	High performance MySQL [optimization, backups, and replication ; covers version 5.5]
title_exact_search	High performance MySQL [optimization, backups, and replication ; covers version 5.5]
title_full	High performance MySQL [optimization, backups, and replication ; covers version 5.5] Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko
title_fullStr	High performance MySQL [optimization, backups, and replication ; covers version 5.5] Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko
title_full_unstemmed	High performance MySQL [optimization, backups, and replication ; covers version 5.5] Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko
title_short	High performance MySQL
title_sort	high performance mysql optimization backups and replication covers version 5 5
title_sub	[optimization, backups, and replication ; covers version 5.5]
topic	MySQL (DE-588)4559381-4 gnd Lastteilung (DE-588)4323960-2 gnd Datenreplikation (DE-588)4742677-9 gnd Sicherungskopie (DE-588)4513560-5 gnd Benchmark (DE-588)4144457-7 gnd
topic_facet	MySQL Lastteilung Datenreplikation Sicherungskopie Benchmark
url	http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025002029&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA
work_keys_str_mv	AT schwartzbaron highperformancemysqloptimizationbackupsandreplicationcoversversion55 AT zaitsevpeter highperformancemysqloptimizationbackupsandreplicationcoversversion55 AT tkacenkovadimp highperformancemysqloptimizationbackupsandreplicationcoversversion55

Verfügbarkeit

Es ist kein Print-Exemplar vorhanden.

Fernleihe Bestellen Achtung: Nicht im THWS-Bestand! Inhaltsverzeichnis

MARC

Datensatz im Suchindex

Es ist kein Print-Exemplar vorhanden.

Ähnliche Einträge