Yesterday built MySQL5.5 source debug environment, while the iron is hot, build MySQL5.7 environment, mainly marked some different parts with 5.5 build
Table level lock, overhead, lock fast, will not appear deadlock. The granularity of locks is large. The concurrency is low. Row-level lock, low overhead, slow...
Takeaway: Data bus (DBus) focuses on real-time data collection and distribution. IT can aggregate the data generated by IT systems in business processes and convert...
This paper describes the basic concept of relational database, and the SQL statements derived from set relational algebra, including a variety of join operations and...
A, what is MVCC MVCC, the full name of Multi - VersionConcurrencyControl, namely Multi version concurrency control. Second, why do you need MVCC to understand...
Multiple programs access MySQL tables or records, there will be race conditions, to solve this problem, we proposed the lock. Table level locking is implemented...
MySQL is a popular open source database. In the development process, we often use read and write separation, separate libraries and tables, and distinguish development...
Locking is the mechanism by which computer programs run to coordinate concurrent access to the same data resource. For database system, data is a kind...
As a first step, you will connect to the database, and your connector will receive you. Connectors establish connections to clients, obtain permissions, and maintain...
The premise for all of this article is that MySQL's storage engine is Innodb. We know that MySql's default transaction isolation level is RR (repeatable...
You're probably familiar with transactions, and when you're dealing with databases, you're going to use transactions all the time. The most classic example is transfer...
Summary of mysql transactions and locking mechanism. Add, delete, modify, and check the same batch of data in mysql. This will cause dirty read, dirty...
We have mastered the use of SELECT statement combined with WHERE query conditions to obtain the required data, but in the practical application will also...
I have recently studied chapter 1 of High Performance MySQL and learned the concept of transaction isolation levels. I feel that this part is easier...