On Thu, Apr 18, 2019 at 07:41:23PM -0400, Greg Rundlett (freephile) wrote:
What does total RAM look like, and is there a swap
partition?
I'm wondering if Apache and MySQL are battling for RAM
The BBB has 512 MB RAM, not expandable. I run FreeBSD from a 60 GB microSD
card, and I dedicated the internal eMMC drive's original 3.4 GB Linux
partition for swap. Very little of that swap is ever used, though. Every
time I look at 'top' it only shows 5% or so in use, and only by my login
shell, not the daemons.
I try to tune services to keep RAM use down. Typical 'top -tw' output:
last pid: 20543; load averages: 1.04, 0.98, 0.85
up 13+20:25:45 20:17:07
30 processes: 30 sleeping
CPU: 0.8% user, 0.0% nice, 0.0% system, 0.8% interrupt, 98.4% idle
Mem: 108M Active, 139M Inact, 115M Laundry, 112M Wired, 55M Buf, 26M Free
Swap: 1964M Total, 116M Used, 1848M Free, 5% Inuse
PID USERNAME THR PRI NICE SIZE RES SWAP STATE TIME WCPU COMMAND
17391 mysql 35 40 0 229M 141M 0 select 14:02 0.15% mysqld
2878 root 1 40 0 65M 11M 0 select 1:10 0.08% perl
9513 mike 1 40 0 12M 4884K 0 select 0:51 0.03% sshd
2151 ntpd 1 40 0 8296K 8320K 0 select 4:00 0.02% ntpd
20053 root 1 40 0 9084K 6040K 0 select 0:00 0.02% sendmail
17431 root 1 4 0 100M 14M 0 kqread 0:04 0.01% php-fpm
18455 www 1 8 0 36M 15M 0 nanslp 0:07 0.01% php
682 unbound 1 40 0 16M 8880K 0 select 6:10 0.00% local-unbound
17441 www 1 4 0 12M 5596K 0 kqread 0:31 0.00% nginx
706 root 1 40 0 4860K 1776K 0 select 0:21 0.00% syslogd
2880 root 1 40 0 68M 27M 0 select 0:20 0.00% perl
3898 root 1 8 0 4860K 824K 0 nanslp 0:20 0.00% cron
20239 www 1 4 0 104M 36M 0 accept 0:13 0.00% php-fpm
20380 www 1 4 0 104M 31M 0 accept 0:06 0.00% php-fpm
9669 root 1 16 0 6432K 2272K 0 pause 0:05 0.00% tcsh
18375 mike 1 40 0 9572K 5904K 0 select 0:03 0.00% ssh
583 root 1 40 0 3924K 412K 0 select 0:02 0.00% devd
15699 mysql 1 8 0 5264K 2148K 0 wait 0:01 0.00% sh
3888 root 1 51 0 11M 3968K 0 select 0:01 0.00% sshd
2881 root 1 40 0 65M 10M 0 select 0:00 0.00% perl
9514 mike 1 16 0 6768K 0 2056K pause 0:00 0.00% <tcsh>
9511 root 1 40 0 12M 4728K 0 select 0:00 0.00% sshd
18330 mike 1 16 0 6772K 3736K 0 pause 0:00 0.00% tcsh
9668 mike 1 8 0 5360K 0 1788K wait 0:00 0.00% <su>
18452 root 1 8 0 5360K 2628K 0 wait 0:00 0.00% su
18453 www 1 16 0 5516K 2696K 0 pause 0:00 0.00% csh
20057 smmsp 1 16 0 8660K 5792K 0 pause 0:00 0.00% sendmail
3948 root 1 40 0 4332K 1644K 0 ttyin 0:00 0.00% getty
20412 www 1 4 0 100M 14M 0 accept 0:00 0.00% php-fpm
17440 root 1 16 0 11M 4608K 0 pause 0:00 0.00% nginx
(PID 18455 = tt-rss feed updater; PID 2881 = SpamAssassin)
I watched 'top -tw' while producing the crash and there was no swap use at
all. Even during a successful edit, the top of 'top' is showing RAM's not a
problem:
CPU: 55.6% user, 0.0% nice, 13.1% system, 23.9% interrupt, 7.3% idle
Mem: 147M Active, 108M Inact, 118M Laundry, 111M Wired, 55M Buf, 14M Free
Swap: 1964M Total, 99M Used, 1864M Free, 5% Inuse
Here's 'vmstat -w 1' output before, during, and after a successful edit:
procs memory page disks faults cpu
r b w avm fre flt re pi po fr sr mm0 mm1 in sy cs us sy id
3 0 2 691M 26M 0 0 0 0 0 60 1 0 44 163 97 0 1 99
3 0 2 691M 26M 0 0 0 0 0 60 0 0 39 169 79 0 3 97
3 0 2 691M 26M 0 0 0 0 0 54 0 0 42 155 95 1 1 98
5 0 2 695M 26M 164 0 0 0 0 60 0 0 111 599 238 2 5 93
4 0 2 691M 26M 35 0 0 0 196 60 0 0 52 224 92 0 2 98
3 0 2 691M 26M 0 0 0 0 0 60 0 0 43 174 86 1 1 98
4 0 2 691M 26M 0 0 0 0 0 60 0 0 42 147 92 0 1 99
2 1 2 691M 26M 61 0 0 0 20 60 25 0 2477 2217 3423 65 12 22
2 0 2 693M 25M 114 0 0 0 298 66 50 0 2640 1304 3370 89 8 2
2 2 2 693M 25M 65 0 0 0 120 60 16 0 1995 546 1883 91 9 0
1 0 2 693M 25M 77 0 0 0 61 60 25 0 2480 455 2818 93 7 0
1 0 2 693M 25M 0 0 0 0 0 60 4 0 1399 192 663 98 2 0
1 0 2 693M 25M 54 0 0 0 160 60 21 0 1492 1320 975 89 10 1
2 0 2 693M 25M 155 0 0 0 372 60 55 0 2957 3679 4283 78 20 2
7 3 2 696M 24M 126 0 0 0 2083 66 183 0 5895 1852 10022 51 49 0
5 4 2 696M 24M 107 0 0 0 1408 60 244 0 12751 2486 23605 51 49 0
3 0 2 696M 23M 104 0 0 0 797 60 180 0 8104 2135 14689 64 36 0
2 0 2 696M 20M 369 0 18 0 174 66 91 3 4300 2674 6677 67 33 0
2 0 2 694M 20M 132 0 4 0 817 60 70 0 3308 3420 4868 79 21 0
4 0 2 697M 18M 1193 0 1 0 538 60 19 0 1901 3219 1928 84 16 0
3 0 2 707M 16M 973 0 0 0 710 60 35 0 1914 3476 2104 79 21 0
2 0 2 705M 16M 191 0 0 0 407 60 16 0 1864 3265 1941 89 9 2
2 2 2 707M 16M 34 0 0 0 327 60 49 0 3901 4143 5965 77 23 0
1 0 2 707M 16M 16 0 0 0 216 60 59 0 4025 3740 6352 68 27 5
1 0 2 707M 16M 88 0 0 0 12 66 5 0 1397 4865 809 81 19 0
1 0 2 707M 15M 302 0 0 0 12 60 0 0 1139 6580 148 77 23 0
0 0 2 694M 22M 466 0 0 0 2593 60 0 0 353 1085 153 24 7 69
0 0 2 694M 22M 0 0 0 0 0 60 1 0 78 151 160 1 1 98
0 0 2 694M 22M 6 0 0 0 32 60 7 0 465 278 931 1 4 95
0 0 2 694M 22M 0 0 0 0 56 60 18 0 1232 221 2384 0 7 93
0 0 2 694M 22M 0 0 0 0 0 60 4 0 302 189 621 1 2 97
0 0 2 694M 22M 0 0 0 0 0 60 4 0 301 170 624 0 1 99
0 0 2 694M 22M 0 0 0 0 0 60 0 0 37 173 80 1 1 98
1 0 2 694M 22M 0 0 0 0 0 60 1 0 83 159 175 0 2 98
Here's the same thing when it crashes:
procs memory page disks faults cpu
r b w avm fre flt re pi po fr sr mm0 mm1 in sy cs us sy id
1 0 2 699M 21M 0 0 0 0 0 66 4 0 323 169 628 0 2 98
0 0 2 699M 21M 0 0 0 0 0 60 2 0 72 184 133 0 3 97
2 0 2 699M 21M 6 0 0 0 31 54 3 0 477 1641 258 33 7 60
0 1 2 699M 20M 151 0 0 0 840 60 1109 0 8771 936 16021 50 36 15
1 0 2 699M 16M 582 0 0 0 1898 66 499 0 28483 147 56578 0 43 57
0 1 2 699M 17M 172 0 0 0 2265 60 376 0 28877 171 56985 0 48 52
0 1 2 699M 17M 636 0 0 0 1248 60 441 0 30110 162 59860 1 47 52
0 1 2 699M 17M 612 0 0 0 1224 60 417 0 29243 173 58092 0 41 59
0 1 2 699M 17M 636 0 0 0 1296 66 413 0 30507 147 60642 1 37 63
0 1 2 699M 17M 510 0 0 0 1584 60 386 0 31064 169 61611 0 46 54
0 1 2 699M 17M 480 0 0 0 960 60 314 0 22862 147 45330 1 27 72
0 1 2 699M 17M 514 0 0 0 1456 60 367 0 28493 189 56439 0 47 53
0 1 2 699M 17M 216 0 0 0 2416 60 320 0 32647 160 64335 0 47 53
0 1 2 699M 17M 450 0 0 0 1520 60 411 0 29764 169 58956 1 44 55
0 1 2 699M 17M 600 0 0 0 1200 66 403 0 28716 149 56910 1 45 54
0 1 2 699M 17M 596 0 0 0 1248 60 398 0 29501 169 58548 0 44 56
0 1 2 699M 17M 600 0 0 0 1224 60 391 0 28821 172 57211 1 44 55
0 1 2 699M 17M 276 0 0 0 552 66 179 0 13592 169 26593 0 17 83
0 1 2 699M 17M 132 0 0 0 264 60 89 0 6736 147 12862 0 12 88
0 1 2 699M 17M 432 0 0 0 864 60 280 0 20640 174 40563 0 32 68
0 1 2 699M 17M 204 0 0 0 412 60 151 0 11409 165 21299 0 19 81
0 1 2 699M 17M 504 0 0 0 1032 60 332 0 24438 188 48209 0 33 67
0 1 2 699M 17M 636 0 0 0 1248 60 456 0 30150 147 59932 0 38 62
1 0 2 699M 17M 624 0 0 0 1272 66 547 0 30275 173 60258 0 45 55
0 1 2 699M 17M 624 0 0 0 1248 60 604 0 29725 149 59148 0 36 64
1 0 2 694M 27M 309 0 0 0 4132 60 509 0 28489 276 56415 0 48 52
0 0 2 694M 27M 33 0 0 0 0 60 1 0 46 365 91 0 2 98
0 0 2 694M 27M 0 0 0 0 0 59 2 0 175 169 338 1 2 98
0 0 2 694M 27M 0 0 0 0 0 60 0 0 39 147 79 1 1 98
0 0 2 694M 27M 0 0 0 0 16 60 1 0 170 169 337 1 3 96
I'm no expert in interpreting this but I don't get the impression it's
thrashing.
Any thoughts on the pcre clue and the fact that it always dies at right after
that one SQL query?