BestHub
Sign in
Tagged articles
5000 articles
Page 45 of 50
Tencent Database Technology
Tencent Database Technology
Aug 4, 2020 · Databases

Root Cause Analysis of MySQL OOM in Tencent Cloud CDB Instances

This article details a comprehensive investigation of MySQL out‑of‑memory (OOM) alerts on a Tencent Cloud CDB instance during a high‑traffic marketing event, covering background, observed symptoms, step‑by‑step debugging, analysis of server and engine memory usage, relevant MySQL bugs, fetch_cache behavior, and the final configuration recommendations to prevent OOM.

Database OptimizationOOMPerformance Schema
0 likes · 14 min read
Root Cause Analysis of MySQL OOM in Tencent Cloud CDB Instances
21CTO
21CTO
Aug 3, 2020 · Databases

Transparent Data Encryption: How It Secures Databases, Pros & Cons

This article explains how Transparent Data Encryption (TDE) protects sensitive data in databases by encrypting pages with keys stored in a secure vault, outlines its advantages and drawbacks, and compares page-level encryption with column-level approaches.

Key VaultTransparent Data Encryptiondatabase encryption
0 likes · 6 min read
Transparent Data Encryption: How It Secures Databases, Pros & Cons
Ziru Technology
Ziru Technology
Aug 3, 2020 · Databases

Unlocking MySQL Binlog: How Replication, Recovery, and Auditing Really Work

This article explains the MySQL binary log (binlog), its structure and contents, the three main uses—point‑in‑time recovery, master‑slave replication, and audit logging—followed by a detailed walkthrough of the replication process, an overview of Alibaba's Canal mechanism, and extensive code examples illustrating binlog parsing and event handling.

CanalReplicationmysql
0 likes · 12 min read
Unlocking MySQL Binlog: How Replication, Recovery, and Auditing Really Work
Top Architect
Top Architect
Aug 3, 2020 · Databases

Case Study: Insert‑Into‑Select Migration Failure and Resolution in MySQL

This article analyzes a real‑world MySQL incident where using INSERT INTO SELECT to migrate billions of rows caused table‑wide locking and payment failures, explains the underlying locking behavior, and presents a solution using proper indexing and FORCE INDEX to avoid full‑table scans.

INSERT INTO SELECTSQL Performanceindexing
0 likes · 7 min read
Case Study: Insert‑Into‑Select Migration Failure and Resolution in MySQL
Laravel Tech Community
Laravel Tech Community
Aug 2, 2020 · Databases

MySQL Database Design and SQL Writing Standards

This document outlines comprehensive MySQL database design standards and SQL writing guidelines, covering naming conventions, character sets, table and column specifications, index design, partitioning, data types, transaction handling, and prohibited statements to ensure stable, performant, and maintainable production databases.

PartitioningSQL Standardsindexing
0 likes · 18 min read
MySQL Database Design and SQL Writing Standards
MaGe Linux Operations
MaGe Linux Operations
Aug 1, 2020 · Databases

What Are the Core Components of MySQL? A Deep Dive

This article breaks down MySQL’s architecture into its five key parts—connector, parser, optimizer, executor, and storage engine—explaining each component’s role from establishing connections and handling permissions to query parsing, execution planning, and data storage, with example commands and code snippets.

Database ArchitectureQuery Processingmysql
0 likes · 3 min read
What Are the Core Components of MySQL? A Deep Dive
Liangxu Linux
Liangxu Linux
Aug 1, 2020 · Databases

Why MySQL’s “utf8” Isn’t Real UTF‑8 and How utf8mb4 Fixes It

The article explains that MySQL’s legacy "utf8" charset only supports three‑byte sequences, causing errors with true four‑byte Unicode characters, and shows how the later "utf8mb4" charset provides proper UTF‑8 support along with historical context and migration guidance.

