BestHub
Sign in
Tagged articles

performance tuning

1102 articles · Page 11 of 12
ITPUB
ITPUB
May 19, 2017 · Databases

Optimizing Redis Master‑Slave Performance in Cloud Environments

This article examines common performance and reliability problems encountered in Redis master‑slave deployments—such as AOF and SAVE settings, key count mismatches, client output buffer limits, replication backlog size, and node liveness checks—and provides concrete configuration commands and tuning strategies to improve stability, especially in cloud environments.

ConfigurationMaster‑SlaveRedis
0 likes · 7 min read
Optimizing Redis Master‑Slave Performance in Cloud Environments
Qunar Tech Salon
Qunar Tech Salon
May 18, 2017 · Databases

Understanding Bind Variable Peeking and Its Impact on Oracle Execution Plans

This article explains how Oracle's bind variable peeking influences execution plan selection, demonstrates the performance differences between full table scans and index scans with skewed data distributions, and provides practical methods—including 10046 events, v$sql_bind_capture, and AWR views—to capture and analyze bind variable values for better SQL tuning.

AWRBind VariablesOracle
0 likes · 14 min read
Understanding Bind Variable Peeking and Its Impact on Oracle Execution Plans
MaGe Linux Operations
MaGe Linux Operations
May 13, 2017 · Databases

How to Evaluate and Optimize Database Performance: Key Metrics & Strategies

This article explains what constitutes a database performance problem, outlines essential metrics such as response time, throughput, baseline and bottleneck identification, and presents practical tuning methods—including workload reduction, resource configuration, and optimization balance—to help engineers systematically improve database efficiency.

SQL optimizationThroughputbottleneck analysis
0 likes · 8 min read
How to Evaluate and Optimize Database Performance: Key Metrics & Strategies
转转QA
转转QA
May 9, 2017 · Databases

MySQL Slow Query and Index Optimization

This article explains how to identify and analyze MySQL slow queries using tools like SHOW VARIABLES, EXPLAIN, mysqldumpslow, and profiling, and provides practical recommendations for configuring server variables, optimizing indexes, and improving query performance through systematic testing and best‑practice SQL design.

Index OptimizationMySQLSQL
0 likes · 18 min read
MySQL Slow Query and Index Optimization
ITPUB
ITPUB
May 8, 2017 · Big Data

Master Spark Performance: Practical Tuning Tips and Real‑World Examples

This article explains essential Spark concepts, illustrates common performance bottlenecks, and provides concrete tuning strategies for memory, CPU, serialization, data locality, file I/O, and shuffle reduction, backed by real‑world examples and visual metrics.

CPU OptimizationConfigurationSpark
0 likes · 19 min read
Master Spark Performance: Practical Tuning Tips and Real‑World Examples
dbaplus Community
dbaplus Community
Apr 19, 2017 · Databases

How to Use MariaDB Spider for Horizontal & Vertical Sharding

This article explains what MariaDB Spider is, its role as a pluggable storage engine for MySQL/MariaDB sharding, demonstrates vertical and horizontal partitioning with real‑world Tencent game case, provides installation steps, configuration commands, performance considerations, tunable parameters, and load‑balancing architecture.

MariaDBSpiderVertical Sharding
0 likes · 8 min read
How to Use MariaDB Spider for Horizontal & Vertical Sharding
dbaplus Community
dbaplus Community
Apr 17, 2017 · Databases

Mastering Oracle‑to‑MySQL Migration: Tools, Pitfalls, and Performance Tweaks

This article shares practical experiences and step‑by‑step guidance for migrating databases from Oracle to MySQL, covering pre‑migration preparation, target selection, data‑object migration tools such as SQL LOAD, Python scripts, Oracle GoldenGate, MySQL Migration Toolkit and Kettle, handling of views, triggers, stored procedures, data validation techniques, and key MySQL performance parameters.

ETLMySQLOracle
0 likes · 26 min read
Mastering Oracle‑to‑MySQL Migration: Tools, Pitfalls, and Performance Tweaks
Node Underground
Node Underground
Apr 11, 2017 · Backend Development

How Netflix, RisingStack, and nearForm Debug Production Performance

The article reviews real‑world performance‑tuning practices from Netflix, RisingStack, and nearForm, explaining how they diagnose slow responses, CPU spikes, cryptographic overhead, and event‑loop blocking using techniques such as flame‑graph analysis, crypto profiling, and avoiding costly JSON.stringify operations.

Backend Developmentflame graphsperformance tuning
0 likes · 2 min read
How Netflix, RisingStack, and nearForm Debug Production Performance
dbaplus Community
dbaplus Community
Mar 22, 2017 · Databases

Mastering Oracle Dynamic Sampling for Accurate Cardinality Estimates

This article explains Oracle's dynamic sampling feature, outlines typical scenarios such as temporary tables and complex filters, presents real CRM case studies with misestimated cardinalities, demonstrates step‑by‑step solutions using DBMS_STATS commands, and shows how 12c enhancements dramatically improve estimation accuracy for complex queries.

12cDatabase StatisticsDynamic Sampling
0 likes · 8 min read
Mastering Oracle Dynamic Sampling for Accurate Cardinality Estimates
ITPUB
ITPUB
Mar 21, 2017 · Databases

