BestHub
Sign in
Tagged articles

performance tuning

1102 articles · Page 9 of 12
MaGe Linux Operations
MaGe Linux Operations
Jul 19, 2020 · Databases

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

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

MySQLSQLdatabase partitioning
0 likes · 14 min read
Optimizing Zabbix with MySQL: Version Tips, Permissions, and Partitioning Strategies
ITPUB
ITPUB
Jul 15, 2020 · Databases

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

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

EXPLAINMySQLSQL
0 likes · 19 min read
Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization
21CTO
21CTO
Jul 9, 2020 · Databases

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

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

Batch DeleteIndex OptimizationMySQL
0 likes · 15 min read
How to Optimize Large MySQL Tables: Index Tuning, Online DDL, and Efficient Deletion
Ctrip Technology
Ctrip Technology
Jul 9, 2020 · Backend Development

Lessons from QMQ: Network and Disk I/O Problems and Their Mitigations

The article analyzes real‑world network and disk I/O issues encountered in Qunar Message Queue (QMQ), explains root causes such as Netty OOM, file‑handle exhaustion, TCP timeout handling, and large‑traffic bursts, and presents practical mitigation strategies for backend systems.

Network IOQMQdisk-io
0 likes · 11 min read
Lessons from QMQ: Network and Disk I/O Problems and Their Mitigations
iQIYI Technical Product Team
iQIYI Technical Product Team
Jul 3, 2020 · Artificial Intelligence

Optimizing Video Inference Services for High GPU Utilization in AI Applications

By moving decoding, color conversion, preprocessing, inference, and re‑encoding entirely onto the GPU and enabling batch processing with flexible Python scripts, iQIYI’s video‑image enhancement service achieved ten‑fold throughput, over 90 % GPU utilization, and dramatically lower resource use, accelerating AI video inference deployment.

AI DeploymentDeepStreamGPU optimization
0 likes · 14 min read
Optimizing Video Inference Services for High GPU Utilization in AI Applications
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 3, 2020 · Databases

PostgreSQL Q&A: Use Cases, Oracle Comparison, Features, Migration and Best Practices

This article compiles a series of questions and answers from a recent PostgreSQL live session, covering recommended scenarios, differences with Oracle, backup and recovery, clustering, PostGIS, stored procedures, migration tips, version recommendations, performance tuning, high‑availability, and real‑world adoption across industries.

Oracle migrationPostgreSQLdatabase
0 likes · 10 min read
PostgreSQL Q&A: Use Cases, Oracle Comparison, Features, Migration and Best Practices
Efficient Ops
Efficient Ops
Jul 1, 2020 · Databases

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

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

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

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

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

MySQLSQL optimizationindex
0 likes · 7 min read
MySQL View Optimization: Fixing Slow Query Caused by Character Set Conversion
Java Architect Essentials
Java Architect Essentials
Jun 22, 2020 · Operations

ActiveMQ Message Queue Optimization: Removing Synchronized Lock and Tuning queuePrefetch

This article analyzes a severe ActiveMQ message‑queue backlog caused by a synchronized onMessage listener, then demonstrates how removing the lock and tuning the queuePrefetch parameter, along with a dual‑queue redesign, can boost consumption throughput by over thirty times, eliminating the data pile‑up.

ActiveMQconcurrencymessage queue
0 likes · 8 min read
ActiveMQ Message Queue Optimization: Removing Synchronized Lock and Tuning queuePrefetch
Java Captain
Java Captain
Jun 14, 2020 · Databases

MySQL Single‑Table Optimization, Indexing, Partitioning, and Sharding Strategies

This article presents comprehensive techniques for improving MySQL performance on large single tables, covering column choices, index design, query writing, engine selection, system parameters, hardware upgrades, read‑write splitting, caching, table partitioning, vertical and horizontal sharding, and guidance on selecting mature sharding solutions.

MySQLPartitioningdatabase optimization
0 likes · 27 min read
MySQL Single‑Table Optimization, Indexing, Partitioning, and Sharding Strategies
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 10, 2020 · Backend Development

Elasticsearch Index and Search Optimization Guide

This article provides a comprehensive overview of Elasticsearch architecture and presents practical index and search optimization techniques, configuration recommendations, stress‑testing methods, and monitoring tools to improve cluster performance and reliability.

Cluster ConfigurationElasticsearchSearch Optimization
0 likes · 13 min read
Elasticsearch Index and Search Optimization Guide
dbaplus Community
dbaplus Community
May 31, 2020 · Databases

Why Intel’s PAUSE Instruction Slows MySQL on Skylake CPUs and How to Fix It