Character SetMariaDBencoding
0 likes · 8 min read
Why MySQL’s “utf8” Isn’t Real UTF‑8 and How utf8mb4 Fixes It
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 30, 2020 · Databases

Using gh-ost for Online MySQL Schema Migration – Introduction, Architecture, Installation, and Practical Usage

This article provides a comprehensive guide to gh-ost, the GitHub‑released online MySQL schema migration tool, covering its design principles, three migration modes, download and RPM installation, common command‑line options, interactive socket commands, and a step‑by‑step example of altering a column type while monitoring progress and performing a safe cut‑over.

Database ToolsLinuxSchema Change
0 likes · 25 min read
Using gh-ost for Online MySQL Schema Migration – Introduction, Architecture, Installation, and Practical Usage
Programmer DD
Programmer DD
Jul 30, 2020 · Databases

Why Is MySQL Consuming CPU? Identify Culprits and Optimize Performance

Understanding CPU usage in MySQL involves recognizing that user processes, IO waits, and system interrupts dominate consumption, and by reducing IO, optimizing queries, indexing, and minimizing costly calculations, you can lower CPU load, improve throughput, and avoid performance bottlenecks.

CPU optimizationdatabasemysql
0 likes · 5 min read
Why Is MySQL Consuming CPU? Identify Culprits and Optimize Performance
ITPUB
ITPUB
Jul 28, 2020 · Databases

Why MySQL Binlog Can Cause Order Fulfillment Delays and How to Fix It

This article explains MySQL Binlog’s role in event‑driven order processing, analyzes hidden pitfalls such as premature Binlog reads and two‑phase commit issues, and offers practical solutions like retry strategies and direct Binlog consumption to ensure data consistency.

Database LogsEvent-Driven Architecturemysql
0 likes · 14 min read
Why MySQL Binlog Can Cause Order Fulfillment Delays and How to Fix It
Programmer DD
Programmer DD
Jul 28, 2020 · Databases

Designing Scalable Like/Comment Systems: MySQL vs Redis Strategies

This article explores the requirements and database design patterns for implementing likes, comments, and favorites in apps, comparing traditional MySQL schemas with Redis‑based storage and caching solutions, and discusses their trade‑offs, scalability, and data consistency considerations.

ConsistencyDatabase designlikes
0 likes · 8 min read
Designing Scalable Like/Comment Systems: MySQL vs Redis Strategies
Programmer DD
Programmer DD
Jul 27, 2020 · Databases

Boost MySQL Performance: Bulk Insert, GROUP BY, ORDER BY, and OR Query Optimizations

This article presents practical MySQL performance tricks, covering bulk data insertion with DISABLE/ENABLE KEYS, loading data in primary‑key order, multi‑value INSERTs, INSERT DELAYED, separating index and data files, GROUP BY sorting elimination, index‑driven ORDER BY, OR‑condition indexing, replacing sub‑queries with JOINs, and using SQL hints such as USE, IGNORE, and FORCE INDEX.

Bulk InsertSQL Optimizationindexing
0 likes · 14 min read
Boost MySQL Performance: Bulk Insert, GROUP BY, ORDER BY, and OR Query Optimizations
IT Architects Alliance
IT Architects Alliance
Jul 27, 2020 · Industry Insights

Future of Databases: Oracle, DB2, SAP HANA, MySQL & NoSQL Trends

The article provides a comprehensive analysis of major relational databases—Oracle, DB2, SAP HANA, MySQL, PostgreSQL—and emerging NoSQL solutions, examining their underlying technologies, recent developments, market adoption, and the overall industry landscape shaping the future of data storage.

NoSQLOracledatabases
0 likes · 3 min read
Future of Databases: Oracle, DB2, SAP HANA, MySQL & NoSQL Trends
JavaEdge
JavaEdge
Jul 26, 2020 · Databases

How to Choose and Use Prefix Indexes for String Columns in MySQL

