How To Fix YUM Update Errors with Percona GPG Keys

Author: erics, April 16th, 2019

Problem: Trying to run a yum -y update as root aborts with the following error:

The solution, found on the Percona website, is this: sudo yum update percona-release Source URL: https://www.percona.com/blog/2019/02/05/new-percona-package-signing-key-requires-update-on-rhel-and-centos/

Categories: How-To's, Technology Tags: GPG, howto, key, Keys, Percona, percona-release, release, tips, update, Yum, yum update | 1 comment

How To Update the innodb_log_file_size Setting in MySQL

Author: erics, October 29th, 2014

[root@db1 ~]# service mysqld stop [root@db1 ~]# cd /var/lib/mysql [root@db1 mysql]# ls -l ib_logfile? -rw-rw—- 1 mysql mysql 5242880 Oct 29 23:00 ib_logfile0 -rw-rw—- 1 mysql mysql 5242880 Oct 29 22:38 ib_logfile1 [root@db1 mysql]# mv ib_logfile0 ib_logfile0.old [root@db1 mysql]# mv ib_logfile1 ib_logfile1.old [root@db1 ~]# vi /etc/my.cnf innodb_log_file_size=64M # comment out the old value, if one […]

Categories: How-To's, Technology Tags: Change, howto, InnoDB, innodb_log_file_size, my.cnf, mysql, Percona, tips, update | No comments