Discover | BestHub

Quick starts observability golang distributed systems platform engineering kubernetes raft

Results

Matches for “mysql”

1000 results

Databases Apr 3, 2025 IT Xianyu

Understanding Transactions and Locks in MySQL: Concepts, Isolation Levels, and Practical Examples

This article explains how MySQL transactions and locking mechanisms ensure data consistency and handle high concurrency, covering basic transaction commands, isolation levels, practical lock implementations, deadlock simulation, and best‑practice recommendations for avoiding common concurrency problems.

DeadlockMySQLOptimistic LockPessimistic LockTransactionsLocksIsolation Levels

Databases Apr 2, 2025 Raymond Ops

How to Set Up MySQL Master‑Slave Replication (Step‑by‑Step Guide)

This guide walks you through preparing multiple virtual machines, configuring MySQL server IDs, setting up both classic and GTID‑based master‑slave replication, and managing the replication with essential commands, complete with code examples and architecture diagrams.

DatabaseMySQLMaster‑SlaveReplicationTutorialGTID

Databases Apr 2, 2025 Architect's Tech Stack

Understanding the Impact of WHERE 1=1 on MySQL Index Usage in MyBatis Queries

This article explains the purpose of using the always‑true condition “WHERE 1=1” in MyBatis SQL mappings, demonstrates through EXPLAIN queries that it does not prevent index usage, and recommends a cleaner MyBatis syntax that lets MySQL’s optimizer remove the redundant condition.

PerformanceSQLDatabaseMyBatisIndexWHERE 1=1

Databases Apr 1, 2025 Mike Chen's Internet Architecture

Understanding MySQL Optimistic Lock: Principles and Implementation

This article explains the concept of MySQL optimistic locking, its underlying version‑or‑timestamp mechanism, and provides step‑by‑step SQL examples for adding a version column, reading data, and safely updating records while handling concurrent modifications.

DatabaseMySQLConcurrency ControlOptimistic LockVersioning

Databases Apr 1, 2025 Rare Earth Juejin Tech Community

Root Cause Analysis of MySQL Index and Implicit Conversion Issue Leading to Production Failure

The article explains how an unexpected MySQL index interaction with a BIT column and implicit type conversion caused a production outage, details the investigation steps, presents the problematic SQL and table schema, and offers a quick fix by removing the offending index.

SQLMySQLIndexImplicit ConversionDatabase DebuggingBIT Type

Databases Mar 31, 2025 Architect's Tech Stack

Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL

This article investigates MySQL's recommendation to avoid UUIDs and non‑sequential keys by benchmarking insert performance of auto‑increment, UUID, and random (snowflake) primary keys, analyzing their index structures, drawbacks, and concluding that sequential auto‑increment keys provide the best overall efficiency.

JavaPerformanceIndexingMySQLAuto IncrementUUIDPrimary Key

Databases Mar 31, 2025 Aikesheng Open Source Community

Smarter Query Routing with MySQL Routing Guidelines

The article explains how MySQL Shell and MySQL Router 9.2 introduce Routing Guidelines, a declarative, context‑aware query routing feature that lets administrators define fine‑grained rules based on server roles, session attributes, and network information to improve latency, load‑balancing, and fault‑tolerance in complex MySQL topologies.

Database ArchitectureMySQLAdminAPIMySQL RouterQuery RoutingRouting Guidelines

Databases Mar 31, 2025 Lobster Programming

How Does MySQL Store Data? Inside InnoDB Files, Pages, and Row Formats

This article explains where MySQL stores its data on disk, how the InnoDB engine organizes files, pages, extents, segments, and rows, and details the Compact, Dynamic, and Compressed row formats, including null‑value handling and overflow mechanisms.

databasestorage engineInnoDBMySQLrow format

Databases Mar 29, 2025 Cognitive Technology Team

Understanding MySQL Index Merge: Types, Use Cases, and Optimization Strategies

The article explains MySQL's Index Merge optimization, detailing its three types—Intersection, Union, and Sort‑Union—when it is beneficial, how to design indexes and rewrite queries for better performance, and the associated costs and limitations.

Query OptimizationPerformance TuningMySQLDatabase IndexingIndex Merge

Databases Mar 29, 2025 Cognitive Technology Team

MySQL Multi-Range Read (MRR) Optimization: Advantages, Limitations, Use Cases, and Configuration

MySQL's Multi-Range Read (MRR) optimization reduces random disk I/O by scanning indexes, sorting keys, and retrieving rows sequentially, offering advantages like sequential data access and batch key processing, while outlining its limitations, applicable scenarios, usage conditions, and configuration via optimizer_switch variables and buffer settings.

MySQLindex optimizationquery performancedisk I/OMRR

Previous Page 14 Next