Sorry, there is a mistake in the question. An explanation has been made in the answer the scenario is that there is a script task, that starts multiple processes these processes operate on multiple tables at the same time (only insert, for these t...
under the premise that the created_at column is indexed. the data volume of the table is tens of millions of levels. explain shows that the number of rows scanned is 2 million select count (*) from users where created_at < 2018-08-28 0000lv 00l...
I recently did a raffle everyone can only draw once I want to insert a record for each lucky draw request, and then read the first record for comparison to determine whether he is drawing the lottery for the first time, delete the useless record if n...
Note that our current isolation level is read uncommitted, that is, the lowest isolation level. Dirty reading occurs at this level, and A transaction modifies a row of data, but in the case of uncommitted, this row of data is read by a behavior other th...
What is the automatic locking strategy for InnoDB and Myisam in RT,MySQL, respectively? When do we need to explicitly add read-write locks? ...
what is the locking mechanism of mysql transaction serialization isolation level Open transactions in both An and B clients, if 1 if A transaction deletes a record (), B transaction cannot read deleted and uncommitted transactions in A transaction not...
as shown in the question, is there only data or indexes on the hard disk and in a data page in innodb_pool_buffer? is it impossible for a data page to have both data and indexes? ...
such as the title. see that MySQL generates a tree for the primary key, and the leaf node holds the row data corresponding to the primary key. The secondary index leaf node holds the value of the primary key. excuse me: does the leaf node of th...
I use only one primary key on the innodb, table and a clustered index (the default is a clustered index). In my query statement, the where condition is this primary key, but the query column is arbitrary. I found that the extra of the execution plan is ...