Tagged articles
2671 articles
Page 22 of 27
Java Backend Technology
Java Backend Technology
Nov 21, 2019 · Databases

Boost MySQL Performance: 8 Proven Tricks to Slash Query Times

This article examines common MySQL performance pitfalls such as inefficient LIMIT usage, implicit type conversion, suboptimal joins, mixed sorting, and unpushed predicates, and demonstrates eight practical rewriting techniques—including using max values, JOINs, WITH clauses, and early range reduction—to dramatically accelerate query execution.

MySQLPerformance TuningSQL optimization
0 likes · 7 min read
Boost MySQL Performance: 8 Proven Tricks to Slash Query Times
Qunar Tech Salon
Qunar Tech Salon
Nov 20, 2019 · Databases

Redis Expiration Mechanisms and Key Deletion Strategies

This article explains how Redis manages key expiration using EXPIRE, PEXPIRE, EXPIREAT, and PEXPIREAT commands, details the internal expires dictionary, demonstrates code examples for setting, retrieving, and removing TTL, and discusses the lazy and periodic deletion strategies along with their impact on persistence and replication.

ExpirationKey DeletionLazy Deletion
0 likes · 22 min read
Redis Expiration Mechanisms and Key Deletion Strategies
21CTO
21CTO
Nov 18, 2019 · Backend Development

Building a Scalable Like System with Spring Cloud, Redis, and Quartz

This article explains how to design and implement a high‑frequency like/unlike feature for large social platforms using Spring Cloud, Redis caching, MySQL persistence, and Quartz scheduled jobs, covering Redis setup, data modeling, service interfaces, database schema, and periodic data synchronization.

Like SystemQuartzSpringBoot
0 likes · 19 min read
Building a Scalable Like System with Spring Cloud, Redis, and Quartz
ITPUB
ITPUB
Nov 15, 2019 · Databases

How Oracle Uses Cache, Buffer, and Write‑Back to Keep Data Consistent

The article explains the differences between cache and buffer, how Oracle’s log buffer and data buffer cache interact with various storage‑level caches, and why write‑back, battery‑backed caches, RAID and disk cache settings are crucial for maintaining data consistency during power loss.

CacheOracleWrite-Ahead Logging
0 likes · 6 min read
How Oracle Uses Cache, Buffer, and Write‑Back to Keep Data Consistent
AntTech
AntTech
Nov 13, 2019 · Databases

Evolution of Alipay’s Technical Architecture for Double 11 (2009‑2023): From SOFA to OceanBase and Cloud‑Native

This article chronicles Alipay’s engineering journey from 2009 to the present, detailing how its distributed middleware, database sharding, load‑balancing, LDC, OceanBase, cloud‑native Service Mesh, big‑data and blockchain technologies have been continuously refined to support ever‑growing Double 11 transaction volumes.

database
0 likes · 12 min read
Evolution of Alipay’s Technical Architecture for Double 11 (2009‑2023): From SOFA to OceanBase and Cloud‑Native
21CTO
21CTO
Nov 7, 2019 · Databases

How to Automate MySQL & MariaDB Backups on Jelastic PaaS

This guide explains how to create automated backup plans for MySQL and MariaDB databases on Jelastic PaaS, covering script configuration, cron scheduling, remote storage options, and restoring backups through phpMyAdmin, ensuring data safety and easy recovery.

JelasticMariaDBMySQL
0 likes · 7 min read
How to Automate MySQL & MariaDB Backups on Jelastic PaaS
360 Quality & Efficiency
360 Quality & Efficiency
Nov 1, 2019 · Mobile Development

Using uiautomator1.0 for Android Automation: Shell Context, PackageManager, Database, Activity & Process Monitoring, and Chinese Input Support

This article demonstrates how to leverage uiautomator1.0 for Android automation by creating a shell‑based Context, accessing PackageManager, managing SQLite databases, monitoring app activities and processes, and implementing Chinese text input through AccessibilityNodeInfo.

Androidautomationdatabase
0 likes · 4 min read
Using uiautomator1.0 for Android Automation: Shell Context, PackageManager, Database, Activity & Process Monitoring, and Chinese Input Support
System Architect Go
System Architect Go
Oct 27, 2019 · Databases

Mastering InfluxDB: Data Types, Schema Design, and Index Configuration