This article explains why and how to create prefix indexes for string fields in MySQL, compares full‑column and prefix indexes with concrete examples, shows how to pick an optimal prefix length using cardinality statistics, and discusses alternative solutions such as reverse storage and hash fields.

Database OptimizationPrefix Indexindexing
0 likes · 12 min read
How to Choose and Use Prefix Indexes for String Columns in MySQL
Big Data Technology & Architecture
Big Data Technology & Architecture
Jul 26, 2020 · Databases

Overview of Canal, Maxwell, Databus, and Alibaba Cloud DTS for MySQL Binlog‑Based Change Data Capture

This article introduces several MySQL binlog-based change data capture solutions—including Canal, Maxwell, Databus, and Alibaba Cloud's Data Transmission Service—explaining their principles, architecture, features, and usage considerations for incremental data subscription and processing.

BinlogCanalChange Data Capture
0 likes · 6 min read
Overview of Canal, Maxwell, Databus, and Alibaba Cloud DTS for MySQL Binlog‑Based Change Data Capture
Laravel Tech Community
Laravel Tech Community
Jul 25, 2020 · Databases

Comprehensive Guide to MySQL Optimization: Philosophy, Tools, and Practical Steps

This article presents a thorough overview of MySQL optimization, covering the query execution process, philosophical principles, risk assessment, required participants, optimization dimensions, commonly used diagnostic tools, emergency and regular tuning procedures, hardware and system level adjustments, as well as detailed configuration parameters for both the server and the database engine.

Database Optimizationmysqlperformance tuning
0 likes · 14 min read
Comprehensive Guide to MySQL Optimization: Philosophy, Tools, and Practical Steps
JavaEdge
JavaEdge
Jul 25, 2020 · Databases

Should You Use Unique Indexes in MySQL? Performance Impact of Change Buffer

This article explains the differences between normal and unique indexes in MySQL, examines how they affect query and update performance, details InnoDB's change‑buffer mechanism, and provides practical guidance on when to prefer ordinary indexes for better write efficiency.

Change BufferInnoDBUnique Index
0 likes · 13 min read
Should You Use Unique Indexes in MySQL? Performance Impact of Change Buffer
21CTO
21CTO
Jul 23, 2020 · Databases

How to Achieve 570,000 Writes/sec in MySQL with TokuDB

This article explains how a friend loaded over 2 billion rows into MySQL using XeLabs TokuDB, detailing configuration, bulk‑load commands, benchmark results of roughly 574 k rows per second, and comparisons with InnoDB performance on a cloud server.

Database OptimizationTokuDBbulk load
0 likes · 6 min read
How to Achieve 570,000 Writes/sec in MySQL with TokuDB
ITPUB
ITPUB
Jul 23, 2020 · Databases

How to Achieve 570,000 MySQL Writes per Second with TokuDB

This article details a real‑world test that loads 200 million rows into a MySQL TokuDB table in under six minutes, achieving roughly 570 k writes per second, and compares the results with InnoDB while providing configuration tips and bulk‑loader considerations.

Database OptimizationHigh ThroughputTokuDB
0 likes · 6 min read
How to Achieve 570,000 MySQL Writes per Second with TokuDB
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 22, 2020 · Databases

Comprehensive Guide to MySQL Storage Engines, Data Types, Indexes, Views, Stored Procedures, and Triggers

This article provides an in‑depth overview of MySQL, covering storage engine concepts, selecting appropriate data types, index design and usage, view creation, stored procedure syntax, variable handling, and trigger implementation, with practical examples and SQL code snippets to illustrate each topic.

Data TypesStorage EngineStored Procedures
0 likes · 25 min read
Comprehensive Guide to MySQL Storage Engines, Data Types, Indexes, Views, Stored Procedures, and Triggers
ITPUB
ITPUB
Jul 22, 2020 · Databases

How to Achieve 570,000 Writes per Second in MySQL with TokuDB

