BestHub
Sign in
Tagged articles
175 articles
Page 1 of 2
Architect's Guide
Architect's Guide
Apr 27, 2026 · Backend Development

How to Optimize Large Transactions in API Endpoints

The article examines why large database transactions inside API endpoints degrade performance, outlines issues such as data inconsistency, lock contention, undo‑log overhead, and DB pressure, and presents practical optimizations including removing remote RPC calls, using programmatic transactions, batch processing, splitting into smaller transactions, and asynchronous parallel execution with code examples.

Backend DevelopmentBatch ProcessingProgrammatic Transaction
0 likes · 9 min read
How to Optimize Large Transactions in API Endpoints
Chen Tian Universe
Chen Tian Universe
Feb 26, 2026 · Backend Development

Building a Payment Middle Platform: 5 Core Modules and Real-World Scenarios

This article explains why SaaS providers need a payment middle platform, outlines the five essential modules—merchant account configuration, core payment system, reconciliation, profit sharing, and settlement—and describes four common payment scenarios with practical implementation guidance.

Transactionspayment
0 likes · 13 min read
Building a Payment Middle Platform: 5 Core Modules and Real-World Scenarios
Architecture & Thinking
Architecture & Thinking
Jan 19, 2026 · Databases

Why Transactions Matter: Mastering MySQL ACID and Isolation Levels

This article explains MySQL transaction fundamentals, illustrates a banking transfer scenario, details the ACID properties, explores dirty reads, non‑repeatable reads and phantom reads, and compares the four SQL‑92 isolation levels with practical code examples and InnoDB behavior.

ACIDInnoDBIsolation Levels
0 likes · 10 min read
Why Transactions Matter: Mastering MySQL ACID and Isolation Levels
Xiao Liu Lab
Xiao Liu Lab
Dec 21, 2025 · Databases

Master MySQL for Ops: DML/DQL Tricks, Permissions & Transaction Pitfalls

This guide equips MySQL ops engineers with practical DML/DQL commands, permission management, transaction handling, and common pitfalls, offering step‑by‑step examples, performance tips and safety checklists to ensure reliable database maintenance and troubleshooting.

Database operationsPermissionsTransactions
0 likes · 27 min read
Master MySQL for Ops: DML/DQL Tricks, Permissions & Transaction Pitfalls
Code Wrench
Code Wrench
Dec 13, 2025 · Databases

Mastering Database Internals for Go Interviews: Indexes, Transactions, Locks, MVCC & Connection Pools

This article equips Go backend developers with deep, interview‑ready knowledge of database internals—covering how indexes truly work, why queries can still be slow, transaction isolation levels, lock types, MVCC mechanics, and connection‑pool tuning—to avoid performance pitfalls and stand out in technical interviews.

Connection PoolGoLocks
0 likes · 12 min read
Mastering Database Internals for Go Interviews: Indexes, Transactions, Locks, MVCC & Connection Pools
Ray's Galactic Tech
Ray's Galactic Tech
Nov 19, 2025 · Databases

Master InnoDB: Architecture, Indexes, Transactions & Performance Tuning

This comprehensive guide walks you through MySQL InnoDB's core architecture, storage structures, indexing mechanisms, transaction and concurrency control, crash recovery, backup options, and practical performance‑tuning techniques, providing clear explanations and real‑world SQL examples.

Database ArchitectureInnoDBMVCC
0 likes · 8 min read
Master InnoDB: Architecture, Indexes, Transactions & Performance Tuning
Tencent Cloud Developer
Tencent Cloud Developer
Sep 3, 2025 · Databases

Deep Dive into GORM: Architecture, Internals, and Common Pitfalls

This article provides a comprehensive overview of Go's powerful GORM ORM library, covering its core concepts, architecture, internal logic, common pitfalls, practical tips, and advanced features such as soft deletes, transaction handling, batch operations, and integration with trpc-go, helping developers master GORM's inner workings.

Batch InsertGORMGo
0 likes · 26 min read
Deep Dive into GORM: Architecture, Internals, and Common Pitfalls
Raymond Ops
Raymond Ops
Aug 20, 2025 · Databases

Master MySQL Storage Engines: InnoDB vs MyISAM and Transaction Essentials

This comprehensive guide explains MySQL storage engine concepts, compares built‑in engines like InnoDB and MyISAM, details how to view and configure engines, and covers transaction fundamentals, isolation levels, locking mechanisms, and practical migration case studies for reliable database operations.

ACIDInnoDBStorage Engine
0 likes · 17 min read
Master MySQL Storage Engines: InnoDB vs MyISAM and Transaction Essentials
php Courses
php Courses
Jul 22, 2025 · Databases

