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.
Free Flarum hosting on an expert platform by FreeFlarum.com
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?
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).
- Edited
If it is the final fix, thanks. Appreciate your hard work.
Now it's working. (How to use money extension
Silverteal How to use money extension
You should read or ask this on the extension discussion instead.
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!
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 ?
[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.
- Edited
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 ?
- Edited
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
GhostSlayer Its free what did you expect lol