This article examines how the increased latency of Intel's PAUSE instruction on Skylake CPUs creates a performance bottleneck for MySQL, details the profiling steps that identified ut_delay as the hotspot, and presents a series of optimizations—including spin‑wait parameter tuning and a MySQL 8.0 patch—that restore throughput on affected hardware.

CPU performanceMySQLpause instruction
0 likes · 19 min read
Why Intel’s PAUSE Instruction Slows MySQL on Skylake CPUs and How to Fix It
Big Data Technology & Architecture
Big Data Technology & Architecture
May 28, 2020 · Big Data

Hadoop System Bottleneck Detection and MapReduce Optimization Guide

This article provides a comprehensive guide on detecting Hadoop system bottlenecks, analyzing resource constraints, and applying practical MapReduce performance tuning techniques—including baseline creation, counter analysis, combiner usage, compression, and proper Writable types—to achieve optimal big‑data processing efficiency.

HadoopMapReduceOptimization
0 likes · 11 min read
Hadoop System Bottleneck Detection and MapReduce Optimization Guide
Laravel Tech Community
Laravel Tech Community
May 18, 2020 · Databases

MySQL Large‑Table Index Optimization and Delete Performance Improvement

This article analyzes a MySQL master‑slave instance with a massive arrival_record table, identifies slow‑query causes using pt‑query‑digest and tcpdump, proposes index redesign, demonstrates backup/restore with mydumper, compares online DDL and pt‑osc, and presents batch‑delete strategies that dramatically reduce SLA‑triggering latency.

Batch DeleteIndex OptimizationLarge Table
0 likes · 14 min read
MySQL Large‑Table Index Optimization and Delete Performance Improvement
Big Data Technology Architecture
Big Data Technology Architecture
May 15, 2020 · Big Data

Performance Tuning of Hive on Spark in YARN Mode

This article explains how to optimize Hive on Spark running on YARN, covering YARN node resource configuration, Spark executor and driver memory settings, dynamic allocation, parallelism, and key Hive parameters to achieve superior performance compared to Hive on MapReduce.

Cluster ConfigurationHiveSpark
0 likes · 11 min read
Performance Tuning of Hive on Spark in YARN Mode
ITPUB
ITPUB
May 10, 2020 · Databases

How We Migrated MySQL to Tencent Cloud CDB and Boosted Performance Up to 10×

This case study details the migration of Weimeng's MySQL databases to Tencent Cloud CDB, describing the testing methodology, performance bottlenecks discovered (NUMA, network parameters, low‑concurrency issues, and version bugs), the step‑by‑step optimizations applied, and the resulting QPS improvements across various workloads.

MySQLNUMATencent Cloud CDB
0 likes · 20 min read
How We Migrated MySQL to Tencent Cloud CDB and Boosted Performance Up to 10×
Big Data Technology Architecture
Big Data Technology Architecture
Apr 24, 2020 · Databases

Best Practices for HBase Region Count and Size to Improve Cluster Stability and Performance

The article explains how maintaining an optimal number of HBase regions (typically 20‑200 per RegionServer) and appropriate region size, along with careful MemStore and compaction settings, can prevent memory pressure, reduce GC pauses, and enhance overall cluster stability and throughput.

Cluster OptimizationHBaseRegion Management
0 likes · 5 min read
Best Practices for HBase Region Count and Size to Improve Cluster Stability and Performance
Java Architect Essentials
Java Architect Essentials
Apr 17, 2020 · Fundamentals

Comprehensive Java JVM Interview Guide: Architecture, Memory, GC, Class Loading, and Optimization

This article provides an extensive overview of Java Virtual Machine fundamentals for interview preparation, covering JVM components, runtime data areas, heap vs. stack memory, garbage collection mechanisms, algorithms, collectors, memory allocation strategies, class loading processes, and tuning tools.

Class LoadingJVMgarbage collection
0 likes · 31 min read
Comprehensive Java JVM Interview Guide: Architecture, Memory, GC, Class Loading, and Optimization
Youzan Coder
Youzan Coder
Apr 15, 2020 · Databases

Optimizing Druid Connection Pool: Practical Configurations and Tuning Guide

This article explains how to size and tune Druid's connection pool for high‑traffic Java applications, covering pool‑size formulas, timeout settings, keep‑alive behavior, essential XML properties, and version recommendations to prevent misleading SQL latency and improve overall database stability.

DruidJavaconnection pool
0 likes · 10 min read
Optimizing Druid Connection Pool: Practical Configurations and Tuning Guide
Liangxu Linux
Liangxu Linux
Apr 12, 2020 · Databases

