JohnWH
-
Posts
6 -
Joined
-
Last visited
Content Type
Downloads
Release Notes
IPS4 Guides
IPS4 Developer Documentation
Invision Community Blog
Development Blog
Deprecation Tracker
Providers Directory
Forums
Events
Store
Gallery
Posts posted by JohnWH
-
-
Was planning on moving from ElasticSearch to OpenSearch in the weekend and wanted to check if anyone had any experience with going with the newest version (2.6.0). Going by the OpenSearch documentation it states they are only introducing breaking changes between major versions, but wanted to see if anyone had any experience with it as it is not always easy to do full testing in a dev environment.
Can see the following at line 98 applications\core\modules\admin\discovery\search.php, and would assume one could just take >= 2.2 and bump it to >= 2.7 (Any other constants/variables/strings/etc that needs to be changed?)
if ( version_compare( $response['version']['number'], '2.2', '>=' ) ) { throw new \DomainException( \IPS\Member::loggedIn()->language()->addToStack('search_opensearch_server_unsupported_version', FALSE, array( 'sprintf' => array( $response['version']['number'] ) ) ) ); }
Cheers
-
Hi Marc, thank you for getting so quickly back to us. Much appreciated
Unfortunately it would be a challenge sorting off-premises sftp. Would it be possible to either here or via DM get some details regarding what needs to be done in plain text? Have access to the file system myself and would most likely be capable to solve it by just getting an indication on where the problem lies.
Just as some quick notes: No settings have been altered, nor any plugins been installed or similar. The only change was manually uploading and extracting the 4.6.12.1 delta zip file the upgrade tool generated before running the upgrade
Cheers,
-
14 minutes ago, Marc Stridgen said:
We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section.
We look forward to further assisting you.
Hi Marc,
Have updated the credentials on file. Due to technical limitations I could not include ftp
Cheers
-
Hi,
We upgraded to 4.6.12.1 a couple of days ago and have been receiving reports from members that the "Unread Content" activity stream has changed behavior from only showing every updated thread once regardless of how many new comments there were, to showing one entry in the feed for every new comment, making the stream harder to keep track on due to the amount of entries on some busier threads.
Is this related to what's being described in here and now considered intended, or some thing else?
Have tried to reindex everything (using elasticsearch if that matters) and also reset the feeds in the admin panel, but that did not change it
Any tips/comments to change it back would be greatly appreciated 🙂
Database optimization suggestions wanted
in Classic self-hosted technical help
Posted
Hi,
Let me preface by saying I realize this is outside the scope of normal support (hence posting in this forum) and any pointers/suggestions would be in "at your own risk" territory. Am also aware that any file and/or DB suggested changes can cause issues and a more careful/time consuming approach in terms of future upgrades, but that is more than acceptable if it means a faster/better experience for our users.
To make a long story short (as I'm sure overall this post will be anything but) we're having performance related issues that mostly stem from having 15k+ forums and was hoping someone would have any pointers, specifically when it comes to improving query execution time and PHP processing time.
The vast majority of the forums are subforums under multiple sections of three categories to help organize and also reduce DOM size/prevent them being listed on the forum index, like so:
The forums run across three dedicated servers:
- Webserver (nginx + php8.1-fpm)
- Elasticsearch + Redis (enabled on all forum settings supporting them)
- Database server (MariaDB 10.6)
As for the forum software, other than a custom theme having a handful of template changes in terms of HTML/JS/CSS, the only modification is one custom plugin having an insignificant server load cost.
What seems to be struggling the most is the DB. When looking at the process list there is one query that is slow enough to consistently show up. Am planning to enabling the slow query log with all filters and full verbosity to get a better overview of the rest.
Current MySQLTuner Info (once initial changes have been done the server will be restarted to give some more sane 24-48 hour values to go by)
join_buffer_size and tmp_table_size/max_heap_table_size related
Current MariaDB config
Questions:
ALTER TABLE `core_permission_index` CHANGE `perm_view` `perm_view` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `core_permission_index` ADD INDEX(`app`, `perm_type`, `perm_type_id`, `perm_view`);
Any comments or suggestions would be greatly appreciated!