Efficient MySQL performance : best practices and techniques
Description
Loading Description...
More Details
Format
Language
English
ISBN
9781098105044, 1098105044, 9781098105068, 1098105060
Notes
General Note
Includes index.
Description
You'll find several books on basic or advanced MySQL performance, but nothing in between. That's because explaining MySQL performance without addressing its complexity is difficult. This practical book bridges the gap by teaching software engineers mid-level MySQL knowledge beyond the fundamentals, but well shy of deep-level internals required by database administrators (DBAs). Daniel Nichter shows you how to apply the best practices and techniques that directly affect MySQL performance. You'll learn how to improve performance by analyzing query execution, indexing for common SQL clauses and table joins, optimizing data access, and understanding the most important MySQL metrics. You'll also discover how replication, transactions, row locking, and the cloud influenceMySQL performance. Understand why query response time is the North Star of MySQL performance Learn query metrics in detail, including aggregation, reporting, and analysis See how to index effectively for common SQL clauses and table joins Explore the most important server metrics and what they reveal about performance Dive into transactions and row locking to gain deep, actionable insight Achieve remarkable MySQL performance at any scale.
Local note
O'Reilly,O'Reilly Online Learning: Academic/Public Library Edition
Subjects
LC Subjects
Also in this Series
Checking series information...
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Nichter, D. (2021). Efficient MySQL performance: best practices and techniques . O'Reilly Media, Inc..
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Nichter, Daniel. 2021. Efficient MySQL Performance: Best Practices and Techniques. O'Reilly Media, Inc.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Nichter, Daniel. Efficient MySQL Performance: Best Practices and Techniques O'Reilly Media, Inc, 2021.
MLA Citation, 9th Edition (style guide)Nichter, Daniel. Efficient MySQL Performance: Best Practices and Techniques O'Reilly Media, Inc., 2021.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
6a5bf79d-3627-11f3-d648-c474fd3e2e42-eng
Grouping Information
| Grouped Work ID | 6a5bf79d-3627-11f3-d648-c474fd3e2e42-eng |
|---|---|
| Full title | efficient mysql performance best practices and techniques |
| Author | nichter daniel |
| Grouping Category | book |
| Last Update | 2024-05-09 03:20:59AM |
| Last Indexed | 2024-05-21 02:42:14AM |
Book Cover Information
| Image Source | contentCafe |
|---|---|
| First Loaded | May 4, 2023 |
| Last Used | Dec 25, 2023 |
Marc Record
| First Detected | Mar 20, 2023 10:15:05 AM |
|---|---|
| Last File Modification Time | Mar 20, 2023 10:15:05 AM |
| Suppressed | Record had no items |
MARC Record
| LEADER | 03619cam a2200517 i 4500 | ||
|---|---|---|---|
| 001 | on1289799198 | ||
| 003 | OCoLC | ||
| 005 | 20230320101424.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 211019s2022 cau fo 001 0 eng d | ||
| 019 | |a 1287956760|a 1287992654|a 1288026739|a 1288137394|a 1288140788|a 1290679953 | ||
| 020 | |a 9781098105044|q (electronic book) | ||
| 020 | |a 1098105044|q (electronic book) | ||
| 020 | |a 9781098105068|q (electronic book) | ||
| 020 | |a 1098105060|q (electronic book) | ||
| 035 | |a (OCoLC)1289799198|z (OCoLC)1287956760|z (OCoLC)1287992654|z (OCoLC)1288026739|z (OCoLC)1288137394|z (OCoLC)1288140788|z (OCoLC)1290679953 | ||
| 037 | |a 9781098105082|b O'Reilly Media | ||
| 037 | |a 898408A0-A3FC-48D2-B65A-242D4A32F978|b OverDrive, Inc.|n http://www.overdrive.com | ||
| 040 | |a UKAHL|b eng|e rda|e pn|c UKAHL|d ORMDA|d OCLCO|d OCLCF|d YDX|d STF|d YDXIT|d N$T|d UKAHL|d YDX|d OCLCQ|d TEFOD|d NLHHG|d OCLCQ|d HRM | ||
| 049 | |a MAIN | ||
| 050 | 4 | |a QA76.73.S67|b N53 2022 | |
| 082 | 0 | 4 | |a 005.75/85|2 23 |
| 100 | 1 | |a Nichter, Daniel,|e author. | |
| 245 | 1 | 0 | |a Efficient MySQL performance :|b best practices and techniques /|c Daniel Nichter. |
| 264 | 1 | |a Sebastopol, CA :|b O'Reilly Media, Inc.,|c 2021 | |
| 264 | 4 | |c ©2022 | |
| 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 | ||
| 500 | |a Includes index. | ||
| 505 | 0 | |a Query Response Time -- Indexes and Indexing -- Data -- Access Patterns -- Sharding -- Server Metrics -- Replication Lag -- Transactions -- Other Challenges -- MySQL in the Cloud -- Index. | |
| 520 | |a You'll find several books on basic or advanced MySQL performance, but nothing in between. That's because explaining MySQL performance without addressing its complexity is difficult. This practical book bridges the gap by teaching software engineers mid-level MySQL knowledge beyond the fundamentals, but well shy of deep-level internals required by database administrators (DBAs). Daniel Nichter shows you how to apply the best practices and techniques that directly affect MySQL performance. You'll learn how to improve performance by analyzing query execution, indexing for common SQL clauses and table joins, optimizing data access, and understanding the most important MySQL metrics. You'll also discover how replication, transactions, row locking, and the cloud influenceMySQL performance. Understand why query response time is the North Star of MySQL performance Learn query metrics in detail, including aggregation, reporting, and analysis See how to index effectively for common SQL clauses and table joins Explore the most important server metrics and what they reveal about performance Dive into transactions and row locking to gain deep, actionable insight Achieve remarkable MySQL performance at any scale. | ||
| 590 | |a O'Reilly|b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a MySQL (Electronic resource)|9 21171 |
| 630 | 0 | 7 | |a MySQL (Electronic resource)|2 fast|0 (OCoLC)fst01395715|9 21171 |
| 776 | 0 | 8 | |i Print version:|z 1098105095|z 9781098105099|w (OCoLC)1266362986 |
| 856 | 4 | 0 | |u https://library.access.arlingtonva.us/login?url=https://learning.oreilly.com/library/view/~/9781098105082/?ar|x O'Reilly|z eBook |
| 938 | |a Askews and Holts Library Services|b ASKH|n AH39675504 | ||
| 938 | |a Askews and Holts Library Services|b ASKH|n AH39547633 | ||
| 938 | |a EBSCOhost|b EBSC|n 3114441 | ||
| 938 | |a YBP Library Services|b YANK|n 302627058 | ||
| 938 | |a YBP Library Services|b YANK|n 17760523 | ||
| 994 | |a 92|b VIA | ||
| 999 | |c 283267|d 283267 | ||