How to Double Oracle Data Load Speed with Bulk Inserts and Parallelism

This article explains why frequent small commits are slower than a single bulk SQL operation, demonstrates how to rewrite PL/SQL procedures to use bulk inserts, adjust UNDO settings, and enable parallel execution, achieving up to six‑fold performance gains on large data loads.

Bulk InsertOraclePL/SQL
0 likes · 9 min read
How to Double Oracle Data Load Speed with Bulk Inserts and Parallelism
ITPUB
ITPUB
Mar 15, 2017 · Databases

From Table Design to Scalable MySQL: A Complete Optimization Roadmap

This article outlines the five evolutionary stages of a MySQL deployment—table design, deployment, performance tuning, architecture scaling, and maintenance—detailing practical configuration tweaks, kernel and hardware optimizations, replication strategies, caching, sharding, partitioning, and essential monitoring and backup techniques.

MySQLReplicationbackup
0 likes · 18 min read
From Table Design to Scalable MySQL: A Complete Optimization Roadmap
ITPUB
ITPUB
Mar 10, 2017 · Databases

Master SQL Server Query Execution: Order, Tips, and Real-World Optimizations

This article explains SQL Server's logical and physical query execution order, offers practical techniques such as converting loops to batch operations, using temporary tables, optimizing indexes, and avoiding common pitfalls, all illustrated with code samples and performance measurements.

Query OptimizationSQL ServerTemp Tables
0 likes · 15 min read
Master SQL Server Query Execution: Order, Tips, and Real-World Optimizations
ITPUB
ITPUB
Mar 4, 2017 · Databases

Practical Guide to Optimizing SQL Server Performance

This article provides a step‑by‑step tutorial on preparing the environment, configuring the query analyzer, using SQL Server Profiler, and applying common commands such as clearing caches and enabling statistics to identify and resolve performance bottlenecks in SQL Server queries.

Query AnalyzerSQL Serverdatabase optimization
0 likes · 5 min read
Practical Guide to Optimizing SQL Server Performance
ITPUB
ITPUB
Jan 18, 2017 · Databases

Essential Database Design and Query Optimization Tips for Faster SQL Performance

This article provides practical guidelines for designing efficient database schemas and optimizing SQL queries, covering row size limits, data type choices, index usage, common pitfalls in WHERE clauses, and best practices for temporary tables and transaction handling to improve overall database performance.

Query OptimizationSQLdatabase design
0 likes · 11 min read
Essential Database Design and Query Optimization Tips for Faster SQL Performance
ITPUB
ITPUB
Jan 14, 2017 · Databases

Why Is My SQL Server Slowing Down? Understanding and Fixing CXPACKET Waits

A client reported intermittent database slowness, which was traced to high CXPACKET wait times; the article explains the CXPACKET mechanism, provides a diagnostic script, analyzes disk I/O bottlenecks, and offers practical recommendations such as faster disks, separating data and log files, and isolating large log tables.

CXPACKETSQL Serverdatabase optimization
0 likes · 5 min read
Why Is My SQL Server Slowing Down? Understanding and Fixing CXPACKET Waits
Alibaba Cloud Developer
Alibaba Cloud Developer
Jan 12, 2017 · Databases

Inside Alibaba’s Database Hacks That Quadrupled Double‑11 Query Speed

The article details how Alibaba’s database team engineered multiple breakthroughs—PK_Access query optimization, a high‑performance Memcached plugin, batch‑processed inventory hotspot handling, full‑scale SQL collection, and an upgraded Data Replication Center—to dramatically boost Double‑11 transaction throughput, cut latency, and enhance overall system resilience.

AlibabaSQL Monitoringdatabase optimization
0 likes · 14 min read
Inside Alibaba’s Database Hacks That Quadrupled Double‑11 Query Speed
Architecture Digest
Architecture Digest
Jan 9, 2017 · Databases

Comprehensive Guide to MySQL Single-Table Optimization, Partitioning, Sharding, and Scaling Strategies

This article outlines practical techniques for optimizing large MySQL tables—including column and index tuning, query improvements, engine selection, system parameters, hardware upgrades, caching, partitioning, vertical and horizontal sharding, and discusses client‑side and proxy‑based sharding solutions and compatible databases.

MySQLPartitioningdatabase optimization
0 likes · 24 min read
Comprehensive Guide to MySQL Single-Table Optimization, Partitioning, Sharding, and Scaling Strategies
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Dec 24, 2016 · Databases

Why Your SQL Execution Plans Fail and How to Optimize Them

This article explains what execution plans are, why seemingly identical SQL statements can produce different plans, and offers practical tips—such as standardizing query syntax, simplifying nested queries, using temporary tables, bind variables, appropriate transaction scopes, and careful use of NOLOCK—to improve database performance and avoid common pitfalls.

Bind VariablesSQLSQL Server
0 likes · 13 min read
Why Your SQL Execution Plans Fail and How to Optimize Them
dbaplus Community
dbaplus Community
Nov 27, 2016 · Databases

How to Trace Recursive SQL Calls in Oracle Using 10046 and Orasrp

This article demonstrates step‑by‑step how Oracle DBAs can identify the origin of recursive SQL statements by leveraging the 10046 trace at both SQL‑ID and session levels, analyzing the trace with the Orasrp tool, and ultimately pinpointing the PL/SQL function that generated the query.

