Debian Linux 서버에 이상한 상황이 발생했습니다.
우리의 문제/문제/질문:
일부 방문자가 웹사이트에 전화하는 경우 - Apache는 방문자의 요청을 수신하고 약 1-20초 동안(첫 번째 요청의 경우) 머물렀다가 다른 (무작위) 객체(이미지, 자바 스크립트, html, php 및 기타 로드된 항목)를 처리할 수도 있습니다. 개체) 파일) 동일한 세션 동안 동일한 웹사이트에 대한 정적 및 동적 콘텐츠. 데이터베이스 요청으로 정적 그림/이미지를 호출하는지 아니면 동적 PHP 파일을 호출하는지 여부는 중요하지 않습니다.
PM2(소켓 node.js)에서도 마찬가지입니다. Apache와 마찬가지로 때때로 서버-클라이언트 메시지 사이에 갇히게 됩니다.
그 결과, 2주 전 1.2초도 안 걸렸던 웹사이트 로딩 시간이 1분 이상 걸렸습니다.
로그에 오류가 없습니다...
클라이언트가 TTFB를 "대기"하기 전에 내 서버의 Apache 웹 서버는 무엇을 하고 있나요?
서버에 대한 일부 정보:
소프트웨어 RAID1의 2개 HDD SATA /dev/sda 및 /dev/sdb. (RAID1 테스트, HDD 테스트 모두 양호, HDD 모두 OK)
애플리케이션을 실행하는 서버: Apache2, nginx(정적 콘텐츠의 역방향 프록시), 로컬 MySQL(MyISAM + InnoDB), 로컬 MongoDB 및 PM2(socket node.js). 네트워크 라우팅, 네트워크 카드, DNS는 100% 정상입니다. 매일 약 10,000명의 방문객이 방문하고 있습니다.
Apache의 strace를 시도했지만 데이터가 너무 많아서(약 5초에 1Gb 이상) 다른 스레드 중에서 시스템 호출에 대한 스레드를 찾을 수 없습니다.
Linux host 3.2.0-4-amd64 #1 SMP Debian 3.2.60-1+deb7u3 x86_64 GNU/Linux
PHP는 Apache 모듈로 실행됩니다.
RAID1 상태:
# cat /proc/mdstat
Personalities : [raid1]
md2 : active raid1 sda3[2] sdb3[1]
1936077760 blocks super 1.2 [2/2] [UU]
md1 : active raid1 sda2[2] sdb2[1]
523968 blocks super 1.2 [2/2] [UU]
md0 : active raid1 sda1[2] sdb1[1]
16768896 blocks super 1.2 [2/2] [UU]
unused devices: <none>
하드 드라이브 상태:
# smartctl -H /dev/sdb
smartctl 5.41 2011-06-09 r3365 [x86_64-linux-3.2.0-4-amd64] (local build)
Copyright (C) 2002-11 by Bruce Allen, http://smartmontools.sourceforge.net
=== START OF READ SMART DATA SECTION ===
SMART overall-health self-assessment test result: PASSED
# smartctl -H /dev/sda
smartctl 5.41 2011-06-09 r3365 [x86_64-linux-3.2.0-4-amd64] (local build)
Copyright (C) 2002-11 by Bruce Allen, http://smartmontools.sourceforge.net
=== START OF READ SMART DATA SECTION ===
SMART overall-health self-assessment test result: PASSED
두 데이터베이스 시스템(Mongo 및 MySQL)에 대한 로깅은 구성에서 비활성화되어 있지만 EXT4 파일 시스템에서는 작동합니다.
다음은 가장 높은 IO로 실행되는 프로세스에 대한 일부 데이터입니다.
15:13:51 15313 be/4 mongodb 0.00 K/s 39.51 K/s 0.00 % 0.02 % mongod_config --config /etc/mongod_config.conf
15:13:51 27418 be/4 root 0.00 K/s 11.85 K/s 0.00 % 0.00 % rsyslogd -c5
15:13:53 339 be/3 root 0.00 K/s 382.84 K/s 0.00 % 10.95 % [jbd2/md2-8]
15:13:55 25191 be/4 nginx 27.46 K/s 0.00 K/s 0.00 % 0.90 % nginx: worker process
15:13:55 27418 be/4 root 0.00 K/s 15.69 K/s 0.00 % 0.00 % rsyslogd -c5
15:13:55 27801 be/4 mongodb 0.00 K/s 23.54 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:13:56 339 be/3 root 0.00 K/s 165.80 K/s 0.00 % 13.04 % [jbd2/md2-8]
15:13:56 27418 be/4 root 0.00 K/s 11.84 K/s 0.00 % 0.00 % rsyslogd -c5
15:14:01 339 be/3 root 0.00 K/s 391.00 K/s 0.00 % 7.43 % [jbd2/md2-8]
15:14:01 27418 be/4 root 0.00 K/s 19.75 K/s 0.00 % 0.00 % rsyslogd -c5
15:14:02 339 be/3 root 0.00 K/s 228.93 K/s 0.00 % 14.90 % [jbd2/md2-8]
15:14:02 15059 be/4 mysql 0.00 K/s 15.79 K/s 0.00 % 0.04 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:02 27627 be/4 mongodb 0.00 K/s 19.74 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:14:03 27418 be/4 root 0.00 K/s 11.84 K/s 0.00 % 0.00 % rsyslogd -c5
15:14:03 27587 be/4 www-data 0.00 K/s 702.42 K/s 0.00 % 0.00 % apache2 -k start
15:14:03 27589 be/4 mongodb 0.00 K/s 966.81 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:14:05 14959 be/4 mysql 0.00 K/s 236.84 K/s 0.00 % 0.09 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:06 339 be/3 root 0.00 K/s 197.61 K/s 0.00 % 46.68 % [jbd2/md2-8]
15:14:06 14959 be/4 mysql 0.00 K/s 529.58 K/s 0.00 % 0.39 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:06 27418 be/4 root 0.00 K/s 11.86 K/s 0.00 % 0.00 % rsyslogd -c5
15:14:07 339 be/3 root 0.00 K/s 138.08 K/s 0.00 % 12.15 % [jbd2/md2-8]
15:14:07 18365 be/4 mysql 0.00 K/s 11.84 K/s 0.00 % 0.04 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:10 25191 be/4 nginx 15.79 K/s 0.00 K/s 0.00 % 2.99 % nginx: worker process
15:14:11 25192 be/4 nginx 39.48 K/s 3.95 K/s 0.00 % 2.77 % nginx: worker process
15:14:11 25199 be/4 nginx 19.74 K/s 0.00 K/s 0.00 % 0.69 % nginx: worker process
15:14:11 25194 be/4 nginx 23.69 K/s 3.95 K/s 0.00 % 0.01 % nginx: worker process
15:14:12 339 be/3 root 0.00 K/s 464.09 K/s 0.00 % 6.12 % [jbd2/md2-8]
15:14:14 27418 be/4 root 0.00 K/s 11.84 K/s 0.00 % 0.00 % rsyslogd -c5
15:14:14 27605 be/4 mongodb 0.00 K/s 23.69 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:14:16 339 be/3 root 0.00 K/s 244.83 K/s 0.00 % 38.10 % [jbd2/md2-8]
15:14:16 14959 be/4 mysql 0.00 K/s 418.59 K/s 0.00 % 0.32 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:16 27342 be/4 mongodb 0.00 K/s 15.80 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:14:18 27418 be/4 root 0.00 K/s 15.80 K/s 0.00 % 0.00 % rsyslogd -c5
15:14:20 27398 be/4 mongodb 0.00 K/s 27.10 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:14:21 339 be/3 root 0.00 K/s 402.19 K/s 0.00 % 9.45 % [jbd2/md2-8]
15:14:21 27328 be/4 www-data 0.00 K/s 11.83 K/s 0.00 % 0.00 % apache2 -k start
15:14:22 25192 be/4 nginx 23.72 K/s 0.00 K/s 0.00 % 0.41 % nginx: worker process
15:14:22 27595 be/4 www-data 0.00 K/s 11.86 K/s 0.00 % 0.00 % apache2 -k start
15:14:23 339 be/3 root 0.00 K/s 307.91 K/s 0.00 % 10.74 % [jbd2/md2-8]
15:14:23 27549 be/4 mongodb 0.00 K/s 15.79 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:14:25 339 be/3 root 0.00 K/s 247.60 K/s 0.00 % 9.74 % [jbd2/md2-8]
15:14:25 27388 be/4 mongodb 0.00 K/s 27.51 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:14:26 339 be/3 root 0.00 K/s 90.01 K/s 0.00 % 33.82 % [jbd2/md2-8]
15:14:26 25195 be/4 nginx 15.65 K/s 0.00 K/s 0.00 % 1.71 % nginx: worker process
15:14:26 14959 be/4 mysql 0.00 K/s 508.77 K/s 0.00 % 0.34 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:27 25195 be/4 nginx 0.00 K/s 11.62 K/s 0.00 % 0.00 % nginx: worker process
15:14:30 15313 be/4 mongodb 0.00 K/s 35.57 K/s 0.00 % 0.04 % mongod_config --config /etc/mongod_config.conf
15:14:31 339 be/3 root 0.00 K/s 351.53 K/s 0.00 % 4.41 % [jbd2/md2-8]
15:14:33 339 be/3 root 0.00 K/s 43.37 K/s 0.00 % 7.53 % [jbd2/md2-8]
15:14:33 15059 be/4 mysql 0.00 K/s 11.83 K/s 0.00 % 0.04 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:33 27794 be/4 mongodb 0.00 K/s 15.77 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:14:33 27835 be/4 mongodb 0.00 K/s 11.83 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:14:34 339 be/3 root 0.00 K/s 106.56 K/s 0.00 % 12.32 % [jbd2/md2-8]
15:14:34 14977 be/4 mysql 0.00 K/s 11.84 K/s 0.00 % 0.06 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:34 27418 be/4 root 0.00 K/s 15.79 K/s 0.00 % 0.00 % rsyslogd -c5
15:14:37 339 be/3 root 0.00 K/s 242.20 K/s 0.00 % 8.01 % [jbd2/md2-8]
15:14:37 25195 be/4 nginx 11.72 K/s 0.00 K/s 0.00 % 1.01 % nginx: worker process
15:14:37 14977 be/4 mysql 0.00 K/s 11.72 K/s 0.00 % 0.04 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:37 27634 be/4 www-data 0.00 K/s 15.63 K/s 0.00 % 0.00 % apache2 -k start
15:14:37 27636 be/4 mongodb 0.00 K/s 19.53 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:14:37 27842 be/4 www-data 0.00 K/s 11.72 K/s 0.00 % 0.00 % apache2 -k start
15:14:39 27418 be/4 root 0.00 K/s 11.77 K/s 0.00 % 0.00 % rsyslogd -c5
15:14:39 27849 be/4 mongodb 0.00 K/s 31.39 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:14:41 27801 be/4 mongodb 118.35 K/s 43.39 K/s 0.00 % 1.34 % mongod --config /etc/mongod.conf
15:14:41 22209 be/4 mysql 0.00 K/s 11.83 K/s 0.00 % 0.00 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:44 339 be/3 root 0.00 K/s 541.22 K/s 0.00 % 51.74 % [jbd2/md2-8]
15:14:44 14959 be/4 mysql 0.00 K/s 1335.27 K/s 0.00 % 0.85 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:44 18604 be/4 mysql 0.00 K/s 11.85 K/s 0.00 % 0.16 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:45 25195 be/4 nginx 23.68 K/s 0.00 K/s 0.00 % 0.90 % nginx: worker process
15:14:46 339 be/3 root 0.00 K/s 327.37 K/s 0.00 % 9.90 % [jbd2/md2-8]
15:14:46 18362 be/4 mysql 0.00 K/s 11.83 K/s 0.00 % 0.05 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:46 27800 be/4 mongodb 0.00 K/s 11.83 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
15:14:47 339 be/3 root 0.00 K/s 46.87 K/s 0.00 % 7.34 % [jbd2/md2-8]
15:14:47 18504 be/4 mysql 0.00 K/s 15.62 K/s 0.00 % 0.06 % mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
15:14:50 27867 be/4 mongodb 0.00 K/s 23.64 K/s 0.00 % 0.00 % mongod --config /etc/mongod.conf
Apache 구성에서:
<IfModule mpm_prefork_module>
StartServers 7
MinSpareServers 7
MaxSpareServers 15
ServerLimit 1024
MaxClients 1024
MaxRequestsPerChild 10000
</IfModule>
업데이트 1 (추가 정보)
# iostat
Linux 3.2.0-4-amd64 (host) 08/19/2018 _x86_64_ (8 CPU)
avg-cpu: %user %nice %system %iowait %steal %idle
8.86 0.00 3.80 1.02 0.00 86.32
Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
sdb 96.78 3093.98 498.35 2022098528 325699718
sda 96.09 3085.66 498.35 2016660127 325699718
md0 0.01 0.01 0.02 4002 10552
md1 0.05 0.02 0.05 13068 32539
md2 88.37 252.24 496.79 164852095 324679412
# cat /etc/fstab
proc /proc proc defaults 0 0
/dev/md/0 none swap sw 0 0
/dev/md/1 /boot ext3 defaults 0 0
/dev/md/2 / ext4 defaults 0 0
업데이트 2 (추가 정보)
# dmesg -T
.....
.....
[Sun Aug 19 17:03:28 2018] type=1300 audit(1534691393.580:36049): arch=c000003e syscall=54 success=yes exit=0 a0=3 a1=0 a2=40 a3=17344e0 items=0 ppid=16922 pid=16923 auid=4294967295 uid=0 gid=0 euid=0 suid=0 fsuid=0 egid=0 sgid=0 fsgid=0 tty=(none) ses=4294967295 comm="iptables" exe="/sbin/xtables-multi" key=(null)
[Sun Aug 19 17:04:14 2018] type=1325 audit(1534691439.884:36050): table=filter family=2 entries=85
[Sun Aug 19 17:04:14 2018] type=1300 audit(1534691439.884:36050): arch=c000003e syscall=54 success=yes exit=0 a0=3 a1=0 a2=40 a3=1b12660 items=0 ppid=16956 pid=16957 auid=4294967295 uid=0 gid=0 euid=0 suid=0 fsuid=0 egid=0 sgid=0 fsgid=0 tty=(none) ses=4294967295 comm="iptables" exe="/sbin/xtables-multi" key=(null)
[Sun Aug 19 17:05:02 2018] type=1325 audit(1534691487.740:36051): table=filter family=2 entries=86
[Sun Aug 19 17:05:02 2018] type=1300 audit(1534691487.740:36051): arch=c000003e syscall=54 success=yes exit=0 a0=3 a1=0 a2=40 a3=1f417d0 items=0 ppid=16993 pid=16994 auid=4294967295 uid=0 gid=0 euid=0 suid=0 fsuid=0 egid=0 sgid=0 fsgid=0 tty=(none) ses=4294967295 comm="iptables" exe="/sbin/xtables-multi" key=(null)
[Sun Aug 19 17:09:19 2018] CPU7: Core power limit notification (total events = 11377)
[Sun Aug 19 17:09:19 2018] CPU1: Core power limit notification (total events = 11377)
[Sun Aug 19 17:09:19 2018] CPU4: Core power limit notification (total events = 11377)
[Sun Aug 19 17:09:19 2018] CPU3: Core power limit notification (total events = 11377)
[Sun Aug 19 17:09:19 2018] CPU5: Core power limit notification (total events = 11377)
[Sun Aug 19 17:09:19 2018] CPU0: Core power limit notification (total events = 11377)
[Sun Aug 19 17:09:19 2018] CPU2: Core power limit notification (total events = 11377)
[Sun Aug 19 17:09:19 2018] CPU6: Core power limit notification (total events = 11377)
[Sun Aug 19 17:09:19 2018] CPU1: Package power limit notification (total events = 11377)
[Sun Aug 19 17:09:19 2018] CPU4: Package power limit notification (total events = 11377)
[Sun Aug 19 17:09:19 2018] CPU3: Package power limit notification (total events = 11376)
[Sun Aug 19 17:09:19 2018] CPU5: Package power limit notification (total events = 11375)
[Sun Aug 19 17:09:19 2018] CPU0: Package power limit notification (total events = 11376)
[Sun Aug 19 17:09:19 2018] CPU2: Package power limit notification (total events = 11377)
[Sun Aug 19 17:09:19 2018] CPU6: Package power limit notification (total events = 11376)
[Sun Aug 19 17:09:19 2018] CPU7: Package power limit notification (total events = 11377)
[Sun Aug 19 17:09:19 2018] CPU3: Core power limit normal
[Sun Aug 19 17:09:19 2018] CPU0: Core power limit normal
[Sun Aug 19 17:09:19 2018] CPU7: Core power limit normal
[Sun Aug 19 17:09:19 2018] CPU1: Core power limit normal
[Sun Aug 19 17:09:19 2018] CPU5: Core power limit normal
[Sun Aug 19 17:09:19 2018] CPU2: Core power limit normal
[Sun Aug 19 17:09:19 2018] CPU4: Core power limit normal
[Sun Aug 19 17:09:19 2018] CPU6: Core power limit normal
[Sun Aug 19 17:09:19 2018] CPU0: Package power limit normal
[Sun Aug 19 17:09:19 2018] CPU7: Package power limit normal
[Sun Aug 19 17:09:19 2018] CPU1: Package power limit normal
[Sun Aug 19 17:09:19 2018] CPU5: Package power limit normal
[Sun Aug 19 17:09:19 2018] CPU2: Package power limit normal
[Sun Aug 19 17:09:19 2018] CPU4: Package power limit normal
[Sun Aug 19 17:09:19 2018] CPU6: Package power limit normal
[Sun Aug 19 17:09:19 2018] CPU3: Package power limit normal
[Sun Aug 19 17:11:48 2018] type=1325 audit(1534691893.367:36052): table=filter family=2 entries=87
[Sun Aug 19 17:11:48 2018] type=1300 audit(1534691893.367:36052): arch=c000003e syscall=54 success=yes exit=0 a0=3 a1=0 a2=40 a3=185a7d0 items=0 ppid=17942 pid=17943 auid=4294967295 uid=0 gid=0 euid=0 suid=0 fsuid=0 egid=0 sgid=0 fsgid=0 tty=(none) ses=4294967295 comm="iptables" exe="/sbin/xtables-multi" key=(null)
[Sun Aug 19 17:13:28 2018] type=1325 audit(1534691993.655:36053): table=filter family=2 entries=86
[Sun Aug 19 17:13:28 2018] type=1300 audit(1534691993.655:36053): arch=c000003e syscall=54 success=yes exit=0 a0=3 a1=0 a2=40 a3=950650 items=0 ppid=17983 pid=17984 auid=4294967295 uid=0 gid=0 euid=0 suid=0 fsuid=0 egid=0 sgid=0 fsgid=0 tty=(none) ses=4294967295 comm="iptables" exe="/sbin/xtables-multi" key=(null)
[Sun Aug 19 17:14:14 2018] type=1325 audit(1534692039.907:36054): table=filter family=2 entries=85
[Sun Aug 19 17:14:14 2018] type=1300 audit(1534692039.907:36054): arch=c000003e syscall=54 success=yes exit=0 a0=3 a1=0 a2=40 a3=1ec14e0 items=0 ppid=18025 pid=18026 auid=4294967295 uid=0 gid=0 euid=0 suid=0 fsuid=0 egid=0 sgid=0 fsgid=0 tty=(none) ses=4294967295 comm="iptables" exe="/sbin/xtables-multi" key=(null)
[Sun Aug 19 17:15:02 2018] type=1325 audit(1534692087.763:36055): table=filter family=2 entries=84
[Sun Aug 19 17:15:02 2018] type=1300 audit(1534692087.763:36055): arch=c000003e syscall=54 success=yes exit=0 a0=3 a1=0 a2=40 a3=84a360 items=0 ppid=18133 pid=18134 auid=4294967295 uid=0 gid=0 euid=0 suid=0 fsuid=0 egid=0 sgid=0 fsgid=0 tty=(none) ses=4294967295 comm="iptables" exe="/sbin/xtables-multi" key=(null)
[Sun Aug 19 17:15:28 2018] type=1325 audit(1534692114.219:36056): table=filter family=2 entries=83
[Sun Aug 19 17:15:28 2018] type=1300 audit(1534692114.219:36056): arch=c000003e syscall=54 success=yes exit=0 a0=3 a1=0 a2=40 a3=1280370 items=0 ppid=18243 pid=18244 auid=4294967295 uid=0 gid=0 euid=0 suid=0 fsuid=0 egid=0 sgid=0 fsgid=0 tty=(none) ses=4294967295 comm="iptables" exe="/sbin/xtables-multi" key=(null)
[Sun Aug 19 17:17:14 2018] type=1325 audit(1534692219.563:36057): table=filter family=2 entries=84
[Sun Aug 19 17:17:14 2018] type=1300 audit(1534692219.563:36057): arch=c000003e syscall=54 success=yes exit=0 a0=3 a1=0 a2=40 a3=189b4e0 items=0 ppid=18389 pid=18390 auid=4294967295 uid=0 gid=0 euid=0 suid=0 fsuid=0 egid=0 sgid=0 fsgid=0 tty=(none) ses=4294967295 comm="iptables" exe="/sbin/xtables-multi" key=(null)
mysql> show variables like 'thread_cache_size';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| thread_cache_size | 8 |
+-------------------+-------+
1 row in set (0.00 sec)
mysql> show status like 'Threads%';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_cached | 7 |
| Threads_connected | 1 |
| Threads_created | 3082 |
| Threads_running | 1 |
+-------------------+-------+
4 rows in set (0.00 sec)