Tagged articles
5000 articles
Page 36 of 50
FunTester
FunTester
Aug 26, 2021 · Databases

Master MySQL Interview Questions: 33 Essential Queries and Answers

This article presents a complete MySQL interview guide, including a script to create and populate tables for students, teachers, courses, scores, and grades, followed by 33 common interview questions with detailed SQL solutions covering selection, aggregation, joins, subqueries, and ordering.

DatabaseInterviewMySQL
0 likes · 19 min read
Master MySQL Interview Questions: 33 Essential Queries and Answers
vivo Internet Technology
vivo Internet Technology
Aug 25, 2021 · Databases

Introduction to MySQL Group Replication (MGR): Features, Evolution, Deployment and Testing

MySQL Group Replication, introduced in 2016, delivers high‑availability, strong consistency, fault‑tolerant and scalable MySQL clusters through a Paxos‑based, plugin‑driven architecture that supports both single‑primary and multi‑primary modes, with detailed installation, configuration, deployment and testing guidance, while noting its limited current adoption due to ecosystem maturity.

ClusterGroup ReplicationMySQL
0 likes · 15 min read
Introduction to MySQL Group Replication (MGR): Features, Evolution, Deployment and Testing
dbaplus Community
dbaplus Community
Aug 24, 2021 · Databases

Why Slow SQL Hurts Your MySQL and How to Fix It

This article explains the dangers of slow SQL in MySQL, walks through the query execution flow, details InnoDB storage engine architecture and index types, and provides practical strategies for indexing, query rewriting, and configuration to eliminate performance bottlenecks.

InnoDBMySQLslow-query
0 likes · 14 min read
Why Slow SQL Hurts Your MySQL and How to Fix It
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 24, 2021 · Databases

Troubleshooting MySQL Group Replication Transaction Certification Errors and Recovery

An in‑depth analysis of MySQL Group Replication (MGR) transaction certification failures, covering error symptoms, root‑cause investigation, replication‑group transaction set mismatches, and step‑by‑step recovery procedures with code examples and best‑practice recommendations to keep MGR clusters clean.

DatabaseGroup ReplicationMySQL
0 likes · 19 min read
Troubleshooting MySQL Group Replication Transaction Certification Errors and Recovery
Selected Java Interview Questions
Selected Java Interview Questions
Aug 23, 2021 · Backend Development

Optimizing Bulk Data Import into MySQL with MyBatis: From Simple List Insertion to Multi‑Threaded Batch Processing

This article demonstrates how to dramatically speed up importing tens of thousands of records into MySQL by evolving a naïve list‑to‑MySQL approach into grouped batch inserts and finally a multi‑threaded MyBatis solution, while also addressing packet size limits and configuration tweaks.

BackendBatch InsertJava
0 likes · 9 min read
Optimizing Bulk Data Import into MySQL with MyBatis: From Simple List Insertion to Multi‑Threaded Batch Processing
Java Interview Crash Guide
Java Interview Crash Guide
Aug 23, 2021 · Databases

Understanding MySQL Isolation Levels and MVCC: A Deep Dive

This article explains MySQL transaction isolation levels, the four concurrency problems (dirty write, dirty read, non‑repeatable read, phantom), how MVCC and version chains work, and the differences between READ COMMITTED and REPEATABLE READ using practical examples and diagrams.

Isolation LevelsMVCCMySQL
0 likes · 10 min read
Understanding MySQL Isolation Levels and MVCC: A Deep Dive
Top Architect
Top Architect
Aug 20, 2021 · Databases

Querying Multi‑Business Unit Product Sales Statistics with MySQL and MyBatis Dynamic SQL

This article explains how to retrieve sales statistics for multiple business units and their associated products from a MySQL table, compares several implementation approaches—including loop queries, OR concatenation, mixed filtering, and row‑comparison using MyBatis dynamic SQL—evaluates index usage, and provides the final recommended solution.

Database QueryDynamic SQLMyBatis
0 likes · 8 min read
Querying Multi‑Business Unit Product Sales Statistics with MySQL and MyBatis Dynamic SQL
FunTester
FunTester
Aug 20, 2021 · Databases

Why Is One MySQL CPU Core at 99%? A Step‑by‑Step Troubleshooting Guide