10 Must‑Know Advanced SQL Tricks to Boost Your Development Efficiency

This article presents ten essential advanced SQL techniques—including EXPLAIN, window functions, CTEs, bulk operations, index optimization, transactions, JSON handling, temporary tables, proper NULL handling, and recursive queries—to help developers write more efficient, maintainable, and powerful database code.

Advanced QueriesCTEDatabase Optimization
0 likes · 8 min read
10 Must‑Know Advanced SQL Tricks to Boost Your Development Efficiency
Programmer Xu Shu
Programmer Xu Shu
May 16, 2025 · Databases

Mastering Redis Transactions: When to Use MULTI/EXEC, WATCH, and DISCARD

Redis is ubiquitous in Java development for caching, ranking, and distributed locks, but its transaction model differs from traditional databases; this article explains Redis transaction fundamentals, core commands (MULTI, EXEC, DISCARD, WATCH), common pitfalls, best practices, and interview FAQs to help developers avoid mistakes.

MULTITransactionsexec
0 likes · 11 min read
Mastering Redis Transactions: When to Use MULTI/EXEC, WATCH, and DISCARD
Raymond Ops
Raymond Ops
Apr 4, 2025 · Databases

Mastering Redis: Persistence, Cache Pitfalls, Data Types, Clustering & Locks

This article explains Redis persistence mechanisms (RDB and AOF), common cache problems and their solutions, the various Redis data structures and their use cases, cluster deployment options, master‑slave replication, transaction commands, and how to implement distributed locks with SETNX and expiration.

CacheData TypesPersistence
0 likes · 13 min read
Mastering Redis: Persistence, Cache Pitfalls, Data Types, Clustering & Locks
Practical DevOps Architecture
Practical DevOps Architecture
Feb 14, 2025 · Databases

Comprehensive MySQL Advanced Features Course Outline

This MySQL course provides an extensive curriculum covering advanced functions, transaction management, backup and recovery, user permission handling, and multi‑table relationships, presented through a series of video modules that guide learners from fundamental concepts to practical, production‑level implementations.

Advanced SQLTransactionsmysql
0 likes · 6 min read
Comprehensive MySQL Advanced Features Course Outline
IT Services Circle
IT Services Circle
Nov 27, 2024 · Databases

15 Common MySQL Pitfalls and How to Avoid Them

This article outlines fifteen typical MySQL pitfalls—including missing WHERE clauses, lack of indexes, improper NULL handling, wrong data types, deep pagination, missing EXPLAIN analysis, charset misconfiguration, SQL injection risks, transaction misuse, collation issues, overusing SELECT *, index loss, frequent schema changes, missing backups, and unarchived historical data—and provides concrete examples and best‑practice solutions to improve performance, reliability, and security.

Database OptimizationSQLSecurity
0 likes · 13 min read
15 Common MySQL Pitfalls and How to Avoid Them
Alibaba Cloud Developer
Alibaba Cloud Developer
Oct 11, 2024 · Backend Development

Avoid Common Go Middleware Pitfalls: Lessons from Alibaba’s Experience

This article shares the most frequent Go middleware pitfalls encountered at Alibaba, explains their root causes—from uneven request distribution and CPU leaks to transaction mishandling and SQL incompatibilities—and provides concrete solutions and best‑practice recommendations to help developers avoid repeating these errors.

GoSQLTransactions
0 likes · 20 min read
Avoid Common Go Middleware Pitfalls: Lessons from Alibaba’s Experience
Cognitive Technology Team
Cognitive Technology Team
Sep 1, 2024 · Fundamentals

Fundamental Design Patterns, Layered Architecture, and Concurrency Principles for Enterprise Applications

The article explains core software design patterns, the benefits and pitfalls of layered architecture, essential database and transaction practices, and concurrency control techniques such as isolation, immutability, optimistic and pessimistic locking, guiding developers to build robust enterprise systems.

Design PatternsTransactionslayered architecture
0 likes · 10 min read
Fundamental Design Patterns, Layered Architecture, and Concurrency Principles for Enterprise Applications
JavaEdge
JavaEdge
Jul 25, 2024 · Blockchain

Understanding Ethereum: Accounts, Transactions, and Network Basics

This article provides a comprehensive overview of Ethereum, explaining what it is, how its external and contract accounts work, the mechanics of transactions and gas, the underlying network architecture, major client implementations, and how Hardhat facilitates smart‑contract development.

