On Thu, January 4, 2018 11:58 pm, Phil Stracchino wrote: > On 01/04/18 00:52, Voytek wrote:
> I have to say, that location is pretty whacked. I wonder who came up > with that? Who built the MariaDB packages? Phil, and: systemctl status rh-mariadb102-mariadb that's what happens when you blindly follow some instructions without understanding what you doing.... CentOS SCLo Software Collections say, what do you use for backup script ? I've used in the past one from sf.net tried the tuneup, need to wait to have longer time: General recommendations: Control warning line(s) into /var/opt/rh/rh-mariadb102/log/mariadb/mariadb.log file Control error line(s) into /var/opt/rh/rh-mariadb102/log/mariadb/mariadb.log file MySQL started within last 24 hours - recommendations may be inaccurate Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1 Performance should be activated for better diagnostics Consider installing Sys schema from https://github.com/mysql/mysql-sys Read this before changing innodb_log_file_size and/or innodb_log_files_in_group: http://bit.ly/2wgkDvS Variables to adjust: query_cache_size (=0) query_cache_type (=0) query_cache_limit (> 1M, or use smaller result sets) performance_schema = ON enable PFS innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.