During a performance test a MySQL server showed one CPU core constantly at 99% while the others were idle, prompting a detailed investigation that checks I/O thread settings, multi‑core utilization, transaction locks, slow‑query logging, and index optimization to resolve the bottleneck.

Database OptimizationInnoDBMySQL
0 likes · 6 min read
Why Is One MySQL CPU Core at 99%? A Step‑by‑Step Troubleshooting Guide
ITPUB
ITPUB
Aug 19, 2021 · Databases

Why Does MySQL LIMIT with ORDER BY Return Duplicate Rows on Page 2?

When using MySQL pagination with LIMIT together with ORDER BY, the second page can unexpectedly contain rows from the first page because MySQL 5.6's priority‑queue optimization performs an unstable heap sort, causing nondeterministic ordering for equal values and leading to duplicate results.

DatabaseLIMITMySQL
0 likes · 7 min read
Why Does MySQL LIMIT with ORDER BY Return Duplicate Rows on Page 2?
ITPUB
ITPUB
Aug 19, 2021 · Databases

How to Turn a Single MySQL Server into a High‑Availability Cluster

This article explains why a single MySQL instance becomes insufficient as data volume and concurrency grow, and walks through master‑slave replication, asynchronous and semi‑synchronous modes, group replication, and various high‑availability solutions such as MHA, MySQL InnoDB Cluster, and Orchestrator, while also covering read/write splitting techniques and practical implementation tips.

Group ReplicationMaster‑SlaveMySQL
0 likes · 20 min read
How to Turn a Single MySQL Server into a High‑Availability Cluster
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 19, 2021 · Databases

Understanding MHA Master Selection Logic and Cross‑Version Switching Issues

This article analyses why MHA reports a "bad new master" error during master‑slave switches, explains the internal candidate‑master and bad‑master selection algorithms, demonstrates how MySQL version differences affect cross‑version promotion through test scenarios, and provides detailed code excerpts to illustrate the decision process.

Cross-VersionMHAMySQL
0 likes · 12 min read
Understanding MHA Master Selection Logic and Cross‑Version Switching Issues
Sohu Tech Products
Sohu Tech Products
Aug 18, 2021 · Databases

Understanding Slow Queries, Index Optimization, and Search Solutions with MySQL, Elasticsearch, and HBase

This article explains why MySQL queries become slow, how proper indexing and index‑pushdown can improve performance, discusses common index‑failure causes, and then introduces Elasticsearch and HBase as complementary search and storage solutions for large‑scale data, including practical usage tips and architectural considerations.

DatabaseElasticsearchHBase
0 likes · 18 min read
Understanding Slow Queries, Index Optimization, and Search Solutions with MySQL, Elasticsearch, and HBase
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 18, 2021 · Databases

Anti‑Normalization in MySQL: Reducing Joins with Redundant Columns

The article explains the drawbacks of strict relational normalization, introduces the concept of anti‑normalization (controlled redundancy) to simplify queries, demonstrates it with a set of employee, department, salary tables and four typical query scenarios, and shows how denormalizing the schema can dramatically improve MySQL query performance.

Anti-NormalizationDatabase DesignDenormalization
0 likes · 11 min read
Anti‑Normalization in MySQL: Reducing Joins with Redundant Columns
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 17, 2021 · Databases

Design and Implementation of a Cloud‑Native MySQL Container Platform for High Availability and Resource Efficiency

The article describes how a bank built a Kubernetes‑based, containerized MySQL service platform (CDD) to improve database high availability, resource utilization, automated operations, and agile delivery by addressing network, storage, scheduling, and management challenges through custom networking, hybrid storage, scheduler extensions, and multi‑AZ deployment.

ContainerizationDatabaseMySQL
0 likes · 16 min read
Design and Implementation of a Cloud‑Native MySQL Container Platform for High Availability and Resource Efficiency
IT Xianyu
IT Xianyu
Aug 17, 2021 · Databases

Key New Features of MySQL 8.0 for Relational Databases

MySQL 8.0 introduces several relational‑database enhancements, including invisible indexes for performance tuning, persistent configuration via SET PERSIST, default utf8mb4 character set, support for Common Table Expressions, and window functions, each illustrated with practical SQL examples.

