BestHub
Sign in
Tagged articles

database performance

435 articles · Page 5 of 5
dbaplus Community
dbaplus Community
Aug 28, 2016 · Databases

Scaling Databases: From Baseline Metrics to Multi‑Layer Optimization

This guide walks DBAs through evaluating current database resources, establishing performance baselines, building business pressure models, conducting realistic stress tests, and applying a seven‑layer optimization roadmap—from statement tweaks to hardware upgrades and business‑level adjustments—to ensure the system can handle ten‑fold or hundred‑fold growth.

HardwareOptimizationcapacity-planning
0 likes · 16 min read
Scaling Databases: From Baseline Metrics to Multi‑Layer Optimization
ITPUB
ITPUB
Aug 12, 2016 · Databases

Unlock Oracle Cursor Insights: Master V$SQL, V$SQLAREA, and Tuning Parameters

This article explains Oracle cursor concepts, details the key V$SQL and related views, highlights crucial columns for performance tuning, and describes important parameters such as open_cursor and cursor_sharing, helping DBAs optimize SQL execution and manage shared pool memory effectively.

CursorOracleSQL Tuning
0 likes · 13 min read
Unlock Oracle Cursor Insights: Master V$SQL, V$SQLAREA, and Tuning Parameters
Efficient Ops
Efficient Ops
Aug 1, 2016 · Databases

Why Uber’s MySQL Switch Misrepresents PostgreSQL: A Deep Technical Dive

This article critically examines Uber’s claim that MySQL outperforms PostgreSQL by dissecting the alleged PostgreSQL limitations, presenting detailed performance tests, and clarifying the true costs of write amplification, replication, and upgrade processes for both databases.

MVCCMySQLPostgreSQL
0 likes · 20 min read
Why Uber’s MySQL Switch Misrepresents PostgreSQL: A Deep Technical Dive
21CTO
21CTO
Jun 15, 2016 · Databases

Why Adding Indexes to Every Column Won’t Speed Up MySQL Queries

This article explains MySQL’s indexing fundamentals, the left‑most prefix rule, B+‑tree structure, disk I/O considerations, and provides step‑by‑step methods and real‑world cases for diagnosing and optimizing slow queries in production systems.

B+ TreeIndexingMySQL
0 likes · 25 min read
Why Adding Indexes to Every Column Won’t Speed Up MySQL Queries
dbaplus Community
dbaplus Community
Jun 7, 2016 · Databases

Master MySQL Data Types and Index Optimization for Faster Queries

This guide explains how to choose optimal MySQL data types, use enums, handle dates, and design efficient indexes—including B‑tree, prefix, and covering indexes—while also covering storage engine differences, maintenance commands, and normalization strategies to boost database performance.

Data TypesIndex OptimizationMySQL
0 likes · 16 min read
Master MySQL Data Types and Index Optimization for Faster Queries
ITPUB
ITPUB
May 22, 2016 · Databases

Why Optimistic Locking Improves High‑Concurrency Performance

Optimistic locking replaces heavyweight pessimistic locks with a version‑based approach, allowing concurrent reads and only checking a version or timestamp during updates, which reduces lock contention, improves performance under high concurrency, but requires careful handling of external updates to avoid dirty data.

Optimistic Lockingconcurrency controldatabase performance
0 likes · 5 min read
Why Optimistic Locking Improves High‑Concurrency Performance
dbaplus Community
dbaplus Community
May 15, 2016 · Databases

Unlocking SQL Server Parallel Query Execution: Concepts, Plans, and Practical Tips

SQL Server’s parallel query execution leverages multiple CPUs to accelerate CPU‑bound workloads, and this article explains the underlying hardware prerequisites, scheduler/task/worker model, serial vs parallel plans, exchange operators, parallel joins, CXPACKET waits, and configuration settings such as cost threshold and max degree of parallelism.

CXPACKETParallel JoinsParallel Query
0 likes · 15 min read
Unlocking SQL Server Parallel Query Execution: Concepts, Plans, and Practical Tips
dbaplus Community
dbaplus Community
Apr 27, 2016 · Databases

Unlocking Oracle 12c Optimizer: Adaptive Query Optimization and New Statistics Features

This technical guide explores Oracle 12c's optimizer enhancements, covering adaptive query optimization, adaptive plans and join methods, hybrid hash distribution, dynamic and adaptive statistics, automatic re‑optimization, statistics feedback, new histogram types, and online statistics collection, with practical examples and visual illustrations.

Adaptive Query OptimizationOracleSQL Plan Directives
0 likes · 26 min read
Unlocking Oracle 12c Optimizer: Adaptive Query Optimization and New Statistics Features
dbaplus Community
dbaplus Community
Apr 22, 2016 · Databases

Mastering Oracle Parallel Query: How It Works and When to Use It

This article explains Oracle's parallel query feature, covering its benefits, resource costs, required conditions, various data‑distribution methods such as broadcast, replicate and hash, how to read parallel execution plans, and practical monitoring techniques to avoid performance pitfalls.

Hash JoinOracleParallel Query
0 likes · 31 min read
Mastering Oracle Parallel Query: How It Works and When to Use It
dbaplus Community
dbaplus Community
Apr 9, 2016 · Databases

The Simple SQL That Can Crash a 1TB IBM Power780 Server

The article explains how a seemingly harmless SQL statement, when executed millions of times on an IBM Power780 system with a 1 TB configuration, can overload the library cache mutex, causing the database to stall, and provides the original script, reproduction steps, and practical advice to avoid such catastrophic contention.

DBALibrary CacheOracle
0 likes · 8 min read
The Simple SQL That Can Crash a 1TB IBM Power780 Server
dbaplus Community
dbaplus Community
Mar 23, 2016 · Databases