This article explains how to load over 20 billion rows into MySQL using the XeLabs‑compiled TokuDB engine, detailing configuration tweaks, table schema, bulk‑loader commands, benchmark results that reach 574 k rows per second, and practical tips for handling auto‑increment keys.

Database OptimizationTokuDBbulk load
0 likes · 7 min read
How to Achieve 570,000 Writes per Second in MySQL with TokuDB
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 22, 2020 · Databases

Understanding and Resolving MySQL Character Set and Data Corruption Issues

This article explains why MySQL data can become garbled due to mismatched character sets during insertion or retrieval, explores various scenarios such as client‑side encoding errors, mixed encodings within tables, and LATIN1 storage, and provides detailed solutions including setting proper client encodings, using strict SQL_MODE, and exporting/importing data to unify character sets.

Character SetData Corruptionencoding
0 likes · 15 min read
Understanding and Resolving MySQL Character Set and Data Corruption Issues
Programmer DD
Programmer DD
Jul 22, 2020 · Big Data

How to Sync Billions of MySQL Records to HBase: 3 Powerful Methods Using Hadoop, Kafka, and Flink

This comprehensive guide walks you through setting up a pseudo‑distributed Hadoop environment, loading massive MySQL data with LOAD DATA, Python scripts, and multithreading, and then synchronizing the data to HBase using three approaches—Sqoop, a Kafka‑Thrift pipeline, and a real‑time Kafka‑Flink pipeline—while also comparing query performance of HBase and Phoenix.

FlinkHBaseKafka
0 likes · 28 min read
How to Sync Billions of MySQL Records to HBase: 3 Powerful Methods Using Hadoop, Kafka, and Flink
JavaEdge
JavaEdge
Jul 21, 2020 · Databases

Mastering MySQL Row Locks: Two‑Phase Locking, Deadlocks & Performance Tips

This article explains how MySQL implements row‑level locking, the two‑phase locking protocol, common deadlock scenarios with online ticket sales, and practical strategies—including lock ordering, deadlock detection settings and sharding tricks—to improve concurrency and reduce CPU overhead.

deadlockmysqlrow lock
0 likes · 9 min read
Mastering MySQL Row Locks: Two‑Phase Locking, Deadlocks & Performance Tips
Top Architect
Top Architect
Jul 21, 2020 · Databases

Why MySQL’s “utf8” Is Not Real UTF‑8 and You Should Use utf8mb4

The article explains that MySQL’s legacy “utf8” character set only supports three‑byte sequences and therefore cannot store true UTF‑8 characters, describes the historical reasons behind this limitation, and advises all MySQL/MariaDB users to migrate to the proper utf8mb4 charset.

Character SetMariaDBdatabase
0 likes · 12 min read
Why MySQL’s “utf8” Is Not Real UTF‑8 and You Should Use utf8mb4
Java Backend Technology
Java Backend Technology
Jul 21, 2020 · Databases

Boost MySQL Pagination Speed: Proven Techniques and Benchmarks

This article examines why full‑table scans on massive MySQL tables are slow, explains standard LIMIT‑based pagination, and presents several optimization strategies—including sub‑queries, ID‑range filtering, and temporary tables—backed by concrete performance measurements.

mysqlperformancequery optimization
0 likes · 10 min read
Boost MySQL Pagination Speed: Proven Techniques and Benchmarks
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 20, 2020 · Databases

InnoDB Cluster Built-in Functions: A Practical Guide for MySQL Group Replication Management

This tutorial walks through the test environment and demonstrates how InnoDB Cluster's built‑in functions—such as get_cluster, describe, list_routers, set_option, options, set_instance_option, set_primary_instance, switch_to_multi_primary_mode, switch_to_single_primary_mode, status, and dissolve—simplify the deployment, monitoring, and administration of MySQL group replication, complete with code snippets and visual results.

Group ReplicationInnoDB ClusterPython
0 likes · 10 min read
InnoDB Cluster Built-in Functions: A Practical Guide for MySQL Group Replication Management
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 20, 2020 · Databases

