Shulou(Shulou.com)06/01 Report--

A set of MySQL 5.6 slave libraries on line, database restart due to OOM.

# tail -50 /var/log/messagesNov 13 16:00:40 app-push-db2 kernel: Out of memory: Kill process 26121 (mysqld) score 957 or sacrifice childNov 13 16:00:40 app-push-db2 kernel: Killed process 26121 (mysqld) total-vm:18804176kB, anon-rss:15541596kB, file-rss:0kB, shmem-rss:0kB

Reasons for error:

The server where this instance is located has a single instance of MySQL deployed. The physical memory is 16 GB, and the cache innodb_fuffer_pool_size allocated to the database is 12 GB.

# free -g total used free shared buff/cache availableMem: 15 10 0 0 5 4Swap: 0 0 0

To improve performance, this instance has disk swap turned off.

# cat /etc/rc.local#!/ bin/bash# THIS FILE IS ADDED FOR COMPATIBILITY PURPOSES## It is highly advisable to create own systemd services or udev rules# to run scripts during boot instead of using this file.## In contrast to previous versions due to parallel execution during boot# this script will NOT be run after all other services.## Please note that you must run 'chmod +x /etc/rc.d/rc.local' to ensure# that this script will be executed during boot.touch /var/lock/subsys/localswapoff -a

When there are too many client connections, memory resources are exhausted.

Solution:

Adjust innodb_buffer_pool_size to 10 gigabytes to reserve some memory for the operating system and client connections.

Restart the database to validate the parameters.

# grep innodb_buffer_pool /etc/my.cnfinnodb_buffer_pool_size=10G

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.