Boost MySQL Insert Speed with Batch Inserts, Transactions, and Ordered Data

This article explains three practical techniques—batching multiple rows into a single INSERT, wrapping inserts in transactions, and inserting records in primary‑key order—to significantly improve MySQL InnoDB insert performance, backed by detailed test results and important configuration tips.

Batch InsertInnoDBInsert Optimization
0 likes · 7 min read
Boost MySQL Insert Speed with Batch Inserts, Transactions, and Ordered Data
dbaplus Community
dbaplus Community
Mar 7, 2016 · Databases

How SQL Server Hekaton Supercharges OLTP with In‑Memory, Latch‑Free Architecture

This article examines the performance bottlenecks of traditional relational databases, explains how SQL Server 2014's In‑Memory OLTP (Hekaton) uses latch‑free Bw‑tree structures, optimistic timestamp‑based concurrency, and native compilation to achieve orders‑of‑magnitude speedups, and discusses its practical limits and real‑world case studies.

HekatonIn-Memory OLTPLatch-Free
0 likes · 20 min read
How SQL Server Hekaton Supercharges OLTP with In‑Memory, Latch‑Free Architecture
dbaplus Community
dbaplus Community
Feb 21, 2016 · Databases

Boost Oracle Distributed Query Performance with Collocated Inline Views and Hints

This article explains how to optimize Oracle distributed queries that involve remote tables by minimizing remote calls, reducing result set size, and improving execution plans through techniques such as collocated inline views, CBO behavior, and driving_site hints, illustrated with detailed examples and performance measurements.

Collocated ViewDistributed QueryHints
0 likes · 11 min read
Boost Oracle Distributed Query Performance with Collocated Inline Views and Hints
dbaplus Community
dbaplus Community
Nov 25, 2015 · Databases

Unlock Oracle SQL Monitor: Free Tool for Powerful SQL Optimization

This guide explains how to access and use Oracle SQL Monitor—a free feature in Oracle Enterprise Edition—to capture SQL execution details, analyze performance bottlenecks, compare estimated and actual rows, and apply targeted optimizations using both the EM console and command‑line scripts.

OracleSQL MonitorSQL Tuning
0 likes · 9 min read
Unlock Oracle SQL Monitor: Free Tool for Powerful SQL Optimization
dbaplus Community
dbaplus Community
Nov 18, 2015 · Databases

Demystifying DB2 Optimizer: How Cost Models Shape Query Performance

This article explains the inner workings of the DB2 optimizer, its four-step processing flow, cost‑based decision making, and detailed examples comparing full‑table and index scans, followed by practical tuning tips and a Q&A session for real‑world query optimization.

Cost ModelDB2Index Scan
0 likes · 19 min read
Demystifying DB2 Optimizer: How Cost Models Shape Query Performance
Architect
Architect
Sep 18, 2015 · Databases

Implementing Asynchronous MySQL Queries in PHP Using Coroutines

This article explains how to achieve asynchronous MySQL queries in PHP by leveraging mysqlnd's async functions and PHP generators, compares synchronous and asynchronous execution times, provides a complete coroutine‑based example, and discusses performance considerations and limitations.

CoroutinesMySQLPHP
0 likes · 7 min read
Implementing Asynchronous MySQL Queries in PHP Using Coroutines
Efficient Ops
Efficient Ops
Jul 24, 2015 · Databases

What MySQL 5.7 InnoDB Experts Reveal: Key Q&A on New Features

An expert panel from the High‑Efficiency Operations community answers eleven pressing MySQL 5.7 questions, covering test hardware, GA timeline, GIS speed, virtual column indexing, materialized view plans, 2‑D geo support, performance monitoring, Oracle’s market strategy, geojson handling, multi‑source replication, buffer‑pool locking, and InnoDB Memcached consistency.

GISInnoDBMaterialized Views
0 likes · 7 min read
What MySQL 5.7 InnoDB Experts Reveal: Key Q&A on New Features
Qunar Tech Salon
Qunar Tech Salon
May 3, 2015 · Databases

Optimizing PostgreSQL Queries for Flight Data Retrieval at Qunar

The article analyzes a slow PostgreSQL query that joins multiple tables to fetch flight numbers, compares several alternative query formulations with their execution plans, and presents a final solution using array aggregation to achieve sub‑millisecond performance despite existing indexes.

PostgreSQLSQLdatabase performance
0 likes · 7 min read
Optimizing PostgreSQL Queries for Flight Data Retrieval at Qunar
ITPUB
ITPUB
Aug 28, 2014 · Databases

How Oracle DBAs Tackle Performance: Real‑World Stats Tuning and Career Insights

In this interview, veteran Oracle DBA Shi Yuedong shares his career journey, personal philosophy on opportunity, a hands‑on performance‑diagnosis case at Lenovo, experiments revealing Oracle 12.1's default statistics sampling rate, and thoughtful perspectives on big data versus data‑warehouse evolution.

DBAdata warehousedatabase performance
0 likes · 18 min read
How Oracle DBAs Tackle Performance: Real‑World Stats Tuning and Career Insights
MaGe Linux Operations
MaGe Linux Operations
Jun 23, 2014 · Databases

How a Simple Diagnostic Box Can Reveal and Fix Slow Database Queries

By adding a lightweight diagnostic box that displays each page’s database query count and total execution time, developers can quickly spot inefficient queries, compare development and production performance, and make informed optimizations, ultimately improving website speed and reliability.

SQL queriesdatabase performancediagnostic tools
0 likes · 5 min read
How a Simple Diagnostic Box Can Reveal and Fix Slow Database Queries