Tagged articles

InnoDB

905 articles · Page 10 of 10
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.

Database PerformanceGISInnoDB
0 likes · 7 min read
What MySQL 5.7 InnoDB Experts Reveal: Key Q&A on New Features
Efficient Ops
Efficient Ops
Jul 5, 2015 · Databases

What’s New in MySQL InnoDB 5.7? Performance Boosts and Fresh Features

The article reviews MySQL InnoDB 5.7’s major performance enhancements—such as transaction pooling, temporary‑table redesign, buffer and DDL optimizations—and introduces new capabilities like native partitioning, dynamic buffer sizing, GIS support, virtual columns, and advanced compression, all illustrated with benchmark graphics.

InnoDBNew FeaturesOptimization
0 likes · 11 min read
What’s New in MySQL InnoDB 5.7? Performance Boosts and Fresh Features
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
Qunar Tech Salon
Qunar Tech Salon
Jan 18, 2015 · Databases

MySQL Performance Optimizations and Feature Improvements: Group Commit, DDL Fast Fail, GTID, Auto‑Increment Persistence, Replication, and Key Partitioning

This article presents a comprehensive technical overview of MySQL performance tuning and feature enhancements—including group‑commit redesign, DDL fast‑fail, GTID handling, persistent auto‑increment, replication parallelism, and key‑partition hash changes—backed by real‑world test data from Taobao's large‑scale deployment.

DDLGroup CommitInnoDB
0 likes · 27 min read
MySQL Performance Optimizations and Feature Improvements: Group Commit, DDL Fast Fail, GTID, Auto‑Increment Persistence, Replication, and Key Partitioning