This guide explains InfluxDB’s schemaless data types, best practices for designing tag‑and‑field schemas, and how to choose and configure its in‑memory or TSI indexes, including key parameters such as max‑series‑per‑database and max‑values‑per‑tag for optimal performance.

InfluxDBTime Seriesconfiguration
0 likes · 6 min read
Mastering InfluxDB: Data Types, Schema Design, and Index Configuration
Big Data Technology & Architecture
Big Data Technology & Architecture
Oct 26, 2019 · Databases

KeyDB Multithreaded Architecture and Design Overview

KeyDB is a high‑performance, multithreaded fork of Redis that retains full Redis compatibility while delivering up to twice the query throughput and 60 % lower latency, and the article explains its thread model, connection management, fastlock mechanism, and active‑replica features in detail.

ArchitectureKeyDBLock
0 likes · 7 min read
KeyDB Multithreaded Architecture and Design Overview
Programmer DD
Programmer DD
Oct 26, 2019 · Databases

How JDTX Redefines Distributed Transactions with ACID Guarantees

This article introduces JDTX, a novel distributed transaction middleware that combines ACID guarantees, high performance, and 1PC architecture, explains its design principles, compares two‑phase commit with flexible transactions, details its MVCC and WAL implementation, and outlines integration with Apache ShardingSphere and future roadmap.

JDTXMVCCShardingSphere
0 likes · 19 min read
How JDTX Redefines Distributed Transactions with ACID Guarantees
macrozheng
macrozheng
Oct 22, 2019 · Databases

Mastering Redis Persistence: RDB, AOF, and Hybrid Strategies Explained

This article provides a comprehensive guide to Redis persistence mechanisms, covering the internal database structure, detailed operations of RDB snapshotting and AOF command logging, their configurations, advantages, drawbacks, hybrid persistence, and practical strategy recommendations for various deployment scenarios.

AOFHybridPersistence
0 likes · 34 min read
Mastering Redis Persistence: RDB, AOF, and Hybrid Strategies Explained
Tencent Cloud Developer
Tencent Cloud Developer
Oct 14, 2019 · Cloud Computing

Building a Mini-Program Operation Tool with Cloud Development: Maoyan's Practice

Maoyan Entertainment created the “Tangtu” mini‑program operation tool with WeChat Cloud Development, letting operations and product managers visually design, edit and publish holiday activities via cloud storage, database and functions, cutting staff from three to one, slashing development time and cost while highlighting the need for explicit environment variables and careful migration from traditional MySQL services.

Activity TemplateFrontend DevelopmentMini-program Operations
0 likes · 20 min read
Building a Mini-Program Operation Tool with Cloud Development: Maoyan's Practice
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 12, 2019 · Databases

How to Locate and Analyze Slow SQL Queries in MySQL

This article explains how to identify slow MySQL queries using the slow‑query log and SHOW PROCESSLIST, then demonstrates how to analyze their execution plans with EXPLAIN, covering key fields, common values, and practical examples for effective performance optimization.

MySQLPerformance Optimizationdatabase
0 likes · 13 min read
How to Locate and Analyze Slow SQL Queries in MySQL
Sohu Tech Products
Sohu Tech Products
Oct 9, 2019 · Databases

MongoDB Aggregation Framework: Stages, Pipelines, and Examples

This article provides an in‑depth overview of MongoDB’s aggregation framework, explaining the concepts of pipelines and stages such as $match, $group, $project, $lookup, $unwind, and $out, and includes practical code examples, syntax details, and comparisons to SQL aggregation.

MapReduceMongoDBPipeline
0 likes · 25 min read
MongoDB Aggregation Framework: Stages, Pipelines, and Examples
ITPUB
ITPUB
Oct 9, 2019 · Databases

What’s New in PostgreSQL 12? Performance Boosts and Advanced Features

PostgreSQL 12 brings major enhancements—including up to 40% faster queries on large datasets, improved indexing, partitioning, JSON path queries, generated columns, pluggable table access methods, stronger authentication, and built‑in JIT compilation—while also adding better localization, multi‑constraint authorization, and convenient maintenance commands.

JSONPartitioningPerformance
0 likes · 6 min read
What’s New in PostgreSQL 12? Performance Boosts and Advanced Features
FunTester
FunTester
Sep 28, 2019 · Backend Development

