Anmol Sharma

Tio

Sun, 22 Oct 2023 07:51:10 +0530 from friendica

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

Anmol Sharma

Mon, 23 Oct 2023 03:09:49 +0530 from Anmol says

What did you do?

Tio

Mon, 23 Oct 2023 03:58:11 +0530 from friendica

@Anmol Sharma (anmol@anmol.net.in) Well first of all I am using a daemon and not cron jobs via this tutorial nequalsonelifestyle.com/2022/0…

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

Anmol Sharma

Mon, 23 Oct 2023 19:35:59 +0530 from Anmol says

Amazing, thank you for the valuable information.