10046DBAOracle
0 likes · 8 min read
How to Trace Recursive SQL Calls in Oracle Using 10046 and Orasrp
dbaplus Community
dbaplus Community
Nov 15, 2016 · Databases

How I Cut a 4‑Minute Oracle Query to 3.5 Seconds: A Step‑by‑Step SQL Optimization Tale

After a typhoon delayed work, the author tackled a 347‑line Oracle SQL that took over four minutes to return results, dissected its massive subqueries and views, applied three rounds of restructuring with WITH clauses and driver‑table tactics, and ultimately reduced the total runtime to just 3.5 seconds while dramatically speeding up deep data extraction.

Driver TableOracleQuery Optimization
0 likes · 12 min read
How I Cut a 4‑Minute Oracle Query to 3.5 Seconds: A Step‑by‑Step SQL Optimization Tale
ITPUB
ITPUB
Nov 6, 2016 · Databases

Why Is Your SQL Server Slowing Down? Understanding and Fixing CXPACKET Waits

The article explains the CXPACKET wait type in SQL Server, shows how to identify it with diagnostic queries, illustrates its parallelism mechanism with analogies and diagrams, and provides practical steps and hardware recommendations to resolve performance slowdowns caused by this wait.

CXPACKETParallelismSQL Server
0 likes · 5 min read
Why Is Your SQL Server Slowing Down? Understanding and Fixing CXPACKET Waits
ITPUB
ITPUB
Nov 4, 2016 · Databases

Mastering Oracle Statistics Collection: When, How, and Optimization Tips

This guide explains when and why Oracle statistics are needed, how to control automatic and manual collection, prevent out‑of‑range errors, boost efficiency with parallel and incremental methods, and handle special cases like volatile or temporary tables for optimal query performance.

DBAOracledatabase optimization
0 likes · 16 min read
Mastering Oracle Statistics Collection: When, How, and Optimization Tips
ITPUB
ITPUB
Nov 1, 2016 · Databases

How to Slash Redo Log Generation and Logical Reads in Oracle UPDATE Statements

A detailed Oracle performance case study shows how adding selective predicates and a supporting index to an UPDATE that runs hourly can reduce redo log generation from over 100 MB to under 1 MB and cut logical reads by more than 95%, with step‑by‑step measurements and code examples.

Logical ReadsOracleSQL
0 likes · 8 min read
How to Slash Redo Log Generation and Logical Reads in Oracle UPDATE Statements
MaGe Linux Operations
MaGe Linux Operations
Oct 27, 2016 · Backend Development

Master JVM Performance: Essential Tools (jps, jstack, jmap, jstat, hprof)

Learn how to diagnose and resolve common Java performance issues such as OutOfMemoryError, thread deadlocks, and high CPU usage by using built‑in JVM tools—including jps, jstack, jmap, jhat, jstat, and hprof—through detailed command examples, output explanations, and practical profiling techniques.

JVMJavaMonitoring Tools
0 likes · 11 min read
Master JVM Performance: Essential Tools (jps, jstack, jmap, jstat, hprof)
ITPUB
ITPUB
Oct 25, 2016 · Databases

Optimizing MySQL: Key InnoDB Settings and How to Tune Them

This guide explains essential MySQL InnoDB parameters—such as buffer pool size, instances, connection limits, log buffer, statistics collection, lock timeout, thread concurrency, and I/O threads—and provides practical CPU‑based settings to help you optimize database performance.

Database ConfigurationInnoDBMySQL
0 likes · 4 min read
Optimizing MySQL: Key InnoDB Settings and How to Tune Them
Liulishuo Tech Team
Liulishuo Tech Team
Oct 17, 2016 · Big Data

Practical Tips and Common Pitfalls for Tuning Apache Spark Performance

This article shares hands‑on experience from Spark Summit attendees, covering why Spark is powerful, common performance problems such as slow jobs, OOM, data skew, excessive partitions, and provides concrete tuning advice on executors, cores, memory, and debugging techniques.

Apache SparkData SkewExecutor Configuration
0 likes · 11 min read
Practical Tips and Common Pitfalls for Tuning Apache Spark Performance
Java Backend Technology
Java Backend Technology
Oct 15, 2016 · Databases

Boost Query Speed in Million-Row Databases: Proven Optimization Techniques

This article presents a comprehensive set of practical strategies for improving database query performance, covering index design, SQL statement refinements, Java backend considerations, hardware tuning, and storage‑procedure usage to accelerate operations on large‑scale relational databases.

Query Optimizationindexingperformance tuning
0 likes · 13 min read
Boost Query Speed in Million-Row Databases: Proven Optimization Techniques
dbaplus Community
dbaplus Community
Oct 11, 2016 · Databases

Mastering Oracle Hints: Benefits, Risks, and Best‑Practice Guidance

This article explores Oracle's Hint feature, reviewing its classification, demonstrating how improper use can degrade performance, presenting real‑world negative cases, and summarizing Oracle's official stance and best‑practice recommendations for when and how to apply Hints effectively.

