Discover | BestHub

Quick starts observability golang distributed systems kubernetes raft platform engineering

Results

Matches for “mysql”

1000 results

Databases Apr 24, 2025 Top Architect

Data Synchronization Strategies Between MySQL and Elasticsearch

This article examines why MySQL alone struggles with large‑scale, complex queries, introduces Elasticsearch as a complementary search engine, and compares several synchronization approaches—including synchronous double‑write, asynchronous double‑write, Logstash pipelines, binlog streaming, Canal, and Alibaba Cloud DTS—detailing their implementations, advantages, disadvantages, and typical use cases.

Backend DevelopmentElasticsearchMySQLData SynchronizationDatabases

Databases Apr 24, 2025 Java Captain

Why Using UUID as a Primary Key in MySQL Causes Performance Issues and How to Optimize It

This article explains why using UUID as a primary key in MySQL can degrade insert, update, and query performance due to large index size, unordered values, and frequent index splits, and offers optimization strategies such as ordered UUIDs, binary storage, combined auto‑increment keys, and table partitioning.

PerformanceOptimizationDatabaseMySQLUUIDIndexPrimary Key

Databases Apr 23, 2025 Java Tech Enthusiast

Choosing the Right Date/Time Storage in MySQL and PostgreSQL

When storing dates in MySQL or PostgreSQL, avoid VARCHAR fields and select between DATETIME (no time‑zone, larger range) and TIMESTAMP (UTC conversion, smaller range) based on whether automatic time‑zone handling and the 2038 limit suit your application, with Unix timestamps as a high‑performance alternative.

databaseMySQLdatetimetimestamptimezone

Databases Apr 23, 2025 Code Ape Tech Column

Impact of Full Table Scans on MySQL Server Memory and InnoDB Buffer Pool

A full‑table scan of a 200 GB InnoDB table on a MySQL server with 100 GB RAM does not exhaust server memory because MySQL streams rows to the client, uses a fixed net_buffer, and InnoDB’s optimized LRU algorithm limits buffer‑pool pressure, ensuring stable performance.

performanceInnoDBMySQLLRUbuffer poolfull table scan

Databases Apr 23, 2025 Zhuanzhuan Tech

Quick 3‑Step Guide to Locate and Analyze MySQL InnoDB Deadlocks

This article explains how to find the MySQL deadlock log, parse its contents to determine the time, order, and affected rows, identify the lock types and root cause, and provides extended examples of special locking scenarios, all illustrated with real‑world SQL and code snippets.

DatabasedeadlockInnoDBMySQLTroubleshooting

Databases Apr 23, 2025 Architect's Guide

Understanding MySQL Indexes: Types, B+Tree Structure, and Clustered vs. Non‑Clustered Indexes

This article explains MySQL indexes, their purpose and working principle, compares primary, ordinary, composite and full‑text indexes, describes the B+Tree storage structure versus B‑Tree, and clarifies the differences between clustered and non‑clustered (auxiliary) indexes along with their advantages and drawbacks.

PerformanceDatabaseMySQLIndexB+TreeClustered Index

Databases Apr 22, 2025 Architecture Digest

Understanding MySQL INT Display Width and ZEROFILL

This article explains why the number in MySQL's int(N) definition does not limit the column's numeric range, demonstrates that int(1) can store the full 4‑byte unsigned range, and shows how the ZEROFILL attribute adds zero‑padding for display purposes.

databaseMySQLINTZEROFILLdisplay width

Databases Apr 22, 2025 Aikesheng Open Source Community

Implementing a MySQL Configuration Comparison Script: Key Considerations and Common Pitfalls

This article explains how to build a MySQL configuration comparison script by retrieving runtime variable values, parsing my.cnf and mysqld-auto.cnf files, handling formatting and case issues, and accurately comparing values while addressing typical challenges such as unit conversion, boolean representation, and legacy variable names.

ConfigurationMySQLShelljqDatabase Administrationawkpt-config-diff

Databases Apr 19, 2025 IT Xianyu

Step-by-Step Guide to Setting Up MySQL 5.7 Master‑Slave Replication

This tutorial walks through preparing the Linux environment, installing MySQL 5.7, configuring master and slave servers, creating replication users, verifying synchronization, troubleshooting common issues, and applying advanced options such as GTID and semi‑synchronous replication, all with complete command examples.

DatabaseConfigurationLinuxMySQLMaster‑SlaveReplicationGTIDSemi‑Sync

Backend Development Apr 18, 2025 Top Architect

Optimizing XML-to-MySQL Import: Reducing Execution Time from 300 s to 4 s with Batch Processing and Multithreading

This article details how to dramatically speed up importing over 60,000 XML records into MySQL by profiling the original 300‑second implementation, enabling JDBC batch writes, configuring MySQL rewriteBatchedStatements, and applying a Disruptor‑based multithreaded pipeline, ultimately achieving sub‑5‑second runtimes with modest memory usage.

JavaPerformanceOptimizationMySQLMultithreadingDisruptorBatchProcessingXMLParsing

Previous Page 9 Next