Skip to main content

Since the latest changes and optimizations I did some 2-3 weeks ago for Friendica, our instance became so fast it is unbelievable. Go from one page to another in less than 1-2 seconds, at times it feels instant. Amazing! #tromstuff

Rokosun reshared this.

in reply to Anmol Sharma

Well first of all I am using a daemon and not cron jobs via this tutorial

Then In /etc/mysql/mariadb.conf.d/50-server.cnf and add Under [mariadb]:

\#enable the old query optimizer setting
optimizer_use_condition_selectivity = 1
optimizer_switch = 'rowid_filter=off'

You can also add to the same file under mariadb and mysql:
innodb_buffer_pool_size = 20G
innodb_log_buffer_size = 256M
innodb_log_file_size = 1G
innodb_write_io_threads = 16
in reply to Tio

Amazing, thank you for the valuable information.