Essential MySQL Performance Tuning Tools and How to Use Them

This guide introduces four open‑source MySQL tuning utilities—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download and run each tool, and shows how to interpret their AWR‑style reports for concrete performance and security improvements.

Database ToolsMySQLOptimization
0 likes · 9 min read
Essential MySQL Performance Tuning Tools and How to Use Them
Java Architect Essentials
Java Architect Essentials
Apr 8, 2020 · Cloud Native

Rainbond (CloudHelp) Installation and Optimization Guide

This article provides a comprehensive step‑by‑step guide for installing, configuring, and performance‑tuning the Rainbond (formerly CloudHelp) Kubernetes‑based platform, covering prerequisites, FAQ, installation commands, node addition, kernel and system parameter adjustments, and post‑installation verification.

Cloud NativeDevOpsInstallation
0 likes · 11 min read
Rainbond (CloudHelp) Installation and Optimization Guide
Tencent Cloud Developer
Tencent Cloud Developer
Apr 5, 2020 · Databases

Database Operations, Optimization, High Availability and Self‑Service – Insights from DBA Yang Jianrong

Senior DBA Yang Jianrong shares how standardized processes, robust security, and modern optimization—such as partitioning, middleware, and NoSQL—combined with high‑availability designs and self‑service tools like automated slow‑log analysis can streamline large‑scale MySQL operations, migrations, and continuous DBA learning.

DBAOptimizationbackup
0 likes · 24 min read
Database Operations, Optimization, High Availability and Self‑Service – Insights from DBA Yang Jianrong
ITPUB
ITPUB
Apr 3, 2020 · Databases

Essential SQL Server Queries: From Server Properties to Index Management

A comprehensive collection of SQL Server commands covering server properties, configuration, system views, monitoring, backup, replication, Always On, file management, index operations, and troubleshooting techniques for database administrators.

Always OnBackup MonitoringSQL Server
0 likes · 28 min read
Essential SQL Server Queries: From Server Properties to Index Management
FunTester
FunTester
Apr 3, 2020 · Fundamentals

JVM Memory Model, GC Log Analysis, and Production Parameter Optimization

This article examines production JVM memory architecture, explains GC log generation and analysis, details the ParNew + CMS collector behavior, and provides practical parameter tuning recommendations to optimize heap size, young generation, and garbage collection for stable Java applications in production environments.

JVMJavagarbage collection
0 likes · 10 min read
JVM Memory Model, GC Log Analysis, and Production Parameter Optimization
Architects Research Society
Architects Research Society
Apr 2, 2020 · Operations

Optimizing NGINX and Linux Settings for High Performance

This article provides a comprehensive guide to tuning Linux kernel parameters and NGINX configuration directives—such as backlog queues, file descriptors, worker processes, keepalive settings, access log buffering, sendfile, and limits—to achieve optimal web server performance for high‑traffic sites.

ConfigurationLinuxNginx
0 likes · 10 min read
Optimizing NGINX and Linux Settings for High Performance
FunTester
FunTester
Apr 1, 2020 · Backend Development

Mastering JVM Performance: 6 Essential Parameters and GC Tuning Tips

Learn how to optimize Java applications by configuring six critical JVM parameters—including heap size, Metaspace limits, GC algorithm selection, logging, heap dumps, thread stack size, and network timeouts—while understanding their impact on performance, memory usage, and troubleshooting common out‑of‑memory issues.

Heap DumpJVMJava
0 likes · 9 min read
Mastering JVM Performance: 6 Essential Parameters and GC Tuning Tips
ITPUB
ITPUB
Mar 23, 2020 · Databases

Essential MySQL Performance Tuning Tools: MySQLTuner, Tuning‑Primer, and Percona Toolkit

This guide introduces four open‑source MySQL diagnostic utilities—MySQLTuner, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining how to download, run them against a live server, interpret the generated AWR‑style reports, and apply the recommended configuration changes for better stability and speed.

MySQLdatabase optimizationmysqltuner
0 likes · 8 min read
Essential MySQL Performance Tuning Tools: MySQLTuner, Tuning‑Primer, and Percona Toolkit
Programmer DD
Programmer DD
Mar 21, 2020 · Databases

Essential MySQL Performance Tuning Tools and How to Use Them

This guide introduces four key MySQL optimization utilities—mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest—explains how to download, install, and run each tool, and shows how to interpret their health‑check reports to identify performance bottlenecks, configuration issues, and security risks.

MySQLdatabase optimizationpercona-toolkit
0 likes · 8 min read
Essential MySQL Performance Tuning Tools and How to Use Them
Open Source Linux
Open Source Linux
Mar 19, 2020 · Operations