8.0CTEDatabase
0 likes · 7 min read
Key New Features of MySQL 8.0 for Relational Databases
Big Data Technology Architecture
Big Data Technology Architecture
Aug 17, 2021 · Big Data

Detailed Overview of Flink CDC 2.0: Architecture, Features, and Future Roadmap

This article provides an in‑depth technical overview of Flink CDC 2.0, covering its CDC fundamentals, comparison of query‑based and log‑based approaches, the new lock‑free chunk algorithm, FLIP‑27 based parallel snapshot reading, performance benchmarks, documentation improvements, and future roadmap for stability and ecosystem integration.

Change Data CaptureData IntegrationDebezium
0 likes · 16 min read
Detailed Overview of Flink CDC 2.0: Architecture, Features, and Future Roadmap
21CTO
21CTO
Aug 16, 2021 · Databases

Why LIMIT with Large Offsets Slows MySQL and How to Fix It

This article explains why MySQL queries using LIMIT with a large offset become extremely slow, demonstrates the inefficiency through a 950‑million‑row table example, and shows how rewriting the query with a sub‑select join reduces execution time from seconds to milliseconds while preserving results.

InnoDBMySQLPerformance tuning
0 likes · 9 min read
Why LIMIT with Large Offsets Slows MySQL and How to Fix It
Top Architect
Top Architect
Aug 16, 2021 · Databases

Understanding MySQL Auto‑Increment IDs and Their Limits

This article explains the various types of auto‑increment identifiers in MySQL—including table primary keys, InnoDB row_id, Xid, trx_id, thread_id—and discusses their maximum values, overflow behavior, and alternative solutions such as using Redis for external unique keys.

InnoDBMySQLRedis
0 likes · 8 min read
Understanding MySQL Auto‑Increment IDs and Their Limits
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 16, 2021 · Databases

Resolving MySQL 8 Clone Plugin Restart Failures with Systemd Configuration

This article explains why MySQL 8's clone plugin may report a restart failure (error 3707), analyzes the role of the monitoring process, and provides systemd service configurations—including RestartForceExitStatus=16 and Environment=MYSQLD_PARENT_PID=1—to ensure automatic restarts succeed after clone operations while preventing unwanted restarts in other failure scenarios.

Clone PluginDatabase operationsMySQL
0 likes · 5 min read
Resolving MySQL 8 Clone Plugin Restart Failures with Systemd Configuration
Qunar Tech Salon
Qunar Tech Salon
Aug 16, 2021 · Operations

Design and Practice of Qunar Data Synchronization Platform: ES Multi‑Version Migration, High Availability, and Data Consistency

The article details Qunar's data synchronization platform that aggregates MySQL data into Elasticsearch, covering its architecture, component choices, ES5‑to‑ES7 migration, hot‑plugging, reindexing, high‑availability design, consistency guarantees, operational optimizations, and future roadmap.

ETLElasticsearchMySQL
0 likes · 16 min read
Design and Practice of Qunar Data Synchronization Platform: ES Multi‑Version Migration, High Availability, and Data Consistency
Java Captain
Java Captain
Aug 15, 2021 · Databases

Querying Multi‑Business Unit Sales Statistics Using Row Comparison in MySQL

The article describes how to design a MySQL table for product sales statistics, initialize large data sets, and compare several approaches—including loop queries, OR concatenation, mixed filtering, and row‑comparison techniques—ultimately selecting row‑comparison as the most efficient solution within MyBatis dynamic SQL constraints.

Database DesignDynamic SQLMyBatis
0 likes · 6 min read
Querying Multi‑Business Unit Sales Statistics Using Row Comparison in MySQL
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 14, 2021 · Databases

Why Your MySQL Queries Are Slow and How to Fix Them with Indexes, ElasticSearch, and HBase

This article explains why MySQL queries become slow—covering index misuse, MDL locks, flush waits, row locks, and large‑table bottlenecks—then introduces ElasticSearch’s inverted‑index architecture and HBase’s column‑family storage, offering practical tips for performance tuning and hybrid solutions.

DatabaseElasticsearchHBase
0 likes · 18 min read
Why Your MySQL Queries Are Slow and How to Fix Them with Indexes, ElasticSearch, and HBase
ITPUB
ITPUB
Aug 13, 2021 · Databases

Why LIMIT with Large OFFSET Slows MySQL and How to Speed It Up