OracleSQLdatabase optimization
0 likes · 14 min read
Mastering Oracle Hints: Benefits, Risks, and Best‑Practice Guidance
Meituan Technology Team
Meituan Technology Team
Sep 23, 2016 · Fundamentals

Understanding G1 Garbage Collector: Key Concepts, Regions, SATB, RSet, and Pause Prediction Model

The G1 Garbage‑First collector is a server‑side, region‑based Java GC designed for multi‑processor, large‑memory systems that concurrently marks objects using SATB, tracks cross‑region references with RSets, and employs a pause‑prediction model to meet user‑specified pause‑time goals while maintaining high throughput.

G1 GCJVMJava
0 likes · 15 min read
Understanding G1 Garbage Collector: Key Concepts, Regions, SATB, RSet, and Pause Prediction Model
dbaplus Community
dbaplus Community
Sep 13, 2016 · Databases

How to Speed Up Zabbix Latest Data Display by Adding Dedicated Tables and Indexes

This article explains why Zabbix's original table design slows down data insertion and query in large‑scale deployments, and provides a step‑by‑step code‑level optimization that creates separate "latest" tables with primary‑key indexes, modifies the server source, and updates the front‑end query to dramatically improve performance without affecting historical data ingestion.

MySQLOracledatabase optimization
0 likes · 11 min read
How to Speed Up Zabbix Latest Data Display by Adding Dedicated Tables and Indexes
dbaplus Community
dbaplus Community
Sep 12, 2016 · Databases

What’s New in MySQL 5.7? InnoDB, JSON, and Feature Highlights

This article walks through the major MySQL 5.7 enhancements—including InnoDB buffer‑dump improvements, multi‑threaded page cleaning, dynamic buffer‑pool resizing, global tablespaces, default DYNAMIC row format, native partitioning, truncate‑undo logs, native JSON support, sys schema, optimizer hints, trigger upgrades, syslog integration, and virtual columns—providing practical steps, examples, and usage tips for DBAs.

Database FeaturesInnoDBJSON
0 likes · 12 min read
What’s New in MySQL 5.7? InnoDB, JSON, and Feature Highlights
dbaplus Community
dbaplus Community
Sep 7, 2016 · Databases

Why Oracle MERGE Triggers ORA-00600 Errors and How to Diagnose Them

This article examines a recurring ORA-00600 crash caused by Oracle MERGE statements, walks through reproducing the issue, analyzes the impact of bound variables and table size, identifies a version‑specific bug, and offers practical work‑arounds and recommendations for DBAs.

Database BugORA-00600Oracle
0 likes · 12 min read
Why Oracle MERGE Triggers ORA-00600 Errors and How to Diagnose Them
Architecture Digest
Architecture Digest
Sep 1, 2016 · Databases

Upgrading SQL Server 2008 R2 to 2014 and Implementing AlwaysOn High Availability: Process, Research, Testing, and Lessons Learned

This article shares a real-world case study of migrating a SQL Server 2008 R2 environment to SQL Server 2014, detailing the pre‑migration research, architecture redesign with AlwaysOn high‑availability, testing procedures, implementation steps, performance tuning, and common pitfalls encountered during the three‑month project.

AlwaysOnSQL Serverdatabase migration
0 likes · 12 min read
Upgrading SQL Server 2008 R2 to 2014 and Implementing AlwaysOn High Availability: Process, Research, Testing, and Lessons Learned
ITPUB
ITPUB
Aug 27, 2016 · Databases

Boost MySQL Performance: Proven Tips from Google, Amazon, and More

This article explains how major companies keep MySQL fast at massive scale and provides practical techniques—including schema design, InnoDB advantages, table compression, bulk loading order, and hardware choices—to optimize MySQL performance for billions‑row tables.

HardwareInnoDBMySQL
0 likes · 8 min read
Boost MySQL Performance: Proven Tips from Google, Amazon, and More
ITPUB
ITPUB
Aug 18, 2016 · Databases

Cut Oracle Data Extraction from 20 Hours to 1 Hour: Proven DBA Tuning Tricks

An experienced DBA shares a real-world case of optimizing a nightly Oracle reporting pipeline, detailing how partitioned tables, truncate operations, table compression, disabling logging, and parallel execution reduced a 20‑hour data extraction to under one hour, and compiles community‑sourced tuning tips for large‑scale data warehouses.

Data WarehousingOracleSQL optimization
0 likes · 14 min read
Cut Oracle Data Extraction from 20 Hours to 1 Hour: Proven DBA Tuning Tricks
dbaplus Community
dbaplus Community
Aug 17, 2016 · Databases

How We Turned a Sluggish Hospital HIS on SQL Server 2008R2 into a Faster System

This article walks through a real‑world case study of a hospital HIS running on SQL Server 2008R2, detailing the system’s hardware specs, performance metrics, three‑phase optimization process—including general tuning, statement‑level fixes, and deep CPU/memory analysis—and the measurable results achieved without adding new hardware.

Hospital HISSQL Serverdatabase optimization
0 likes · 12 min read
How We Turned a Sluggish Hospital HIS on SQL Server 2008R2 into a Faster System
ITPUB
ITPUB
Aug 16, 2016 · Databases

Mastering Oracle UNDO Tablespace: Monitoring, Tuning, and Space Reclamation

