in reply to Anmol Sharma

friendica (DFRN) - Link to source

Tio

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
⇧