1. Database storage structure: page The index structure provides us with an efficient indexing method, but the index information and data records are stored in the file, or in the page structure to be precise. On the other hand, indexes are implemented in the storage engine. The storage engine on the MySQL server is responsible […]
Tag: innodb
MySQL InnoDB storage engine uses B+ tree for indexing instead of B tree
Table of Contents MySQL InnoDB storage engine uses B + tree for indexing instead of B tree Introduction to B-Tree and B+Tree Why Choose B+Tree Application scenarios of B + tree Summarize Sample code MySQL InnoDB storage engine uses B + tree for indexing instead of B tree MySQL is a commonly used relational database […]
Do you know how to integrate MySQL 8 innodb replication?
Let me introduce the group at the beginning. If you are interested in PolarDB, MongoDB, MySQL, PostgreSQL, Redis, Oceanbase, Sql Server, etc. and have questions, you can join the group if you have any needs. There are big names and CTOs in the major database industry in the group, who can solve your problems. . […]
MySQL log data table, how much faster is MyISAM than InnoDB query?
Table of Contents Briefly introduce the two engines Start actual measurement Comparing the capacity occupied by data, MyISAM occupies less space. From the comparison of query efficiency, MyISAM is indeed faster. MYISAM table structure Laravel table creation statement Laravel scheduled task-clean logs and keep only the latest 3 million records A brief introduction to the […]
MySQL5: MySQL data storage file; the index and data in MylSAM are two independent files. How does it find the data through the index? Clustered index/clustered index, why does the secondary index in InnoDB not store addresses but key values? How to understand row ID?
MySQL5: MySQL data storage file; the index and data in MylSAM are two independent files. How does it find the data through the index? Clustered index/clustered index, why does the secondary index in InnoDB not store addresses but key values? How to understand row ID? MySQL data storage file How to implement different storage engine […]
[MySQL Indexing and Optimization] InnoDB data storage structure
Article directory 1. Database storage structure: page 1.1 The basic unit of disk and memory interaction: page 1.2 Overview of page structure 1.3 Page Superstructure 2. Internal structure of the page 3. InnoDB row format (or record format) 3.1 Compact line format 3.2 Dynamic and Compressed row formats 3.3 Redundant row format 4. Area, segment […]
Performance Evaluation | GreatDB VIP PLUGIN Plan VS MySQL InnoDB Cluster High Availability Plan
Foreword Recently, we have communicated and investigated with many database users and learned that a considerable number of MySQL high-availability or failover solutions currently in production use the read-write separation function or the business access VIP (Virtual IP Address) method. to shield the backend database architecture. In MySQL, the VIP mechanism is generally completed with […]
Mysql InnoDB exclusive lock
Mysql InnoDB exclusive lock Usage: select … for update; For example: select * from goods where id = 1 for update; Prerequisite for exclusive lock application: No thread uses exclusive locks or shared locks for any row data in the result set, otherwise the application will be blocked. for update only applies to InnoDB and […]
Mysql InnoDB data update/deletion causes table lock
1. The data structure of the reconciliation table is as follows create table t_cgw_ckjnl ( CNL_CODE varchar(10) default ‘ ‘ not null comment ‘channel coding’, CNL_PLT_CD varchar(32) default ‘ ‘ not null comment ‘channel platform number’, CNL_TYP varchar(10) default ‘ ‘ not null comment ‘channel type’, CHK_BAT_NO varchar(32) default ‘ ‘ not null comment ‘Reconciliation […]
InnoDB Cluster Troubleshooting Manual
1. Cluster environment inspection and recovery 1.1 Cluster status check 1) Use any host name to log in to the cluster according to the host name in the cluster /data/mysql/mysql3306/mysql-shell/mysql-shell/bin/mysqlsh –uri [email protected]:3306 2) Check cluster status var cluster = dba.getCluster() cluster.status() 3) Status interpretation 1.Online Normally online 2.Offline Completely offline, group replication is turned off […]