When a MySQL query uses LIMIT with a large offset on a table of millions of rows, the database must scan hundreds of thousands of index entries and corresponding clustered rows, causing massive random I/O; rewriting the query with a sub‑query join reduces I/O dramatically, cutting execution time from over a minute to under a second while also preventing buffer‑pool pollution.

InnoDBLIMITMySQL
0 likes · 9 min read
Why LIMIT with Large OFFSET Slows MySQL and How to Speed It Up
Python Programming Learning Circle
Python Programming Learning Circle
Aug 12, 2021 · Databases

Understanding MySQL Slow Queries, Index Optimization, ElasticSearch Basics, and HBase Overview

This article explains why MySQL queries become slow, how proper indexing—including B+‑tree, left‑most prefix, index push‑down, and covering indexes—can improve performance, outlines common causes of index failure, and then introduces ElasticSearch search capabilities and HBase column‑family storage as complementary solutions for large‑scale data handling.

Database OptimizationElasticsearchHBase
0 likes · 16 min read
Understanding MySQL Slow Queries, Index Optimization, ElasticSearch Basics, and HBase Overview
dbaplus Community
dbaplus Community
Aug 11, 2021 · Databases

Turn Slow MySQL Queries into Millisecond Performance with Smart Rewrites

This article explains common MySQL performance pitfalls such as large‑offset LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS clauses, and condition pushdown, and shows how to rewrite each pattern using indexes, JOINs, UNION ALL, CTEs and early filtering to achieve execution times measured in milliseconds instead of seconds.

CTEIndexesJoin
0 likes · 13 min read
Turn Slow MySQL Queries into Millisecond Performance with Smart Rewrites
MaGe Linux Operations
MaGe Linux Operations
Aug 11, 2021 · Databases

Understanding Cloud MySQL: Instance Types, Replication Modes, and High Availability

This article explains the different Cloud MySQL instance architectures, details asynchronous, semi‑synchronous, and strong synchronous replication, describes high‑availability failover mechanisms, outlines upgrade procedures, and covers binlog usage, rollback methods, slow‑query optimization, and storage fragmentation.

Instance TypesMySQLPerformance tuning
0 likes · 11 min read
Understanding Cloud MySQL: Instance Types, Replication Modes, and High Availability
ITPUB
ITPUB
Aug 11, 2021 · Databases

Boost MySQL Performance: Essential Tools and How to Use Them

This guide introduces four practical MySQL performance‑tuning utilities—MySQLTuner, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining how to download, run, and interpret their reports to identify configuration issues, memory overload, and slow‑query problems.

MySQLMySQLTunerPerformance tuning
0 likes · 8 min read
Boost MySQL Performance: Essential Tools and How to Use Them
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 11, 2021 · Databases

Using MySQL 8.0 Administrative Connection Interface to Solve “Too Many Connections” Errors

The article explains why MySQL can hit the max_connections limit, introduces the MySQL 8.0 administrative connection interface and its configuration variables, demonstrates how to create a privileged user and test connection limits with code examples, and offers best‑practice recommendations to prevent connection saturation.

Administrative Connection InterfaceConnection PoolingDatabase Administration
0 likes · 9 min read
Using MySQL 8.0 Administrative Connection Interface to Solve “Too Many Connections” Errors
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 11, 2021 · Databases

How MySQL InnoDB Guarantees ACID: Locks, MVCC, and Log Mechanics

This article explains how MySQL's InnoDB engine implements ACID properties by detailing transaction atomicity, consistency, isolation levels, lock granularity, MVCC version chains, undo/redo logs, buffer pool behavior, and the interplay between redo log and binlog to ensure durability and data integrity.

ACIDInnoDBLock
0 likes · 16 min read
How MySQL InnoDB Guarantees ACID: Locks, MVCC, and Log Mechanics
Liangxu Linux
Liangxu Linux
Aug 10, 2021 · Databases

How to Efficiently Remove Duplicate Rows in MySQL Tables

This guide explains step‑by‑step how to identify and delete duplicate records in MySQL tables, covering simple SELECT checks, handling MySQL’s update‑from limitation, and fast deletion techniques that keep one record per duplicate group.

DeleteGROUP BYMySQL
0 likes · 5 min read
How to Efficiently Remove Duplicate Rows in MySQL Tables
Java Backend Technology
Java Backend Technology
Aug 10, 2021 · Databases