AccountsEthereumHardhat
0 likes · 14 min read
Understanding Ethereum: Accounts, Transactions, and Network Basics
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 24, 2024 · Databases

Summary of the MySQL Transaction Module Series

This article reviews the 14-part series on MySQL's transaction module, covering initialization, transaction types, two‑phase commit, binlog handling, savepoints, and full rollback, and provides links to each detailed post, including discussions on BEGIN statements, read‑only transactions, and the internal mechanisms of InnoDB.

BinlogInnoDBSavepoint
0 likes · 5 min read
Summary of the MySQL Transaction Module Series
Architecture & Thinking
Architecture & Thinking
Nov 17, 2023 · Databases

Mastering MySQL Transactions: ACID, Isolation Levels, and Common Pitfalls

This article explains MySQL transaction fundamentals, the necessity of ACID properties, details the four isolation levels and their impact on phenomena like dirty reads, non‑repeatable reads, and phantom reads, and provides practical SQL examples and strategies for ensuring data consistency in high‑concurrency environments.

ACIDDatabase ConcurrencyInnoDB
0 likes · 15 min read
Mastering MySQL Transactions: ACID, Isolation Levels, and Common Pitfalls
Su San Talks Tech
Su San Talks Tech
Sep 4, 2023 · Databases

Master MySQL Interview Essentials: 43 Key Topics Explained

This comprehensive guide consolidates 43 essential MySQL interview topics—from normalization, storage engines, and indexing to transaction handling, logging, replication, and performance tuning—providing clear explanations, code examples, and diagrams to help candidates quickly master the core concepts.

Database InterviewReplicationSQL
0 likes · 37 min read
Master MySQL Interview Essentials: 43 Key Topics Explained
IT Services Circle
IT Services Circle
Jun 10, 2023 · Databases

Comprehensive MySQL Interview Guide: Key Concepts and Practices

This article provides a systematic, interview‑focused overview of MySQL fundamentals—including normal forms, DML vs DDL, primary and foreign keys, storage engines, redo and binlog mechanisms, indexing strategies, transaction properties, MVCC, lock types, replication, and common performance pitfalls—helping candidates quickly master essential database knowledge for interview success.

SQLTransactionsdatabase
0 likes · 32 min read
Comprehensive MySQL Interview Guide: Key Concepts and Practices
Architects Research Society
Architects Research Society
Jun 4, 2023 · Big Data

Understanding Transactions in Apache Kafka

This article explains the design, semantics, and practical usage of Apache Kafka's transaction API, covering why transactions are needed for exactly‑once processing, the underlying atomic multi‑partition writes, zombie fencing, consumer guarantees, Java API details, performance considerations, and operational best practices.

Apache KafkaDistributed SystemsExactly-Once
0 likes · 19 min read
Understanding Transactions in Apache Kafka
ITPUB
ITPUB
May 26, 2023 · Databases

Mastering Redis Transactions: Commands, CAS Locks, and Common Pitfalls

This article explains why Redis offers transactions, introduces the five core transaction commands, demonstrates practical examples including WATCH and CAS optimistic locking, and discusses error handling and the reasons Redis does not support rollback.

CASTransactionsdatabase
0 likes · 9 min read
Mastering Redis Transactions: Commands, CAS Locks, and Common Pitfalls
Architects Research Society
Architects Research Society
Apr 25, 2023 · Big Data

Understanding Transactions in Apache Kafka: Semantics, API, and Practical Guidance

This article explains the purpose, semantics, and design of Apache Kafka's transaction API, describes how exactly‑once processing is achieved in stream‑processing applications, outlines the Java client usage, and discusses the internal components, performance considerations, and best‑practice tips for developers.

Distributed SystemsExactly-OnceJava
0 likes · 16 min read
Understanding Transactions in Apache Kafka: Semantics, API, and Practical Guidance
ITPUB
ITPUB
Mar 23, 2023 · Databases

How MySQL InnoDB Implements ACID: Deep Dive into Transactions, Locks, and Isolation

This article explains how MySQL InnoDB achieves the ACID properties—Atomicity, Consistency, Isolation, Durability—by detailing the roles of undo logs, redo logs, buffer pool, lock mechanisms, and MVCC, and outlines transaction lifecycle commands, isolation levels, and consistency guarantees.

ACIDInnoDBIsolation
0 likes · 10 min read
How MySQL InnoDB Implements ACID: Deep Dive into Transactions, Locks, and Isolation
ITPUB
ITPUB
Mar 19, 2023 · Databases

Master Redis Persistence, Transactions, and Pipelines: A Practical Guide