Essential Ops Playbook: Avoid Costly Mistakes in Server Management

This guide shares practical Linux server operation rules, emphasizing thorough testing, careful use of destructive commands, strict access control, regular backups, security hardening, continuous monitoring, and disciplined performance tuning to prevent costly outages and data loss.

Server Operationsbackupmonitoring
0 likes · 13 min read
Essential Ops Playbook: Avoid Costly Mistakes in Server Management
360 Tech Engineering
360 Tech Engineering
Mar 12, 2020 · Databases

TiDB on 360 Cloud Platform: Deployment, Migration, and Performance Tuning

This article shares the experience of deploying TiDB on the 360 Cloud Platform, covering background challenges with massive tables, TiDB's online DDL and high‑performance features, cluster architecture, DM migration workflow, common operational issues, and detailed tuning parameters to improve latency, QPS, and resource utilization.

DMSQLTiDB
0 likes · 22 min read
TiDB on 360 Cloud Platform: Deployment, Migration, and Performance Tuning
dbaplus Community
dbaplus Community
Mar 4, 2020 · Databases

How to Optimize Scalar Subqueries in Oracle SQL for Better Performance

This article explains the nature of scalar subqueries, identifies three common performance pitfalls, and provides practical rewrite techniques—including LEFT/INNER JOIN, MERGE, and WITH‑MATERIALIZE—illustrated with three real‑world Oracle SQL cases to dramatically reduce execution time.

OracleSQLScalar Subquery
0 likes · 15 min read
How to Optimize Scalar Subqueries in Oracle SQL for Better Performance
Big Data Technology Architecture
Big Data Technology Architecture
Mar 4, 2020 · Databases

HBase Memory‑Related Performance Tuning Guide

This article explains how to optimize HBase performance by properly configuring JVM memory, selecting suitable garbage‑collection strategies, enabling MSLAB and BucketCache, and adjusting read/write cache ratios to reduce fragmentation and improve throughput.

HBaseJVMcache
0 likes · 8 min read
HBase Memory‑Related Performance Tuning Guide
macrozheng
macrozheng
Mar 3, 2020 · Fundamentals

Mastering Java Garbage Collection: Algorithms, Regions, and Tuning Tips

This article provides a comprehensive overview of Java's automatic garbage collection, covering memory regions, identification methods, core algorithms such as mark‑sweep, copying, and generational collection, detailed explanations of various collectors (Serial, CMS, G1, etc.), and practical tuning insights for optimal performance.

JVMJavagarbage collection
0 likes · 31 min read
Mastering Java Garbage Collection: Algorithms, Regions, and Tuning Tips
ITPUB
ITPUB
Feb 22, 2020 · Databases

12 Practical SQL Optimization Tips to Speed Up Your Queries

This article presents a concise collection of twelve actionable SQL tuning techniques—including using proper comparison operators, LIMIT 1, appropriate data types, breaking large statements, UNION ALL, consistent query formatting, avoiding SELECT *, indexing WHERE/JOIN/ORDER BY columns, pagination with LIMIT, and leveraging EXPLAIN—to help developers improve database performance.

Query PlanningSQLdatabase optimization
0 likes · 5 min read
12 Practical SQL Optimization Tips to Speed Up Your Queries
Architecture Digest
Architecture Digest
Feb 11, 2020 · Backend Development

Improving Server Concurrency and Performance: Methods and Strategies

This article explains what server concurrency means, how to measure it with throughput and stress testing, and presents practical techniques such as CPU parallelism, reducing context switches and lock contention, using persistent connections, optimizing I/O models, and scaling hardware to boost overall server performance.

Backend DevelopmentI/O Modelsperformance tuning
0 likes · 15 min read
Improving Server Concurrency and Performance: Methods and Strategies
Programmer DD
Programmer DD
Feb 8, 2020 · Backend Development

Master Java Memory: Essential JVM Flags to Prevent OutOfMemory Errors

This guide explains the most important JVM parameters—such as -Xms, -Xmx, -Xss, and various -XX options—detailing how each setting influences heap, stack, and generation sizes and how proper configuration can avoid common OutOfMemoryError scenarios in Java applications.

JVMJavaOutOfMemoryError
0 likes · 3 min read
Master Java Memory: Essential JVM Flags to Prevent OutOfMemory Errors
dbaplus Community
dbaplus Community
Jan 7, 2020 · Databases

Why ClickHouse Beats Presto for Real‑Time Metrics: A Deep Dive

This article examines the shortcomings of a Storm‑based real‑time metric platform, outlines the requirements for a stable, SQL‑driven, fast engine, and explains why ClickHouse was chosen over Presto, detailing performance benchmarks, architectural advantages, cluster configuration, engine options, best practices, and common operational issues.

