• Complain

Jesper Wisborg Krogh - My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs

Here you can read online Jesper Wisborg Krogh - My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. publisher: Apress, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

Jesper Wisborg Krogh My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs
  • Book:
    My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs
  • Author:
  • Publisher:
    Apress
  • Genre:
  • Rating:
    3 / 5
  • Favourites:
    Add to favourites
  • Your mark:
    • 60
    • 1
    • 2
    • 3
    • 4
    • 5

My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

Jesper Wisborg Krogh: author's other books


Who wrote My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs? Find out the surname, the name of the author of the book and a list of all author's works by series.

My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

Reset

Interval:

Bookmark:

Make
Contents
Landmarks
Book cover of MySQL Concurrency Jesper Wisborg Krogh MySQL Concurrency - photo 1
Book cover of MySQL Concurrency
Jesper Wisborg Krogh
MySQL Concurrency
Locking and Transactions for MySQL Developers and DBAs
1st ed.
Logo of the publisher Jesper Wisborg Krogh Hornsby NSW Australia Any - photo 2
Logo of the publisher
Jesper Wisborg Krogh
Hornsby, NSW, Australia

Any source code or other supplementary material referenced by the author in this book is available to readers on GitHub via the books product page, located at www.apress.com/9781484266519 . For more detailed information, please visit http://www.apress.com/source-code .

ISBN 978-1-4842-6651-9 e-ISBN 978-1-4842-6652-6
https://doi.org/10.1007/978-1-4842-6652-6
Jesper Wisborg Krogh 2021
This work is subject to copyright. All rights are reserved by the Publisher, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or hereafter developed.
The use of general descriptive names, registered names, trademarks, service marks, etc. in this publication does not imply, even in the absence of a specific statement, that such names are exempt from the relevant protective laws and regulations and therefore free for general use.
The publisher, the authors and the editors are safe to assume that the advice and information in this book are believed to be true and accurate at the date of publication. Neither the publisher nor the authors or the editors give a warranty, expressed or implied, with respect to the material contained herein or for any errors or omissions that may have been made. The publisher remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.
Distributed to the book trade worldwide by Springer Science+Business Media LLC, 1 New York Plaza, Suite 4600, New York, NY 10004. Phone 1-800-SPRINGER, fax (201) 348-4505, e-mail orders-ny@springer-sbm.com, or visit www.springeronline.com. Apress Media, LLC is a California LLC and the sole member (owner) is Springer Science + Business Media Finance Inc (SSBM Finance Inc). SSBM Finance Inc is a Delaware corporation.

To my wife Ann-Margrete Thanks for the patience and support.

Introduction

When working with databases, locks and transactions are some of the most difficult and misunderstood topics. This book aims at improving your understanding of these two concepts, how they work, how you can investigate them, and how you can improve your workload, so it works the best with them. This is achieved through a combination of discussing monitoring, the lock and transaction theory, and a series of case studies.

MySQL is famous for its support for storage engines. However, this book exclusively covers the InnoDB storage engine, and only MySQL 8 is considered. That said, most of the discussion also applies to older versions of MySQL, and in general, it is mentioned when a feature is new in MySQL 8 or that MySQL 8 has a different behavior compared to older versions.

Book Audience

The book has been written for developers and database administrators who have experience working with MySQL and want to expand their knowledge of how locks and transactions work in the realm of MySQL concurrency.

Examples and the Books GitHub Repository

I have tried to add as many examples and outputs from examples as possible. Some of the examples are quite short, some are quite long. In either case, I hope you are able to follow them and reproduce the effect or result demonstrated. At the same time, please do bear in mind that by nature there is often randomness involved, and the exact outcome of the examples may depend on how the tables and data have been used prior to the example. In other words, you may get different results even if you did everything right. This particularly applies to numbers that relate to lock ids, memory locations, mutexes/semaphores, timings, and the like.

Examples that are long or produce outputs that are either long or wide have been added to this books GitHub repository. This includes some of the figures that may be hard to read with the image size that the page format allows.

Note

The link to the repository can be found from the books home page at www.apress.com/gp/book/9781484266519 . It can also be found directly at www.github.com/Apress/mysql-concurrency .

To make it easier to reproduce the examples and to provide example queries that can be used to examine the issue the test demonstrates, a module written in Python for use in MySQL Shell is also included in the books GitHub repository. The basic installation and usage instructions are covered in Chapter and the full documentation in Appendix B.

The GitHub repository will also be the home of the errata for the book once that is created. I will use the errata not only to communicate errors in the book but also to provide updates when bug fixes and new features in MySQL 8 cause changes to book content. If necessary, I will also update the examples in the repository to reflect the behavior in the newer releases. For these reasons, I recommend that you keep an eye on the repository.

Book Structure

I have attempted to keep each chapter relatively self-contained with the aim that you can use the book as a reference book. The drawback of this choice is that there is some duplication of information from time to time. This is particularly evident in the case studies that repeat some of the information discussed in earlier chapters. This was a deliberate choice, and I hope it helps you to reduce the amount of page flipping to find the information you need.

The book is divided into 18 chapters and two appendixes. Chapter go through six case studies. The appendixes contain references for monitoring locks and transactions and for the MySQL Shell module provided with the book.
  • Chapter, Introduction: This introductory chapter covers some high-level concepts as well as introduces the MySQL Shell module for reproducing the example and the test data used in this book.

  • Chapter, Monitoring Locks: This chapter covers how you can monitor locks using the Performance Schema, the sys schema, status counters, and InnoDB metrics. There is also information on how to use the InnoDB lock monitor and the deadlock information in the InnoDB monitor and how to obtain information about mutex and semaphore contention.

  • Chapter, Monitoring InnoDB Transactions: This chapter primarily shows how you can use the information_schema.INNODB_TRX view to investigate InnoDB transaction. The transaction list in the InnoDB monitor and transaction-related InnoDB metrics are also covered.

  • Chapter, Transactions in the Performance Schema: This chapter continues where the previous stopped by going through the transaction information in the Performance Schema and how you can find the statements for a transaction.

  • Chapter, Lock Access Levels:

Next page
Light

Font size:

Reset

Interval:

Bookmark:

Make

Similar books «My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs»

Look at similar books to My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


Reviews about «My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs»

Discussion, reviews of the book My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.