Intermediate-Advanced user level
My SQL Concurrency: Locking and Transactions for MySQL Developers and DBAs
β Scribed by Jesper Wisborg Krogh
- Publisher
- Apress
- Tongue
- English
- Category
- Library
No coin nor oath required. For personal study only.
π SIMILAR VOLUMES
Master SQL Serverβs Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurre
Master SQL Serverβs Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurre
If you've designed your SQL code intelligently, and implemented a sensible indexing strategy, there's a good chance your queries will "fly", when tested in isolation. In the real world, however, where multiple processes can access the same data at the same time, SQL Server often has to make one proc
Your application can have impeachable indexes and queries, but they wont help you if you cant get to your data because another application has it locked. Thats why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. If youve desi
This book teaches you how to use MySQL and mSQL, two popular and robust database products that support key subsets of SQL on both Linux and Unix systems. Unlike commercial databases, mSQL and MySQL are affordable and easy to use. Both are free for nonprofit use and cost a small amount for commerc