BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 48 of 50
Top Architect
Top Architect
Aug 14, 2020 · Big Data

Billion‑Row MySQL to HBase Synchronization: Load Data, Kafka‑Thrift, and Flink Solutions

This article presents a comprehensive guide for transferring massive MySQL datasets to HBase, covering environment setup on Ubuntu, three synchronization methods—MySQL LOAD DATA, a Kafka‑Thrift pipeline using Maxwell, and real‑time Flink processing—along with performance comparisons and practical tips for Hadoop, HBase, Kafka, Zookeeper, Phoenix, and related tools.

DataSyncFlinkHBase
0 likes · 24 min read
Billion‑Row MySQL to HBase Synchronization: Load Data, Kafka‑Thrift, and Flink Solutions
Open Source Linux
Open Source Linux
Aug 14, 2020 · Operations

Speed Up Linux Workflows: Quick Dir Jump, Vim Tweaks, MySQL Prompt & System Info

This guide introduces several handy Linux command-line tricks, including the 'z' shortcut for rapid directory navigation, a feature‑rich Vim configuration, customizing MySQL prompts, reliable methods to display system version details, and concise commands for checking disk usage, helping users streamline their workflow.

LinuxMySQLsystem administration
0 likes · 4 min read
Speed Up Linux Workflows: Quick Dir Jump, Vim Tweaks, MySQL Prompt & System Info
MaGe Linux Operations
MaGe Linux Operations
Aug 13, 2020 · Backend Development

Cutting a 37‑Second API Call to 1.5 Seconds with Python Flask Profiling

When a business platform’s settings page took 36 seconds to load, we used Chrome’s Network timing, Python profiling, and MySQL query analysis to identify backend bottlenecks, then applied redesign, thread‑pooling, batch queries, and ORM optimizations, reducing response time from 37.6 s to 1.47 s.

Backend DevelopmentFlaskMySQL
0 likes · 9 min read
Cutting a 37‑Second API Call to 1.5 Seconds with Python Flask Profiling
Top Architect
Top Architect
Aug 13, 2020 · Databases

Understanding Index Usage and Slow Queries in MySQL

This article explains why using indexes does not guarantee fast queries in MySQL, analyzes full index scans, index selectivity, the cost of row look‑ups (back‑to‑table), and presents optimization techniques such as index condition pushdown and virtual columns to improve performance.

MySQLdatabase optimizationindex
0 likes · 13 min read
Understanding Index Usage and Slow Queries in MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 11, 2020 · Databases

Understanding MySQL Row‑Based Replication: RelayLog Replay, binlog_row_image, and slave_rows_search_algorithms

This article analyzes MySQL data‑update loss caused by writes on master‑slave pairs, explains BEFORE and AFTER IMAGE handling in row‑based binlogs, examines the binlog_row_image and slave_rows_search_algorithms parameters, and details the implementation of hash, index, and table scans during slave replay.

HashScanMySQLReplication
0 likes · 18 min read
Understanding MySQL Row‑Based Replication: RelayLog Replay, binlog_row_image, and slave_rows_search_algorithms
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 9, 2020 · Databases

MySQL Passive Performance Optimization Principles and Practices

This article explains the principles of MySQL performance optimization, distinguishes active and passive approaches, and provides concrete solutions for slow single queries, partially slow queries, and overall slow queries through proper indexing, data partitioning, slow‑query‑log configuration, and read‑write splitting.

Data PartitioningMySQLPerformance Optimization
0 likes · 12 min read
MySQL Passive Performance Optimization Principles and Practices
Selected Java Interview Questions
Selected Java Interview Questions
Aug 8, 2020 · Databases

MySQL Single‑Table Optimization, Sharding, and Scaling Strategies

This article explains why MySQL tables with massive row counts suffer performance degradation and provides practical guidance on single‑table optimization, field and index design, query tuning, engine selection, system parameters, hardware upgrades, read‑write splitting, caching layers, partitioning, vertical and horizontal sharding, as well as client‑side and proxy‑side sharding solutions.

MySQLdatabase optimizationindexing
0 likes · 26 min read
MySQL Single‑Table Optimization, Sharding, and Scaling Strategies
Laravel Tech Community
Laravel Tech Community
Aug 7, 2020 · Databases

