Free Flarum hosting on an expert platform by FreeFlarum.com

Silverteal

hmmm... 502 bad gateway nginx

Up2Vex

Silverteal Hes clearing stuff atm, eta 30-40mins

Silverteal

Up2Vex I see

Up2Vex

Sanguine All my tags are gone?

Silverteal

up and down

Silverteal

“Rejected our connection request”

Up2Vex

Silverteal yeah we all the same issue bro

Sanguine

Have removed a number of forums, but MariaDB keeps crashing, unfortunately without any relevant logging.
Am still trying some things. Otherwise, it will be Plan C: boot a new server and load backups from there. But that will take 12+ hours, and may reset your forums to last night. Hopefully it won't be necessary.

Up2Vex

Sanguine Have removed a number of forums, but MariaDB keeps crashing, unfortunately without any relevant logging.
Am still trying some things. Otherwise, it will be Plan C: boot a new server and load backups from there. But that will take 12+ hours, and may reset your forums to last night. Hopefully it won't be necessary.

was there an update to the MariaDB?

Sanguine

Up2Vex No, last MariaDB upgrade was in Feb

Silverteal

hmmm... Maybe somebody want to download their database. but https://www.freeflarum.com/settings didn't work either (I downloaded it an hours ago)

[deleted]

@Sanguine I'm an IT infrastructure consultant by trade. Let me know if I can be of any assistance here. You're providing an amazing service, and I'd like to help as much as I can (no charge of course).

Sanguine

Up2Vex No, I have purged 700 unused forums, and MariaDB appears stable again. I suspect that it doesn't like that many small databases.

[deleted] Thanks! Would you have any suggestions on how to optimize MariaDB for many (5k) small databases? I have just increased log level from 1 to 3, which would hopefully produce relevant information, should another crash happen. For now, I am in the dark on what triggered these crashes. The server has 8G ram, of which 2GB is free during normal operation. In order to accommodate many open tables, I have - for a long time - been running MariaDB's open_files_limit setting at 64K.

I am also available via DM at https://telegram.me/gwillem

Thanks!

Up2Vex

@Sanguine Seems to be working now

Up2Vex

@Sanguine Thanks for fixing it! Did you manage to figure out what happened? xd

meetdilip

If it is the final fix, thanks. Appreciate your hard work.

Silverteal

Now it's working. (How to use money extension

jordanjay29

Silverteal How to use money extension

You should read or ask this on the extension discussion instead.

Silverteal

jordanjay29 🙂

Up2Vex

@Sanguine seems to have crashed again 🙁

Sanguine

Up2Vex No, I am restarting MariaDB to increase log level, see previous post. It should be running again.

[deleted]

Sanguine Would you have any suggestions on how to optimize MariaDB for many (5k) small databases?

Potentially - are you using any form of partitioning in the MySQL sense ? Also, contact me on Discord - if you can share the my.ini or my.conf file, this would help.

Is there a specific time where bottlenecks are evident within the DB ? You've probably looked at these already, but http://linuxpitstop.com/tips-to-improve-mariadb-performance/ has some good tips.

« Previous Page Next Page »