In order to solve the concurrency problem, many locks are introduced in MySQL database. Most of the time, database locks are automatically added during database...
Some articles say timestamp does not exist time zone problem, and some other articles say sometimes zone problem, timestamp in the end does not exist...
For Internet companies, with the increasing number of users and data, slow query is an inevitable problem. In general, slow query indicates that the interface...
During recent code review, I had an argument with my classmates about the performance of an SQL statement. The advantage of programmers is that everyone...
Transaction isolation is one of the foundations of database processing. Isolation is the I in the abbreviation ACID; The isolation level is a setting used...
Mysql lock mechanism: global lock, table lock, row lock, optimistic lock principle, pessimistic lock principle. And the use of lock scenarios and precautions
MySQL advanced course Introduction Day01 Day02 Day03 Day04 1 Linux installation MySQL architecture application optimization MySQL common tools 2 Index storage engine query cache optimization...
Remember in college that will start at the university of classroom, will often hear the teacher speak what Shared locks, exclusive locks the vocabulary of...
Optimistic and pessimistic locks of MySQL are used according to business scenarios. Use locks for each service scenario. But both types of locks solve concurrency...
In production environments, databases are backed up periodically to avoid data loss. The Crontab command of Linux can help us to periodically back up the...
Table structure field type Source int mysql automatic conversion summary Because of the implicit conversion of mysql string parameters to 0, and then query the...
This is the lowest transaction isolation, AB two transactions, A transaction executes, modify the data, but did not submit data, then B transaction querying data,...
MySQL InnoDB implements MVCC based on ReadView (consistency snapshot) to achieve non-locked read, greatly improving database concurrency. Meanwhile, InnoDB implements committed and repeatable reads based...
> Last week, did a synchronous delete function, the specific process is, database delete --> call the third party run delete interface, synchronous delete. ####...
1. Concept Introduction Redo logs are used to repair and correct fault recovery data and ensure transaction persistence. To achieve persistence innoDB needs to flush...
MVCC mechanism is an important mechanism for mysql to solve transaction problems. Through this mechanism, mysql solves the problems about transaction: dirty write, dirty read,...
This series of articles is an introduction to some of the lesser-known but important MySQL knowledge I encountered during the development of the game server....