11 months ago •
4 people like this
Anmol Sharma and Roma like this.
Rokosun reshared this.
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'
innodb_buffer_pool_size = 20G innodb_log_buffer_size = 256M innodb_log_file_size = 1G innodb_write_io_threads = 16
Roma likes this.
Tio likes this.
Anmol Sharma
in reply to Tio • • •Tio
in reply to Anmol Sharma • •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]:
You can also add to the same file under mariadb and mysql:
Roma likes this.
Anmol Sharma
in reply to Tio • • •Tio likes this.