Home
PmaControl
Databases
Solutions
- Support 24×7 MariaDB & MySQL emergencies
- Observabilité SQL Monitoring, alerts, topology
- Haute disponibilité Replication, failover, Galera
- Disaster Recovery Backup, restore, RPO/RTO
- Sécurité & conformité Audit, GDPR, SOC2
- Migration & upgrade Zero downtime, pt-osc, gh-ost
Plans
Resources
Areas of expertise
- Observabilité SQL Monitoring, alerts, Dot3 topology
- Haute disponibilité Replication, failover, Galera
- Sécurité & conformité Audit, GDPR, SOC2, ISO 27001
- Disaster Recovery Backup, restore, RPO/RTO
- Performance & optimisation Digests, EXPLAIN, tuning
- Migration & upgrade Zero downtime, pt-osc
Quick links
Support 24×7
Book a demo

Book a demo

← All articles

Articles tagged optimization 1

July 23, 2025

mariadb performance optimization

Bad Data Design Leads to Poor Performances: From 105 Minutes to 17 Seconds

How a DATE vs INT type mismatch in a join caused a 105-minute execution time, resolved to 17 seconds with a virtual generated column.

Read article →