When VIP Expiration Hits 2038: Uncovering MySQL INT Overflow

A bug was discovered where a user's VIP expiration date could not extend beyond a specific day in 2038 because the timestamp was stored in a signed INT column, whose maximum value (2147483647) corresponds to 2038‑01‑19 11:14:07, causing the system to fail to save later dates.

INT overflowMySQLVIP expiration
0 likes · 3 min read
When VIP Expiration Hits 2038: Uncovering MySQL INT Overflow
Programmer DD
Programmer DD
Sep 27, 2019 · Databases

How to Use MySQL User Variables for Cumulative Daily User Counts

This article explains how to calculate cumulative daily user totals in MySQL using user-defined variables, demonstrates the necessary SQL queries, compares them with a Java‑style algorithm, and highlights important considerations such as variable initialization and practical pitfalls.

MySQLcumulative sumdaily active users
0 likes · 6 min read
How to Use MySQL User Variables for Cumulative Daily User Counts
dbaplus Community
dbaplus Community
Sep 26, 2019 · Databases

Mastering Oracle 12c Multitenant Backup & Recovery: A Step‑by‑Step Guide

An in‑depth exploration of Oracle 12c’s multitenant architecture explains key concepts, analyzes a real‑world backup failure, and provides a comprehensive, step‑by‑step RMAN procedure—including control file handling, datafile restoration, and selective tablespace skipping—to reliably recover pluggable databases.

BackupMultitenantOracle
0 likes · 13 min read
Mastering Oracle 12c Multitenant Backup & Recovery: A Step‑by‑Step Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 25, 2019 · Databases

MySQL Replication FAQ: Compatibility, Master‑Slave Behavior, Performance, and High‑Availability

This article provides a comprehensive MySQL replication FAQ covering cross‑OS and hardware compatibility, master‑slave connection behavior, monitoring lag, forcing master pause, bidirectional replication considerations, performance improvements, high‑availability setups, and how to exclude GRANT/REVOKE statements from replication.

Master‑SlaveMySQLPerformance
0 likes · 10 min read
MySQL Replication FAQ: Compatibility, Master‑Slave Behavior, Performance, and High‑Availability
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 16, 2019 · Databases

DBLE 2.19.07.0 Release Notes and Detailed Analysis

The article provides a comprehensive overview of DBLE version 2.19.07.0, including project background, new features, enhanced data import/export methods, updated show commands, protocol extensions, a full translated release‑notes list, bug‑fix details, and compatibility changes for this distributed database middleware.

Bug FixesDBLERelease Notes
0 likes · 11 min read
DBLE 2.19.07.0 Release Notes and Detailed Analysis
Architecture Digest
Architecture Digest
Sep 16, 2019 · Backend Development

Designing a Unified Multi-Account Login System: Schemas, Flows, and One-Click Authentication

This article outlines the design of a unified multi‑account login system, covering self‑built phone‑number authentication, optimized password‑less login, third‑party integrations, database schema separation, and a one‑click carrier‑based login to improve user experience and scalability.

Authenticationaccount‑designdatabase
0 likes · 16 min read
Designing a Unified Multi-Account Login System: Schemas, Flows, and One-Click Authentication
Amap Tech
Amap Tech
Sep 12, 2019 · Backend Development

Common Java Backend Issues and Solutions: Distributed Systems, Multithreading, and Data Access

The article distills years of Java backend experience into a concise checklist, showing how to replace JVM‑local locks with distributed locks, move thread‑blocked work to reliable message queues, model workflows with finite‑state machines, choose suitable inter‑service protocols, and always paginate queries to avoid memory and consistency problems.

databasedesign-patternsdistributed-systems
0 likes · 25 min read
Common Java Backend Issues and Solutions: Distributed Systems, Multithreading, and Data Access
Architecture Digest
Architecture Digest
Sep 11, 2019 · Databases

Distributed ID Generation Mechanisms: Auto‑Increment, Multi‑Master, Segment Mode, Snowflake and Redis

This article reviews various distributed ID generation strategies—including database auto‑increment tables, dual‑master MySQL setups, segment allocation, the Snowflake algorithm, and Redis INCR—detailing their designs, SQL examples, scalability trade‑offs, and open‑source implementations.