ClickHouseReal-time Analyticsmerge-tree
0 likes · 18 min read
Why ClickHouse Beats Presto for Real‑Time Metrics: A Deep Dive
ITPUB
ITPUB
Jan 5, 2020 · Backend Development

Why My HttpClient Connection Pool Crashed the System: A Thread Exhaustion Study

The author describes how a high‑traffic promotion system using HttpClient suffered massive thread and port exhaustion due to misconfigured connection‑pool parameters, details the investigation steps—including monitoring, jstack analysis, and source code review—and outlines corrective measures and preventive testing strategies.

Backend DevelopmentHttpClientJava
0 likes · 10 min read
Why My HttpClient Connection Pool Crashed the System: A Thread Exhaustion Study
ITPUB
ITPUB
Dec 30, 2019 · Databases

8 Proven MySQL Tricks to Supercharge Your Queries

This article presents eight practical MySQL optimization techniques—including smarter LIMIT usage, implicit type conversion fixes, join rewrites, mixed sorting, EXISTS elimination, condition pushdown, early row limiting, and intermediate result pushdown—each illustrated with SQL examples and performance comparisons that reduce query times from seconds to milliseconds.

JOINLIMITMySQL
0 likes · 13 min read
8 Proven MySQL Tricks to Supercharge Your Queries
Liangxu Linux
Liangxu Linux
Dec 23, 2019 · Databases

Boost MySQL Performance: Practical Tips for LIMIT, Implicit Conversion, Joins, and More

This article presents concrete MySQL optimization techniques—including smarter LIMIT usage, avoiding implicit type conversion, rewriting updates and deletes with JOINs, handling mixed ordering, replacing EXISTS with joins, pushing down conditions, and leveraging WITH clauses—to dramatically reduce query execution times from seconds to milliseconds.

JOINLIMITMySQL
0 likes · 14 min read
Boost MySQL Performance: Practical Tips for LIMIT, Implicit Conversion, Joins, and More
macrozheng
macrozheng
Dec 20, 2019 · Big Data

How to Supercharge Elasticsearch for Billion‑Row Queries: Practical Optimization Guide

This article explains the architecture of Elasticsearch and Lucene, outlines common performance bottlenecks, and provides concrete indexing and search optimization techniques—including bulk writes, shard routing, doc values tuning, and pagination strategies—to achieve sub‑second query responses on billions of records.

ElasticsearchLucenebig data
0 likes · 14 min read
How to Supercharge Elasticsearch for Billion‑Row Queries: Practical Optimization Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 11, 2019 · Databases

MySQL CPU Saturation Case Study: Analyzing and Optimizing a Slow ORDER BY Query

This article examines a MySQL instance that hit 100% CPU at 9 am on 2019‑01‑11, identifies the offending ORDER BY query through slow‑log and EXPLAIN analysis, and demonstrates how adding a composite index and correcting implicit type conversions reduced execution time from over 10 seconds to milliseconds.

Index OptimizationMySQLperformance tuning
0 likes · 7 min read
MySQL CPU Saturation Case Study: Analyzing and Optimizing a Slow ORDER BY Query
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Nov 28, 2019 · Operations

Master Disk I/O Performance Tuning on Kunpeng Processors: Tools & Tips

This guide explains how to optimize disk I/O on Kunpeng processors by outlining the underlying performance bottlenecks, introducing essential monitoring tools like iostat, and detailing practical kernel and filesystem tuning methods—including dirty page settings, read-ahead adjustments, I/O scheduler selection, and XFS configuration.

KunpengLinuxdisk I/O
0 likes · 15 min read
Master Disk I/O Performance Tuning on Kunpeng Processors: Tools & Tips
Architecture Digest
Architecture Digest
Nov 22, 2019 · Big Data

Elasticsearch Optimization Practices for Large‑Scale Data Platforms

This article presents a comprehensive guide to optimizing Elasticsearch for massive data volumes, covering Lucene fundamentals, index and shard design, practical performance‑tuning techniques, and real‑world testing results that enable cross‑month queries and sub‑second response times.

ElasticsearchIndex OptimizationLucene
0 likes · 14 min read
Elasticsearch Optimization Practices for Large‑Scale Data Platforms
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.

MySQLSQL optimizationdatabase
0 likes · 7 min read
Boost MySQL Performance: 8 Proven Tricks to Slash Query Times
vivo Internet Technology
vivo Internet Technology
Nov 6, 2019 · Big Data

