Tag: Database
32 articles
MySQL Database Sharding: Vertical vs Horizontal Partitioning
Database sharding explained: vertical partitioning, horizontal partitioning, vertical sharding, vertical table splitting, horizontal table splitting. This article analyzes principles and practical ...
MySQL MHA Master-Slave Failover: High Availability Solution
MHA high availability solution: Manager, Node, fault handling, failover. This article analyzes principles and practical applications to help readers master key technical details.
MySQL Read-Write Separation: Principles and Implementation
Read-write separation principles, implementation methods, master-slave lag solutions, database middleware. This article analyzes principles and practical applications to help readers master key tec...
MySQL Transaction Control: Lost Update, Locking and MVCC
Concurrent transaction problems: lost update, dirty read, non-repeatable read, phantom read, lock mechanism: shared lock, exclusive lock, MVCC. This article provides in-depth analysis of principles...
MySQL Transaction and Lock Mechanism: ACID Properties
ACID properties: atomicity, consistency, isolation, durability, WAL mechanism. This article provides in-depth analysis of principles and practical applications.
MySQL Slow Query Analysis and Optimization Guide
Slow query log, mysqldumpslow, EXPLAIN analysis, common optimization solutions. This article provides in-depth analysis of principles and practical applications.
MySQL Index and Sorting: Filesort and Index Sort
filesort sorting, index sorting, two-pass sorting, single-pass sorting, clustered index and secondary index sorting. This article provides in-depth analysis of principles and practical applications.
MySQL Index Optimization: Table Lookup, Covering Index, L...
Table lookup queries, covering index, leftmost prefix principle, LIKE queries, NULL value handling. This article provides in-depth analysis of principles and practical applications.
MySQL EXPLAIN: Index Analysis and Query Optimization
EXPLAIN command: select_type, type, possible_keys, key, rows, key_len, Extra. This article provides in-depth analysis of principles and practical applications.
MySQL Clustered vs Secondary Index: Structure and Perform...
Clustered index (secondary index, primary key index), secondary index, table lookup query, covering index. This article provides in-depth analysis of principles and practical applications.
MySQL Index Principles: B+Tree, Hash, Binary Search
Index principles: B+Tree, Hash index, binary search, InnoDB adaptive hash index. This article provides in-depth analysis of principles and practical applications.
MySQL Index Types: BTree, Hash, FULLTEXT, RTree Explained
Index types: BTree, Hash, FULLTEXT, RTree, regular index, unique index, primary key index, composite index, clustered index. This article provides in-depth analysis of principles and practical appl...
MySQL Binlog: Recording Modes, Replication, Data Recovery
Binlog three recording modes: STATEMENT, ROW, MIXED, file format, write mechanism, master-slave replication. This article provides in-depth analysis of principles and practical applications.
MySQL Undo/Redo Log: Transaction Rollback and Persistence
Undo Log for rollback, Redo Log for redo, transaction atomicity, durability, MVCC. This article provides in-depth analysis of principles and practical applications.
MySQL InnoDB Storage Structure: Tablespace, Segment, Exte...
InnoDB storage structure: Tablespace, Segment, Extent, Page, Row. Row formats: REDUNDANT, COMPACT, DYNAMIC, COMPRESSED
MySQL Architecture to Threads: Storage Engine and Thread ...
MySQL 5.7/8.0 storage engine optimization, InnoDB thread model: IO Thread, Purge Thread, Page Cleaner Thread, Master Thread
MySQL InnoDB Disk Structure: Tablespace, Log System, Data...
InnoDB disk structure: system tablespace, file-per-table tablespace, general tablespace, temporary tablespace, Doublewrite Buffer, Redo Log, Undo Log - complete storage architecture guide.
MySQL InnoDB Storage Structure: Buffer Pool and Log Mecha...
InnoDB memory structure: Buffer Pool, Change Buffer, Adaptive Hash Index, Log Buffer - this article provides an in-depth analysis of principles and practical applications.
MySQL Storage Engines: InnoDB vs MyISAM Deep Comparison
MySQL storage engine comparison: InnoDB, MyISAM, Memory, Archive - transactions, locking mechanisms, index structures. This article provides in-depth analysis of principles and practical applications.
MySQL Connection, Thread, Query Cache and Optimizer Deep ...
MySQL connection mechanism, half-duplex communication, query cache, query optimizer explained. This article provides in-depth analysis of principles and practical applications.
MySQL Internal Architecture: Service Layer and Storage En...
MySQL four-layer architecture: network connection layer, service layer, storage engine layer, system file layer. This article provides in-depth analysis of principles and practical applications.
MySQL Evolution: From Standalone to Cloud Database
MySQL development history, main branches, architecture evolution (standalone -> master-slave -> sharding -> cloud database). This article provides in-depth analysis of principles and practical appl...
MyBatis Quick Start - POM, Mapper, Core Files, CRUD Opera...
MyBatis quick start tutorial covering MyBatis development steps including POM dependency configuration, Mapper mapping files, SqlMapConfig core configuration file, and CRUD operations. Practical an...
MyBatis Deep Dive - ORM Concepts, Mapping Relations, and ...
This article introduces the MyBatis framework in depth, starting from ORM concepts, explaining MyBatis development history, technical advantages, and comparisons with common ORM frameworks like Hib...
MySQL Master-Slave Replication: Read-Write Separation and...
This article provides an in-depth explanation of MySQL master-slave replication: master-slave mode, read-write separation, semi-sync replication principles and configuration.
MySQL Design Guide: Availability, Scalability, Consistency
This article provides an in-depth explanation of MySQL database design: availability (redundancy, failover), scalability (sharding, read-write separation), consistency (strong consistency vs eventu...
MySQL Deadlock: Principles, Scenarios and Prevention
This article provides an in-depth explanation of MySQL deadlocks: deadlock definition, necessary conditions, table lock deadlocks, row-level deadlocks, shared to exclusive lock conversion, deadlock...
MySQL Lock Mechanism: From Table Locks to Row Locks
This article provides an in-depth explanation of MySQL lock mechanisms: pessimistic locking, optimistic locking, table-level locks, row-level locks (shared locks, exclusive locks), intention locks,...
MySQL Parallel Replication: From 5.6 to 8.0 Evolution
This article provides an in-depth explanation of MySQL parallel replication technology: from 5.6 database-based parallel to 5.7 group commit-based to 8.0 writeset-based evolution.
MySQL Dual-Master Architecture and MMM High Availability
Deep dive into MySQL dual-master architecture and MMM high availability solution: dual-master mode, MMM fault handling, monitoring mechanism. This article analyzes principles and practical applicat...
MySQL MHA Master-Slave Failover: Architecture and Impleme...
Deep dive into MySQL MHA high availability solution: MHA architecture, fault handling, primary-standby switch, lag issues and solutions. This article analyzes principles and practical applications.
MySQL Transaction Isolation Levels: Read Uncommitted to S...
This article provides an in-depth explanation of MySQL transaction isolation levels: Read Uncommitted, Read Committed, Repeatable Read, and Serializable, analyzing dirty read, non-repeatable read, ...