Segmentdatabasedistributed-id
0 likes · 13 min read
Distributed ID Generation Mechanisms: Auto‑Increment, Multi‑Master, Segment Mode, Snowflake and Redis
ITPUB
ITPUB
Sep 9, 2019 · Databases

Redis Interview Essentials: Top Questions & Expert Answers

This article compiles essential Redis interview questions covering its advantages over Memcached, performance pitfalls, data structures, persistence options, clustering, scaling strategies, and practical usage patterns such as distributed locks and asynchronous queues, providing concise answers and best‑practice recommendations for each topic.

PerformancePersistenceScalability
0 likes · 18 min read
Redis Interview Essentials: Top Questions & Expert Answers
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 6, 2019 · Databases

Setting Up MySQL 8.0 to MySQL 5.7 Replication

This guide explains how to configure replication from a MySQL 8.0 master to a MySQL 5.7 slave, covering supported version combinations, character‑set adjustments, authentication plugin changes, user creation, CHANGE MASTER commands, status verification, quick testing, and common pitfalls when using newer MySQL features.

MySQLMySQL5.7MySQL8
0 likes · 7 min read
Setting Up MySQL 8.0 to MySQL 5.7 Replication
Tencent Cloud Developer
Tencent Cloud Developer
Sep 5, 2019 · Cloud Computing

Understanding Cloud Development for WeChat Mini‑Game Applications

The August 17 “Mini‑Program·Cloud Development” salon explained how Tencent Cloud’s server‑less BaaS/FaaS platform lets WeChat mini‑game developers replace traditional H5 back‑ends with lightweight cloud functions, databases and CDN storage, cutting development time from hours to minutes, while supporting real‑time sync, token management, and future SDK expansions.

Cloud FunctionsFrontend DevelopmentServerless
0 likes · 17 min read
Understanding Cloud Development for WeChat Mini‑Game Applications
Big Data Technology Architecture
Big Data Technology Architecture
Aug 29, 2019 · Databases

19 Common MySQL Optimization Techniques

This article presents nineteen practical MySQL optimization methods—including using EXPLAIN, limiting IN clause size, specifying columns in SELECT, proper use of LIMIT, avoiding costly ORDER BY RAND(), choosing between IN and EXISTS, leveraging full‑text indexes, and applying join and index best practices—to improve query performance and reduce resource consumption.

MySQLPerformancedatabase
0 likes · 11 min read
19 Common MySQL Optimization Techniques
NetEase Game Operations Platform
NetEase Game Operations Platform
Aug 24, 2019 · Databases

MongoDB Index Optimization for High‑Write CMDB Workloads and Slow‑Log Reduction

This article analyzes the performance bottlenecks of a MongoDB‑based CMDB under high write concurrency, explains index structures and storage, demonstrates how to identify and eliminate full‑table scans and redundant multikey indexes, and shows the resulting reduction in slow‑log volume and CPU usage.

Index OptimizationMongoDBPerformance Tuning
0 likes · 36 min read
MongoDB Index Optimization for High‑Write CMDB Workloads and Slow‑Log Reduction
Java Captain
Java Captain
Aug 22, 2019 · Databases

Redis Data Structures and Common Commands Overview

This article introduces Redis's fundamental and advanced data structures, explains how each is represented internally, and provides detailed examples of essential commands such as KEYS, EXISTS, DEL, EXPIRE, TTL, and TYPE, highlighting their usage, complexity, and best‑practice considerations.

Data Structurescommandsdatabase
0 likes · 10 min read
Redis Data Structures and Common Commands Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 10, 2019 · Databases

Weekly Community Digest: MySQL Rankings, Percona XtraBackup 8.0.7 Release, DBLE & DTLE Updates, and Technical Articles

This weekly digest highlights the August MySQL ranking surge, Percona XtraBackup 8.0.7 features, free Mycat diagnostic support, DBLE and DTLE weekly reports, and several in‑depth technical articles covering MySQL cloning, group replication, charset performance, ZooKeeper deployment, and InnoDB index construction.

DBLEDTLEInnoDB
0 likes · 5 min read
Weekly Community Digest: MySQL Rankings, Percona XtraBackup 8.0.7 Release, DBLE & DTLE Updates, and Technical Articles
Meitu Technology
Meitu Technology
Aug 9, 2019 · Databases

