MySQL Concurrency
Locking and Transactions for MySQL Developers and DBAs
| Price | $49.02 - $49.98
|
| Rating |   |
| Author | Jesper Wisborg Krogh |
| Publisher | Apress |
| Published | 2021 |
| Pages | 376 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 148426651X |
| ISBN-13 | 9781484266519 |
Know how locks work in MySQL and how they relate to transactions. This book explains the major role that locks play in database systems, showing how locks are essential in allowing high-concurrency workloads. You will learn about lock access levels and lock granularities from the user level as well as table locks to record and gap locks. Most importantly, the book covers troubleshooting techniques when locking becomes a pain point.
Several of the lock types in MySQL have a duration of a transaction. For this reason, it is important to understand how transactions work. This book covers the basics of transactions as well as transaction isolation levels and how they affect locking. The book is meant to be your go-to resource for solving locking contention and similar problems in high-performance MySQL database applications.
Detecting locking issues when they occur is the first key to resolving such issues. MySQL Concurrency provides techniques for detecting locking issues such as contention. The book shows how to analyze locks that are causing contention to see why those locks are in place. A collection of six comprehensive case studies combine locking and transactional theory with realistic lock conflicts. The case studies walk you through the symptoms to look for in order to identify which issue you are facing, the cause of the conflict, its analysis, solution, and how to prevent the issue in the future.
- Jesper Wisborg Krogh (3 books)
4 5 2
Similar Books
by Alexander Pachev
With more than three million users, MySQL is the most popular open-source database server in the world, providing an extremely fast, reliable, and inexpensive alternative to commercial database management systems. Gives corporate users a complete guide to building enterprise-level database applications with MySQL. Covers the pros and cons...
Price: $42.98 | Publisher: Wiley | Release: 2003
by Sasha Pachev
Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. This book provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner-workings of this powerful database. You'll learn how data structures and convenience fun...
Price: $32.11 | Publisher: O'Reilly Media | Release: 2007
MySQL Stored Procedure Programming
by Guy Harrison, Steven Feuerstein
MySQL Stored Procedure Programming covers a lot of ground. The book starts with a thorough introduction to stored procedures programming and functions, covering the fundamentals of data types, operators, and using SQL in stored procedures. You'll learn how to build and maintain stored programs -- covering transactions, stored functio...
Price: $6.38 | Publisher: O'Reilly Media | Release: 2006
MySQL in a Nutshell, 2nd Edition
by Russell Dyer
When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or statement at the right moment are pre...
Price: $5.20 | Publisher: O'Reilly Media | Release: 2008
PHP & MySQL: The Missing Manual
by Brett McLaughlin
If you can build websites with CSS and JavaScript, this book takes you to the next level-creating dynamic, database-driven websites with PHP and MySQL. Learn how to build a database, manage your content, and interact with users through queries and web forms. With step-by-step tutorials, real-world examples, and jargon-free explanations, y...
Price: $4.22 | Publisher: O'Reilly Media | Release: 2011
PHP and MySQL Web Development, 4th Edition
by Luke Welling, Laura Thomson
PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Int...
Price: $5.96 | Publisher: Addison-Wesley | Release: 2008
by Andrea Tarr
Assuming no previous experience with PHP or MySQL, this book is ideal reading for anyone who wants to go beyond HTML / CSS in order to provide clients with the most dynamic web sites possible. The approachable tone breaks down the basics of programming and PHP and MySQL in individual lessons starting with the installation of the programs ...
Price: $19.99 | Publisher: Wrox | Release: 2011
Learning PHP, MySQL, JavaScript, and CSS, 2nd Edition
by Robin Nixon
Learn how to build interactive, data-driven websites - even if you don't have any previous programming experience. If you know how to build static sites with HTML, this popular guide will help you tackle dynamic web programming. You'll get a thorough grounding in today's core open source technologies: PHP, MySQL, JavaScript...
Price: $25.00 | Publisher: O'Reilly Media | Release: 2012