This guide explains how to monitor Oracle UNDO tablespace usage, adjust automatic UNDO management parameters, interpret V$UNDOSTAT statistics, and safely reclaim space by creating a new UNDO tablespace and dropping the old one, helping DBAs avoid ORA‑01555 errors and space shortages.

OracleSQLdatabase administration
0 likes · 18 min read
Mastering Oracle UNDO Tablespace: Monitoring, Tuning, and Space Reclamation
dbaplus Community
dbaplus Community
Aug 15, 2016 · Databases

Unlocking SQL: Why It Remains the Key to Databases and How to Optimize It

This comprehensive presentation explores SQL’s history, its enduring relevance amid NoSQL and NewSQL trends, explains the execution order and optimizer mechanics, offers practical optimization rules and step‑by‑step execution processes, and illustrates concepts through multiple real‑world case studies and a detailed Q&A.

Case StudiesSQLdatabase optimization
0 likes · 23 min read
Unlocking SQL: Why It Remains the Key to Databases and How to Optimize It
ITPUB
ITPUB
Jul 24, 2016 · Databases

10 Proven Techniques to Supercharge Your Database Performance

Learn ten practical strategies—from careful schema design and precise SELECT statements to query caching, index creation, and smart use of JOINs, LIMIT, UNION, and wildcards—that dramatically improve database speed and reduce server load on high‑traffic websites.

Query DesignSQLcaching
0 likes · 9 min read
10 Proven Techniques to Supercharge Your Database Performance
ITPUB
ITPUB
Jul 19, 2016 · Databases

How to Optimize MySQL InnoDB on SSDs: Practical Tuning Steps and Insights

This article walks through diagnosing severe I/O spikes in a MySQL project, explains SSD characteristics, and provides step‑by‑step InnoDB parameter tweaks, I/O scheduler changes, and monitoring results that lead to a stable, balanced database performance on SSD storage.

InnoDBMySQLSSD
0 likes · 14 min read
How to Optimize MySQL InnoDB on SSDs: Practical Tuning Steps and Insights
ITPUB
ITPUB
Jul 7, 2016 · Databases

Ace the Oracle OCM Exam: Insider Tips, Environment Setup, and Common Pitfalls

This guide shares a detailed recount of preparing for the Oracle OCM certification, covering exam locations, odd/even machine handling, required software installations, crash scenarios, step‑by‑step skillset tasks, and practical review tips to help candidates succeed.

Data GuardOCMOracle
0 likes · 11 min read
Ace the Oracle OCM Exam: Insider Tips, Environment Setup, and Common Pitfalls
ITPUB
ITPUB
Jun 23, 2016 · Databases

How to Uncover Oracle Hidden Parameters with Views and Trace

This article explains two practical techniques for identifying Oracle hidden parameters—querying internal views like GV$PARAMETER and X$ tables, and using AUTOTRACE to inspect execution plans—so DBAs can reveal undocumented settings, their defaults, and current values.

Database InternalsHidden ParametersOracle
0 likes · 5 min read
How to Uncover Oracle Hidden Parameters with Views and Trace
ITPUB
ITPUB
Jun 21, 2016 · Databases

Speed Up PL/SQL Developer on Oracle 12c by Disabling Dynamic Sampling

The article describes a slow PL/SQL Developer experience on an Oracle 12.1.0.2 test database, explains how missing dictionary and fixed object statistics cause delays, shows how to gather these stats, disable optimizer_dynamic_sampling, and restart the database to significantly improve query and autocomplete performance.

Dynamic SamplingOraclePL/SQL Developer
0 likes · 3 min read
Speed Up PL/SQL Developer on Oracle 12c by Disabling Dynamic Sampling
Practical DevOps Architecture
Practical DevOps Architecture
Jun 20, 2016 · Databases

MySQL Performance Tuning Guide: Architecture, System, MySQL Settings, and Application Optimizations

This guide outlines comprehensive MySQL performance tuning techniques, covering architectural replication, system‑level hardware adjustments, MySQL configuration parameters, and application‑level query optimizations with specific recommended values for buffers, caches, and connection limits.

BuffersMySQLdatabase optimization
0 likes · 6 min read
MySQL Performance Tuning Guide: Architecture, System, MySQL Settings, and Application Optimizations
dbaplus Community
dbaplus Community
May 25, 2016 · Databases

How Parallel Execution Supercharges SQL Server Queries—and the Pitfalls to Avoid

This article explains the theory behind SQL Server's parallel execution, illustrates its performance gains with Amdahl's Law, lists operators that block parallelism, discusses configuration settings, warns of deadlocks and thread starvation, and presents practical MapReduce‑style optimizations for real‑world workloads.

Amdahl's LawMapReduceQuery Optimization
0 likes · 16 min read
How Parallel Execution Supercharges SQL Server Queries—and the Pitfalls to Avoid
Architecture Digest
Architecture Digest
May 25, 2016 · Big Data

Advanced Spark Performance Optimization: Data Skew and Shuffle Tuning

This article provides a comprehensive guide on tackling Spark performance bottlenecks by diagnosing data skew, locating the offending stages and operators, and applying a range of practical solutions—including Hive pre‑processing, key filtering, shuffle parallelism, two‑stage aggregation, map‑join, and combined strategies—followed by an in‑depth discussion of shuffle manager evolution and key configuration parameters for fine‑tuning.