Elasticsearch Optimization Practices at Tencent: An Interview with Tencent Cloud Engineer Chen Xi

In an interview, Tencent Cloud senior engineer Chen Xi explains how Tencent optimizes Elasticsearch for massive log, monitoring, and document search workloads by prioritizing stability through kernel tweaks, boosting performance with scenario‑specific settings, cutting costs via redundant storage trimming and off‑heap indexing, and leveraging rich data‑pipeline components and robust distributed cluster management to lower operational overhead while anticipating future ecosystem growth and community collaboration.

Distributed SearchElasticsearchTencent Cloud
0 likes · 4 min read
Elasticsearch Optimization Practices at Tencent: An Interview with Tencent Cloud Engineer Chen Xi
Programmer DD
Programmer DD
Nov 4, 2019 · Operations

Master JVM Performance: Essential Tools and Real‑World Tuning Guide

This article introduces the most common JVM performance problems in enterprise Java applications and provides a practical guide to using core monitoring and tuning tools such as jps, jstack, jmap, jstat and hprof, complete with command syntax, sample outputs and step‑by‑step troubleshooting examples.

JVMJavaMonitoring Tools
0 likes · 13 min read
Master JVM Performance: Essential Tools and Real‑World Tuning Guide
FunTester
FunTester
Oct 30, 2019 · Fundamentals

Mastering JVM Memory: Models, GC Algorithms, and Optimization Tips

This article provides a comprehensive overview of the JVM memory model, garbage collection algorithms, various collectors and their trade‑offs, class loading steps, object lifecycle, escape analysis, and practical tuning commands for optimizing Java applications.

GC algorithmsJVMJava
0 likes · 14 min read
Mastering JVM Memory: Models, GC Algorithms, and Optimization Tips
Architects Research Society
Architects Research Society
Oct 23, 2019 · Big Data

Talend Performance Tuning Strategy: Identifying and Eliminating Bottlenecks

This article presents a structured, repeatable approach for Talend data‑integration jobs that guides readers through pinpointing performance bottlenecks, testing individual pipeline stages, and applying targeted optimizations to sources, targets, and transformations to achieve higher throughput and more reliable ETL processes.

Data IntegrationETLTalend
0 likes · 9 min read
Talend Performance Tuning Strategy: Identifying and Eliminating Bottlenecks
ITPUB
ITPUB
Oct 14, 2019 · Databases

Why Oracle Throws Mysterious Errors and How to Fix Them

The article shares a database expert’s experience with three types of Oracle bugs—internal errors, slow execution plans, and incorrect results—explains why they occur, offers concrete fixes such as patching and session parameters, and outlines essential skills for reliable SQL development.

Database BugsOptimizationOracle
0 likes · 9 min read
Why Oracle Throws Mysterious Errors and How to Fix Them
Architect's Tech Stack
Architect's Tech Stack
Oct 12, 2019 · Backend Development

How to Minimize Long GC Pauses in Java Applications

Long garbage collection pauses can degrade Java application performance and SLA, so this guide outlines seven practical steps—including reducing object allocation rates, increasing young generation size, selecting appropriate GC algorithms, avoiding swap usage, tuning GC threads, managing I/O load, and limiting System.gc() calls—to minimize pause times.

GC optimizationJVMgarbage collection
0 likes · 10 min read
How to Minimize Long GC Pauses in Java Applications
21CTO
21CTO
Sep 8, 2019 · Databases

Master MySQL Optimization: Proven Strategies for High Performance and Stability

This comprehensive guide walks you through MySQL optimization philosophy, risk management, stakeholder involvement, practical tools, hardware and system tuning, kernel parameter adjustments, and detailed MySQL configuration tweaks to achieve both performance gains and reliable stability in production environments.

LinuxMySQLdatabase optimization
0 likes · 18 min read
Master MySQL Optimization: Proven Strategies for High Performance and Stability
Efficient Ops
Efficient Ops
Sep 2, 2019 · Databases

Master MySQL Optimization: Strategies, Tools, and Best Practices

This comprehensive guide explains MySQL optimization philosophy, required participants, key dimensions, essential tools, step‑by‑step tuning procedures, hardware and system tuning, and detailed MySQL and InnoDB parameter settings to improve performance and reliability.

MySQLSQLdatabase optimization
0 likes · 18 min read
Master MySQL Optimization: Strategies, Tools, and Best Practices
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 OptimizationMongoDBdatabase
0 likes · 36 min read
MongoDB Index Optimization for High‑Write CMDB Workloads and Slow‑Log Reduction
Architects' Tech Alliance
Architects' Tech Alliance
Aug 23, 2019 · Operations

