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?
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?
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 ...
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...
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...
What is the automatic locking strategy for InnoDB and Myisam in RT,MySQL, respectively? When do we need to explicitly add read-write locks? ...
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...
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...