Re: MYSQL CRASHING FREQUENTLY
Posted by: Sam Mathews
Date: July 02, 2017 07:11AM

Hi Peter

"When i am not running bulk insert it crashes after 10-12 hours.

Mostly OLTP or OLAP in those periods? Is error log from such crashes significantly different from bulk insert crashes?"

Yes initial Insert of golden gate runs during that time which is similar to insert into ... select * from tablename;

Also from this link

http://www.speedemy.com/17-key-mysql-config-file-settings-mysql-5-7-proof/

POINT 8

I have updated this variable

innodb_thread_concurrency=80. earlier it was 0.


Today when my database crashed, i checked the syslog, which says


Jul 2 12:11:01 localhost kernel: Out of memory: Kill process 95362 (mysqld) score 385 or sacrifice child
Jul 2 12:11:01 localhost kernel: Killed process 95362 (mysqld) total-vm:999223316kB, anon-rss:507787824kB, file-rss:0kB, shmem-rss:0kB
Jul 2 12:11:09 localhost mysqld_safe: /usr/bin/mysqld_safe: line 178: 95362 Killed nohup /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mysqlerr.log --open-files-limit=15000 --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock < /dev/null >> /var/log/mysqlerr.log 2>&1 >> /var/log/mysqlerr.log 2>&1 >> /var/log/mysqlerr.log 2>&1 >> /var/log/mysqlerr.log 2>&1 >> /var/log/mysqlerr.log 2>&1 >> /var/log/mysqlerr.log 2>&1 >> /var/log/mysqlerr.log 2>&1 >> /var/log/mysqlerr.log 2>&1 >> /var/log/mysqlerr.log 2>&1 >> /var/log/mysqlerr.log 2>&1 >> /var/log/mysqlerr.log 2>&1 >> /var/log/mysqlerr.log 2>&1 >> /var/log/mysqlerr.log 2>&1
Jul 2 12:11:10 localhost mysqld_safe: 170702 12:11:10 mysqld_safe Number of processes running now: 0
Jul 2 12:11:10 localhost mysqld_safe: 170702 12:11:10 mysqld_safe mysqld restarted
Jul 2 12:11:11 localhost dbus-daemon: dbus[1471]: [system] Activating service name='org.fedoraproject.Setroubleshootd' (using servicehelper)
Jul 2 12:11:11 localhost dbus[1471]: [system] Activating service name='org.fedoraproject.Setroubleshootd' (using servicehelper)
Jul 2 12:11:17 localhost dbus[1471]: [system] Successfully activated service 'org.fedoraproject.Setroubleshootd'
Jul 2 12:11:17 localhost dbus-daemon: dbus[1471]: [system] Successfully activated service 'org.fedoraproject.Setroubleshootd'
Jul 2 12:11:19 localhost setroubleshoot: failed to retrieve rpm info for /var/log/mysqlerr.log
Jul 2 12:11:20 localhost setroubleshoot: SELinux is preventing mysqld_safe from open access on the file /var/log/mysqlerr.log. For complete SELinux messages. run sealert -l 913eb6c8-5cbf-4959-84fb-af1ce3e37702

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.