IO Performance Evaluation, Monitoring, and Optimization Guide

This article explains how to assess, monitor, and tune system I/O performance by defining I/O models, selecting appropriate evaluation tools, tracking key metrics for disk and network I/O, and applying practical optimization strategies for both storage and network bottlenecks.

IO performancecapacity planningdisk I/O
0 likes · 15 min read
IO Performance Evaluation, Monitoring, and Optimization Guide
MaGe Linux Operations
MaGe Linux Operations
Aug 19, 2019 · Databases

Master MySQL Optimization: Practical Strategies for High Performance

This guide walks through MySQL's query process, optimization philosophy, required participants, dimensions, tools, and detailed hardware, system, and configuration tuning steps, providing actionable commands and code snippets to improve database stability, security, and performance.

MySQLdatabase optimizationperformance tuning
0 likes · 16 min read
Master MySQL Optimization: Practical Strategies for High Performance
FunTester
FunTester
Aug 15, 2019 · Backend Development

Boost Your Mac Load Test: Tuning sysctl and HttpClient for 20k+ Connections

This guide shares practical steps to overcome TIME_WAIT port exhaustion on macOS and optimize Apache HttpClient settings for high‑concurrency load testing, including sysctl tweaks for maximum file descriptors, port range adjustments, connection‑pool parameters, timeout configurations, and a custom connection‑recycling thread, enabling over 20 k concurrent requests without bottlenecks.

HttpClientJavaLoad Testing
0 likes · 5 min read
Boost Your Mac Load Test: Tuning sysctl and HttpClient for 20k+ Connections
ITPUB
ITPUB
Aug 12, 2019 · Operations

How JD.com Scaled Its Order Search with a Real‑Time Dual Elasticsearch Cluster

This article details JD.com’s order center journey from a simple Elasticsearch deployment to a highly available, dual‑cluster architecture, covering isolation, replica tuning, hot‑cold data separation, version upgrades, and practical lessons on pagination, field data, and doc values.

Elasticsearchcluster architecturedata synchronization
0 likes · 13 min read
How JD.com Scaled Its Order Search with a Real‑Time Dual Elasticsearch Cluster
DataFunTalk
DataFunTalk
Aug 9, 2019 · Big Data

Performance Optimization Techniques for Spark and Spark Streaming Applications

This article explains how to improve Spark and Spark Streaming performance by tuning serialization, broadcast variables, parallelism, batch intervals, memory usage, garbage collection, and Kafka integration, providing practical code examples and real‑world optimization results.

Broadcast VariablesMemory OptimizationSpark
0 likes · 32 min read
Performance Optimization Techniques for Spark and Spark Streaming Applications
Big Data Technology Architecture
Big Data Technology Architecture
Aug 9, 2019 · Databases

Understanding Elasticsearch: Architecture, Core Concepts, and Performance Optimization

This article provides a comprehensive overview of Elasticsearch, covering its role in handling structured and unstructured data, core concepts such as Lucene, inverted indexes, clusters, shards, replicas, mapping, indexing processes, storage mechanisms, and practical performance tuning tips for deployment.

ElasticsearchReplicationinverted index
0 likes · 35 min read
Understanding Elasticsearch: Architecture, Core Concepts, and Performance Optimization
Programmer DD
Programmer DD
Aug 5, 2019 · Databases

Master MySQL Optimization: Practical Strategies to Boost Performance and Stability

This guide walks you through MySQL's query process, the philosophy and risks of optimization, the key participants, core dimensions such as hardware, system, schema and SQL, essential diagnostic tools, emergency and regular tuning steps, system‑level monitoring, kernel and user limits, as well as detailed MySQL and InnoDB configuration parameters for achieving high performance and reliability.

MySQLSQLdatabase optimization
0 likes · 15 min read
Master MySQL Optimization: Practical Strategies to Boost Performance and Stability
Architect's Tech Stack
Architect's Tech Stack
Aug 1, 2019 · Fundamentals

Common Java OutOfMemoryError Types and Their Solutions

This article lists the most frequent Java OutOfMemoryError cases—including Java heap space, GC overhead limit exceeded, PermGen/Metaspace, native thread creation failures, array size limits, and direct buffer memory—explains their root causes, and provides practical troubleshooting steps and JVM tuning parameters to resolve them.

JVMOutOfMemoryErrordebugging
0 likes · 11 min read
Common Java OutOfMemoryError Types and Their Solutions
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.

MySQLQuery RewriteSQL optimization
0 likes · 14 min read
8 MySQL Query Optimizations to Slash Execution Time
FunTester
FunTester
Jul 31, 2019 · Databases

