from Anmol says
@
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
