#1296 - Performance issue viewing forum topics
-
By Chris Graham
- Added
- 1 view
| Identifier | #1296 |
|---|---|
| Issue type | Minor issue (breaks specific functionality) |
| Title | Performance issue viewing forum topics |
| Status | Completed |
| Handling member | Chris Graham |
| Version | 9.0.7 |
| Addon | General / Uncategorised |
| Description | Composr now does a "delayed insert" when logging "members viewing this topic", allowing MySQL to log it in it's own time rather than immediately. It also tries to avoid doing non-essential tasks on log tables when something is locking them, after waiting a bit in case the lock goes away. Both of these are actually big recent performance optimisations designed to avoid a server getting overrun with queued locked requests. However, it so happens that MySQL records a special kind of lock for delayed inserts, and shared servers may be slow in them going through due to MySQL contention, so that had the unintended affect of sometimes making topic viewing actually slower while it tries to wait for the delayed logging from previous requests to go through (those two optimisations weren't expected to interact like that) - something we didn't notice in development, but has been seen now on a couple of shared servers. |
| Steps to reproduce | |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments