High performance MySQL: [optimization, backups, replication, and more]
Gespeichert in:
| Format: | Buch |
|---|---|
| Sprache: | English |
| Veröffentlicht: |
Beijing [u.a.]
O'Reilly
2008
|
| Ausgabe: | 2. ed., covers version 5.1 |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | 1. Aufl. u.d.T.: Zawodny, Jeremy D.: High performance MySQL |
| Beschreibung: | XXII, 684 S. graph. Darst. |
| ISBN: | 9780596101718 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV023480684 | ||
| 003 | DE-604 | ||
| 005 | 20091127 | ||
| 007 | t | ||
| 008 | 080807s2008 d||| |||| 00||| eng d | ||
| 020 | |a 9780596101718 |9 978-0-596-10171-8 | ||
| 035 | |a (OCoLC)438959425 | ||
| 035 | |a (DE-599)BVBBV023480684 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-355 |a DE-1051 |a DE-573 |a DE-91 |a DE-861 | ||
| 080 | |a 004.43 | ||
| 082 | 0 | |a 005.7565 |2 22 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 084 | |a DAT 663f |2 stub | ||
| 245 | 1 | 0 | |a High performance MySQL |b [optimization, backups, replication, and more] |c Baron Schwartz ... |
| 250 | |a 2. ed., covers version 5.1 | ||
| 264 | 1 | |a Beijing [u.a.] |b O'Reilly |c 2008 | |
| 300 | |a XXII, 684 S. |b graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a 1. Aufl. u.d.T.: Zawodny, Jeremy D.: High performance MySQL | ||
| 630 | 0 | 4 | |a MySQL (Electronic resource) |
| 650 | 0 | 7 | |a Benchmark |0 (DE-588)4144457-7 |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 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 |
| 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 Schwartz, Baron |e Sonstige |4 oth | |
| 856 | 4 | 2 | |m Digitalisierung UB Passau |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016662848&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-016662848 | ||
Datensatz im Suchindex
| _version_ | 1804137906765299712 |
|---|---|
| adam_text | Table of
Contents
Foreword
................................................................ix
Preface
.................................................................xi
1.
MySQL Architecture
................................................. 1
MySQL s Logical Architecture
1
Concurrency Control
3
Transactions
6
Multiversion Concurrency Control
12
MySQL s Storage Engines
14
2.
Finding Bottlenecks: Benchmarking and Profiling
.....................32
Why Benchmark?
33
Benchmarking Strategies
33
Benchmarking Tactics
37
Benchmarking Tools
42
Benchmarking Examples
45
Profiling
54
Operating System Profiling
76
3.
Schema Optimization and Indexing
..................................80
Choosing Optimal Data Types
80
Indexing Basics
96
Indexing Strategies for High Performance
106
An Indexing Case Study
131
Index and Table Maintenance
136
Normalization and Denormalization
139
Speeding Up ALTER TABLE
146
Notes on Storage Engines
149
4.
Query Performance Optimization
...................................152
Slow Query Basics: Optimize Data Access
152
Ways to Restructure Queries
157
Query Execution Basics
160
Limitations of the MySQL Query Optimizer
179
Optimizing Specific Types of Queries
188
Query Optimizer Hints
195
User-Defined Variables
198
5.
Advanced MySQL Features
.........................................204
The MySQL Query Cache
204
Storing Code Inside MySQL
216
Cursors
224
Prepared Statements
225
User-Defined Functions
229
Views
231
Character Sets and Collations
236
Full-Text Searching
243
Foreign Key Constraints
252
Merge Tables and Partitioning
253
Distributed (XA) Transactions
262
6.
Optimizing Server Settings
........................................265
Configuration Basics
266
General Tuning
271
Tuning MySQL s I/O Behavior
281
Tuning MySQL Concurrency
295
Workload-Based Tuning
298
Tuning Per-Connection Settings
304
7.
Operating System and Hardware Optimization
.......................305
What Limits MySQL s Performance?
306
How to Select CPUs for MySQL
306
Balancing Memory and Disk Resources
309
Choosing Hardware for a Slave
317
RAID Performance Optimization
317
Storage Area Networks and Network-Attached Storage
325
Using Multiple Disk Volumes
326
Network Configuration
328
Choosing an Operating System
330
Choosing
a Filesystem
331
Threading
334
Swapping
334
Operating System Status
336
8.
Replication
......................................................343
Replication Overview
343
Setting Up Replication
347
Replication Under the Hood
355
Replication Topologies
362
Replication and Capacity Planning
376
Replication Administration and Maintenance
378
Replication Problems and Solutions
387
How Fast Is Replication?
405
The Future of MySQL Replication
407
9.
Scaling and High Availability
.......................................409
Terminology
410
Scaling MySQL
412
Load Balancing
436
High Availability
447
10.
Application-Level Optimization
.....................................457
Application Performance Overview
457
Web Server Issues
460
Caching
463
Extending MySQL
470
Alternatives to MySQL
471
11.
Backup and Recovery
.............................................472
Overview
473
Considerations and Tradeoffs
477
Managing and Backing Up Binary Logs
486
Backing Up Data
488
Recovering from a Backup
499
Backup and Recovery Speed
510
Backup Tools
511
Scripting Backups
518
12.
Security
.........................................................521
Terminology
521
Account Basics
522
Operating System Security
541
Network Security
542
Data Encryption
550
MySQL in a chrooted Environment
554
13.
MySQL Server Status
..............................................557
System Variables
557
SHOW STATUS
558
SHOW INNODB STATUS
565
SHOW
PROCESSLIST
578
SHOW MUTEX STATUS
579
Replication Status
580
INFORMATIONLSCHEMA
581
14.
Tools for High Performance
........................................583
Interface Tools
583
Monitoring Tools
585
Analysis Tools
595
MySQL Utilities
598
Sources of Further Information
601
A. Transferring Large Files
............................................603
B. Using EXPLAIN
...................................................607
С
Using Sphinx with MySQL
..........................................623
D. Debugging Locks
.................................................650
Index
.................................................................659
|
| adam_txt |
Table of
Contents
Foreword
.ix
Preface
.xi
1.
MySQL Architecture
. 1
MySQL's Logical Architecture
1
Concurrency Control
3
Transactions
6
Multiversion Concurrency Control
12
MySQL's Storage Engines
14
2.
Finding Bottlenecks: Benchmarking and Profiling
.32
Why Benchmark?
33
Benchmarking Strategies
33
Benchmarking Tactics
37
Benchmarking Tools
42
Benchmarking Examples
45
Profiling
54
Operating System Profiling
76
3.
Schema Optimization and Indexing
.80
Choosing Optimal Data Types
80
Indexing Basics
96
Indexing Strategies for High Performance
106
An Indexing Case Study
131
Index and Table Maintenance
136
Normalization and Denormalization
139
Speeding Up ALTER TABLE
146
Notes on Storage Engines
149
4.
Query Performance Optimization
.152
Slow Query Basics: Optimize Data Access
152
Ways to Restructure Queries
157
Query Execution Basics
160
Limitations of the MySQL Query Optimizer
179
Optimizing Specific Types of Queries
188
Query Optimizer Hints
195
User-Defined Variables
198
5.
Advanced MySQL Features
.204
The MySQL Query Cache
204
Storing Code Inside MySQL
216
Cursors
224
Prepared Statements
225
User-Defined Functions
229
Views
231
Character Sets and Collations
236
Full-Text Searching
243
Foreign Key Constraints
252
Merge Tables and Partitioning
253
Distributed (XA) Transactions
262
6.
Optimizing Server Settings
.265
Configuration Basics
266
General Tuning
271
Tuning MySQL's I/O Behavior
281
Tuning MySQL Concurrency
295
Workload-Based Tuning
298
Tuning Per-Connection Settings
304
7.
Operating System and Hardware Optimization
.305
What Limits MySQL's Performance?
306
How to Select CPUs for MySQL
306
Balancing Memory and Disk Resources
309
Choosing Hardware for a Slave
317
RAID Performance Optimization
317
Storage Area Networks and Network-Attached Storage
325
Using Multiple Disk Volumes
326
Network Configuration
328
Choosing an Operating System
330
Choosing
a Filesystem
331
Threading
334
Swapping
334
Operating System Status
336
8.
Replication
.343
Replication Overview
343
Setting Up Replication
347
Replication Under the Hood
355
Replication Topologies
362
Replication and Capacity Planning
376
Replication Administration and Maintenance
378
Replication Problems and Solutions
387
How Fast Is Replication?
405
The Future of MySQL Replication
407
9.
Scaling and High Availability
.409
Terminology
410
Scaling MySQL
412
Load Balancing
436
High Availability
447
10.
Application-Level Optimization
.457
Application Performance Overview
457
Web Server Issues
460
Caching
463
Extending MySQL
470
Alternatives to MySQL
471
11.
Backup and Recovery
.472
Overview
473
Considerations and Tradeoffs
477
Managing and Backing Up Binary Logs
486
Backing Up Data
488
Recovering from a Backup
499
Backup and Recovery Speed
510
Backup Tools
511
Scripting Backups
518
12.
Security
.521
Terminology
521
Account Basics
522
Operating System Security
541
Network Security
542
Data Encryption
550
MySQL in a chrooted Environment
554
13.
MySQL Server Status
.557
System Variables
557
SHOW STATUS
558
SHOW INNODB STATUS
565
SHOW
PROCESSLIST
578
SHOW MUTEX STATUS
579
Replication Status
580
INFORMATIONLSCHEMA
581
14.
Tools for High Performance
.583
Interface Tools
583
Monitoring Tools
585
Analysis Tools
595
MySQL Utilities
598
Sources of Further Information
601
A. Transferring Large Files
.603
B. Using EXPLAIN
.607
С
Using Sphinx with MySQL
.623
D. Debugging Locks
.650
Index
.659 |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| building | Verbundindex |
| bvnumber | BV023480684 |
| classification_rvk | ST 271 |
| classification_tum | DAT 663f |
| ctrlnum | (OCoLC)438959425 (DE-599)BVBBV023480684 |
| dewey-full | 005.7565 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7565 |
| dewey-search | 005.7565 |
| dewey-sort | 15.7565 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| discipline_str_mv | Informatik |
| edition | 2. ed., covers version 5.1 |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01980nam a2200505 c 4500</leader><controlfield tag="001">BV023480684</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20091127 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">080807s2008 d||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780596101718</subfield><subfield code="9">978-0-596-10171-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)438959425</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV023480684</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-355</subfield><subfield code="a">DE-1051</subfield><subfield code="a">DE-573</subfield><subfield code="a">DE-91</subfield><subfield code="a">DE-861</subfield></datafield><datafield tag="080" ind1=" " ind2=" "><subfield code="a">004.43</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.7565</subfield><subfield code="2">22</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">DAT 663f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">High performance MySQL</subfield><subfield code="b">[optimization, backups, replication, and more]</subfield><subfield code="c">Baron Schwartz ...</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2. ed., covers version 5.1</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing [u.a.]</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2008</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXII, 684 S.</subfield><subfield code="b">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">1. Aufl. u.d.T.: Zawodny, Jeremy D.: High performance MySQL</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">MySQL (Electronic resource)</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="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">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="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">Schwartz, Baron</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Passau</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=016662848&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-016662848</subfield></datafield></record></collection> |
| id | DE-604.BV023480684 |
| illustrated | Illustrated |
| index_date | 2024-07-02T21:37:51Z |
| indexdate | 2024-07-09T21:19:44Z |
| institution | BVB |
| isbn | 9780596101718 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-016662848 |
| oclc_num | 438959425 |
| open_access_boolean | |
| owner | DE-355 DE-BY-UBR DE-1051 DE-573 DE-91 DE-BY-TUM DE-861 |
| owner_facet | DE-355 DE-BY-UBR DE-1051 DE-573 DE-91 DE-BY-TUM DE-861 |
| physical | XXII, 684 S. graph. Darst. |
| publishDate | 2008 |
| publishDateSearch | 2008 |
| publishDateSort | 2008 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | High performance MySQL [optimization, backups, replication, and more] Baron Schwartz ... 2. ed., covers version 5.1 Beijing [u.a.] O'Reilly 2008 XXII, 684 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier 1. Aufl. u.d.T.: Zawodny, Jeremy D.: High performance MySQL MySQL (Electronic resource) Benchmark (DE-588)4144457-7 gnd rswk-swf Datenreplikation (DE-588)4742677-9 gnd rswk-swf Sicherungskopie (DE-588)4513560-5 gnd rswk-swf MySQL (DE-588)4559381-4 gnd rswk-swf Lastteilung (DE-588)4323960-2 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 Schwartz, Baron Sonstige oth Digitalisierung UB Passau application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016662848&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | High performance MySQL [optimization, backups, replication, and more] MySQL (Electronic resource) Benchmark (DE-588)4144457-7 gnd Datenreplikation (DE-588)4742677-9 gnd Sicherungskopie (DE-588)4513560-5 gnd MySQL (DE-588)4559381-4 gnd Lastteilung (DE-588)4323960-2 gnd |
| subject_GND | (DE-588)4144457-7 (DE-588)4742677-9 (DE-588)4513560-5 (DE-588)4559381-4 (DE-588)4323960-2 |
| title | High performance MySQL [optimization, backups, replication, and more] |
| title_auth | High performance MySQL [optimization, backups, replication, and more] |
| title_exact_search | High performance MySQL [optimization, backups, replication, and more] |
| title_exact_search_txtP | High performance MySQL [optimization, backups, replication, and more] |
| title_full | High performance MySQL [optimization, backups, replication, and more] Baron Schwartz ... |
| title_fullStr | High performance MySQL [optimization, backups, replication, and more] Baron Schwartz ... |
| title_full_unstemmed | High performance MySQL [optimization, backups, replication, and more] Baron Schwartz ... |
| title_short | High performance MySQL |
| title_sort | high performance mysql optimization backups replication and more |
| title_sub | [optimization, backups, replication, and more] |
| topic | MySQL (Electronic resource) Benchmark (DE-588)4144457-7 gnd Datenreplikation (DE-588)4742677-9 gnd Sicherungskopie (DE-588)4513560-5 gnd MySQL (DE-588)4559381-4 gnd Lastteilung (DE-588)4323960-2 gnd |
| topic_facet | MySQL (Electronic resource) Benchmark Datenreplikation Sicherungskopie MySQL Lastteilung |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016662848&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT schwartzbaron highperformancemysqloptimizationbackupsreplicationandmore |