Storage Engines

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.

Data ModelsDistributed DatabasesReplication

0 likes · 29 min read

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

Architect

Jul 21, 2021 · Databases

MySQL 100 Interview Questions: Indexes, Transactions, Table Design, and Storage Engines

This article compiles 100 common MySQL interview questions for developers, covering index structures and optimization, transaction ACID properties and isolation levels, primary‑key design, storage‑engine choices, sharding strategies, and miscellaneous SQL nuances such as binlog formats and MyBatis parameter handling.

Database DesignIndexesMySQL

0 likes · 20 min read

MySQL 100 Interview Questions: Indexes, Transactions, Table Design, and Storage Engines

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.

DatabaseIndexesMySQL

0 likes · 10 min read

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

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 DesignIndexesMySQL

0 likes · 20 min read

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

Architecture Digest

Oct 15, 2020 · Databases

Understanding MySQL Indexes: B‑Tree, B+Tree, and Index Design Principles

This article explains how MySQL indexes work, compares binary trees, B‑Tree and B+Tree structures, describes their implementation in MyISAM and InnoDB storage engines, and provides practical guidelines for creating efficient single‑column, composite, and covering indexes to improve query performance.

B+ TreeDatabase OptimizationIndexes

0 likes · 17 min read

Understanding MySQL Indexes: B‑Tree, B+Tree, and Index Design Principles

Selected Java Interview Questions

Jun 8, 2020 · Databases

Comprehensive MySQL Interview Guide: Concepts, Indexes, Transactions, Storage Engines, and Optimization

This article provides an extensive overview of MySQL fundamentals for interview preparation, covering primary key concepts, index types and usage, transaction properties and isolation levels, storage engine differences, query execution order, performance tuning with EXPLAIN, lock mechanisms, replication strategies, and high‑concurrency solutions.

DatabaseIndexesMySQL

0 likes · 49 min read

Comprehensive MySQL Interview Guide: Concepts, Indexes, Transactions, Storage Engines, and Optimization

Java Captain

Aug 6, 2019 · Databases

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

This article presents a comprehensive MySQL interview guide covering index types and optimization, transaction concepts and isolation levels, table schema design best practices, storage engine differences, and common performance issues such as large pagination and slow query analysis.

IndexesMySQLPerformance Tuning

0 likes · 20 min read

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

Java Architect Essentials

Jun 10, 2018 · Databases

MySQL Storage Engines, Lock Types, and Security Practices

This article explains the different MySQL storage engines, describes the various lock types and their granularity, and provides a comprehensive list of practical measures to improve MySQL security and protect the database from common attacks.

DatabaseLocksMySQL

0 likes · 14 min read

MySQL Storage Engines, Lock Types, and Security Practices

Efficient Ops

Aug 27, 2017 · Databases

Master MySQL: Core Scenarios, Engines, and Performance Optimization

This article provides a comprehensive overview of MySQL, covering its primary application scenarios, architecture diagram, detailed storage engine characteristics, factors influencing server performance, lock mechanisms, query and schema optimization techniques, scalability strategies such as data sharding, and the role of caching and search technologies.

MySQLQuery OptimizationSchema Design

0 likes · 22 min read

Master MySQL: Core Scenarios, Engines, and Performance Optimization

Architecture Digest

Nov 28, 2016 · Databases

Fundamentals of Data Storage: Engines, Models, Transactions, Distributed Design, and Redundancy

This article explains the importance of data storage, describes single‑node storage engines and data models, outlines transaction and concurrency control, and covers distributed storage principles, CAP and FLP theorems, 2PC and Paxos protocols, as well as redundancy, backup, and failover mechanisms.

2PCBackupCAP theorem

0 likes · 8 min read

Fundamentals of Data Storage: Engines, Models, Transactions, Distributed Design, and Redundancy

Qunar Tech Salon

Mar 11, 2015 · Databases

MongoDB 3.0 Release Highlights and New Features

MongoDB 3.0 introduces a pluggable storage engine API with WiredTiger support, expands backup set capacity, adds sharding enhancements, improves security with SCRAM‑SHA‑1 authentication, and upgrades tooling and logging, while retaining MMAPv1 as the default engine.

BackupMongoDBSharding

0 likes · 4 min read

MongoDB 3.0 Release Highlights and New Features