This article explains Redis's in‑memory database persistence mechanisms—including RDB snapshots and AOF logging—detailing configuration, automatic and manual triggers, advantages and drawbacks, as well as Redis transaction commands and pipeline usage, providing practical code examples to help developers master data durability and performance.

AOFPersistencePipelines
0 likes · 12 min read
Master Redis Persistence, Transactions, and Pipelines: A Practical Guide
Architects Research Society
Architects Research Society
Mar 15, 2023 · Big Data

Understanding Transactions in Apache Kafka: Semantics, API, and Practical Considerations

This article explains why exactly‑once semantics are needed for stream‑processing applications, describes Kafka's transactional model and semantics, details the Java transaction API and its usage, and discusses the internal components, performance trade‑offs, and practical guidelines for building reliable Kafka‑based pipelines.

Distributed SystemsExactly-OnceJava
0 likes · 17 min read
Understanding Transactions in Apache Kafka: Semantics, API, and Practical Considerations
Architect
Architect
Jan 16, 2023 · Databases

Redis Fundamentals: Pipelines, Pub/Sub, Expiration, Transactions, Persistence, Distributed Locks and Clustering

This article provides a comprehensive overview of Redis, covering basic concepts, pipeline optimization, publish/subscribe messaging, key expiration strategies, transaction behavior, persistence mechanisms (RDB, AOF, hybrid), distributed locking techniques, Redisson and Redlock algorithms, as well as high‑availability setups using replication, Sentinel and Cluster modes.

Distributed LocksPersistenceTransactions
0 likes · 32 min read
Redis Fundamentals: Pipelines, Pub/Sub, Expiration, Transactions, Persistence, Distributed Locks and Clustering
ITPUB
ITPUB
Oct 29, 2022 · Databases

Understanding Local vs Distributed Transactions: ACID, Pitfalls, and Solutions

This article explains the fundamentals of local transactions, highlights their advantages and limitations, introduces the challenges of distributed transactions across services and databases, and reviews common solutions such as 2PC, reliable messaging, TCC, and max‑effort notification.

2PCACIDTransactions
0 likes · 10 min read
Understanding Local vs Distributed Transactions: ACID, Pitfalls, and Solutions
JD Cloud Developers
JD Cloud Developers
Sep 29, 2022 · Databases

Mastering Data Consistency: Transactions, Isolation Levels, and MVCC Explained

This article explores how to achieve data consistency by examining transaction properties, isolation levels, common concurrency issues like dirty, non-repeatable, and phantom reads, and compares lock‑based concurrency control with multi‑version concurrency control (MVCC), detailing undo logs, read‑view mechanisms, and practical examples.

ConsistencyMVCCTransactions
0 likes · 15 min read
Mastering Data Consistency: Transactions, Isolation Levels, and MVCC Explained
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Sep 14, 2022 · Databases

Master MySQL: 3 Normal Forms, Engine Differences, Indexing, Transactions & More

This comprehensive guide covers MySQL fundamentals such as the three normal forms, differences between MyISAM and InnoDB, redo log versus binlog, when queries bypass indexes, join types, various index structures, covering indexes, back‑row lookups, transaction properties and isolation levels, common performance bottlenecks, replication mechanics, lag mitigation, storage behavior after deletes, VARCHAR limits, lock types, systematic SQL tuning steps, the purpose and trade‑offs of indexes, B+‑tree advantages, MVCC internals, and the Snowflake distributed ID algorithm.

ReplicationTransactionsindexing
0 likes · 24 min read
Master MySQL: 3 Normal Forms, Engine Differences, Indexing, Transactions & More
Java Tech Enthusiast
Java Tech Enthusiast
Aug 31, 2022 · Databases

Redis Persistence, Transactions, and Distributed Locks

Redis ensures data durability through RDB snapshots and AOF logs—configurable for location, compression, and sync policies—while offering atomic transactions via MULTI/EXEC and simple distributed locks using SETNX (optionally guarded by WATCH) with expirations to prevent deadlocks.

AOFPersistenceRDB
0 likes · 11 min read
Redis Persistence, Transactions, and Distributed Locks
IT Architects Alliance
IT Architects Alliance
Aug 30, 2022 · Big Data

Understanding Kafka: Architecture, Topics, Partitions, Producers, Consumers, Offsets, Transactions, and Configuration

This article provides a comprehensive overview of Apache Kafka, explaining its distributed message‑queue architecture, the role of topics and partitions, producer and consumer workflows, leader election, offset management, consumer‑group rebalancing, delivery semantics, transaction processing, file organization, and key configuration settings.