Redis 6 Multithreaded I/O Implementation and Performance Evaluation

The article details Redis 6’s new multithreaded I/O feature—motivated by network‑I/O bottlenecks, implemented with lock‑free pending‑read queues that offload reads, writes, and protocol parsing to worker threads while keeping command execution single‑threaded—and demonstrates through a simple benchmark that using four I/O threads roughly doubles GET/SET throughput compared with Redis 5.

BenchmarkMultithreaded I/OPerformance
0 likes · 11 min read
Redis 6 Multithreaded I/O Implementation and Performance Evaluation
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 9, 2019 · Databases

InnoDB Index Build Process and Fill Factor in MySQL 5.7+

Since MySQL 5.7 InnoDB builds secondary indexes using a bottom‑up, sorted‑index approach, the article explains the three build phases, presents a step‑by‑step B‑tree construction example with SQL code, and discusses the innodb_fill_factor setting, its impact, advantages, and drawbacks.

B+TreeInnoDBMySQL
0 likes · 11 min read
InnoDB Index Build Process and Fill Factor in MySQL 5.7+
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 6, 2019 · Databases

MySQL Group Replication Version Compatibility Policies and Upgrade Guidelines

Starting with MySQL 8.0.17, Group Replication introduces patch‑level version compatibility policies that govern primary‑member election, write‑ability, donor selection, and upgrade procedures for mixed‑version clusters, ensuring safe operation during rolling upgrades and multi‑primary mode transitions.

Group ReplicationMySQLVersion Compatibility
0 likes · 12 min read
MySQL Group Replication Version Compatibility Policies and Upgrade Guidelines
FunTester
FunTester
Aug 3, 2019 · Mobile Development

How to Use Java Multithreading for Database Operations in Android UIAutomator Tests

The article demonstrates a simple Java ThreadTest class that enables concurrent database updates during Android UIAutomator and Selenium‑Java test cases, showing how to control execution with key flags, integrate the thread into test methods, and optionally use join() to avoid exceptions.

SeleniumUIAutomatordatabase
0 likes · 4 min read
How to Use Java Multithreading for Database Operations in Android UIAutomator Tests
ITPUB
ITPUB
Aug 1, 2019 · Databases

Mastering NewLife.Redis: Architecture, Usage, and Performance Tips

This article explains the two‑layer architecture of NewLife.Redis, demonstrates basic and advanced usage with code examples, shares stress‑test results achieving hundreds of thousands of operations per second, and provides practical tips and FAQs for high‑performance Redis deployments.

BenchmarkPerformancecaching
0 likes · 11 min read
Mastering NewLife.Redis: Architecture, Usage, and Performance Tips
Architects' Tech Alliance
Architects' Tech Alliance
Jul 31, 2019 · Databases

Overview of Five Common Data Replication Technologies

This article introduces the global data replication market, explains synchronous and asynchronous replication, and details five typical replication techniques—host‑based, application/middleware‑based, database‑based, storage‑gateway‑based, and storage‑media‑based—highlighting their principles, advantages, and trade‑offs for disaster‑recovery planning.

Asynchronous Replicationdata replicationdatabase
0 likes · 11 min read
Overview of Five Common Data Replication Technologies
ITPUB
ITPUB
Jul 31, 2019 · Databases

8 MySQL Query Optimizations to Slash Execution Time

This article presents practical MySQL performance tricks—including smarter LIMIT usage, avoiding implicit type conversion, rewriting UPDATE/DELETE with JOIN, handling mixed ordering, replacing EXISTS with JOIN, pushing down conditions, narrowing result sets early, and leveraging WITH clauses—to dramatically reduce query execution times.

MySQLPerformance TuningQuery Rewrite
0 likes · 14 min read
8 MySQL Query Optimizations to Slash Execution Time
ITPUB
ITPUB
Jul 26, 2019 · Databases

Why KEYS Can Crash Redis and How SCAN Keeps It Responsive

The article explains how using the KEYS command on millions of Redis keys blocks the single‑threaded server, causing outages, and demonstrates how the incremental SCAN command with cursor, MATCH, and COUNT options provides a safe, non‑blocking way to iterate large keyspaces.