How to Efficiently Remove Duplicate Rows in MySQL Tables

This article explains why a naïve Python script for deleting duplicate MySQL rows is too slow, demonstrates the MySQL error caused by deleting from the same table you query, and provides two pure‑SQL solutions: one that removes all duplicates and another that keeps a single row per duplicate key.

MySQLdata deduplicationdatabase cleanup
0 likes · 5 min read
How to Efficiently Remove Duplicate Rows in MySQL Tables
Practical DevOps Architecture
Practical DevOps Architecture
Aug 9, 2021 · Operations

MySQL Installation and Configuration Bash Script

This article provides a step‑by‑step Bash script for installing, configuring, and starting MySQL 8.0 on a Linux system, including user creation, directory setup, permission handling, initialization checks, and service management, and ensures proper environment variables.

BashDatabaseInstallation
0 likes · 4 min read
MySQL Installation and Configuration Bash Script
ITPUB
ITPUB
Aug 9, 2021 · Databases

Boost MySQL Performance: Essential Tools and How to Use Them

This guide introduces four popular MySQL performance‑tuning utilities—mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest—provides download commands, usage examples, and detailed guidance on interpreting their reports to identify configuration issues and query bottlenecks.

MySQLpercona-toolkitpt-query-digest
0 likes · 9 min read
Boost MySQL Performance: Essential Tools and How to Use Them
php Courses
php Courses
Aug 9, 2021 · Databases

Interview Transcript: MySQL, Redis, PHP, and Distributed Systems Questions

The article records a video interview where the candidate answers technical questions on MySQL isolation levels, InnoDB indexing, locking, distributed locks, Redis sharding, PHP‑FPM architecture, RabbitMQ, AOP, Hyperf, and other backend topics, reflecting on the challenges faced during the session.

BackendDatabasesDistributed Systems
0 likes · 7 min read
Interview Transcript: MySQL, Redis, PHP, and Distributed Systems Questions
Top Architect
Top Architect
Aug 8, 2021 · Backend Development

My First Java Web Project: From Planning to Deployment – A Full‑Stack Journey

This article recounts the author’s experience building a simple Java web application for a university anniversary, covering planning, environment setup, documentation, database design, coding challenges with Spring Boot, Redis, and session handling, deployment on Alibaba Cloud, and the lessons learned about architecture, logging, and monitoring.

Backend DevelopmentJavaMySQL
0 likes · 10 min read
My First Java Web Project: From Planning to Deployment – A Full‑Stack Journey
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 5, 2021 · Databases

Understanding and Optimizing ORDER BY in MySQL

This article explains the internal execution process of MySQL's ORDER BY, compares full‑field and rowid sorting, shows how indexes, sort_buffer size and max_length_for_sort_data affect performance, and provides practical optimization techniques such as composite and covering indexes.

MySQLOrder ByRowid
0 likes · 13 min read
Understanding and Optimizing ORDER BY in MySQL
Sohu Tech Products
Sohu Tech Products
Aug 4, 2021 · Backend Development

Resolving Duplicate OpenID Insertions with Distributed Locks in a Fast App Center

To prevent duplicate OpenID records caused by concurrent synchronization requests in the Fast App Center, this article analyzes the root cause, evaluates database‑level unique indexes versus application‑level distributed locks, and presents a Redis‑based lock implementation with cleanup procedures to ensure data consistency.

BackendData ConsistencyJava
0 likes · 16 min read
Resolving Duplicate OpenID Insertions with Distributed Locks in a Fast App Center
Wukong Talks Architecture
Wukong Talks Architecture
Aug 4, 2021 · Databases

Understanding MySQL InnoDB Locks: Shared, Exclusive, Intention, Gap, Next‑Key, Auto‑Inc, and Predicate Locks

The article presents a detailed interview‑style walkthrough of MySQL InnoDB locking mechanisms, covering table‑ versus row‑level locks, shared and exclusive locks, intention locks, gap and next‑key locks, auto‑increment locks, predicate locks, and related SQL statements, illustrated with tables and code examples.

