Tag: innodb

Innodb underlying principle and Mysql logging mechanism

MySQL internal component structure Server layer It mainly includes connectors, lexical analyzers, optimizers, executors, etc., covering most of MySQL’s core service functions, as well as all built-in functions (such as date, time, mathematics and encryption functions, etc.), and all cross-storage engine functions. Implemented at this layer, such as stored procedures, triggers, views, etc. Engine Layer […]

04: Sysbench stress test-innodb_flush_log_at_trx_commit, sync_binlog parameters impact on performance

sysbench stress test-innodb_flush_log_at_trx_commit, sync_binlog parameter’s impact on performance Table of contents Sysbench stress test-innodb_flush_log_at_trx_commit, the impact of sync_binlog parameters on performance 1. Preparation before OLTP test 2. MySQL data transfer process 3. Parameter description 4. Test performance 5. Summary 1. Preparation before OLTP test Basic Information: Host information CPU Memory Hard disk System version MySQL […]

InnoDB storage engine: lock

What is a lock Locks are a key feature that distinguishes database systems from file systems. Locking mechanisms are used to manage concurrent access to shared resources. Databases use locksto support concurrent access to shared resources and provide data integrity and consistency. The implementation of InnoDB storage engine locks is very similar to that of […]

Mysql-7.In-depth analysis of the underlying principles of Innodb and the Mysql logging mechanism

Key learning content: 1. Detailed explanation of the internal component structure of MySQL 2. Analysis of the underlying principles of Innodb storage engine 3. Detailed explanation of Redolog redo log principle 4. Detailed explanation of the principle of binlog binary archive log 5. Practical data recovery after deleting the database and running away 6. Detailed […]

max_connections of MySQL Server layer and innodb_thread_concurrency of engine layer

The MySQL database server is composed of Server layer and Engine layer The Server layer includes connectors, query caches, analyzers, optimizers, executors, etc., covering MySQL Most of the core service functions, as well as all built-in functions (such as date, time, mathematical and encryption functions, etc.), all cross-storage engine functions are implemented in this layer, […]

InnoDB transaction principle of MySql storage engine (detailed analysis)

This article directory ACID design principles Atomicity C consistency I isolation How does the underlying layer of InnoDB implement transaction isolation level? Solution 1: Non-locking consistent read (MVCC) Solution 2: Lock Consistent Read (LBCC) D persistence ACID design principles Similar to the dependency inversion principle of the six basic principles of the Java language (depending […]

MySQL database – storage engine (2) – storage engine features (InnoDB, MyISAM, Memory), storage engine selection

Table of Contents Storage engine features InnoDB introduce Features document logical storage structure MyISAM introduce Features document Memory introduce Features document Differences and features Storage engine selection Storage engine features Above we introduced what a storage engine is and how to specify a storage engine when creating a table. Next, we will introduce the three […]

InnoDB engine – logical storage structure, architecture, background thread, transaction principle

1. Logical storage structure: #InnoDBEngine ###InnoDB engine-logical storage structure Tablespace (table space)–>Segment (segment)–>Extent (area)–>Page (page)–>Row (row) Tablespace: Table space (ibd file), one mysql real column can correspond to multiple table spaces, used to store records, indexes and other data Segment: Segment, which is divided into data segment (Leaf node segment), index segment (Non-leaf node segment), […]