KEYSPerformanceSCAN
0 likes · 5 min read
Why KEYS Can Crash Redis and How SCAN Keeps It Responsive
ITPUB
ITPUB
Jul 25, 2019 · Databases

Master Oracle Database: Create, Backup, Restore, and Manage Tables & Data

This guide provides step‑by‑step Oracle commands for creating and dropping databases, performing full and selective backups, restoring data locally or remotely, managing tables—including creation, deletion, renaming, column alterations, primary keys, indexes, and views—as well as querying, inserting, updating, deleting, and copying data efficiently.

BackupOracleRestore
0 likes · 8 min read
Master Oracle Database: Create, Backup, Restore, and Manage Tables & Data
Architect's Tech Stack
Architect's Tech Stack
Jul 25, 2019 · Databases

Database Command and Design Standards

The article outlines comprehensive MySQL database standards covering naming conventions, table and column design, index strategies, SQL development practices, and operational guidelines to improve performance, maintainability, and security, including recommendations on data types, character sets, reserved fields, binary data storage, and safe query patterns.

SQL Best Practicesdatabaseindex design
0 likes · 21 min read
Database Command and Design Standards
FunTester
FunTester
Jul 24, 2019 · Backend Development

Method‑Based Multithreaded Performance Testing Framework in Java

The article describes a Java performance testing framework that was refactored from a request‑based to a method‑based design, introducing a ThreadBase class and specialized adapters for HTTP requests, database queries, and concurrent execution, and discusses the advantages of code‑based concurrency and Groovy.

GroovyHTTPPerformance Testing
0 likes · 12 min read
Method‑Based Multithreaded Performance Testing Framework in Java
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 23, 2019 · Databases

MySQL 8.0.17 Release Highlights: Cloning, JSON Multi‑Value Indexes, Optimizer Improvements, and More

MySQL 8.0.17 introduces server cloning via MySQL Shell, multi‑value indexes for JSON arrays, enhanced JSON schema validation, optimizer and Volcano iterator upgrades, new collations, replication and routing enhancements, plus numerous bug fixes and deprecations, all detailed in the official release notes.

JSON IndexMySQLRelease Notes
0 likes · 8 min read
MySQL 8.0.17 Release Highlights: Cloning, JSON Multi‑Value Indexes, Optimizer Improvements, and More
MaGe Linux Operations
MaGe Linux Operations
Jul 20, 2019 · Operations

When a Production Database Vanishes: Lessons from a Dev’s Nightmare

A developer recounts how a misconfigured production environment led to the accidental deletion of both content and user databases, the frantic scramble to diagnose the issue, the discovery of a backup oversight, and the hard‑earned lessons on backups, testing, and authentication security.

AuthenticationBackupdatabase
0 likes · 9 min read
When a Production Database Vanishes: Lessons from a Dev’s Nightmare
Architects' Tech Alliance
Architects' Tech Alliance
Jul 19, 2019 · Backend Development

Evolution of Taobao Backend Architecture from Single Machine to Cloud‑Native High Concurrency

The article traces Taobao's backend architecture evolution—from a single‑machine setup through caching, load balancing, database sharding, microservices, containerization, and cloud deployment—illustrating the technologies and design principles needed to scale from hundreds to tens of millions of concurrent users.

ArchitectureMicroservicesScalability
0 likes · 19 min read
Evolution of Taobao Backend Architecture from Single Machine to Cloud‑Native High Concurrency
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 13, 2019 · Databases

Weekly Community Digest: MySQL 8.0.17 New Features, Redis 6 Release, DBLE & DTLE Updates, and Upcoming Shanghai Meetup

This weekly digest summarizes the latest MySQL 8.0.17 enhancements, Redis 6's new RESP3 protocol, free Mycat diagnostics, DBLE and DTLE weekly reports, original technical articles on MySQL fragmentation, dynamic permissions and TempTable engine, plus details of the upcoming Shanghai 3306π meetup.

DBLEDTLEMySQL
0 likes · 7 min read
Weekly Community Digest: MySQL 8.0.17 New Features, Redis 6 Release, DBLE & DTLE Updates, and Upcoming Shanghai Meetup
DataFunTalk
DataFunTalk
Jun 28, 2019 · Databases

Deep Dive into Phoenix Index Creation, Maintenance, and SQL Compilation