MySQL Master‑Slave Replication: Principles, Setup Guide, and Interview Questions

This article explains MySQL master‑slave replication, covering its concepts, asynchronous replication mechanisms, various synchronization strategies, step‑by‑step installation and configuration on CentOS 7, and includes common interview questions with answers; it also provides practical commands, troubleshooting tips, and performance considerations for read‑write separation in production environments.

CentOSMaster‑SlaveReplication
0 likes · 15 min read
MySQL Master‑Slave Replication: Principles, Setup Guide, and Interview Questions
MaGe Linux Operations
MaGe Linux Operations
Jul 19, 2020 · Databases

Optimizing Zabbix with MySQL: Version Tips, Permissions, and Partitioning Strategies

This guide details recommended MySQL versions for Zabbix, proper grant statements for read/write and read‑only users, essential MySQL configuration tweaks, SQL techniques for item and function updates, read‑write splitting, upgrade procedures, backup strategies, and comprehensive partition maintenance scripts to improve performance and manage data growth.

Zabbixdatabase partitioningmysql
0 likes · 14 min read
Optimizing Zabbix with MySQL: Version Tips, Permissions, and Partitioning Strategies
Architect's Tech Stack
Architect's Tech Stack
Jul 19, 2020 · Databases

MySQL Pagination Query Optimization Techniques and Performance Testing

This article explains various MySQL pagination methods—including simple LIMIT queries, sub‑query optimizations, ID‑range filtering, and temporary‑table approaches—provides detailed performance measurements on a large order_history table, and concludes with practical recommendations while also promoting a comprehensive interview‑question PDF collection.

Database Optimizationmysqlperformance
0 likes · 10 min read
MySQL Pagination Query Optimization Techniques and Performance Testing
ITPUB
ITPUB
Jul 18, 2020 · Databases

Why MySQL 5.7 Auto‑Increment Duplicates After Upgrade and How to Diagnose It

After upgrading a MySQL 5.6 master to 5.7, inserts on several InnoDB tables began failing with duplicate‑key errors because the auto_increment value became inconsistent, and the article walks through kernel‑level investigation, reproduction steps, bug analysis, and practical fixes.

BinlogBug AnalysisDuplicate Key
0 likes · 11 min read
Why MySQL 5.7 Auto‑Increment Duplicates After Upgrade and How to Diagnose It
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 17, 2020 · Databases

Comprehensive MySQL Tutorial: Basics, Data Types, Operators, Functions, and Queries

This article provides a thorough, step‑by‑step guide to MySQL, covering how to install and start the server, create databases and tables, use DDL/DML/DQL statements, understand numeric, date/time and string data types, apply arithmetic, comparison, logical and bitwise operators, and leverage common built‑in functions for efficient data manipulation.

Data Typesdatabasefunctions
0 likes · 38 min read
Comprehensive MySQL Tutorial: Basics, Data Types, Operators, Functions, and Queries
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 16, 2020 · Databases

Comprehensive Guide to MySQL Optimization: Table Design, Indexes, Partitioning, and Read/Write Splitting

This article provides a thorough overview of MySQL performance tuning, covering proper table design according to the three normal forms, various index types and their creation, partitioning strategies, read/write separation, storage engine selection, and practical SQL tips for improving query efficiency.

Database OptimizationPartitioningindexing
0 likes · 14 min read
Comprehensive Guide to MySQL Optimization: Table Design, Indexes, Partitioning, and Read/Write Splitting
JavaEdge
JavaEdge
Jul 15, 2020 · Databases

Understanding MySQL Transaction Isolation Levels and Best Practices

This article explains MySQL transaction isolation concepts, the four standard isolation levels, their effects on dirty, non‑repeatable, and phantom reads, practical configuration steps, when to use repeatable read, how InnoDB implements isolation, and tips for avoiding long transactions and planning backups.