ConcurrencyDatabaseInnoDB
0 likes · 13 min read
Understanding MySQL InnoDB Locks: Shared, Exclusive, Intention, Gap, Next‑Key, Auto‑Inc, and Predicate Locks
Qunar Tech Salon
Qunar Tech Salon
Aug 3, 2021 · Databases

Deep Dive into MySQL 8.0 Server Architecture, Parser, and Optimizer

This article analyzes MySQL 8.0.25 source code, detailing the server architecture, parser reconstruction, prepare/rewrite stages, the optimizer transformations, and the new hypergraph optimizer, while also comparing these mechanisms with PostgreSQL’s processing pipeline.

Database InternalsHypergraphMySQL
0 likes · 12 min read
Deep Dive into MySQL 8.0 Server Architecture, Parser, and Optimizer
Tencent Database Technology
Tencent Database Technology
Aug 2, 2021 · Databases

MySQL 8.0 Resource Groups: Overview and Implementation

This article introduces MySQL 8.0's resource group feature, detailing its concepts, configuration commands, query hint usage, and the underlying implementation including new parser classes, platform APIs, runtime components, performance schema integration, and persistence mechanisms, with code examples throughout.

DatabaseMySQLParser
0 likes · 17 min read
MySQL 8.0 Resource Groups: Overview and Implementation
Selected Java Interview Questions
Selected Java Interview Questions
Aug 2, 2021 · Databases

Why Store IPv4 Addresses as UNSIGNED INT in MySQL: Benefits, Drawbacks, and Conversion Methods

Storing IPv4 addresses as a 32‑bit UNSIGNED INT in MySQL saves space, enables faster range queries, and leverages built‑in conversion functions like INET_ATON/INET_NTOA, while requiring manual readability handling, and can be complemented by Java utilities for application‑level conversions.

Database OptimizationINET_ATONIPv4
0 likes · 5 min read
Why Store IPv4 Addresses as UNSIGNED INT in MySQL: Benefits, Drawbacks, and Conversion Methods
Open Source Linux
Open Source Linux
Aug 1, 2021 · Databases

Why Is MySQL Consuming CPU? Identify and Reduce CPU Bottlenecks

This article explains which components (user processes, IO wait, system interrupts) consume CPU in MySQL, shows their impact on performance, and provides practical strategies to reduce CPU usage through IO optimization, query tuning, data modeling, caching, and hardware upgrades.

CPU BottleneckDatabase OptimizationIO Wait
0 likes · 6 min read
Why Is MySQL Consuming CPU? Identify and Reduce CPU Bottlenecks
dbaplus Community
dbaplus Community
Aug 1, 2021 · Databases

Bind Slow MySQL Queries to Resource Groups with a Simple PHP Tool

This guide introduces a PHP utility that automatically assigns slow MySQL statements (running over 10 seconds) to a dedicated CPU core using MySQL 8.0 resource groups, explaining installation, configuration, execution, and verification steps, along with required system capabilities.

Database AdministrationMySQLPHP
0 likes · 5 min read
Bind Slow MySQL Queries to Resource Groups with a Simple PHP Tool
Code Ape Tech Column
Code Ape Tech Column
Aug 1, 2021 · Databases

Master MySQL Performance: Essential Tools and How to Use Them

This guide introduces four powerful MySQL performance‑tuning utilities—MySQLTuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—detailing their installation, command‑line usage, and how to interpret the generated reports to optimize database configuration and query efficiency.

DatabaseMySQLPercona
0 likes · 9 min read
Master MySQL Performance: Essential Tools and How to Use Them
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 30, 2021 · Databases

Migrating from MariaDB 10.3 to MySQL 5.7.25: Common Issues and Solutions

This article details the practical challenges encountered when migrating a MariaDB 10.3 database to MySQL 5.7.25, explains why certain defaults and engine-specific options cause import errors, and provides step‑by‑step fixes such as adjusting default expressions, removing Aria‑specific parameters, and configuring sql_mode.

MariaDBMySQLcompatibility
0 likes · 5 min read
Migrating from MariaDB 10.3 to MySQL 5.7.25: Common Issues and Solutions
Alibaba Cloud Developer
Alibaba Cloud Developer
Jul 30, 2021 · Databases

How to Tackle MySQL Slow Queries: Metrics, Strategies, and Real Cases

