Blog
Technical exploration and thoughts · 655 articles
MySQL Transactions: ACID Properties, Isolation Levels & U...
MySQL database transaction is a set of SQL operations executed as a single logical unit of work, following ACID principles: Atomicity, Consistency, Isolation and Durability.
MyCat schema.xml: Logical Database, Tables, Data Nodes Guide
schema.xml is MyCat's core configuration file managing logical databases, logical tables, data nodes and data hosts.
MySQL Transaction Issues: Dirty Read, Non-Repeatable Read...
Common issues in database transactions include dirty read, non-repeatable read, and phantom read. These issues are closely related to database isolation levels.
Spring Boot Transaction Propagation: From REQUIRED to NESTED
Transaction propagation is an important mechanism in Spring for handling transaction boundaries, defining how methods interact with transaction context in the call chain.
Spring Boot Declarative vs Programmatic Transactions
Introduces declarative transaction and programmatic transaction concepts, usage methods and comparative analysis. Declarative transaction is implemented through @Transactional annotation, programma...
Spring Transaction Pitfalls Part 2: Common Issues & Solut...
Common Spring transaction pitfalls include non-public access modifiers, unsupported storage engines, incorrect readOnly configuration, transaction timeout too short, and incorrect propagation mecha...
Spring Boot @Transactional: Propagation, Isolation & Roll...
Detailed introduction to @Transactional annotation parameters in Spring Boot, including transaction propagation, isolation levels, and exception rollback strategies.
MyBatis Plugin Mechanism - Principles, Custom Plugins, So...
Detailed introduction to MyBatis plugin mechanism including plugin principles, custom plugin development, intercepting four core components, @Intercepts annotation usage, and source code analysis. ...
Spring Transaction Pitfalls Part 1: Common Issues & Solut...
Spring transaction pitfalls commonly occur in scenarios like classes not managed by Spring, transaction manager not started, improper method modifiers (final, static, private), and same-class inter...
Spring Transaction Pitfalls Part 3: Common Issues & Solut...
Spring transaction pitfalls include rollbackFor configuration errors, transaction annotation overrides, nested transaction issues and more.
MongoDB Basic Operations: Database, Collection & CRUD Guide
MongoDB common commands include show dbs to list databases, use to switch databases, db.createCollection() to create collections, show collections to list collections, db.collection.drop() to delet...
NoSQL Databases: MongoDB, Redis, HBase, Neo4j Comparison
NoSQL is a general term for non-relational databases, including document-based MongoDB, key-value Redis, column-store HBase, and graph database Neo4j, each with its own characteristics and use cases.
MongoDB BSON Format: Core Storage Format vs JSON
BSON is MongoDB's core storage format, a binary-encoded JSON-like format. Compared to JSON, BSON supports more data types like Date, Binary, ObjectId, with better performance.
Spring Transaction Pitfalls Part 4: Multi-threading & Exc...
Spring transaction pitfalls include multi-threaded calls, exception catching without rollback, manual exception throwing errors. In multi-threading scenarios, child threads cannot inherit parent th...
MongoDB Indexing: Types, Principles & Best Practices
MongoDB indexes are core mechanisms for improving query performance, including single field indexes, compound indexes, multi-key indexes, geospatial indexes, text indexes and hashed indexes.
MongoDB Index Management & explain Execution Plan Analysis
MongoDB index management includes createIndex, getIndexes, dropIndex operations. explain analysis supports queryPlanner, executionStats, allPlansExecution modes, analyzing query performance through...
MongoDB Aggregation: $match, $group, $project, $sort Pipe...
MongoDB aggregation framework processes documents through multi-stage pipelines, implementing complex operations similar to SQL GROUP BY, JOIN, SUM, AVG. Common stages include $match, $group, $proj...
MongoDB Pagination: skip() + limit() + sort() & Performance
MongoDB implements pagination through combination of skip(), limit() and sort() methods. Performance optimization suggestions include avoiding large skip values and using range queries as alternati...
MongoDB Data Insert, Batch Write & Logical Queries AND OR...
MongoDB data operations include single insertOne() and batch insertMany(). Query operators include $eq, $ne, $gt, $lt, etc. Logical operators include $and, $or, $not.
MongoDB vs MySQL: B-Tree vs B+Tree Index Mechanisms
MongoDB uses B-tree indexes where nodes store both data and keys. MySQL uses B+tree indexes with all data concentrated in leaf nodes. B+tree is better for range queries, B-tree is better for random...