New answers tagged

0

Analysis of GLOBAL STATUS and VARIABLES: Observations: Version: 5.6.46-log 512 GB of RAM Uptime = 03:30:58; Please rerun SHOW GLOBAL STATUS after several hours. 1930 QPS The More Important Issues: If "transparent huge pages" is turned on in the OS, see if turning it off will prevent the OOMs. (There is some chatter about this as a problem.) ...


0

In my case it was SELinux. I figured this out by getting "denied" in the output: grep -ar mysqld /var/log/audit/* | grep denied Next, I disabled SELinux according to this article: https://linuxize.com/post/how-to-disable-selinux-on-centos-8/ and mysql started without problems (in my case it was a test VM, not sure if this is the right solution for ...


0

Be sure that innodb_buffer_pool_size is about 70% of available RAM. This is the most important setting. It controls the amount of RAM being used for caching, hence it helps speed up most queries. Leave innodb_log_buffer_size at the default given by the install. This setting is much less important. It has to do with writing redo log entries to disk. (Cf &...


Top 50 recent answers are included