Big DataDistributed MessagingKafka
0 likes · 17 min read
Understanding Kafka: Architecture, Topics, Partitions, Producers, Consumers, Offsets, Transactions, and Configuration
Top Architect
Top Architect
Aug 28, 2022 · Big Data

Understanding Kafka Architecture: Topics, Partitions, Producers, Consumers, Offsets, and Transactions

Kafka is a high‑performance distributed message queue that uses topics, partitions, and replicas for scalability, with producers writing messages, consumers reading them via consumer groups, and advanced features such as offset management, delivery semantics, rebalancing, and exactly‑once transactional processing, all coordinated by Zookeeper.

ConsumersDistributed MessagingExactly-Once
0 likes · 17 min read
Understanding Kafka Architecture: Topics, Partitions, Producers, Consumers, Offsets, and Transactions
Meituan Technology Team
Meituan Technology Team
Aug 25, 2022 · Databases

Transactions, Consistency, and Consensus in Distributed Systems

This article explains how transactions, consistency, and consensus interrelate in distributed systems, reviews replication models, details ACID properties, internal consistency models, consensus algorithms, and Kafka’s configuration and transaction support, and highlights verification tools like TLA+ and Jepsen for ensuring correctness.

ACIDConsensusConsistency
0 likes · 46 min read
Transactions, Consistency, and Consensus in Distributed Systems
Architect's Guide
Architect's Guide
Aug 9, 2022 · Databases

Seven Key Aspects of Distributed Storage Systems: Replication, Storage Engine, Transactions, Analytics, Multi‑core, Compute, and Compilation

The article presents a comprehensive guide to distributed storage, organizing its design and implementation into seven essential dimensions—replication, storage engine, transaction processing, analytical query execution, multi‑core scaling, compute engine architecture, and compilation techniques—each explained with core concepts, challenges, and practical considerations.

AnalyticsDatabase ArchitectureTransactions
0 likes · 13 min read
Seven Key Aspects of Distributed Storage Systems: Replication, Storage Engine, Transactions, Analytics, Multi‑core, Compute, and Compilation
JavaEdge
JavaEdge
Jul 24, 2022 · Databases

Understanding Database Transactions: ACID, Isolation, and Real-World Pitfalls

The article examines why robust fault‑tolerance is essential for data stores, explains how transactions simplify error handling, breaks down the ACID guarantees, illustrates isolation and durability with concrete examples and diagrams, and discusses when multi‑object transactions are truly needed.

ACIDConsistencyIsolation
0 likes · 20 min read
Understanding Database Transactions: ACID, Isolation, and Real-World Pitfalls
Liangxu Linux
Liangxu Linux
Apr 7, 2022 · Databases

Essential MySQL Interview Guide: Normal Forms, Permissions, ACID, Indexes & More

This comprehensive guide covers MySQL fundamentals including the three normal forms, permission tables, ACID properties, index design principles, SQL statement categories, sharding, deadlock resolution, isolation anomalies, view characteristics, SQL lifecycle, primary key choices, performance troubleshooting, replication, GTID, backup tools, and backup planning.

BackupDatabase designReplication
0 likes · 13 min read
Essential MySQL Interview Guide: Normal Forms, Permissions, ACID, Indexes & More
Architecture Digest
Architecture Digest
Mar 31, 2022 · Databases

Seven Key Aspects of Distributed Storage Systems

This article outlines the motivation and seven fundamental aspects of distributed storage—replication, storage engine, transactions, analytics, multi‑core processing, computation, and compilation—detailing their roles, challenges, and design considerations for building scalable, reliable, and high‑performance data systems.

Database ArchitectureTransactionsdistributed storage
0 likes · 14 min read
Seven Key Aspects of Distributed Storage Systems
Senior Brother's Insights
Senior Brother's Insights
Dec 21, 2021 · Databases

9 Essential MySQL Optimization Techniques to Boost Performance

This article presents practical MySQL optimization methods—including proper column definitions, NOT NULL usage, JOIN over sub‑queries, UNION, transaction handling, foreign keys, table locking, indexing strategies, and a collection of query‑tuning tips—each illustrated with clear examples and code snippets to improve database speed and reliability.

Database OptimizationSQLTransactions
0 likes · 18 min read
9 Essential MySQL Optimization Techniques to Boost Performance
Java Architect Essentials
Java Architect Essentials
Nov 15, 2021 · Databases

MySQL Optimization: Concepts, Schema Design, Indexes, and Query Tuning

This article provides a comprehensive overview of MySQL fundamentals—including logical architecture, locks, transactions, and storage engines—and offers practical optimization strategies for schema design, data types, indexing, and query execution, supplemented with code examples and performance‑analysis tips.