This article provides a detailed technical analysis of Phoenix's native index creation and maintenance mechanisms, the underlying source code for index building, the role of coprocessors, and the complete SQL compilation pipeline from parsing to execution, highlighting how hints and optimizers influence index usage.

CoprocessorHBasePhoenix
0 likes · 26 min read
Deep Dive into Phoenix Index Creation, Maintenance, and SQL Compilation
Tencent Cloud Developer
Tencent Cloud Developer
Jun 27, 2019 · Databases

Evolution and Technical Analysis of Tencent Cloud Databases: TDSQL and CynosDB

Tencent Cloud’s database evolution progressed from early open‑source integration to self‑developed, cloud‑native solutions, producing the distributed, high‑availability TDSQL and the compute‑storage‑separated, log‑sinking CynosDB, each featuring advanced scheduling, sharding, cost‑based optimization, and asynchronous log replay to deliver scalable, low‑latency performance for diverse workloads.

Cloud NativeCynosDBDistributed Systems
0 likes · 17 min read
Evolution and Technical Analysis of Tencent Cloud Databases: TDSQL and CynosDB
Tencent Database Technology
Tencent Database Technology
Jun 27, 2019 · Databases

Analysis and Optimization of InnoDB lock_wait_thread Contention in a Tencent Cloud Database

The article investigates intermittent slow update performance in a Tencent Cloud internal system caused by massive lock_wait_thread contention, analyzes the underlying InnoDB lock mechanisms and thread behavior, implements a fix by disabling lock_wait_suspend_thread triggers, and demonstrates substantial latency reduction through benchmark results.

InnoDBMySQLPerformance Optimization
0 likes · 8 min read
Analysis and Optimization of InnoDB lock_wait_thread Contention in a Tencent Cloud Database
Youzan Coder
Youzan Coder
Jun 26, 2019 · Databases

Avoid Common Druid Connection Pool Pitfalls: Key Configurations Explained

This article examines Druid 1.1.5 connection‑pool settings—maxWait, connectionProperties, keepAlive, maxActive—illustrates real‑world cases of misconfiguration, provides recommended values, and shares a step‑by‑step investigation of a DB slow‑query incident to help engineers prevent performance and stability issues.

Connection PoolDruidPerformance
0 likes · 12 min read
Avoid Common Druid Connection Pool Pitfalls: Key Configurations Explained
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 25, 2019 · Databases

Performance Analysis of MySQL Row‑Based Binlog Replay for Large Table Delete without WHERE Clause

The article investigates why a DELETE without a WHERE clause on a 500k‑row MySQL table takes over ten hours to replay on a slave, analyzes row‑mode binlog replay mechanisms, compares different slave_rows_search_algorithms, presents test results, and offers practical recommendations for improving replication performance.

BinlogMySQLPerformance
0 likes · 10 min read
Performance Analysis of MySQL Row‑Based Binlog Replay for Large Table Delete without WHERE Clause
Qunar Tech Salon
Qunar Tech Salon
Jun 25, 2019 · Databases

Recap of QInfrarch 2019: Technical Talks on Private Cloud, Real‑time Hotel Computing, Intelligent Ticket Customer Service, and OceanBase

The 2019 QInfrarch technical carnival in Suzhou gathered nearly 160 engineers from Qunar and partner companies to share in‑depth sessions on private cloud databases, real‑time hotel computation, AI‑driven ticket customer service, and OceanBase architecture, concluding with networking, tea breaks, and a lucky‑draw for attendees.

AI Customer ServiceOceanBaseQInfrarch
0 likes · 5 min read
Recap of QInfrarch 2019: Technical Talks on Private Cloud, Real‑time Hotel Computing, Intelligent Ticket Customer Service, and OceanBase
Java Backend Technology
Java Backend Technology
Jun 24, 2019 · Backend Development

What I Learned from 2 Months of Java Backend Interviews: Tips & Insights

Over two months, I interviewed with multiple companies for Java backend roles, sharing detailed experiences from technical rounds—covering JVM, concurrency, distributed locks, databases, and system design—to highlight key questions, effective answers, and practical advice for succeeding in similar backend development interviews.

Distributed SystemsJVMconcurrency
0 likes · 17 min read
What I Learned from 2 Months of Java Backend Interviews: Tips & Insights
Alibaba Cloud Developer
Alibaba Cloud Developer
Jun 24, 2019 · Databases

