Free Flarum hosting on an expert platform by FreeFlarum.com

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.

Up2Vex

Sanguine So what the issue caused by the money extensions? If not could it be readded?

sco85

Hi guys, thanks for this great service, i created a new freeflarum yesterday, but i cant config many extensions like: imgur upload i can only activate it but cant see where to config it ?! and i was surprised that there is nothing about my users on the admin panel !! i installed users directory but the same cant see anything no list no option for that extention on my admin panel; is that because of freeflarum is limited in options as its a free service ?

Sanguine

sco85 Can you ask that elsewhere on this forum? Those questions are not unique to FreeFlarum.

[deleted] are you using any form of partitioning in the MySQL sense

No..

[deleted] if you can share the my.ini or my.conf file

Am running with standard (Ubuntu 18.04 LTS) settings, except for:

[mysqld]
open_files_limit        = 65536
log_warnings            = 3
innodb_buffer_pool_size = 1G

[deleted] Is there a specific time where bottlenecks are evident within the DB

Starting up takes ~ 10 minutes, presumably because of the large (223K rn) number of tables that are initialized.

Otherwise, I have not observed any resource bottlenecks (CPU, I/O, mem)

Thanks for the optimization pointer!

[deleted]

Sanguine We really need to look at optimisation I think. There are a number of benefits to tuning the databases. Are the tables in innodb or myisam ?

GhostSlayer

FreeFlarum is not fast enough. Its good as it works but it has lot of downtimes and pings are usually 1000ms and their website says You won't find better performance. Powered by the fastest machines on the net. which is not true unfortunately

Up2Vex

GhostSlayer Its free what did you expect lol

Sanguine

GhostSlayer I don’t think FreeFlarum has lots of downtime. For the past 2 years, it had an uptime of 99.9% which is better than most commercial hosting services. This week’s unfortunate issue was, luckily, an anomaly.

Regarding ping times: FreeFlarum is hosted in Europe. Indeed, it can have higher latency for people in Asia and Australia. Where are you based?

Sanguine

Up2Vex I don’t think it was caused by the Money extension. However, I am not very eager to try it again right now. Should the service crash, it will cost me half a day to recover, and unfortunately I don’t have that flexibility in my schedule right now. However, I’d like to try it again when the dust has settled and we will have arrived in less hectic times.

« Previous Page Next Page »