On 7/11/2026 at 10:50 PM, RevengeFNF said:

Is there a big diference in performance between Mysql and MariaDB for IOS?

IPS only supports only Mysql 8, or also the last version 9.7?

MySQL 8 only for the time being, as some versions of 9 remove items that are required for the software to function correctly

In terms of performance, we optimise for mySQL. We're not able to say specifically whether or not you will get better performance from MariaDB as thats not what we use here, however it has to be said that I have seen people who have had problems, and resolved them by switching to mySQL in the past.

21 hours ago, RevengeFNF said:

I'am now using Opensearch 3.7 for activity streams and search.

My users started to complain that now the activity streams have a delay. There are new posts that take some time to appear on the stream, while with mysql it was basically real time.

I found this in the tasks:

It's possible we can change this to every minute? It would not be real time, but it would at least minimize the issue.

The problem with having it running every minute is that you lose the optimisation of bulk inserts, and revert back to a constant stream of single inserts and from Invision Community's side, it means that it may delay other tasks from running if it dominates the schedule.

However, there is a constant for those that do want instant updates, just add this to constants.php (but I do recommend against it).

define( 'ELASTICSEARCH_QUEUE_INDEX', false );

On 7/11/2026 at 11:50 PM, RevengeFNF said:

Is there a big diference in performance between Mysql and MariaDB for IOS?

IPS only supports only Mysql 8, or also the last version 9.7?

I've tested both, and in my experience MariaDB is noticeably faster. Even though Invision Community doesn't specifically optimize for MariaDB, it still performs better than MySQL on my forum.

1 hour ago, DracoBlue said:

I've tested both, and in my experience MariaDB is noticeably faster. Even though Invision Community doesn't specifically optimize for MariaDB, it still performs better than MySQL on my forum.

Yes, my experience is same not that much but slightly faster....

6 hours ago, Matt said:

The problem with having it running every minute is that you lose the optimisation of bulk inserts, and revert back to a constant stream of single inserts and from Invision Community's side, it means that it may delay other tasks from running if it dominates the schedule.

However, there is a constant for those that do want instant updates, just add this to constants.php (but I do recommend against it).

define( 'ELASTICSEARCH_QUEUE_INDEX', false );

Thank you.

I guess i will do some tests and check the performance and if there are tasks that get stuck because of it.