Data SkewShuffle OptimizationShuffleManager
0 likes · 35 min read
Advanced Spark Performance Optimization: Data Skew and Shuffle Tuning
ITPUB
ITPUB
May 20, 2016 · Databases

Essential Oracle Monitoring Queries for Performance Tuning

This article compiles a comprehensive set of Oracle SQL queries that monitor wait events, rollback segment contention, tablespace and file system I/O ratios, SGA hit rates, dictionary cache efficiency, MTS activity, fragmentation, and other critical performance metrics, often with recommended threshold values.

Database MonitoringOracleSGA
0 likes · 10 min read
Essential Oracle Monitoring Queries for Performance Tuning
Efficient Ops
Efficient Ops
May 15, 2016 · Fundamentals

Mastering Linux I/O Schedulers: When to Use CFQ, Deadline, or Noop

This article explains the Linux I/O scheduler layer, details the three main scheduling algorithms—CFQ, deadline, and noop—their internal mechanisms, tunable parameters, and provides guidance on selecting the appropriate scheduler for different storage workloads.

CFQDeadlineI/O scheduler
0 likes · 27 min read
Mastering Linux I/O Schedulers: When to Use CFQ, Deadline, or Noop
ITPUB
ITPUB
May 5, 2016 · Databases

Top 50 SQL Server Query Optimization Tips to Boost Performance

This comprehensive guide enumerates over forty common causes of slow SQL Server queries and provides detailed optimization techniques—including indexing strategies, hardware upgrades, partitioning, cursor handling, and configuration tweaks—to dramatically improve query performance and reduce resource bottlenecks.

Query OptimizationSQL Serverdatabase
0 likes · 21 min read
Top 50 SQL Server Query Optimization Tips to Boost Performance
ITPUB
ITPUB
May 3, 2016 · Databases

Practical Tips for Optimizing Oracle SQL Execution Plans

This guide outlines concrete strategies to reduce I/O and CPU overhead in Oracle queries, covering scope reduction, partition pruning, join simplification, hint usage, bind variables, and common pitfalls like Cartesian products and inefficient filters.

JoinsOracleSQL
0 likes · 8 min read
Practical Tips for Optimizing Oracle SQL Execution Plans
ITPUB
ITPUB
Apr 22, 2016 · Databases

Boost Oracle Performance: Master Parallel Execution Techniques

This article explains Oracle's parallel execution features—including parallel query, DML, and DDL—covers object, session, and statement level settings, provides practical SQL examples, discusses common pitfalls, and presents performance test results that demonstrate significant speed improvements for large data migration tasks.

OracleSQLparallel execution
0 likes · 10 min read
Boost Oracle Performance: Master Parallel Execution Techniques
ITPUB
ITPUB
Apr 18, 2016 · Databases

Boost Oracle Data Pump Export/Import Speed: Key Parameters and Settings

This guide details the most effective Oracle Data Pump parameters and related database settings—such as access_method, parallel, network_link, and NLS options—to dramatically improve export and import performance while avoiding common pitfalls.

Data PumpDatabase ParametersExport
0 likes · 12 min read
Boost Oracle Data Pump Export/Import Speed: Key Parameters and Settings
ITPUB
ITPUB
Apr 9, 2016 · Databases

Practical MySQL Performance Tuning Using Status Variables

This guide explains how to use MySQL's SHOW GLOBAL STATUS and SHOW VARIABLES outputs to identify and adjust key parameters such as slow query logging, connection limits, key buffer size, temporary tables, open tables, thread cache, query cache, sorting, file handles, table locks, and table scans for optimal database performance.

ConfigurationMySQLStatus Variables
0 likes · 11 min read
Practical MySQL Performance Tuning Using Status Variables
ITPUB
ITPUB
Apr 6, 2016 · Databases

Boost MySQL Performance: Engine Choice, Indexing, and EXPLAIN Tips

This guide explains practical MySQL optimization techniques—including selecting InnoDB vs. MyISAM, avoiding COUNT(*), using EXPLAIN, and adding selective indexes—to dramatically reduce query time and prevent full‑table scans.

EXPLAINMySQLdatabase optimization
0 likes · 7 min read
Boost MySQL Performance: Engine Choice, Indexing, and EXPLAIN Tips
dbaplus Community
dbaplus Community
Mar 31, 2016 · Databases

Real‑World Oracle DBA Lessons: Roles, Monitoring, and Optimization

This article shares practical Oracle DBA experiences—including role definitions, environment considerations, monitoring strategies, performance‑tuning case studies, development‑business integration, and future‑oriented operations—offering concrete guidance and hard‑won insights for database administrators.

DBAOracledatabase administration
0 likes · 13 min read
Real‑World Oracle DBA Lessons: Roles, Monitoring, and Optimization
21CTO
21CTO
Mar 17, 2016 · Backend Development

Turn Java Enterprise Performance Tuning into a Scientific Process

This article explains a systematic, waiting‑point‑based approach to enterprise Java performance tuning, covering load‑test design, analysis of existing versus new applications, hierarchical and technical waiting points, pool and cache sizing, and a back‑tuning workflow to achieve measurable improvements.

