- 🐛 Fixed degraded database performance when using the Post Analytics screen (#22031) - Chris Raible
View the changelog for full details: v5.107.1...v5.107.2
Tag Name: v5.107.2
Release Date: 1/21/2025
GhostOpen-source publishing platform specifically designed for professional bloggers and publications. Focuses on clean, minimalist writing and publishing experience.
This release addresses a critical performance issue affecting the Post Analytics screen. A recent feature that added automatic refresh intervals was causing excessive database load, particularly for sites with large email recipient tables. The update reverts this change to restore normal database performance.
No migration steps are required for this release. The update is a straightforward hotfix that can be applied without any additional configuration changes.
This release addresses a performance issue that could significantly impact site stability, particularly for Ghost installations with large email recipient databases.
Who should prioritize this update:
The update is low-risk as it simply reverts a problematic feature, making it safe to apply immediately.
This release fixes a critical bug that was causing degraded database performance when using the Post Analytics screen. The issue stemmed from an automatic refresh interval feature introduced in a previous update, which significantly increased the number of requests to the /ghost/api/admin/members/events/ endpoint.
For sites with large email_recipients tables, this led to excessive database load and could cause site-wide performance issues. The fix reverts commit 9082a9f1db1d44026013a8cc8f0dee27e06e1486 to eliminate the automatic refresh behavior and restore normal database performance.
No new features were added in this release. This is a hotfix release focused on resolving a performance issue.
No security fixes were included in this release.
This release significantly improves database performance by removing an automatic refresh interval on the Post Analytics screen that was generating excessive API calls. The change particularly benefits:
email_recipients tablesBy reducing the frequency of calls to the database-intensive /ghost/api/admin/members/events/ endpoint, overall system responsiveness is improved and the risk of database overload is mitigated.
This hotfix addresses a critical performance issue that was affecting Ghost sites, particularly those with large email recipient databases. By removing an automatic refresh interval on the Post Analytics screen, the update significantly reduces database load and improves overall system responsiveness.
The issue was particularly impactful for high-volume newsletter publishers and sites with substantial subscriber bases, as the frequent API calls to the /ghost/api/admin/members/events/ endpoint were creating excessive database pressure. This could manifest as slow admin interface performance, timeouts when accessing analytics, and in severe cases, degraded performance across the entire Ghost installation.
This release demonstrates Ghost's commitment to performance optimization and responsiveness to community-reported issues, ensuring that the platform remains stable and efficient even for high-volume publishing operations.
View the changelog for full details: v5.107.1...v5.107.2