InnoDBIsolation Leveldatabase
0 likes · 8 min read
Understanding MySQL Transaction Isolation Levels and Best Practices
ITPUB
ITPUB
Jul 15, 2020 · Databases

Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization

This guide compiles essential MySQL optimization techniques—including index cardinality, function indexes, EXPLAIN usage, covering indexes, ICP, slow‑query log analysis, online schema changes, and common SQL pitfalls—to help developers efficiently tune database performance.

Database Optimizationexplainindexes
0 likes · 19 min read
Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization
dbaplus Community
dbaplus Community
Jul 14, 2020 · Databases

How to Install and Configure MyCat 1.6.5 for a Distributed MySQL Cluster

This guide walks through installing MySQL nodes, Java, and MyCat 1.6.5, configuring schemas, data nodes, sharding rules, adjusting ports, adding users, and verifying the MyCat service, providing complete code snippets and troubleshooting tips for a functional distributed database middleware setup.

ConfigurationInstallationMycat
0 likes · 16 min read
How to Install and Configure MyCat 1.6.5 for a Distributed MySQL Cluster
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 14, 2020 · Databases

Key Features of MySQL 8.0.21 Release

MySQL 8.0.21 introduces numerous enhancements such as dynamic redo log control, optional tablespace path validation, refined lock system, JSON_VALUE function, atomic CREATE TABLE…AS SELECT, optimizer improvements, reduced group replication cache, multi‑address X Plugin support, and various security and deprecation updates.

GroupReplicationInnoDBJSON
0 likes · 12 min read
Key Features of MySQL 8.0.21 Release
MaGe Linux Operations
MaGe Linux Operations
Jul 13, 2020 · Databases

Automate MySQL Master‑Slave Setup with Python and Paramiko

This guide walks through preparing the environment, configuring the master and slave MySQL servers, and using Python's Paramiko library to automate SSH commands, edit configuration files, restart services, and verify replication, all while handling common pitfalls.

Database AdministrationMariaDBParamiko
0 likes · 5 min read
Automate MySQL Master‑Slave Setup with Python and Paramiko
21CTO
21CTO
Jul 12, 2020 · Backend Development

Master Deno.js: Build a Full‑Stack MySQL CRUD API

This tutorial introduces Deno.js, explains its security‑first runtime features, compares it with Node.js, and walks through building a complete MySQL‑backed CRUD REST API using TypeScript, covering installation, code structure, and execution steps.

BackendCRUDDeno
0 likes · 11 min read
Master Deno.js: Build a Full‑Stack MySQL CRUD API
21CTO
21CTO
Jul 10, 2020 · Databases

Why MySQL 5.7 Upgrade Triggers Duplicate Key Errors on Auto‑Increment?

After upgrading a critical MySQL client from 5.6 to 5.7, duplicate‑key errors appeared during inserts on master, replica and read‑only instances, prompting a deep dive into InnoDB auto‑increment mechanics, related kernel bugs, on‑site analysis, and both application‑side and engine‑side remediation strategies.

Bug AnalysisDuplicate KeyInnoDB
0 likes · 12 min read
Why MySQL 5.7 Upgrade Triggers Duplicate Key Errors on Auto‑Increment?
21CTO
21CTO
Jul 9, 2020 · Databases

How to Optimize Large MySQL Tables: Index Tuning, Online DDL, and Efficient Deletion

This article walks through diagnosing severe SLA alerts caused by slow queries on a massive MySQL table, analyzes query patterns with pt‑query‑digest, redesigns indexes, applies online DDL and pt‑osc for index changes, and demonstrates batch‑delete techniques that dramatically reduce execution time and replication lag.

Batch DeleteIndex OptimizationLarge Tables
0 likes · 15 min read
How to Optimize Large MySQL Tables: Index Tuning, Online DDL, and Efficient Deletion
Selected Java Interview Questions
Selected Java Interview Questions
Jul 9, 2020 · Databases

