PmaControl changelog
Complete 5.x release history
Every v5.x.y tag is listed here, newest first. Tags without a published package are marked.
62 tags documentedLatest release
PmaControl 5.4.42
Expanded cluster diagnostics, alert evidence and connection charts, with more reliable collectors, workers, licensing and security.
Highlights
- ProxySQL distinguishes Group Replication and Galera roles, maintenance causes and unavailable reads; VIP ownership is refreshed.
- Alerting Pro 1.0.44 adds connection charts at +3 σ with exact recorded references and incident context, plus metadata-lock SQL. Missing historical references remain unavailable; plugin activation requires its license.
- Native MariaDB and MySQL journals use bounded SSH retries and durable replay; freshness history covers 60 days, and workers are renewed when their code changes.
- Read-only migration checks retain unknown and manual states. The interface adds daemon duration history, restores query filters and preserves exact BIGINT counters.
- Licenses are bound to the installation UUID; trial expiry is enforced, with progress and remaining-capacity indicators.
- SQL injection vulnerabilities are fixed in the Listener and CheckConfig controllers.
- Back up the database and configuration before upgrading. The package applies registered alert, journal, ProxySQL diagnostic and daemon-duration migrations; source installations use bin/apply-release-migrations.sh.
5.4.37 measurements compared with 5.4.23
These measurements concern 5.4.37. No overall benchmark for 5.4.42 is published here.
Complete Alerting path
Compared on the same Ubuntu 24.04 VM, PHP 8.4.26 and MariaDB 10.11.14. Incident cases use the same 53-waiter snapshot; the report details means, p95, repetitions and limits.
| Treatment | 5.4.23 | 5.4.37 | Median change | SQL queries |
|---|---|---|---|---|
| Atomic claim, interval not elapsed | 0.104 ms | 0.110 ms | +5.5% | 1 → 1 |
| Atomic claim, interval elapsed | 0.471 ms | 0.491 ms | +4.3% | 1 → 1 |
| Healthy callback when due | 2.026 ms | 5.027 ms | +148.2% | 7–9 → 23–29 |
| Healthy callback inside interval | 0.296 ms | 2.952 ms | +895.8% | 2 → 17 |
| Due incident opening | 3.956 ms | 9.044 ms | +128.6% | 9–11 → 37–39 |
| Due incident refresh | 4.010 ms | 8.391 ms | +109.2% | 9 → 35 |
| Due incident resolution | 3.047 ms | 7.132 ms | +134.1% | 8 → 37 |
| Listener dispatch and refresh | 3.960 ms | 7.683 ms | +94.0% | 9 → 35 |
Internal treatments
| Treatment | 5.4.23 | 5.4.37 | Median change | SQL queries |
|---|---|---|---|---|
| JSON decoding, 53 rows | 0.071 ms | 0.072 ms | +1.6% | — |
| Detection, sorting and bounding, 53 waiters | 0.222 ms | 0.234 ms | +5.6% | — |
| Internal healthy callback | 0.042 ms | 0.039 ms | -7.2% | — |
| Internal incident opening | 0.229 ms | 0.221 ms | -3.7% | — |
| Internal incident refresh | 0.232 ms | 0.220 ms | -5.5% | — |
| Internal incident resolution | 0.041 ms | 0.043 ms | +4.6% | — |
Historical measurements for 5.4.23
The figures below were published with 5.4.23 on another environment; they are separate from the controlled comparison above.
Added treatments
Measurements on PHP 8.5.9, MariaDB 10.11.18, with a 53-row stress snapshot.
| Treatment | Samples | Median | p95 | Max |
|---|---|---|---|---|
| Atomic claim, interval not elapsed | 2 000 | 0.078 ms | 0.139 ms | 0.844 ms |
| Atomic claim, interval elapsed | 1 000 | 0.080 ms | 0.099 ms | 0.213 ms |
| Healthy callback skipped inside the interval | 500 | 0.165 ms | 0.260 ms | 0.424 ms |
| Healthy callback when due | 200 | 0.952 ms | 1.159 ms | 1.456 ms |
| Due incident opening | 100 | 2.523 ms | 3.226 ms | 3.433 ms |
| Due incident refresh | 100 | 2.913 ms | 3.796 ms | 5.588 ms |
| Callback with active incident skipped | 500 | 0.170 ms | 0.270 ms | 0.356 ms |
| Due incident resolution | 100 | 1.307 ms | 1.747 ms | 3.314 ms |
Internal treatment detail
| Treatment | Samples | Median | p95 | Max |
|---|---|---|---|---|
| Listener dispatch and complete refresh | 100 | 2.024 ms | 2.544 ms | 2.743 ms |
| JSON decoding only, 53 rows | 5 000 | 0.049 ms | 0.066 ms | 0.153 ms |
| Detection, sorting, and bounding, 53 waiters | 5 000 | 0.737 ms | 0.832 ms | 1.498 ms |
Reused existing pipeline
These stages are unchanged. Long Integrate values are historical mysql_* lane outliers, not a cost of the new rule.
| Treatment | Samples | Median | p95 | Max | Feature delta |
|---|---|---|---|---|---|
| Aspirateur tryMysqlConnection, complete treatment | 29 | 44 ms | 156.6 ms | 841 ms | 0 ms |
| Aspirateur, correlated connection phase | 29 | 4.469 ms | 5.636 ms | 5.846 ms | 0 ms |
| Integrate mysql_* lane, all integrations | 66 | 1 ms | 5,150.75 ms | 173,724 ms | 0 ms |
Release-by-release history
Missing numbers did not receive a stable tag. The v5.0-beta prerelease is intentionally excluded from this v5.x.y list.
PmaControl 5.4
-
v5.4.42 Latest release
Expanded cluster diagnostics, alert evidence and connection charts, with more reliable collectors, workers, licensing and security.
-
Human ISO 27001 assessments with evidence and history, a unified queue view, more reliable worker SQL and partition-based audit retention.
-
Table-size treemap, MySQL account CSV export and expanded monitoring, with more reliable backups and upgrades.
-
Corrected ProxySQL and Galera topology, with more reliable connection history, backups and first collection.
-
Dedicated ProxySQL console, safer topology and inventory, and more reliable alerts and monitoring.
-
Expanded MariaDB, MySQL, Galera and ProxySQL audits, with more reliable monitoring and storage history.
-
Consistent tables, HostStat charts, faster Server/main refresh and repaired Query/all sorting.
-
APT publication hardened by reusing the validated migration plan.
-
v5.4.34 Tag without a published package
Migration plan prepared before package smoke test; tag without a published release or APT package.
-
v5.4.33 Tag without a published package
Bounded Integrate processing and more resilient migrations; tag without a published release or APT package.
-
Restored binlog inventory and disk alerts, with safer collection freshness and plugin activation.
-
Correct Dot3 error colours, with improved monitoring state and daemon lifecycle.
-
Bounded pivot collection and processing, more reliable migrations and daemons, and a hardened plugin catalog.
-
Restored Dot3 topology, visible RAID alerts and disconnected Galera node status.
-
Improved RAID alerts and SSH tunnel scheduling per physical endpoint.
-
Reconcile MySQL availability alerts after a collection gap.
-
Native RAID controller health and ProxySQL worker health indicators.
-
Truthful SSH tunnel health and more reliable durable DDL checks.
-
Consistent design, disabled-producer incidents and safer operator workflows.
-
Metadata-lock alerts, a 30-second cadence, and per-treatment cost measurements.
-
Watchdog isolation and resilient package publication.
-
v5.4.21 Superseded tag
Watchdog error containment and release-checkout hydration; tag superseded by 5.4.22.
-
v5.4.20 Superseded tag
Watchdog daemon-retry isolation; tag superseded by 5.4.22.
-
Layout runtime, upgrade hardening, Monitoring routing, Dot3 topology, and UI fixes.
-
FrankenPHP runtime, backup resilience, legacy routes, and UI updates.
-
Debian packaging, FrankenPHP TLS state, Backup v2, Galera, and the Pro alert feed.
-
Light UI, CI capacity, freshness guard, and Backup/schema reliability.
-
Deterministic APT bootstrap, new design, log security, and collector performance.
-
Bounded catalog v2 protocol and worker memory/pivot reliability.
-
FrankenPHP plugin-publication verification and daemon/CI stabilization.
-
FrankenPHP-only APT release with restored Composer vendoring and fixed install migrations.
-
Package dependency-vendoring fix.
-
FrankenPHP transition, Backup v2 console, licensing, and operations improvements.
-
Backup v2, storage capacity, resumable migrations, and ClickHouse reliability.
-
MariaDB client and mirror-package alignment for Debian 13 installation.
-
Monitoring, audits, bounded sessions, daemon lifecycle, and runtime reliability.
-
One-step installation with PHP 8.5 and MariaDB 11.8.8.
-
APT schema/runtime parity, migration ledger, and hardened DokuWiki exports.
-
Post-install temporary permissions, disabled install routes, and safe audit exports.
-
Adjusted text exported by the byCluster audit.
-
DokuWiki XML-RPC publication of audit/byCluster reports.
-
Null-safe SSH tunnels, portable architecture links, and a fixed dashboard JSON route.
-
Ed25519 licensing, server quota, plugin gating, and consolidated Debian packaging.
PmaControl 5.3
-
Fresh APT installation repaired end-to-end for FrankenPHP and MariaDB 11.8.
PmaControl 5.2
-
PHP 8.5 compatibility plus plugin, partition, HTTP, and replication-throughput fixes.
-
Scalable database explorer, Performance dashboard, auto-partitioning, and Cleaner/Archives extraction.
-
Tolerance for missing first-boot disk metrics.
-
Installable local PMX catalog, destination permissions, and reliable CLI error codes.
-
Fresh FrankenPHP route bootstrap and writable runtime paths.
-
Writable plugin cache created by postinst.
-
Plugin catalog metadata stored as utf8mb4.
-
Plugin-catalog title column added to the full schema.
-
Daemon KPI tables and worker columns added to the install schema.
-
daemon_main.is_enabled added to the full schema.
-
Fresh FrankenPHP installations now serve PmaControl by default.
-
FrankenPHP becomes the default Debian runtime with a separate legacy Apache flavor.
-
PMX marketplace, EOL plugin, MaxScale UI, shared VIPs, and ProxySQL hardening.
-
Self-bootstrapping APT package, ProxySQL encryption, and IntegrateLog/worker/HostStat reliability.
PmaControl 5.1
-
MySQL log explorer, replication graphs, VIP/ProxySQL topology, and annotations.
PmaControl 5.0
-
Debian package publication, replication metrics, MaxScale audit, and runtime guards.
-
Optimized server last-seen lookup, chunked Integrate inserts, and guarded Dot3 access.
-
Complete Read-Only profile and ACL-filtered menu.