Why MySQL Join Query Slowed to 30,000 Seconds and How Restoring an Index Fixed It

The author describes a sudden 30,000‑second slowdown in a simple MySQL join query, details systematic diagnostics—including network, server load, and query testing—and ultimately discovers a missing index on the user_info table, restoring it to bring response times back to sub‑second levels.

Database TroubleshootingIndex OptimizationMySQL
0 likes · 4 min read
Why MySQL Join Query Slowed to 30,000 Seconds and How Restoring an Index Fixed It
Architects' Tech Alliance
Architects' Tech Alliance
Jul 26, 2019 · Operations

IO Performance Evaluation, Tools, Metrics, and Optimization Strategies

This article explains how to assess and improve system I/O performance by defining I/O models, selecting appropriate evaluation tools for disk and network, monitoring key metrics such as IOPS, bandwidth and latency, and applying host, network, and storage‑side optimization techniques for high‑throughput and low‑latency workloads.

IO performanceMonitoring Toolsnetwork latency
0 likes · 16 min read
IO Performance Evaluation, Tools, Metrics, and Optimization Strategies
ITPUB
ITPUB
Jul 17, 2019 · Databases

How to Decode MySQL Execution Plans for Faster Queries

This article explains how to use MySQL's EXPLAIN and EXPLAIN EXTENDED commands to analyze query execution plans, interpret each column such as id, select_type, type, and extra, and apply practical optimization techniques like indexing, avoiding full‑table scans, and forcing index usage to improve SQL performance.

MySQLSQL optimizationexecution plan
0 likes · 12 min read
How to Decode MySQL Execution Plans for Faster Queries
Architect's Tech Stack
Architect's Tech Stack
Jun 29, 2019 · Databases

Practical MySQL Optimization Guide: Philosophy, Tools, and Tuning Techniques

This article provides a comprehensive, step‑by‑step guide to MySQL performance tuning, covering the underlying query process, optimization philosophy, practical tools, system‑level diagnostics, hardware and OS recommendations, as well as detailed configuration parameters for both the server and storage engine.

MySQLSQLdatabase optimization
0 likes · 16 min read
Practical MySQL Optimization Guide: Philosophy, Tools, and Tuning Techniques
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 24, 2019 · Big Data

Hive Optimization Techniques: Column/Partition Pruning, Predicate Pushdown, Join Strategies, and MapReduce Tuning

This article provides a comprehensive guide to improving Hive query performance by covering column and partition pruning, predicate pushdown, replacing ORDER BY with SORT BY, using GROUP BY instead of DISTINCT, fine‑tuning join operations, and optimizing MapReduce parameters such as mapper/reducer counts, file merging, compression, JVM reuse, parallel execution, strict mode, and storage formats.

HiveJOIN optimizationMapReduce
0 likes · 19 min read
Hive Optimization Techniques: Column/Partition Pruning, Predicate Pushdown, Join Strategies, and MapReduce Tuning
Architect's Tech Stack
Architect's Tech Stack
Jun 15, 2019 · Backend Development

Making Java Applications Run Faster: Performance Tuning Tools and Practices

This article presents a comprehensive guide to Java application performance optimization, covering OS‑level and JVM‑level diagnostics, profiling tools, GC analysis, JVM tuning, application‑code refactoring, and database‑layer adjustments, illustrated with real‑world case studies and code examples.

JVMProfilingdatabase optimization
0 likes · 20 min read
Making Java Applications Run Faster: Performance Tuning Tools and Practices
21CTO
21CTO
Jun 5, 2019 · Databases

12 Proven SQL Tricks to Supercharge Your Database Performance

This article presents twelve practical SQL optimization techniques—from using proper comparison operators and LIMIT clauses to indexing strategies and query consistency—to dramatically improve database query speed and overall application performance.

Query PlanningSQLSQL Tips
0 likes · 5 min read
12 Proven SQL Tricks to Supercharge Your Database Performance
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.

MySQLQuery OptimizationSQL
0 likes · 11 min read
Common MySQL Query Performance Issues and Optimization Techniques
Efficient Ops
Efficient Ops
May 9, 2019 · Operations

Master ELK Log Processing: Encoding, Multiline, Grok, and Performance Tuning

This article compiles practical ELK knowledge, covering character‑set conversion, removing unwanted log lines, Grok pattern handling for multi‑line logs, multiline plugin usage in Filebeat and Logstash, date filtering, log type classification, performance optimization, Redis buffering, and Elasticsearch node tuning.

ELKElasticsearchFilebeat
0 likes · 16 min read
Master ELK Log Processing: Encoding, Multiline, Grok, and Performance Tuning