Implementing MySQL Read/Write Splitting with Spring Boot, MyBatis, and MyCat Middleware

This tutorial explains two approaches to achieve MySQL read/write splitting—first by manually implementing routing logic in Spring Boot with MyBatis interceptors and dynamic data sources, and second by configuring the MyCat middleware for automatic load balancing, fault‑tolerance, and multi‑node support, complete with code samples and configuration files.

MyBatisMycatReadWriteSplitting
0 likes · 26 min read
Implementing MySQL Read/Write Splitting with Spring Boot, MyBatis, and MyCat Middleware
FunTester
FunTester
Jul 9, 2020 · Backend Development

Multithreaded Test Case Execution and Database Standards

The article shares practical experiences on running test cases concurrently using Java multithreading and a custom thread pool, and outlines MySQL database naming, null handling, and schema design guidelines, including full code examples for the case runner and thread pool implementation.

Database designThreadPooljava
0 likes · 7 min read
Multithreaded Test Case Execution and Database Standards
dbaplus Community
dbaplus Community
Jul 8, 2020 · Databases

Why MySQL Uses B+ Trees: A Step‑by‑Step Dive into Index Data Structures

This article walks through the evolution of MySQL index implementations—from hash tables and binary search trees to AVL, red‑black, B‑trees and finally B+ trees—explaining their performance trade‑offs, disk‑I/O considerations, and how InnoDB and MyISAM store data and indexes differently.

B+TreeDataStructureInnoDB
0 likes · 21 min read
Why MySQL Uses B+ Trees: A Step‑by‑Step Dive into Index Data Structures
Java Architecture Diary
Java Architecture Diary
Jul 7, 2020 · Databases

Automatically Generate Comprehensive Database Docs with Screw

This article introduces the Screw plugin, a lightweight tool that automates database table structure documentation across multiple databases, supports various output formats, and can be configured via custom Java code or a Maven plugin to streamline enterprise development workflows.

Maven Plugincode-generationdatabase documentation
0 likes · 5 min read
Automatically Generate Comprehensive Database Docs with Screw
Java Backend Technology
Java Backend Technology
Jul 7, 2020 · Databases

Why Your SQL Queries Are Slow: 10 Hidden Factors and How to Fix Them

This article analyzes the various system‑level and database‑level reasons why SELECT, UPDATE, INSERT, or DELETE statements become slow, covering network issues, OS and hardware constraints, MySQL configuration, indexing, execution plans, and query design, and offers practical mitigation strategies.

databasemysqlslow-query
0 likes · 18 min read
Why Your SQL Queries Are Slow: 10 Hidden Factors and How to Fix Them
Architect's Alchemy Furnace
Architect's Alchemy Furnace
Jul 6, 2020 · Databases

Mastering MySQL HA: Step‑by‑Step MHA Setup and Failover Guide

This article walks through preparing a four‑node MySQL environment, configuring password‑less SSH, setting up master‑slave replication with GTID, installing and configuring MHA, testing connectivity, running the manager, verifying automatic failover, and highlighting the key advantages of using MHA for high availability.

Database operationsGTIDMHA
0 likes · 24 min read
Mastering MySQL HA: Step‑by‑Step MHA Setup and Failover Guide
Laravel Tech Community
Laravel Tech Community
Jul 5, 2020 · Databases

Understanding Auto‑Increment Gaps with REPLACE INTO and INSERT … ON DUPLICATE KEY UPDATE in MySQL

This article examines why MySQL auto‑increment primary keys can jump unexpectedly when using REPLACE INTO or INSERT … ON DUPLICATE KEY UPDATE, explains the role of innodb_autoinc_lock_mode, demonstrates examples, and offers practical solutions to prevent uncontrolled ID growth.

