Skip navigation.
Home

Languages

RSS Feed FromDual on Linked In Recommend us on Xing Join us on Facebook Google+ Flickr Contact us

FromDual sitemap

Performance Tuning, Benchmarking, Capacity Planning and Monitoring

MySQL Database Health Check for MySQL/MariaDB
MySQL Performance Monitor
MySQL monitoring solutions
MySQL Performance Tuning Key
Wie der MySQL Optimizer schummelt, wenn es um MySQL Cluster geht...
How the MySQL Optimizer with MySQL Cluster is cheating you...
MySQL Benchmarking
Some more benchmarks added
My thoughts about MySQL (Cluster) replication
My wish for the New Year: MySQL DBA's, please install iostat on your servers!

Backup/Restore/Recovery, Operations and Consulting

What's going on when MySQL does operations on partitions?
FromDual Tools
FromDual consulting tool collection
MySQL Configuration File sample (my.cnf/my.ini)
MyEnv for Multi-Database set-ups
MyEnv (MySQL BasEnv)
MyEnv MySQL Environment
MySQL reporting to syslog
Logging users to the MySQL error log
Can you trust your backup?

Architecture, Design and High Availability

Stealthy migrating MySQL tables and MySQL data access interfaces using enlarged updateable VIEW functionality
MySQL Architecture Overview
Limitations of MySQL
MySQL Scale-Out by Application Partitioning
Linux High Availability (HA) solutions
MySQL Full-Text Search Engines
MySQL Architectures Overview
MySQL High-Availability (HA) solutions
Round-Robin Database Storage Engine (RRD)
MySQL Active - Active Clustering
MySQL Multi-Master – Single-Slave – Replication (Episode 2)

Storage Engines

MySQL storage engines
MySQL Pluggable Storage Engines

MyISAM/Aria

How many warm MyISAM key blocks do you have?

CSV

The MySQL CSV Storage Engine

Federated

MySQL Federated Storage Engine

NDB

For the NDB Storage Engine see MySQL Cluster below.

InnoDB/XtraDB

Disadvantages of explicitly NOT using InnoDB Primary Keys?
Which table is hit by an InnoDB page corruption?
What is CHECK TABLE doing with InnoDB tables?

RRD

Round-Robin Database Storage Engine (RRD)

MySQL Cluster

MySQL Cluster Memory sizing
MySQL Cluster overview
Possible memory leak in NDB-API applications?
MySQL Cluster Local Checkpoint (LCP) and Global Checkpoint (GCP)
Wie der MySQL Optimizer schummelt, wenn es um MySQL Cluster geht...
How the MySQL Optimizer with MySQL Cluster is cheating you...
Sparse files
Some more details about DiskSyncSize
MySQL Cluster: No more room in index file
MySQL Cluster restore
Why does MySQL Cluster takes so long for --initial?

Politics, Strategy and Philosophy

DBA wisdoms
WAMP oder LAMP?
Citation of the week
The battle against Oracle is probably over but has the real war begun yet?

Training, Education and Know-How

Advanced MySQL DBA Workshop - draft
Library (guest/guest)

SQL and development

Determine in MySQL if we are in summer time or winter time (daylight saving time, DST)
MySQL useful add-on collection using UDF
User Defined Function (UDF) collection
Ranking in MySQL results

Other topics

Quick Links to the MySQL documentation
Reading other processes memory
Hunting the core
MySQL Handler Read Status Variables
MySQL hints
Operating System Signals on different platforms
MySQL Questions & Answers
MySQL Cluster analysis for foodmart
ndb_size.pl report for database foodmart (21 tables)
MySQL New Features
What's going on when MySQL does operations on Partitions
Using MySQL User-Defined Functions (UDF) to get MySQL internal informations
Profiling MySQL with oprofile
MySQL trouble shooting
The handler_read_* status variables
Test application for MySQL high availability (HA) set-up
Typical automated MySQL maintenance jobs
SATA Flash Solid State Disk up to 160 Gbyte announced!
Transaction performance
MySQL Multi-Master - Single-Slave - Replication
Profiling MySQL with oprofile
Materialized Views with MySQL
Some more MySQL tools added
MySQL on VMware Workstation/DRBD vs. VMWare ESX Server/SAN
MySQL licenses for dummies
Active/active fail over cluster with MySQL Replication
With MySQL-Enterprise Montior through firewalls
MySQL logon trigger
Materialized Views (MV) with MySQL
Pittfalls with Federated Tables
Library (guest/guest)

German