BestHub
Sign in
Tagged articles

database optimization

509 articles · Page 6 of 6
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 17, 2015 · Databases

Mastering HBase: Table Structure, API Usage, and Performance Tuning

This article explains HBase's column‑oriented architecture, key concepts such as Rowkey, ColumnFamily, and Region, provides Java API examples for table operations, and offers practical optimization techniques—including pre‑splitting, Rowkey design, caching, and compaction settings—to improve read/write performance.

Big DataHBaseJava API
0 likes · 20 min read
Mastering HBase: Table Structure, API Usage, and Performance Tuning
MaGe Linux Operations
MaGe Linux Operations
Apr 17, 2015 · Databases

Why MySQL Slaves Lag Behind Masters and How to Speed Up Replication

This article explains the fundamental reasons why MySQL slave servers experience higher latency than masters and provides practical optimization techniques—including parallel replication, proper indexing, I/O improvements, and hardware choices—to reduce replication lag.

MySQLParallel ReplicationSlave Lag
0 likes · 6 min read
Why MySQL Slaves Lag Behind Masters and How to Speed Up Replication
MaGe Linux Operations
MaGe Linux Operations
Mar 3, 2015 · Databases

Essential MySQL Performance Tuning: Key Metrics & Optimization Tips

Learn how to monitor and optimize MySQL server performance by examining critical variables, status metrics, and configuration parameters such as slow query settings, connection limits, key buffer size, query cache, temporary tables, and thread usage to achieve stable, efficient database operation.

MySQLSQLdatabase optimization
0 likes · 8 min read
Essential MySQL Performance Tuning: Key Metrics & Optimization Tips
MaGe Linux Operations
MaGe Linux Operations
Feb 6, 2015 · Databases

101 Essential MySQL Tuning Tips for Maximum Performance

This article compiles 101 practical MySQL optimization tips covering hardware and OS setup, server configuration, schema design, query refinement, and backup strategies, offering actionable guidance to boost performance, reliability, and scalability of MySQL deployments.

MySQLdatabase optimization
0 likes · 14 min read
101 Essential MySQL Tuning Tips for Maximum Performance
MaGe Linux Operations
MaGe Linux Operations
Nov 18, 2014 · Databases

Boost Zabbix Performance: MySQL SSD Tuning and Configuration Tips

This article explains how to optimize MySQL for large‑scale Zabbix deployments by leveraging SSD storage, adjusting key InnoDB settings, using appropriate partitioning strategies, and considering high‑availability options to dramatically improve disk I/O and overall monitoring throughput.

MySQLSSDZabbix
0 likes · 10 min read
Boost Zabbix Performance: MySQL SSD Tuning and Configuration Tips
ITPUB
ITPUB
Feb 25, 2014 · Databases

Why Database Query Optimization Matters and Key Strategies to Cut Scan Times

The article explains how costly full‑table scans in large databases, such as a bank's million‑record account table, can be reduced to minutes through effective query‑optimization techniques, and outlines the main strategies, automation possibilities, and future trends in SQL performance.

Query Tuningdatabase optimizationfull table scan
0 likes · 3 min read
Why Database Query Optimization Matters and Key Strategies to Cut Scan Times