This article combines salary insights for ZTE offers, practical internship interview tips, a deep dive into Spring bean‑injection annotations, a side‑by‑side comparison of MySQL InnoDB and MyISAM, Redis usage patterns, and JVM OutOfMemoryError diagnostics to help you excel in Java backend interviews.
This guide explains how to enable MySQL slow‑query logging, set appropriate thresholds, locate problematic SQL statements, analyze execution plans with EXPLAIN, and apply index or query rewrites to dramatically improve performance.
When MySQL executes an UPDATE or DELETE that uses a column without an index, it must scan the entire table and acquires a combination of row, gap, and intention locks, which effectively blocks all other write operations and behaves like a table‑level lock, so adding proper indexes is essential.
This article explains MySQL's four transaction isolation levels, the concurrency problems they address, how MVCC works, and provides practical guidance on selecting the appropriate level based on business requirements and performance trade‑offs.
This guide explains how to design a high‑availability architecture using Keepalived's VRRP‑based active‑passive failover, covering technical features, applicable scenarios, environment requirements, step‑by‑step installation and configuration for services like Nginx, MySQL and Redis, plus best practices, troubleshooting, monitoring and backup strategies.
This article explains how defining MySQL table columns as NOT NULL—rather than allowing NULL—can improve query speed, reduce storage consumption, simplify indexing and aggregation, make application code cleaner, and enhance data consistency, while also noting scenarios where NULL is appropriate.
The article explains why MySQL recommends storing IPv4 addresses as unsigned 32‑bit integers instead of strings, detailing space savings, faster range queries, and indexing benefits, while also noting readability drawbacks and providing MySQL functions and Java code for converting between string and integer representations.
This article walks through replacing MyBatis with MyBatis‑Plus in a Java project, diagnosing a Conversion not supported for java.time.LocalDateTime error, uncovering its root cause in MyBatis and mysql‑connector‑java version mismatches, and sharing lessons from subsequent validation bugs and production incidents.
This article explains the fundamentals of database indexing, covering what indexes are, their advantages and drawbacks, underlying structures such as hash tables, B‑tree and B+‑tree, different index types (clustered, non‑clustered, primary, secondary) in MySQL, and practical examples with code snippets.
This comprehensive guide walks you through MySQL InnoDB buffer pool optimization—from assessing current settings and calculating optimal sizes for 32 GB to 256 GB servers, to configuring instances, enabling pre‑warming, tuning dirty‑page flushing, monitoring key metrics, and troubleshooting common issues—to achieve up to a 300 % throughput increase in production environments.
This article walks through building a Spring Boot project with ShardingSphere‑JDBC, covering Maven dependencies, YAML configuration, database setup, sharding rules, distributed ID generation, binding tables, and testing, providing a complete, hands‑on guide to implementing MySQL horizontal partitioning in a real‑world application.
A customer on MySQL 8.0.28 experienced a crash when a complex query used an internal temporary table, exposing a bug in the TempTable storage engine that caused a null pointer dereference during index initialization, a problem that was resolved in MySQL 8.0.30 with additional safety checks.
This article analyses why cache consistency between MySQL and Redis breaks under high concurrency, explains the CAP perspective, walks through five typical failure scenarios, and presents concrete solutions such as delayed double‑delete, retry with MQ, binlog listening, expiration fallback, and mutex locks, ending with a decision guide for selecting the most suitable strategy.
This article examines a puzzling MySQL case where the optimizer selects a full‑table scan despite suitable indexes, explains the role of cost constants, execution‑plan analysis, and demonstrates how to force the optimizer to use the optimal index for faster queries.
This guide explains the background, terminology, pre‑conditions, detailed step‑by‑step procedures, and rollback plan for executing reverse incremental migration from MySQL to OceanBase, covering trigger and foreign‑key handling, OMS operations, data validation, and how to safely switch traffic back to MySQL.
UUIDs provide globally unique identifiers useful in distributed systems, but using them as MySQL primary keys can degrade insert speed, increase storage, and cause page splits; this article explains UUID versions, their structures, performance impacts, and best‑practice techniques such as binary storage, ordered UUIDs, and alternative ID schemes.
This tutorial walks you through building a PHP‑based logistics tracking and delivery management system for e‑commerce, covering database schema design, code for adding, updating, and querying shipment and delivery records, and demonstrates how to integrate these features to improve operational efficiency.
The article shares recent JD backend salary data ranging from 24k to 32k RMB per month, explains the compensation structure, and provides a step‑by‑step interview preparation guide covering project presentation, JWT, Redis, thread pools, MySQL‑Elasticsearch sync, isolation levels and performance analysis.
This article explains MySQL's transaction isolation levels, the ACID principles behind them, common anomalies like dirty reads, non‑repeatable reads and phantom reads, the locking mechanisms that enforce isolation, and how to configure the desired level in practice.
Although MySQL historically labeled its three‑byte character set as “utf8”, it actually implements a truncated version (utf8mb3) that cannot store the full Unicode range, leading to bugs with emojis and rare characters; the newer utf8mb4 restores true UTF‑8 support and is now the default in MySQL 8.0.
This article explains MySQL master‑slave replication, covering asynchronous, semi‑synchronous, and full synchronous modes, their mechanisms, advantages, disadvantages, and ideal use cases for high availability, read/write separation, and strong consistency in large‑scale systems.
This article explains why database expenses balloon, then walks through ten practical techniques—including smart indexing, selective column queries, caching, partitioning, archiving, data‑type tuning, simplifying joins, regular maintenance, query monitoring, and right‑sized hardware—to cut costs up to 60% while preserving or even boosting query speed.
This article explains MySQL indexes—how they speed up queries, their types, the inner workings of B‑Tree and B+Tree structures, page storage mechanics, and the trade‑offs between clustered and secondary indexes, providing practical insights for database optimization.
This comprehensive guide explains how to diagnose MySQL master‑slave replication lag, enable GTID mode, configure semi‑synchronous replication, optimize multi‑threaded replication, set up monitoring and alerting with Prometheus, and perform zero‑data‑loss failover using tools like Orchestrator and custom scripts.
This guide shows how to modify the MySQL 8 binary to change its reported version, letting vulnerability scanners misidentify the server and bypass patching, while providing a quick, temporary defense for internal or compliance‑driven environments.
This guide provides a step‑by‑step troubleshooting workflow for common Spring Boot microservice issues involving Nacos and MySQL, covering log inspection, process verification, port checks, network connectivity, configuration validation, database connection tests, resource monitoring, and a one‑click diagnostic script.
This article presents ten practical MySQL techniques—from using JSON columns for flexible data to leveraging CTEs, window functions, and advanced clauses like WITH ROLLUP and INSERT IGNORE—each illustrated with real‑world scenarios and ready‑to‑run SQL code to improve query efficiency and developer productivity.
This article explains what database transactions are, why they matter, details MySQL’s transaction commands, the ACID properties, isolation levels, lock types, MVCC, how to use InnoDB, handle errors, employ savepoints, and provides concrete SQL examples for creating, committing, rolling back, and managing transactions.
This article explains why MySQL uses B+‑tree indexes—highlighting disk‑IO efficiency, dense storage, superior range queries, and stable performance—while comparing B+‑trees to other structures, detailing their implementation in InnoDB, and providing interview‑style Q&A and optimization tips.
This article explains the purpose of MySQL's optimizer_switch prefer_ordering_index, why the default ON can hurt performance on skewed data, and demonstrates with table creation, data‑loading procedures, and EXPLAIN output how turning the option OFF often yields faster queries.
A massive MySQL table ran out of INT auto‑increment IDs due to high concurrency, leading to insert failures; the article analyzes the root cause, evaluates three remediation strategies, and details the eventual migration to BIGINT with performance monitoring and code snippets.
This article provides a comprehensive overview of MySQL's lock mechanisms, covering lock granularity, lock types, intention locks, record/gap/next‑key locks, their interaction with transaction isolation levels, two‑phase locking, deadlock handling, and practical optimization techniques for high‑concurrency applications.
This article examines MySQL InnoDB deadlocks by analyzing error logs, explaining the two‑phase locking protocol and various lock types, demonstrates how to reproduce a deadlock scenario, categorizes lock behaviors, and offers practical strategies to prevent and monitor deadlocks in database applications.
Learn how to transform a vulnerable MySQL 8 instance into a militarized, audit‑ready database in just half an hour by applying six ready‑to‑run shell and SQL scripts that disable high‑risk accounts, enable enterprise audit logging, enforce SSL, prune privileges, rotate root passwords, and generate compliance reports.
Even if your database appears functional and backed up, a single SQL injection can expose all data; this article reveals five often‑overlooked MySQL security configurations—disabling remote root login, turning off dangerous functions, enabling audit logs, enforcing SSL, and cleaning ghost accounts—to dramatically harden your database in under 30 minutes.
This article explains why MySQL master‑slave replication can fall behind, outlines common causes of data inconsistency, and presents four comprehensive solutions—including architecture tweaks, multi‑threaded replication, configuration tuning, and Percona Toolkit verification—to achieve fast, stable, and accurate data synchronization.
This guide walks through setting up Flowable 6.8.0 with Spring Boot 2.7.x, configuring MySQL, defining and deploying BPMN processes, managing runtime tasks, handling dynamic assignments, querying history, adding extensions like multi‑instance approvals and email notifications, and finally containerizing the application with Docker.
This article explains the concepts, differences, advantages, and disadvantages of database sharding and partitioning, provides practical MySQL examples for horizontal sharding by region and range partitioning, and offers guidance on choosing the right approach for scalability and maintainability.
This guide walks through enabling MySQL slow query logging, analyzing logs with pt‑query‑digest, interpreting EXPLAIN output, applying index and SQL optimizations, tuning database parameters, and setting up Prometheus monitoring, culminating in a real‑world order‑query case that reduces execution time from seconds to milliseconds.
This article explains why deleting tens of millions of rows is challenging, analyzes transaction, lock, resource, and business impacts, and presents five practical solutions—including batch deletion, table rebuild, partition dropping, online migration, and professional tools—along with best‑practice guidelines and a decision matrix.
This guide walks you through creating a full‑stack “afterlife” management platform that simulates traditional Chinese underworld processes, using a Node.js + Express + MySQL backend and a Vue + Element UI frontend, with step‑by‑step setup, configuration, and deployment instructions.
This article details a step‑by‑step performance overhaul for importing 60,000+ XML records into MySQL, covering baseline measurements, MySQL batch processing, asynchronous writes with Disruptor, XML parsing optimizations, and tuning MySQL buffers, ultimately reducing total runtime from 300 seconds to just four seconds.
This article explains what OLTP (Online Transaction Processing) is, outlines its key characteristics, and details how MySQL—through ACID‑compliant transactions, the InnoDB storage engine, various indexing strategies, fast locking mechanisms, query optimization, and high‑availability features—effectively supports high‑concurrency, low‑latency transactional workloads.
Even when CPU and memory appear idle, MySQL can suffer connection timeouts, query stalls, and 100% CPU spikes during peak traffic, but by adjusting six key configuration parameters and following solid SQL‑optimization practices you can reliably support thousands of queries per second.
This article examines three MySQL high‑availability solutions—MHA, Percona XtraDB Cluster, and Galera Cluster—detailing their architectures, advantages, limitations, deployment scenarios, and best‑practice recommendations to help engineers choose the most suitable approach for continuous, reliable database operations.
Learn how to establish, use, and close MySQL database connections in PHP with detailed MySQLi and PDO examples, covering object‑oriented syntax, prepared statements, error handling, and best practices for secure and efficient backend development.
This article delves into the hierarchical logical architecture of MySQL’s InnoDB storage engine, detailing how table spaces, segments, extents, pages, and rows are organized, their functions, configuration options, and how they together enable efficient data storage, access, and transaction management.
This comprehensive guide compares MySQL, PostgreSQL, and MongoDB across core features, transaction models, indexing, scalability, and real‑world use cases, offering a step‑by‑step selection method, detailed pros and cons, and a practical decision flowchart to help engineers pick the right database for their projects.
This article explains MySQL's sorting mechanisms, comparing index sorting and filesort, detailing memory and disk phases, single‑row and double‑row strategies, and provides practical optimization tips such as proper index design and buffer configuration.
This article compares MySQL's InnoDB and MyISAM storage engines across dimensions such as transaction support, locking, file structure, indexing, full‑text search, and COUNT(*) performance, helping developers choose the appropriate engine based on workload and consistency requirements.
Upgrading MySQL from 5.7 to 8.0 involves careful preparation, thorough testing, and handling numerous compatibility issues such as deprecated features, authentication changes, SQL mode differences, and performance regressions, all of which are detailed with step‑by‑step solutions in this guide.
This article walks through the complete lifecycle of a MySQL SELECT statement, detailing how the client, connector, optional query cache, parser, optimizer, and executor interact to transform SQL text into an execution plan and finally return results.
This article examines how MySQL's lock mechanisms and transaction isolation levels can cause deadlocks during high‑concurrency inserts, presents a real‑world case study, walks through log analysis and testing, and offers practical strategies to diagnose, prevent, and resolve such deadlocks.
This guide walks through the challenges of synchronizing tens of millions of records between heterogeneous MySQL databases, explains why traditional mysqldump or file‑based methods fail, and provides a step‑by‑step tutorial on installing, configuring, and using Alibaba's open‑source DataX tool for both full and incremental data synchronization.
This article examines the limitations of traditional threshold‑based database inspections, introduces AI‑driven anomaly detection techniques such as DoubleRollingAggregate, SeasonalAD, and LevelShiftAD, and details practical implementations, tuning strategies, and real‑world use cases for MySQL and Redis monitoring.
This article explores how to replace long UUIDs with short, sequential numeric IDs by evaluating Snowflake, MySQL auto‑increment tables, REPLACE INTO deadlock issues, batch allocation strategies, and a final free‑ID table design that balances performance, simplicity, and low ID waste.
This article provides a detailed overview of MySQL’s four‑layer architecture—including the client, server, storage engine, and system file layers—explaining each layer’s responsibilities, key modules, and the role of various built‑in and third‑party storage engines.
The article shares ZTE salary offers and interview tips, then dives into technical deep‑dives on Spring bean injection annotations, compares MySQL InnoDB and MyISAM, explains Redis usage patterns, and walks through JVM OutOfMemoryError diagnosis with concrete code and tooling examples.
This article details a production Flink CDC server_id conflict caused by copied configurations, explaining how to identify duplicate server_id/server_uuid via MySQL SHOW PROCESSLIST, assign unique identifiers, clear Flink checkpoint state, and verify resolution through logs and replication monitoring.
The article explains MySQL's default Repeatable Read isolation level, how its lock and binlog mechanisms affect consistency and replication, and why many high‑traffic internet firms change to Read Committed to boost concurrency and reduce deadlocks despite the need to handle phantom reads.
This article explains how MySQL master‑slave replication works, covering the binlog mechanism, the three replication steps, and the three reliability modes—asynchronous, semi‑synchronous, and fully synchronous—while highlighting its impact on read throughput, backup, and disaster recovery.
The article outlines the problems of early data services, proposes a two‑step data warehouse solution—abstracting a data model and extracting, cleaning, and storing data from MySQL, MongoDB, and Elasticsearch—then details storage selection, dimensional modeling, incremental ETL, and Airflow workflow management.
This article explains the concepts of driving and driven tables in MySQL JOIN queries, shows how the optimizer chooses their order based on data size, indexes and filters, provides concrete examples with EXPLAIN output, and offers practical tips to control and improve table selection for better performance.
This tutorial shows how to let large language models autonomously invoke external services—specifically a MySQL database—by using the Model Context Protocol (MCP), covering environment setup, MCP service implementation, agent integration, and real‑world execution results.
This article explains MySQL master‑slave replication, covering its purpose for high availability, key features like real‑time disaster backup and read‑write separation, and the three essential steps—binlog recording on the master, I/O thread transfer to the relay log, and SQL thread replay on the slave.
This guide explains MySQL partitioning fundamentals, shows how to create RANGE, LIST, and KEY partitions with concrete CREATE TABLE examples, compares the performance benefits and maintenance trade‑offs, and clarifies the differences between partitioning and sharding to help you decide when to use each technique.
This article examines why PostgreSQL is often a better choice than MySQL for high‑performance workloads, covering architectural differences, indexing capabilities, query optimization, data types, concurrency control, benchmark results, and migration considerations, and provides code examples to illustrate each point.
Learn step-by-step how to design a MySQL categories table, retrieve data with PHP, construct a recursive tree based on parent_id, and render the hierarchical structure as an HTML list, providing a complete solution for managing nested product categories in e‑commerce applications.
This article explains MySQL indexes, their working principle, advantages and drawbacks, different index types, the B+Tree structure, comparisons with B‑Tree, and the differences between clustered and non‑clustered (auxiliary) indexes, providing clear examples and practical insights.
This article explains how MySQL indexes work, why wrapping indexed columns in functions can implicitly mask them, and how adding logical or domain‑knowledge‑based redundant conditions can unlock index usage to dramatically improve query efficiency.
This article explains how PostgreSQL and MySQL store IP addresses using native data types and functions, showing example table definitions, insertion and query statements for both IPv4 and IPv6, and highlights the advantages of using specialized types over plain VARCHAR.
The article walks through swapping MyBatis for MyBatis‑Plus in a legacy Java project, explains the LocalDateTime conversion error caused by MyBatis 3.5.1 and an outdated MySQL driver, shows how upgrading mysql‑connector‑java resolves the issue, and warns that component upgrades can trigger cascading bugs that require thorough testing.
This article explains why defining MySQL table columns as NOT NULL—unless business logic demands NULL—improves query speed, reduces storage overhead, enhances index efficiency, prevents aggregation distortion, simplifies application code, and strengthens data consistency, while also noting scenarios where NULL is appropriate.
This article explains how MySQL OR conditions can cause index loss, demonstrates typical scenarios with multi‑field, range, and dynamic filters, and provides practical solutions such as using UNION/UNION ALL or adding appropriate indexes to restore efficient query performance.
After a normal DDL change on OneDBA, the table size grew by nearly 100 % and some queries became slow because InnoDB’s B+Tree page‑splitting logic mishandles rows larger than 8 KB, causing each page to hold only one record and corrupting statistics.
Adding a new field to a core order table with tens of millions of rows can lock the table and disrupt services, so this article explores various strategies—including master‑slave switching, online DDL tools, extension tables, JSON fields, and repurposing redundant columns—to achieve schema changes safely and efficiently.
This article compares PostgreSQL and MySQL, covering their definitions, core similarities, key differences in performance, scalability, features, ecosystem, and community, and provides practical guidance on selecting the right database for various project scenarios.
Uber migrated its core database from PostgreSQL to MySQL because PostgreSQL suffered from index bloat, write amplification, high replication overhead, and limited MVCC support, prompting a detailed analysis of each issue, the improvements in newer PostgreSQL releases, and how MySQL’s architecture addresses these challenges.
This article compares PostgreSQL and MySQL across architecture, indexing, query optimization, data types, concurrency control, and real‑world benchmarks, showing why PostgreSQL generally outperforms MySQL in high‑throughput, complex‑query, and data‑intensive applications.
The article combines a surprising look at XiaoHongShu's record‑breaking graduate salaries with a comprehensive backend interview guide covering Redis advantages and drawbacks, common data structures, persistence and high‑availability, MySQL lock types, optimistic vs. pessimistic locking, message‑queue fundamentals, RabbitMQ vs. Kafka differences, deadlock avoidance, and a sample algorithm question.
This article explains the fundamentals of database indexes, covering what indexes are, their underlying structures such as B‑Tree, B+‑Tree and hash tables, their advantages and drawbacks, and the various index types—including primary, secondary, clustered and non‑clustered—used in MySQL engines.
This article explains MySQL's InnoDB storage architecture, how data and indexes are organized in 16 KB pages, calculates the capacity of B+ tree nodes, and determines that a table with 20 million rows requires a three‑level B+ tree under typical assumptions.
This article explains how MySQL's implicit type conversion during table joins can render indexes unusable or alter join order, and provides practical solutions such as aligning column types, using optimizer hints, and forcing indexes to restore query performance.
This tutorial shows how to download MySQL DEB bundles, extract them, resolve dependencies, and install MySQL 8.0 or 8.4 on Ubuntu 20.04/22.04/24.04 and Debian 12 using dpkg, with detailed command sequences and screenshots for each step.
This article compares how Oracle, MySQL, and PostgreSQL generate, view, and interpret execution plans, highlighting differences in hint support, caching, query efficiency, and providing practical commands and visual examples to help DBAs diagnose and optimize database performance.
While MySQL remains a reliable, widely-used relational database for simple applications, PostgreSQL’s extensibility, AI-friendly extensions, and growing developer preference—highlighted by recent Stack Overflow surveys—make it the stronger choice for modern, complex workloads, especially those involving vector search, time‑series, and geospatial data.
This tutorial walks you through establishing MySQL connections in PHP using both the mysqli extension and PDO, covering procedural and object‑oriented code, prepared statements, error handling, and proper connection closure for robust backend development.
This article compares MySQL’s SELECT DISTINCT and GROUP BY clauses, explaining their syntax, functional differences, performance implications, and ideal scenarios through detailed examples, index usage analysis, and a feature comparison table, helping developers choose the right approach for deduplication or aggregation tasks.
This guide walks you through adding the MySQL APT repository, selecting the desired MySQL version, installing required dependencies, configuring the package source, installing MySQL on Ubuntu 24.04 and Debian 11/12, enabling the service, and verifying the installation with status checks and database listings.
This article compares PostgreSQL and MySQL across architecture, indexing, complex query optimization, data‑type support, transaction handling, and real‑world benchmark results, showing why PostgreSQL is generally the better choice for high‑concurrency, data‑intensive applications.
This article explores how MySQL decides whether queries with IS NULL or IS NOT NULL predicates can use an index, presenting three concrete examples with varying data sizes and NULL distributions, and explains the underlying storage of NULL values and optimizer cost decisions.
This article provides a comprehensive, cross‑platform tutorial for downloading MySQL RPM bundles, installing required dependencies, using rpm or yum to install MySQL on various RHEL‑compatible distributions, starting the service, retrieving the temporary root password, and securely changing it to a permanent one.
This article outlines MySQL’s three primary replication architectures—async, semi‑sync, and full‑sync—detailing their mechanisms, typical topologies, performance trade‑offs, and suitable scenarios such as read‑heavy web services, high‑availability setups, and strict consistency requirements like financial transactions.
While MySQL has long dominated relational databases with its open‑source stability and massive user base, the rise of AI and PostgreSQL’s extensible ecosystem—highlighted by extensions like pgvector, pg_bm25, TimescaleDB and PostGIS—are shifting developer preference, as shown by the 2025 Stack Overflow survey.
This article explains the five MySQL temporal column types—DATE, DATETIME, TIMESTAMP, YEAR, and TIME—detailing their storage size, valid ranges, typical use‑cases, timezone behavior, and the 2038 problem, helping developers pick the most suitable type for any scenario.
This guide walks through setting up a Docker‑Compose environment, configuring Canal to capture MySQL binlog changes, integrating it with a SpringBoot client, and forwarding change events to RabbitMQ, providing complete code snippets and step‑by‑step instructions for real‑time data change tracking.
This guide provides a comprehensive collection of essential MySQL commands covering database creation, table schema management, data manipulation, user permissions, performance monitoring, and backup/restore procedures, offering a practical reference for developers and administrators.
The article recounts a real‑world incident where a massive MySQL table exceeded the INT auto‑increment limit, causing insert failures, and walks through analysis, three remediation strategies—including converting to BIGINT, using distributed IDs, and sharding—plus practical SQL scripts and performance insights for handling billions of rows.
This article explains how MySQL's OR conditions can cause index loss, provides concrete query examples, analyzes why the optimizer falls back to full table scans, and offers practical solutions such as rewriting with UNION or adding missing indexes to restore efficient index usage.
This article dives deep into MySQL beyond basic CRUD, covering remote user creation, permission grants, communication protocols like TCP/IP, named pipes, shared memory, Unix sockets, and advanced query optimization techniques including index usage, ORDER BY, and LIMIT offset strategies.