Understanding MySQL Locks, Isolation Levels, and Concurrency Control

This article explains MySQL's implicit and explicit locking mechanisms—including table, row, and intention locks—covers lock modes, MVCC, transaction isolation levels, optimistic and pessimistic locking, gap locks, and deadlock causes and solutions, providing practical SQL examples for each concept.

LocksMVCCMySQL
0 likes · 12 min read
Understanding MySQL Locks, Isolation Levels, and Concurrency Control
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 7, 2020 · Databases

Four Common MySQL Insert Statements and Their Usage

This article explains the four frequently used MySQL data‑insertion statements—INSERT, INSERT SELECT, REPLACE INTO, and INSERT … ON DUPLICATE KEY UPDATE—detailing their syntax, options, behavior, and performance considerations for reliable database operations.

INSERTMySQLON DUPLICATE KEY UPDATE
0 likes · 7 min read
Four Common MySQL Insert Statements and Their Usage
Senior Brother's Insights
Senior Brother's Insights
Aug 7, 2020 · Databases

Master MySQL Indexes: Syntax, Types, and Optimization Strategies

This comprehensive guide covers MySQL index creation syntax, various index types—including primary, unique, full‑text, and composite—explains their advantages and drawbacks, details underlying B‑Tree and B+Tree structures, and provides practical strategies and optimization tips for effective index usage.

BTreeFullTextMySQL
0 likes · 19 min read
Master MySQL Indexes: Syntax, Types, and Optimization Strategies
Laravel Tech Community
Laravel Tech Community
Aug 6, 2020 · Databases

MySQL Index Types, Creation Methods, and Optimization Strategies

This article explains MySQL's B‑Tree index structure, describes various index types such as primary, unique, normal, full‑text, and composite indexes, and provides practical techniques for creating efficient indexes, choosing column order, using prefix and covering indexes, and optimizing query sorting.

B+ TreeMySQLSQL
0 likes · 12 min read
MySQL Index Types, Creation Methods, and Optimization Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 5, 2020 · Databases

Understanding MySQL Tablespaces: System, Single, and General

This article explains the three types of MySQL InnoDB tablespaces—system, single, and general—detailing their structures, configuration options, advantages, disadvantages, and practical procedures for creation, migration, optimization, and removal, with concrete command‑line examples.

Database StorageInnoDBMySQL
0 likes · 13 min read
Understanding MySQL Tablespaces: System, Single, and General
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.

MySQLOOMTencent Cloud
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.

Database EncryptionKey VaultMySQL
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.

CanalMySQLReplication
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 SELECTMySQLSQL Performance
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.

MySQLPartitioningPerformance
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.

MySQLQuery ProcessingSQL
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.

MariaDBMySQLcharacter set
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 ToolsLinuxMySQL
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 OptimizationMySQLdatabase
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 LogsMySQLevent-driven architecture
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.

MySQLRedisconsistency
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 InsertMySQLSQL optimization
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.

MySQLNoSQLOracle
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.

MySQLPrefix IndexSQL
0 likes · 12 min read
How to Choose and Use Prefix Indexes for String Columns in MySQL
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.

MySQLSQLdatabase optimization
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 BufferInnoDBMySQL
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.

High PerformanceMySQLTokuDB
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.

MySQLPerformanceTokuDB
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 TypesMySQLStored 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.

MySQLPerformanceTokuDB
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.

MySQLSQLcharacter set
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.

MySQLRow Lockdeadlock
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.

MariaDBMySQLcharacter set
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 ClusterMySQL
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‑SlaveMySQL
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.

MySQLSQLdatabase partitioning
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.

MySQLPerformanceSQL
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 TypesFunctionsMySQL
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.

MySQLPartitioningSQL
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 LevelMySQL
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.

EXPLAINMySQLSQL
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.

ConfigurationInstallationMySQL
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.

MariaDBMySQLParamiko
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 OptimizationMySQL
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.

MySQLMycatReadWriteSplitting
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.

JavaMySQLSQL
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.

JavaMaven PluginMySQL
0 likes · 5 min read
Automatically Generate Comprehensive Database Docs with Screw