This article explains what constitutes a MySQL slow query, why they cause failures, defines quantitative metrics such as micro‑average and macro‑average to assess severity, outlines target goals, presents concrete optimization examples, and shares operational practices for ongoing slow‑SQL governance.

Database PerformanceIndex OptimizationMetrics
0 likes · 13 min read
How to Tackle MySQL Slow Queries: Metrics, Strategies, and Real Cases
Laravel Tech Community
Laravel Tech Community
Jul 29, 2021 · Databases

Common MySQL Commands and Operations Guide

This article provides a comprehensive collection of MySQL command-line instructions for exporting databases or tables, importing data, managing databases and tables, performing DDL and DML operations, handling field types, and configuring user privileges, all illustrated with practical code examples.

DDLDMLDatabase Commands
0 likes · 10 min read
Common MySQL Commands and Operations Guide
MaGe Linux Operations
MaGe Linux Operations
Jul 29, 2021 · Databases

How to Efficiently Remove Duplicate Rows in Large MySQL Tables

This article explains why a naïve Python script for deduplicating millions of rows is too slow, then walks through a series of MySQL queries—including how to identify duplicate names, avoid the 1093 error, and delete duplicates while keeping a single representative row—demonstrating fast, reliable cleanup of large tables.

Data cleaningDatabase OptimizationMySQL
0 likes · 5 min read
How to Efficiently Remove Duplicate Rows in Large MySQL Tables
ITPUB
ITPUB
Jul 28, 2021 · Databases

Master MySQL Performance: Essential SQL Optimization Techniques & Index Strategies

This comprehensive guide walks you through MySQL performance tuning, covering how to monitor server status, identify slow queries, use EXPLAIN for execution plans, create and manage various index types, and apply practical SQL optimizations such as import tricks, insert batching, efficient GROUP BY/ORDER BY, and pagination improvements.

EXPLAINIndexesMySQL
0 likes · 25 min read
Master MySQL Performance: Essential SQL Optimization Techniques & Index Strategies
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 28, 2021 · Operations

Common Open‑Source Tools for MySQL Operations and Maintenance

This article introduces a curated list of open‑source MySQL operational tools—including online DDL changers, backup and restore utilities, load‑testing frameworks, flashback solutions, slow‑query analyzers, replication consistency checkers, audit platforms, and graphical clients—explaining their principles, usage scenarios, and visual references.

MySQLOperationsbackup
0 likes · 8 min read
Common Open‑Source Tools for MySQL Operations and Maintenance
Python Programming Learning Circle
Python Programming Learning Circle
Jul 27, 2021 · Backend Development

Flask Blog Platform Development Tutorial

This article provides a step‑by‑step tutorial for building a full‑stack online blog platform with Flask, MySQL, Layui, and a Markdown editor, covering environment setup, database schema, model definitions, template inheritance, user authentication, CRUD operations for blogs, comment handling, image upload, and custom error pages.

BlogCRUDFlask
0 likes · 25 min read
Flask Blog Platform Development Tutorial
Top Architect
Top Architect
Jul 27, 2021 · Databases

ShardingSphere-Jdbc Overview, MySQL Master‑Slave Replication, Binlog & Redo Log, and Sharding Implementation

This article introduces ShardingSphere‑Jdbc as a lightweight Java JDBC framework, details step‑by‑step Docker‑based MySQL master‑slave replication configuration, reviews redo log and binlog mechanisms, explains two‑phase commit, and demonstrates read‑write splitting and sharding strategies with Spring Boot examples.

JDBCMySQLShardingSphere
0 likes · 28 min read
ShardingSphere-Jdbc Overview, MySQL Master‑Slave Replication, Binlog & Redo Log, and Sharding Implementation
Architect's Tech Stack
Architect's Tech Stack
Jul 26, 2021 · Databases

Efficient Methods to Remove Duplicate Rows in MySQL Tables

This article explains how to identify and delete duplicate records in large MySQL tables, discusses why a naïve delete fails, and provides two robust SQL solutions—one that removes all duplicates and another that retains a single row per duplicated key—demonstrating fast execution even on tables with hundreds of thousands of rows.

Data cleaningMySQLduplicate removal
0 likes · 5 min read
Efficient Methods to Remove Duplicate Rows in MySQL Tables
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 23, 2021 · Databases

Understanding MySQL Index Usage, Slow Queries, and Optimization Strategies

