The issue
is it better MyISAM or InnoDB for a big community? I'm on InnoDB at the moment and sometimes MySQL just freezes.
Flarum information
Flarum core 1.6.3
PHP version: 8.2.3
MySQL version: 8.0.32-0ubuntu0.22.04.2
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, pcntl, random, Reflection, SPL, session, standard, sodium, mysqlnd, PDO, calendar, ctype, curl, exif, FFI, fileinfo, ftp, gettext, iconv, mysqli, pdo_mysql, Phar, posix, readline, shmop, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, Zend OPcache
+----------------------------------------+---------+--------+
| Flarum Extensions | | |
+----------------------------------------+---------+--------+
| ID | Version | Commit |
+----------------------------------------+---------+--------+
| flarum-flags | v1.6.1 | |
| flarum-approval | v1.6.1 | |
| flarum-subscriptions | v1.6.3 | |
| flarum-tags | v1.6.1 | |
| afrux-forum-widgets-core | v0.1.7 | |
| fof-follow-tags | 1.1.7 | |
| flarum-suspend | v1.6.1 | |
| fof-oauth | 1.3.0 | |
| v17development-seo | v1.8.0 | |
| sycho-profile-cover | v1.3.3 | |
| nearata-lang-italian | v1.1.0 | |
| migratetoflarum-canonical | 1.0.0 | |
| justoverclock-welcomebox | 1.3.8 | |
| justoverclock-custom-html-widget | 0.1.4 | |
| ianm-html-head | 1.1.0 | |
| ianm-follow-users | 1.2.0 | |
| fof-user-bio | 1.1.1 | |
| fof-sitemap | 2.0.1 | |
| fof-share-social | 1.1.2 | |
| fof-recaptcha | 1.1.0 | |
| fof-nightmode | 1.5.1 | |
| fof-moderator-notes | 1.1.0 | |
| fof-ignore-users | 1.1.0 | |
| fof-gamification | 1.6.2 | |
| fof-formatting | 1.0.2 | |
| fof-cookie-consent | 1.1.1 | |
| fof-best-answer | 1.2.4 | |
| fof-analytics | 1.1.0 | |
| flarum-sticky | v1.6.1 | |
| flarum-statistics | v1.6.1 | |
| flarum-nicknames | v1.6.1 | |
| flarum-mentions | v1.6.3 | |
| flarum-markdown | v1.6.1 | |
| flarum-lock | v1.6.1 | |
| flarum-emoji | v1.6.1 | |
| flarum-bbcode | v1.6.0 | |
| davwheat-ads | 1.2.0 | |
| clarkwinkelmann-no-email-notifications | 1.0.0 | |
| clarkwinkelmann-first-post-approval | 1.0.1 | |
+----------------------------------------+---------+--------+
Queue driver: sync
Session driver: file
Mail driver: smtp
Debug mode: off