Discover | BestHub

Quick starts observability distributed systems platform engineering kubernetes golang raft

Results

Matches for “mysql”

1000 results

Databases May 3, 2025 Full-Stack Internet Architecture

MySQL Trailing Space Issue: Unexpected Matching of Strings with Trailing Spaces

An investigation reveals that MySQL treats trailing spaces in VARCHAR values as insignificant during string comparison, causing queries like SELECT * WHERE name='Tom' to match rows with extra spaces, and demonstrates that using the BINARY keyword restores exact matching, highlighting a potential bug in MySQL 5.7.

mysqlbugdatabasesbinarystring-comparisontrailing-space

Databases May 2, 2025 Java Captain

Implementing Dynamic MySQL Master‑Slave Switching in SpringBoot Using AOP and Custom Annotations

This article demonstrates how to use SpringBoot 3.0.4 with AOP and a custom @DataSource annotation to dynamically switch between MySQL master and slave databases, ensuring high availability by automatically falling back to the master when a slave fails, and provides configuration and code examples for multiple data sources.

AOPMySQLSpringBootDatabase SwitchingDynamic DataSource

Databases May 2, 2025 Full-Stack Internet Architecture

Demonstrating MySQL Deadlock with a Practical Example

This article explains MySQL deadlocks by creating a test table, running two concurrent transactions—one using SLEEP to hold a lock and another attempting the same resource—to reproduce a deadlock error, and discusses how this approach aids debugging and understanding of transaction conflicts.

DebuggingSQLTransactionDatabaseDeadlockMySQL

Databases May 1, 2025 Full-Stack Internet Architecture

Common Scenarios Where MySQL Indexes Fail

This article explains various situations that cause MySQL indexes to become ineffective—such as leading wildcard LIKE queries, calculations on indexed columns, use of functions, data type mismatches, improper use of composite indexes, and character set differences—providing example SQL, execution plans, and practical testing steps.

SQLPerformance TuningMySQLDatabase OptimizationIndex

Databases May 1, 2025 Cognitive Technology Team

MySQL Optimization Strategies for Read‑Heavy and Write‑Heavy Scenarios

This article systematically examines MySQL optimization techniques for both read‑many/write‑few and write‑many/read‑few business scenarios, covering architecture design, caching, sharding, asynchronous processing, monitoring, and emerging NewSQL/HTAP solutions to achieve high performance, consistency, and scalability.

ShardingCachingPerformance TuningMySQLDatabase OptimizationRead‑Write Splitting

Databases Apr 29, 2025 Architect

Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration

A real‑world MySQL data‑migration case study shows how using INSERT INTO SELECT without proper indexing caused a full table scan, OOM errors, and data loss, and explains how to avoid the pitfall by adding appropriate indexes and understanding transaction locking.

Data MigrationIndexingMySQLINSERT INTO SELECTDatabase PerformanceFull Table ScanTransaction Locking

Backend Development Apr 28, 2025 Top Architect

Replacing MyBatis with MyBatis-Plus: Debugging LocalDateTime Conversion Errors and MySQL Connector Upgrades

The article walks through migrating an old MySQL‑5.7 project from MyBatis 3.5.0 to MyBatis‑Plus 3.1.1, diagnosing a LocalDateTime conversion exception caused by an outdated mysql‑connector‑java driver, and resolves it by upgrading the driver version, highlighting the need for careful component compatibility checks.

JavaBackend DevelopmentMySQLORMMyBatis-PlusLocalDateTime

Databases Apr 28, 2025 php中文网 Courses

Python Database Programming: SQLite and MySQL Basics

This tutorial explains how to use Python's sqlite3 module and MySQL connectors to perform essential database operations such as connecting, creating tables, inserting, querying, updating, deleting records, and managing transactions for both SQLite and MySQL.

pythonsqltransactiondatabasemysqlsqlite

Databases Apr 27, 2025 360 Zhihui Cloud Developer

Why MySQL Memory Stays High and How to Optimize It

This article explains MySQL's memory architecture, why memory usage often stays high after spikes, and provides practical steps—including connection checks, slow query analysis, workload scaling, and switching to jemalloc—to diagnose and reduce memory consumption on 360's internal cloud platform.

Memory OptimizationMySQLDatabase PerformancejemallocConnection Management

Databases Apr 25, 2025 Architect's Guide

Solutions for MySQL Auto Increment ID Exhaustion

This article discusses the problem of MySQL auto‑increment ID exhaustion and presents six practical solutions—including changing column type to BIGINT, using UUIDs, segmenting ID generation, composite keys, adjusting auto‑increment steps, and database sharding—to ensure scalability and uniqueness.

ShardingMySQLDatabase DesignAuto IncrementUUIDID Exhaustion

Previous Page 8 Next