Database OptimizationQuery TuningTransactions
0 likes · 14 min read
MySQL Optimization: Concepts, Schema Design, Indexes, and Query Tuning
ITPUB
ITPUB
Nov 9, 2021 · Databases

Essential MySQL Optimization Tips for Faster Queries

This guide presents practical MySQL performance tricks—including choosing minimal field types, using NOT NULL, preferring JOIN over sub‑queries, leveraging UNION, applying proper transaction control, foreign keys, table locking, indexing strategies, and query‑writing best practices—to dramatically speed up data retrieval and reduce resource consumption.

JoinsQueriesTransactions
0 likes · 19 min read
Essential MySQL Optimization Tips for Faster Queries
Architect
Architect
Sep 14, 2021 · Fundamentals

Understanding Distributed Transactions: From Local ACID to CAP Theory and Message‑Queue Solutions

The article uses a personal bank‑transfer incident to introduce local transaction concepts, explains the CAP theorem, examines the challenges of distributed transactions, and presents a message‑queue‑based design with transaction logs and compensation mechanisms to ensure consistency and idempotency.

CAP theoremDistributed SystemsMessage Queue
0 likes · 15 min read
Understanding Distributed Transactions: From Local ACID to CAP Theory and Message‑Queue Solutions
Wukong Talks Architecture
Wukong Talks Architecture
Sep 9, 2021 · Databases

Comprehensive MySQL Interview Questions and Answers on Indexes, Transactions, Replication, and More

This article compiles twenty detailed MySQL interview questions covering redo log vs. binlog, index types and best practices, covering indexes, joint index matching rules, back‑table queries, left‑most prefix principle, lock mechanisms, MVCC, execution plans, master‑slave replication, XA transactions, and the Snowflake ID algorithm, providing clear explanations and example SQL code.

MVCCReplicationTransactions
0 likes · 30 min read
Comprehensive MySQL Interview Questions and Answers on Indexes, Transactions, Replication, and More
IT Architects Alliance
IT Architects Alliance
Sep 6, 2021 · Databases

Comprehensive Overview of Data Models, Storage Engines, Transactions, Consistency, and Replication in Modern Databases

This article provides a detailed summary of database concepts including data models (relational, document, graph), storage engine architectures (page‑oriented B‑tree, log‑structured LSM), transaction mechanisms, isolation levels, distributed transaction protocols, partitioning strategies, indexing, consistency models, and consensus algorithms such as Lamport timestamps and Raft.

ConsistencyData ModelsStorage Engines
0 likes · 29 min read
Comprehensive Overview of Data Models, Storage Engines, Transactions, Consistency, and Replication in Modern Databases
Selected Java Interview Questions
Selected Java Interview Questions
Aug 30, 2021 · Databases

MySQL Interview Questions and Answers: Indexes, InnoDB vs MyISAM, Transactions, Optimization, and Design

This article compiles a comprehensive set of MySQL interview questions covering index types, the differences between MyISAM and InnoDB, the rationale for auto‑increment primary keys, sharding strategies, ACID properties, isolation levels, storage‑engine trade‑offs, normalization, index best practices, data types, performance tuning, locking mechanisms, B+Tree characteristics, and common SQL operations.

Database designInnoDBSQL
0 likes · 28 min read
MySQL Interview Questions and Answers: Indexes, InnoDB vs MyISAM, Transactions, Optimization, and Design
ITPUB
ITPUB
Aug 18, 2021 · Databases

Master SQL Basics: From Core Concepts to Advanced Queries and Database Management

This comprehensive guide covers fundamental SQL concepts, syntax, and terminology, then walks through CRUD operations, subqueries, joins, unions, functions, ordering, grouping, data definition, transaction control, permission management, stored procedures, cursors, and triggers, providing clear examples for each.

CRUDJoinsSQL
0 likes · 28 min read
Master SQL Basics: From Core Concepts to Advanced Queries and Database Management
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 12, 2021 · Backend Development

How Payment Orchestration Shapes Modern Transaction Systems

This article presents a visual deep‑dive into the core transaction architecture and payment orchestration flow, illustrating each component and their interactions through detailed diagrams that reveal how modern backend systems handle complex payment processes.

BackendOrchestrationTransactions
0 likes · 3 min read
How Payment Orchestration Shapes Modern Transaction Systems
Open Source Linux
Open Source Linux
Jul 22, 2021 · Databases

Master SQL: Essential Syntax, Queries, and Advanced Techniques

