mysql %CPU 97%

meihuak

I have about 7000-8000 visitors per day, but sometimes my flarum is too slow.

is there a method to solve this issue?

mafesa

You can try Cloudflare or something similar to filter requests, there have been a lot of new bots scanning sites for about a month now.

meihuak

mafesa I use CF already , also we set controls for AI bots

KBExit

I see you're on 2 Cores 4 GB Ram.
Do you have CloudFlare? Are you using DB Ques?

meihuak

KBExit hey bro, I have CF, what is DB Ques?

KBExit

meihuak it's a que system. It looks like your database is using a lot of CPU, I'm wondering if it's because you're using Database Ques? I have no idea why your CPU is so high on the database if you're not using that extension.

On your dashboard, what does it say as far as cache and sessions?
For example, Redis works best for large communities since files and sessions take a long time to process. I configure redis from the start before my Flarum goes to the outside world so I don't know what the normal heavy usage is.

Here is Redis: https://discuss.flarum.org/d/37228-friendsofflarum-redis-sessions-cache-queues
Here is DB Qeues: https://discuss.flarum.org/d/28151-database-queue-the-simplest-queue-even-for-shared-hosting

But I don't know if these will solve your issues...

Do you have anything else connected to your databases that may be consuming all those resources?

meihuak

KBExit hey bro, we did not use these 2 extensions

so like you say, Redis is very important for Flarum?

KBExit

meihuak if your forum has a lot of people actively using the forum at the same time, yes. You're going to reduce the demand greatly or reduce delays on all processes.
Recommend getting Redis + Supervisor set up. If you run the Database Que with Cron, all tasks are delayed to 60 seconds. But will still free up a lot of the burden on your server in the meantime still.

GreXXL

I recommend you share your php flarum info output for the beginning so we can find out what your issues are. In general Flarum scales really good and it should not be an issue at all.