This article explains how MySQL index usage affects query performance, demonstrates that hitting an index does not guarantee speed, explores slow‑query logging parameters, shows practical experiments with EXPLAIN, and presents optimization techniques such as composite indexes, index condition push‑down, and virtual columns to reduce row scans.

DatabaseMySQLindex
0 likes · 11 min read
Understanding MySQL Index Usage, Slow Queries, and Optimization Strategies
Architect
Architect
Jul 21, 2021 · Databases

MySQL 100 Interview Questions: Indexes, Transactions, Table Design, and Storage Engines

This article compiles 100 common MySQL interview questions for developers, covering index structures and optimization, transaction ACID properties and isolation levels, primary‑key design, storage‑engine choices, sharding strategies, and miscellaneous SQL nuances such as binlog formats and MyBatis parameter handling.

IndexesMySQLStorage Engines
0 likes · 20 min read
MySQL 100 Interview Questions: Indexes, Transactions, Table Design, and Storage Engines
vivo Internet Technology
vivo Internet Technology
Jul 21, 2021 · Backend Development

Resolving Duplicate OpenID Insertions in Fast App Center: Analysis and Distributed Lock Solutions

The Fast App Center’s duplicate OpenID rows were traced to a non‑atomic check‑then‑insert race condition, prompting the team to evaluate a unique‑index safeguard versus application‑level distributed locking, ultimately implementing a Redis‑based lock to serialize inserts and adding a cleanup job to purge existing duplicates.

Backend DevelopmentDatabase ConcurrencyJava
0 likes · 18 min read
Resolving Duplicate OpenID Insertions in Fast App Center: Analysis and Distributed Lock Solutions
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 21, 2021 · Databases

MySQL Index Design Specification and Best Practices

This article summarizes comprehensive MySQL index design guidelines, covering naming conventions, column selection criteria, index count control, handling of frequently updated columns, function and duplicate indexes, small‑table considerations, and index ordering to optimize query performance.

Database DesignMySQLindexing
0 likes · 8 min read
MySQL Index Design Specification and Best Practices
Su San Talks Tech
Su San Talks Tech
Jul 21, 2021 · Databases

Why Index Hits Still Cause Slow Queries and How to Optimize MySQL

This article explains why a query that uses an index can still be slow, demonstrates how to diagnose index usage and row scans with EXPLAIN and the slow query log, and presents optimization techniques such as composite indexes, index condition pushdown, and virtual columns.

EXPLAINIndex OptimizationMySQL
0 likes · 10 min read
Why Index Hits Still Cause Slow Queries and How to Optimize MySQL
Python Programming Learning Circle
Python Programming Learning Circle
Jul 20, 2021 · Databases

Removing Duplicate Data in MySQL and Keeping Only One Record

This article describes how to identify and delete duplicate rows in MySQL tables—first showing a naive Python‑based approach, then presenting efficient SQL queries that locate duplicate names, explain MySQL's limitation on deleting from the same table being queried, and provide a safe sub‑query solution to remove all duplicates while preserving a single representative row.

MySQLduplicate removalsql
0 likes · 6 min read
Removing Duplicate Data in MySQL and Keeping Only One Record
Big Data Technology & Architecture
Big Data Technology & Architecture
Jul 20, 2021 · Big Data

Common Issues and Solutions for Flink CDC with MySQL

This article summarizes frequent problems encountered when using Flink CDC with MySQL—including Kafka version conflicts, checkpoint timeouts, permission errors, global lock issues, and DDL parsing failures—and provides practical configuration tweaks and code examples to resolve them.

CDCCheckpointDebezium
0 likes · 11 min read
Common Issues and Solutions for Flink CDC with MySQL
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 19, 2021 · Databases

Understanding MySQL 5.7 SQL Mode: Default Values, Usage, and Practical Examples

This article explains MySQL's SQL Mode concept, lists the default mode values for MySQL 5.7, demonstrates how to view and change the mode with SQL commands, describes the impact of common modes such as STRICT_TRANS_TABLES and ONLY_FULL_GROUP_BY, and provides a complete reference table of all supported mode values and predefined mode combinations.

MySQLSQL Modedata validation
0 likes · 10 min read
Understanding MySQL 5.7 SQL Mode: Default Values, Usage, and Practical Examples