JavaLoad TestingOperations
0 likes · 17 min read
Turn Java Enterprise Performance Tuning into a Scientific Process
dbaplus Community
dbaplus Community
Mar 16, 2016 · Databases

How to Supercharge SELECT COUNT(*) in Oracle: 6 Proven Optimization Tricks

Discover six powerful techniques—including B‑tree and bitmap indexes, materialized views, result‑set caching, and clever query rewrites—to dramatically reduce logical reads and accelerate Oracle's SELECT COUNT(*) performance, with step‑by‑step examples and measurable improvements.

Materialized ViewOracleResult Cache
0 likes · 6 min read
How to Supercharge SELECT COUNT(*) in Oracle: 6 Proven Optimization Tricks
21CTO
21CTO
Mar 15, 2016 · Databases

How Database Compression Boosts Performance While Cutting Storage Costs

This article examines why storage capacity limits IT systems, explains how database compression reduces disk usage and I/O time, discusses various dictionary‑based compression methods, related operations and commands, and evaluates compression ratios and overall impact on system performance.

DB2I/O reductiondatabase compression
0 likes · 11 min read
How Database Compression Boosts Performance While Cutting Storage Costs
21CTO
21CTO
Mar 5, 2016 · Backend Development

How SO_REUSEPORT Boosts NGINX Performance and Enables Seamless Rolling Upgrades

NGINX 1.9.1 adds the SO_REUSEPORT socket option, allowing multiple workers to share the same IP and port, which the kernel load‑balances, reducing lock contention and dramatically improving request throughput and latency in multi‑core environments.

SO_REUSEPORTload balancingperformance tuning
0 likes · 6 min read
How SO_REUSEPORT Boosts NGINX Performance and Enables Seamless Rolling Upgrades
dbaplus Community
dbaplus Community
Feb 2, 2016 · Databases

Unlock SQL Speed: Real-World Optimization Tricks and Techniques

This article walks through practical Oracle SQL optimization methods—explaining execution plans, indexes, statistics, hints, and partitioning—using concrete examples and step‑by‑step case studies that show how to dramatically reduce query runtimes and CPU load.

Index OptimizationOracleSQL
0 likes · 24 min read
Unlock SQL Speed: Real-World Optimization Tricks and Techniques
dbaplus Community
dbaplus Community
Dec 28, 2015 · Databases

Mastering Oracle Real‑Time SQL Monitoring for Faster Performance Diagnosis

This guide explains Oracle Real‑Time SQL Monitoring, covering terminology, activation conditions, how to access it via Enterprise Manager Cloud Control, and detailed walkthroughs of its various panels, metrics, and practical examples for diagnosing and optimizing long‑running queries and index builds.

DBAOracleSQL Monitoring
0 likes · 29 min read
Mastering Oracle Real‑Time SQL Monitoring for Faster Performance Diagnosis
21CTO
21CTO
Dec 14, 2015 · Databases

MongoDB Master Russell Smith’s Essential Best‑Practice Checklist

This article compiles Russell Smith’s comprehensive MongoDB best‑practice guide, covering architecture choices, file limits, write safety, schema design, replication, sharding, security, and performance tuning to help engineers avoid common pitfalls and optimize production deployments.

Database ScalingMongoDBReplication
0 likes · 16 min read
MongoDB Master Russell Smith’s Essential Best‑Practice Checklist
ITPUB
ITPUB
Nov 27, 2015 · Databases

How to Build an Effective Oracle Statistics Collection Strategy for High‑Volume Systems

This article outlines practical strategies for Oracle DBAs to design, automate, and fine‑tune statistics‑gathering processes in large, high‑concurrency environments, covering automatic options, handling skewed data, partitioned tables, bind variables, and ongoing optimization cycles.

DBMS_STATSPartitioningdatabase administration
0 likes · 10 min read
How to Build an Effective Oracle Statistics Collection Strategy for High‑Volume Systems
21CTO
21CTO
Nov 23, 2015 · Big Data

How Dianping Scales Real‑Time Analytics with Apache Storm

This article explains how Dianping built a millisecond‑level real‑time computation platform using Apache Storm, covering use cases, system architecture, core Storm concepts, performance tuning, best practices, and a detailed Q&A on their production deployment.

Apache StormReal-time Analyticsbig data
0 likes · 23 min read
How Dianping Scales Real‑Time Analytics with Apache Storm
dbaplus Community
dbaplus Community
Nov 17, 2015 · Databases

Master Oracle SQL Optimization: Proven Roadmap & Real-World Cases

This comprehensive guide explains the essence of Oracle SQL tuning, presents a step‑by‑step optimization roadmap, walks through real‑world case studies—including a high‑CPU query fixed with hints and query rewrites—and details how to capture and interpret accurate execution plans while addressing optimizer parameters and common pitfalls.

OracleSQLdatabase optimization
0 likes · 24 min read
Master Oracle SQL Optimization: Proven Roadmap & Real-World Cases
dbaplus Community
dbaplus Community
Nov 6, 2015 · Databases

Misconfigured Oracle Parallel Parameters Caused a System Outage – DBA Case Study

In this detailed DBA case study, the speaker explains how improper settings of Oracle's parallel execution parameters on an AIX‑based 10gR2 database led to process saturation, undo‑related wait events, and temporary connection issues, and describes the step‑by‑step diagnosis, parameter adjustments, and lessons learned for future tuning.

