View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 1296 | Composr | General / Uncategorised | public | 2013-07-11 23:08 | 2013-07-11 23:08 |
| Reporter | Chris Graham | Assigned To | Chris Graham | ||
| Priority | high | Severity | minor | ||
| Status | resolved | Resolution | fixed | ||
| Product Version | 9.0.7 | ||||
| Summary | 1296: Performance issue viewing forum topics | ||||
| 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. | ||||
| Tags | No tags attached. | ||||
| Attach Tags | |||||
| Attached Files | |||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
|
|
A hotfix (a TAR of files to upload) have been uploaded to this issue. These files are made to the latest intra-version state (i.e. may roll in earlier fixes too if made to the same files) - so only upload files newer than what you have already. Always take backups of files you are replacing or keep a copy of the manual installer for your version, and only apply fixes you need. These hotfixes are not necessarily reliable or well supported. Not sure how to extract TAR files to your Windows computer? Try 7-zip (http://www.7-zip.org/). |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-02-26 18:29 | Chris Graham | Category | General => General / Uncategorised |