This comprehensive guide covers SQL fundamentals—including database terminology, syntax structure, DDL/DML/TCL/DCL commands, CRUD operations, subqueries, joins, unions, functions, ordering, grouping, indexes, constraints, transactions, permissions, stored procedures, cursors, and triggers—providing clear examples and best practices for relational database development.

CRUDSQLStored Procedures
0 likes · 26 min read
Master SQL: Essential Syntax, Queries, and Advanced Techniques
Tencent Cloud Middleware
Tencent Cloud Middleware
Jun 30, 2021 · Fundamentals

Understanding Apache Pulsar Transactions: Core Concepts and Workflow

Apache Pulsar 2.8.0 introduces transaction support, featuring a Transaction Coordinator, Transaction Buffer, Transaction Log, Transaction ID, and Pending Acknowledge State, with a detailed workflow that ensures exactly‑once semantics for stream processing, contrasting its design with Kafka’s approach.

Apache PulsarExactly-OnceKafka Comparison
0 likes · 13 min read
Understanding Apache Pulsar Transactions: Core Concepts and Workflow
Java Interview Crash Guide
Java Interview Crash Guide
Jun 25, 2021 · Backend Development

Understanding Kafka Transactions: TC Service, Producer Flow, and Code Walkthrough

This article explains how Kafka implements transactions, detailing the role of the Transaction Coordinator (TC) service, the transaction flow diagram, producer initialization, partition handling, offset commits, commit and abort processes, and includes a complete Java code example with client‑side and server‑side components.

ConsumerJavaKafka
0 likes · 22 min read
Understanding Kafka Transactions: TC Service, Producer Flow, and Code Walkthrough
Laravel Tech Community
Laravel Tech Community
Jun 9, 2021 · Databases

Comprehensive Guide to SQL Syntax, Commands, and Advanced Features

This article provides a thorough overview of relational database fundamentals, SQL syntax structures, data definition and manipulation languages, transaction control, permission management, as well as detailed examples of CRUD operations, subqueries, joins, unions, functions, constraints, stored procedures, cursors, and triggers, all illustrated with practical code snippets.

DDLDMLSQL
0 likes · 23 min read
Comprehensive Guide to SQL Syntax, Commands, and Advanced Features
php Courses
php Courses
May 19, 2021 · Databases

Fundamentals of Relational Databases: Key Concepts and Common Questions

This article provides a comprehensive overview of relational database fundamentals, covering common DBMS products, SQL language components, integrity constraints, transactions, locking, views, stored procedures, indexes, normalization, key differences, constraints, optimization techniques, storage engines, and performance strategies for high‑traffic sites.

Database OptimizationRelational DatabaseTransactions
0 likes · 12 min read
Fundamentals of Relational Databases: Key Concepts and Common Questions
Selected Java Interview Questions
Selected Java Interview Questions
Apr 22, 2021 · Databases

Key MySQL Concepts: DROP/DELETE/TRUNCATE, Data Types, Storage Engines, Transactions, Views, Procedures, Indexes, UNION, and SQL Language Parts

This article explains the differences between DROP, DELETE, and TRUNCATE, recommends appropriate MySQL data types for monetary values, compares MyISAM and InnoDB storage engines, outlines transaction ACID properties, describes views, stored procedures versus triggers, indexes, UNION vs UNION ALL, and lists the main SQL language categories.

SQLStorage EnginesStored Procedures
0 likes · 10 min read
Key MySQL Concepts: DROP/DELETE/TRUNCATE, Data Types, Storage Engines, Transactions, Views, Procedures, Indexes, UNION, and SQL Language Parts
Intelligent Backend & Architecture
Intelligent Backend & Architecture
Apr 21, 2021 · Databases

Unlocking MySQL: Core Features, Architecture, and Index Optimization Explained

This comprehensive guide explores MySQL’s origins, key characteristics, logical architecture, storage engines, transaction handling, concurrency control, and detailed indexing strategies, offering practical insights and best‑practice recommendations for developers and database administrators seeking to master MySQL performance and reliability.

SQLTransactionsarchitecture
0 likes · 41 min read
Unlocking MySQL: Core Features, Architecture, and Index Optimization Explained
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Apr 10, 2021 · Databases

Comprehensive MySQL Knowledge Points and Optimization Guide

This article provides a thorough overview of MySQL fundamentals—including schema design, storage engines, transaction mechanisms, logging, indexing, and performance tuning—along with practical SQL examples, code snippets, and optimization strategies for both hardware and database configuration.

Transactionsdatabaseindexing
0 likes · 34 min read
Comprehensive MySQL Knowledge Points and Optimization Guide
Architecture Digest
Architecture Digest
Mar 21, 2021 · Databases

MySQL Interview Essentials: Indexes, Transactions, Storage Engines, and Schema Design

This article compiles a comprehensive set of MySQL interview questions covering index structures, B‑tree vs. hash trade‑offs, primary‑key and clustered‑index design, ACID properties, isolation levels, lock types, storage‑engine choices, data‑type considerations, binlog formats, pagination strategies, sharding, stored procedures, normalization, and MyBatis parameter syntax.

Database designSQL OptimizationStorage Engines
0 likes · 20 min read
MySQL Interview Essentials: Indexes, Transactions, Storage Engines, and Schema Design
Liangxu Linux
Liangxu Linux
Mar 16, 2021 · Databases

Master MySQL Transactions, Locks, and Advanced Functions: A Hands‑On Guide

This tutorial walks through MySQL's transaction control, lock statements, autocommit settings, manual commit and rollback, savepoints, differences between transactional and non‑transactional tables, SQL mode configurations, common SQL tricks, regular expressions, and a comprehensive catalog of built‑in functions, all illustrated with step‑by‑step examples and code snippets.

SQL ModeSavepointTransactions
0 likes · 25 min read
Master MySQL Transactions, Locks, and Advanced Functions: A Hands‑On Guide
360 Quality & Efficiency
360 Quality & Efficiency
Mar 5, 2021 · Databases

Asynchronous MySQL Operations with aiomysql and SQLAlchemy in Python

This tutorial explains how to perform asynchronous MySQL operations in Python using aiomysql, covering basic connections, CRUD actions, safe parameter handling to prevent SQL injection, connection pooling, transaction management, integration with SQLAlchemy for ORM queries, and a custom reconnection wrapper for resilient database access.

Connection PoolingPythonSQLAlchemy
0 likes · 38 min read
Asynchronous MySQL Operations with aiomysql and SQLAlchemy in Python
Efficient Ops
Efficient Ops
Feb 3, 2021 · Databases

Master Redis: Core Data Types, Commands, and Advanced Features Explained

This article introduces Redis as an open‑source, in‑memory data‑structure store, explains its role as a NoSQL database, details its five fundamental data types, common commands, expiration handling, pipelines, and transactions, and shows how it fits into modern scaling architectures.

Data StructuresNoSQLTransactions
0 likes · 14 min read
Master Redis: Core Data Types, Commands, and Advanced Features Explained
ITPUB
ITPUB
Jan 26, 2021 · Databases

Master MySQL Transactions, Locks, and Advanced SQL Techniques

This guide walks through MySQL's advanced features, covering lock types, transaction control commands, autocommit handling, savepoints, SQL mode configuration, regular expression usage, common SQL tricks, and a comprehensive overview of built‑in functions with practical code examples.

LocksSQL ModeTransactions
0 likes · 25 min read
Master MySQL Transactions, Locks, and Advanced SQL Techniques
Top Architect
Top Architect
Jan 22, 2021 · Databases

Debunking Common MongoDB Myths: A Comprehensive Guide

This article systematically refutes ten widespread misconceptions about MongoDB—covering scalability, versioning, data format, transactions, relationships, sharding, security, data loss, and suitability—while explaining its architecture, BSON storage, and best‑practice usage with illustrative code examples.

BSONMongoDBNoSQL
0 likes · 14 min read
Debunking Common MongoDB Myths: A Comprehensive Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 17, 2021 · Databases

Comprehensive Overview of MySQL Architecture, Logs, Indexes, Transactions, Locks, MVCC, Buffer Pool, and Optimization

This article provides an in‑depth guide to MySQL internals, covering the SQL execution process, server and storage engine layers, binlog/redo/undo logs, index structures, transaction isolation levels, lock types, MVCC implementation, buffer pool management, and practical optimization techniques.

Transactionsdatabaseindexing
0 likes · 31 min read
Comprehensive Overview of MySQL Architecture, Logs, Indexes, Transactions, Locks, MVCC, Buffer Pool, and Optimization
ITPUB
ITPUB
Dec 11, 2020 · Databases

Master MySQL: 100 Essential Q&A on Indexes, Transactions, and Design

This comprehensive guide answers the most frequent MySQL interview questions, covering index structures, transaction isolation levels, table design best practices, storage engine differences, query optimization techniques, and miscellaneous topics such as data types, binlog formats, and sharding strategies.

Database designStorage EnginesTransactions
0 likes · 23 min read
Master MySQL: 100 Essential Q&A on Indexes, Transactions, and Design