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.
