Hey y'all!
my Flarum has a problem lately. Sometimes, I can't visit my website, and when I check around, I see that there is mysqld process and usage is over %300.
After that mysql stops working, also, my server dashboard says "Bind DNS Service" is stopped.
I checked the log files, and see that log files sizes are huge like 2gb. Log files have something like SQLSTATE[HY000] [2002]
.
And my server support said that, there are endless mysql query caused this mysql problem. please see below SS.
https://prnt.sc/Gdwk8jc_l-BJ
Can anyone help me about this? What is causing this problem?
Flarum core 1.2.0
PHP version: 7.4.27
MySQL version: 5.5.5-10.1.41-MariaDB
Loaded extensions: Core, date, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, gd, gettext, gmp, SPL, iconv, session, intl, json, mbstring, standard, mysqlnd, pcntl, mysqli, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, Reflection, imap, SimpleXML, soap, sockets, exif, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, imagick, mongodb, sodium
+---------------------------------+---------+--------+
| Flarum Extensions | | |
+---------------------------------+---------+--------+
| ID | Version | Commit |
+---------------------------------+---------+--------+
| afrux-forum-widgets-core | v0.1.6 | |
| flarum-tags | v1.2.0 | |
| flarum-suspend | v1.2.0 | |
| flarum-flags | v1.2.0 | |
| fof-oauth | 1.2.0 | |
| v17development-seo | v1.8.0 | |
| tpokorra-post-notification | 0.4.6 | |
| the-turk-flamoji | 1.0.2 | |
| sycho-profile-cover | v1.3.1 | |
| michaelbelgium-discussion-views | v7.1.2 | |
| malago-ads | 0.3.2 | |
| justoverclock-welcomebox | 1.3.5 | |
| justoverclock-hashtag | 0.2.1 | |
| justoverclock-feedback | 0.1.9 | |
| ianm-synopsis | 1.2.0 | |
| fof-user-directory | 1.2.2 | |
| fof-user-bio | 1.0.2 | |
| fof-upload | 1.1.0 | |
| fof-terms | 1.1.2 | |
| fof-split | 1.0.1 | |
| fof-spamblock | 1.0.2 | |
| fof-socialprofile | 1.1.1 | |
| fof-sitemap | 1.0.3 | |
| fof-share-social | 1.0.1 | |
| fof-sentry | 1.0.1 | |
| fof-recaptcha | 1.0.0 | |
| fof-reactions | 1.0.4 | |
| fof-pages | 1.0.1 | |
| fof-nightmode | 1.2.0 | |
| fof-merge-discussions | 1.2.1 | |
| fof-links | 1.0.3 | |
| fof-linguist | 1.0.3 | |
| fof-ignore-users | 1.0.2 | |
| fof-gamification | 1.3.3 | |
| fof-formatting | 1.0.2 | |
| fof-disposable-emails | 1.0.0 | |
| fof-discussion-thumbnail | 1.0.1 | |
| flarum-subscriptions | v1.2.0 | |
| flarum-sticky | v1.2.0 | |
| flarum-pusher | v1.2.0 | |
| flarum-mentions | v1.2.0 | |
| flarum-markdown | v1.2.0 | |
| flarum-lock | v1.2.0 | |
| flarum-likes | v1.2.0 | |
| flarum-lang-turkish | 1.2.0.0 | |
| flarum-lang-english | v1.2.0 | |
| flarum-emoji | v1.2.0 | |
| flarum-approval | v1.2.0 | |
| extiverse-mercury | 0.1.3 | |
| clarkwinkelmann-circle-groups | 1.0.0 | |
| afrux-top-posters-widget | v0.1.3 | |
| afrux-forum-stats-widget | v0.1.0 | |
+---------------------------------+---------+--------+
Queue driver: redis
Mail driver: smtp
Debug mode: off