INSERT ON DUPLICATE KEY UPDATEREPLACE INTOauto_increment
0 likes · 11 min read
Understanding Auto‑Increment Gaps with REPLACE INTO and INSERT … ON DUPLICATE KEY UPDATE in MySQL
JavaEdge
JavaEdge
Jul 4, 2020 · Databases

How MySQL Executes a Query: From Connection to Execution Engine

This article explains MySQL’s internal workflow, covering the Server layer components, Storage Engine layer, connection handling, query cache behavior, lexical and syntax parsing, optimization decisions, and execution steps, including tips for long‑connection management and common pitfalls.

Connection ManagementDatabase InternalsQuery Execution
0 likes · 9 min read
How MySQL Executes a Query: From Connection to Execution Engine
Selected Java Interview Questions
Selected Java Interview Questions
Jul 3, 2020 · Databases

Understanding MySQL Index Structures: From Simple Tables to B+ Trees

This article explains how MySQL stores data using pages, page directories, and multi‑page structures, demonstrates why MySQL silently sorts rows on insert, and shows how these mechanisms combine into the B+‑tree index that optimizes query performance and supports clustering, non‑clustering, and composite indexes.

B+TreeComposite IndexDatabase Pages
0 likes · 24 min read
Understanding MySQL Index Structures: From Simple Tables to B+ Trees
MaGe Linux Operations
MaGe Linux Operations
Jul 2, 2020 · Databases

Mastering MySQL Benchmarking with Sysbench: A Complete Guide

This article explains MySQL benchmark testing, the role and metrics of benchmarking, introduces sysbench, provides step‑by‑step installation and usage instructions, and offers practical tips for interpreting results and optimizing database performance in production environments.

BenchmarkingPerformance TestingSysbench
0 likes · 11 min read
Mastering MySQL Benchmarking with Sysbench: A Complete Guide
Efficient Ops
Efficient Ops
Jul 1, 2020 · Databases

Essential MySQL Naming, Design, and Indexing Standards for Reliable Databases

This guide outlines comprehensive MySQL best practices covering naming conventions, table engine and charset choices, field type selection, index design principles, common index column recommendations, ordering of composite indexes, avoidance of redundant and foreign‑key constraints, SQL development rules, and operational guidelines for large‑scale data handling.

Database designIndex OptimizationSQL Best Practices
0 likes · 21 min read
Essential MySQL Naming, Design, and Indexing Standards for Reliable Databases
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 30, 2020 · Databases

MySQL View Optimization: Fixing Slow Query Caused by Character Set Conversion

This article analyzes a slow MySQL view query caused by mismatched character sets, demonstrates how the automatic charset conversion prevents index usage, and shows step‑by‑step how altering the table charset and removing the conversion restores index usage and reduces execution time from seconds to fractions of a second.

SQL OptimizationViewindex
0 likes · 7 min read
MySQL View Optimization: Fixing Slow Query Caused by Character Set Conversion
Top Architect
Top Architect
Jun 30, 2020 · Databases

Sharding-JDBC Demo: Implementing Database Sharding with Spring Boot

This article demonstrates how to set up Sharding-JDBC in a Spring Boot project, covering project structure, Maven configuration, entity, controller, service, mapper code, database DDL for multiple shards, sharding rules in application.properties, and API testing with Postman.

ORMSharding-JDBCSpring Boot
0 likes · 14 min read
Sharding-JDBC Demo: Implementing Database Sharding with Spring Boot
dbaplus Community
dbaplus Community
Jun 29, 2020 · Databases

How JDBC ResultSetType Settings Trigger SQL Parsing Errors and Performance Issues

The article examines a severe database performance slowdown caused by excessive library cache locks, traces it to improper JDBC ResultSetType settings that introduce unwanted ROWID columns during SQL parsing, and presents systematic experiments across various queries, ResultSetType values, JVM configurations, and database versions to recommend optimal parameter choices.

JDBCOracleResultSetType
0 likes · 11 min read
How JDBC ResultSetType Settings Trigger SQL Parsing Errors and Performance Issues