How X‑Engine Redefines LSM Storage for High‑Performance E‑Commerce

This article provides an in‑depth technical overview of Alibaba's X‑Engine storage engine, explaining its LSM‑based architecture, compaction optimizations, transaction pipeline, caching strategies, and how these innovations enable low‑cost, high‑throughput OLTP for large‑scale e‑commerce workloads.

LSMPolarDB-XStorage Engine
0 likes · 18 min read
How X‑Engine Redefines LSM Storage for High‑Performance E‑Commerce
NetEase Game Operations Platform
NetEase Game Operations Platform
Jun 15, 2019 · Databases

Using MongoDB Change Streams for Real‑Time Data Synchronization

The article explains how MongoDB Change Streams, introduced in version 3.6 and expanded in 4.0, enable near‑real‑time subscription to collection, database, and cluster changes, discusses implementation details, options, code examples in the mongo shell and Python, and provides practical testing insights and driver compatibility notes.

Change StreamsMongoDBPython
0 likes · 12 min read
Using MongoDB Change Streams for Real‑Time Data Synchronization
ITPUB
ITPUB
Jun 11, 2019 · Databases

Why KEYS Can Crash Your Redis and How SCAN Keeps It Running

The article explains how using the KEYS command on large Redis datasets can block the single‑threaded server and cause outages, and demonstrates how the incremental SCAN command safely retrieves keys without impacting performance, including syntax, options, and practical examples.

KEYSPerformanceSCAN
0 likes · 4 min read
Why KEYS Can Crash Your Redis and How SCAN Keeps It Running
Java Captain
Java Captain
May 31, 2019 · Databases

Common MySQL Query Performance Issues and Optimization Techniques

This article examines frequent MySQL performance problems such as inefficient LIMIT pagination, implicit type conversion, sub‑query updates, mixed ordering, EXISTS usage, condition push‑down limits, early result set reduction, and intermediate result set optimization, providing rewritten SQL examples that dramatically improve execution speed.

MySQLPerformance Tuningdatabase
0 likes · 11 min read
Common MySQL Query Performance Issues and Optimization Techniques
Java Backend Technology
Java Backend Technology
May 31, 2019 · Databases

Why MySQL UPDATE Appears to Do Nothing and How to Fix It

This article explains why a syntactically correct MySQL UPDATE statement may seem ineffective, demonstrates the difference between using commas and the AND operator for multi‑column updates, and provides the proper syntax to ensure the intended rows are modified.

MySQLSQL syntaxUPDATE
0 likes · 3 min read
Why MySQL UPDATE Appears to Do Nothing and How to Fix It
dbaplus Community
dbaplus Community
May 29, 2019 · Databases

Redis Replication Deep Dive: PSYNC, Full & Partial Sync, Heartbeats and Async Writes

This guide explains Redis replication in depth, detailing the step‑by‑step slave‑of initiation, the PSYNC command’s role in data synchronization, the full and partial sync processes, heartbeat mechanisms, and asynchronous write propagation, while highlighting key configuration parameters and performance considerations.

Full SyncPSYNCPartial Sync
0 likes · 11 min read
Redis Replication Deep Dive: PSYNC, Full & Partial Sync, Heartbeats and Async Writes
21CTO
21CTO
May 27, 2019 · Databases

Mastering Redis: When to Use Strings, Lists, Sets, Hashes, and Zsets

This article explains Redis' core data types—strings, lists, sets, hashes, sorted sets, and more—detailing their characteristics, common commands, practical use‑cases such as caching, counters, distributed locks, and ranking, and provides best‑practice tips for key design and performance.

Data Structuresdatabasedistributed-lock
0 likes · 7 min read
Mastering Redis: When to Use Strings, Lists, Sets, Hashes, and Zsets
dbaplus Community
dbaplus Community
May 26, 2019 · Databases

Why Is MySQL Query Slow? Common Causes and How to Diagnose Them

This article explains why a MySQL statement may run slowly—whether only occasionally or every time—by examining redo‑log flushing, lock contention, missing or misused indexes, optimizer mis‑estimates, and provides practical commands to identify and resolve each issue.

MySQLdatabaseindexes
0 likes · 12 min read
Why Is MySQL Query Slow? Common Causes and How to Diagnose Them