AIXOracleParallel Parameters
0 likes · 12 min read
Misconfigured Oracle Parallel Parameters Caused a System Outage – DBA Case Study
21CTO
21CTO
Nov 2, 2015 · Backend Development

How to Maximize System Load Capacity: Metrics, Bottlenecks, and Tuning Strategies

This article explains how to measure a system's load capacity, identifies key factors such as bandwidth, hardware, and OS settings, and provides practical optimization techniques for Linux, Nginx, Tomcat, and databases to achieve higher concurrency and better performance.

Backend DevelopmentTomcatperformance tuning
0 likes · 15 min read
How to Maximize System Load Capacity: Metrics, Bottlenecks, and Tuning Strategies
21CTO
21CTO
Aug 31, 2015 · Databases

Optimizing MySQL on SSD: Real‑World InnoDB Tuning Strategies

This article walks through the background of I/O issues in a MySQL project, explains SSD characteristics, and details step‑by‑step InnoDB parameter adjustments—including I/O scheduler changes, innodb_io_capacity, and adaptive flushing—both before and after a master‑slave switch, supported by performance data and diagrams.

InnoDBMySQLSSD
0 likes · 17 min read
Optimizing MySQL on SSD: Real‑World InnoDB Tuning Strategies
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Jul 31, 2015 · Backend Development

Load Balancing Between Worker Threads in Multithreaded Server Programs

The article explains how kernel‑level load balancing works, why naïve thread‑pool wake‑up can cause CPU imbalance, and proposes using thread affinity, priority layers and a custom layered condition variable to achieve better performance in multithreaded server applications on Linux.

kernel schedulingload balancingmultithreading
0 likes · 21 min read
Load Balancing Between Worker Threads in Multithreaded Server Programs
Qunar Tech Salon
Qunar Tech Salon
Jul 5, 2015 · Databases

Conceptual Overview of SQL Server Performance Tuning

This article provides a conceptual summary of SQL Server performance tuning, explaining the goals of optimizing response time and throughput, the importance of baselines and costs, factors influencing performance, and a step‑by‑step DETECT methodology for systematic optimization.

BaselineResponse TimeSQL Server
0 likes · 6 min read
Conceptual Overview of SQL Server Performance Tuning
MaGe Linux Operations
MaGe Linux Operations
Jul 2, 2015 · Databases

15 Essential MySQL & MariaDB Performance Tuning Tips for Faster Databases

This guide walks you through essential MySQL and MariaDB performance‑tuning techniques—including storage engine settings, disk placement, buffer pool sizing, swappiness, connection limits, thread cache, DNS lookup, query cache, temporary tables, slow‑query logging, idle connections, file‑system choices, packet size, and testing tools—to help you optimize and maintain a high‑speed, reliable database server.

InnoDBLinuxMariaDB
0 likes · 15 min read
15 Essential MySQL & MariaDB Performance Tuning Tips for Faster Databases
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
May 3, 2015 · Backend Development

Designing Scalable Netty Push Services: Real‑World IoT Lessons

This article analyzes common push‑service questions, presents a memory‑leak case from an IoT MQTT middleware, and provides detailed Netty design guidelines—including file‑handle limits, CLOSE_WAIT handling, thread and task management, heartbeat tuning, buffer allocation, memory‑pool usage, logging pitfalls, TCP and JVM optimizations—to help engineers build stable, high‑performance million‑connection push servers.

IoTMemory LeakNetty
0 likes · 23 min read
Designing Scalable Netty Push Services: Real‑World IoT Lessons
Qunar Tech Salon
Qunar Tech Salon
Apr 23, 2015 · Operations

Comprehensive Windows 7 and SSD Optimization Guide

This guide provides detailed steps and registry tweaks to optimize Windows 7 performance on SSDs, covering BIOS settings, SSD usage principles, disabling unnecessary services, disk space management, and system configuration commands to improve speed and reduce resource consumption.

SSDSystem OptimizationWindows
0 likes · 8 min read
Comprehensive Windows 7 and SSD Optimization Guide
MaGe Linux Operations
MaGe Linux Operations
Apr 17, 2015 · Backend Development

Boost Nginx Performance: Essential Tuning Tips for High Traffic

Learn how to fine‑tune Nginx by adjusting key global, events, and HTTP settings—such as worker processes, connection limits, gzip compression, and file caching—to maximize throughput and reduce latency under heavy client loads, with a complete example configuration and restart instructions.

BackendConfigurationNginx
0 likes · 13 min read
Boost Nginx Performance: Essential Tuning Tips for High Traffic
ITPUB
ITPUB
Jan 23, 2015 · Databases

Inside Yiche’s SQL Server: Memory DB, HA, Cloud and Performance Secrets

In this technical interview, Yiche Group’s senior DBA Gao Jiwei shares how the company designs its database platform, leverages SQL Server’s in‑memory OLTP, implements high‑availability solutions, builds a private cloud with open‑source tools, and optimizes performance during massive traffic events.

In-Memory OLTPSQL Serverperformance tuning
0 likes · 16 min read
Inside Yiche’s SQL Server: Memory DB, HA, Cloud and Performance Secrets