2018/12/26 23:30 linode 关闭删除前一些状态备份,算是愐怀吧
uptime
[root@n feng]# uptime
15:35:19 up 240 days, 20 min, 1 user, load average: 0.00, 0.00, 0.00
free -m
[root@n feng]# free -m
total used free shared buffers cached
Mem: 979 598 380 118 44 309
-/+ buffers/cache: 244 735
Swap: 255 123 132
top -m
top - 15:37:34 up 240 days, 22 min, 1 user, load average: 0.00, 0.00, 0.00
Tasks: 77 total, 1 running, 39 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 1003304k total, 610928k used, 392376k free, 45784k buffers
Swap: 262140k total, 126644k used, 135496k free, 316108k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
22454 nobody 20 0 477m 123m 109m S 0.0 12.6 4:51.90 php-fpm
24518 nobody 20 0 476m 98m 86m S 0.0 10.1 1:06.22 php-fpm
21476 nobody 20 0 476m 98m 86m S 0.0 10.0 0:44.83 php-fpm
24531 nobody 20 0 476m 97m 85m S 0.0 10.0 1:06.05 php-fpm
24530 nobody 20 0 476m 97m 86m S 0.0 9.9 1:06.23 php-fpm
2828 mysql 20 0 783m 48m 3948 S 0.0 5.0 754:20.54 mysqld
19132 root 20 0 102m 6180 5128 S 0.0 0.6 0:00.03 sshd
25817 nginx 20 0 54016 5236 2660 S 0.0 0.5 30:55.19 nginx
8991 root 20 0 238m 4864 416 S 0.0 0.5 10:16.11 rsyslogd
19134 feng 20 0 103m 4852 2416 S 0.0 0.5 0:00.41 sshd
11101 root 20 0 455m 3596 2404 S 0.0 0.4 5:00.05 php-fpm
19155 root 20 0 105m 2764 2264 S 0.0 0.3 0:00.14 bash
19154 root 20 0 144m 2760 2352 S 0.0 0.3 0:00.01 su
13703 root 20 0 49476 2512 1700 S 0.0 0.3 0:00.01 nginx
26466 root 20 0 26440 2512 600 S 0.0 0.3 12:55.89 ss-server
19135 feng 20 0 105m 2496 2112 S 0.0 0.2 0:00.00 bash
19971 root 20 0 15076 2008 1728 R 0.0 0.2 0:00.00 top
8758 root 20 0 66320 1432 1344 S 0.0 0.1 6:59.90 sshd
2567 root 16 -4 27780 592 480 S 0.0 0.1 13:20.38 auditd
2886 root 20 0 114m 548 464 S 0.0 0.1 0:40.77 crond
1897 root 16 -4 10784 324 320 S 0.0 0.0 0:00.12 udevd
1 root 20 0 19292 96 0 S 0.0 0.0 1:36.95 init
2907 root 20 0 4140 52 48 S 0.0 0.0 0:00.00 agetty
2908 root 20 0 4140 52 48 S 0.0 0.0 0:00.00 agetty
2693 root 20 0 105m 48 48 S 0.0 0.0 0:00.01 mysqld_safe
2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd
4 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 kworker/0:0H
6 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 mm_percpu_wq
7 root 20 0 0 0 0 S 0.0 0.0 3:54.26 ksoftirqd/0
8 root 20 0 0 0 0 I 0.0 0.0 21:00.86 rcu_sched
9 root 20 0 0 0 0 I 0.0 0.0 0:00.00 rcu_bh
10 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
11 root 20 0 0 0 0 S 0.0 0.0 0:00.00 cpuhp/0
top -p
top - 15:38:37 up 240 days, 23 min, 1 user, load average: 0.00, 0.00, 0.00
Tasks: 77 total, 1 running, 39 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 1003304k total, 611348k used, 391956k free, 45812k buffers
Swap: 262140k total, 126644k used, 135496k free, 316112k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
19972 root 20 0 15076 1988 1700 R 0.3 0.2 0:00.01 top
1 root 20 0 19292 96 0 S 0.0 0.0 1:36.95 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd
4 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 kworker/0:0H
6 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 mm_percpu_wq
8 root 20 0 0 0 0 I 0.0 0.0 21:00.86 rcu_sched
9 root 20 0 0 0 0 I 0.0 0.0 0:00.00 rcu_bh
10 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
11 root 20 0 0 0 0 S 0.0 0.0 0:00.00 cpuhp/0
12 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kdevtmpfs
13 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 netns
14 root 20 0 0 0 0 S 0.0 0.0 2:32.35 kauditd
28 root 20 0 0 0 0 I 0.0 0.0 38:15.30 kworker/0:1
ifconfig
[root@n feng]# ifconfig
eth0 Link encap:Ethernet HWaddr F2:3C:91:84:5F:56
inet addr:106.185.34.99 Bcast:106.185.34.255 Mask:255.255.255.0
inet6 addr: 2400:8900::f03c:91ff:fe84:5f56/64 Scope:Global
inet6 addr: fe80::f03c:91ff:fe84:5f56/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:236135630 errors:0 dropped:0 overruns:0 frame:0
TX packets:178602310 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:38497969194 (35.8 GiB) TX bytes:382481811071 (356.2 GiB)
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:65536 Metric:1
RX packets:54474136 errors:0 dropped:0 overruns:0 frame:0
TX packets:54474136 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:113921748796 (106.0 GiB) TX bytes:113921748796 (106.0 GiB)
MySQL/phpMyAdmin 状态
数据库服务器
服务器: My Local MySQL server (Localhost via UNIX socket)
软件: MySQL
软件版本: 5.1.73-log - Source distribution
协议版本: 10
用户: root@localhost
服务器字符集: UTF-8 Unicode (utf8)
网站服务器
nginx/1.14.0
数据库客户端版本: libmysql - 5.1.73
PHP 扩展: mysqli 文档
显示 PHP 信息
phpMyAdmin
版本信息: 3.5.0
文档
维基 (Wiki) (外链,英文)
官方主页 (外链,英文)
贡献
获取支持
更新列表
自启动以来的网络流量: 732.1 GB
此 MySQL 服务器已运行 240 天 0 小时,11 分 17 秒。启动时间为 2018 年 04 月 30 日 15:20 。
此 MySQL 服务器正以主服务器运行于复制进程中。 要获得更多关于此服务器的复制状态,请查看复制状态信息。
复制状态
主服务器状态
变量 值
File mysql-bin.000127
Position 622011141
Binlog_Do_DB
Binlog_Ignore_DB
流量 ø 每小时
已接收 44.8 GB 8 MB
已发送 687.2 GB 122.2 MB
总计 732.1 GB 130.1 MB
连接 ø 每小时 %
最大并发连接数 17 --- ---
已失败 9 <0.01 <0.01%
已取消 39 0.01 <0.01%
总计 3,714 k 644.73 100.00%
进程 ID 用户 主机 数据库 命令 时间 状态 SQL 查询 显示完整查询
杀死 3713760 root localhost mysql Sleep 3 --- ---
杀死 3713761 root localhost 无 Sleep 1 --- ---
杀死 3713762 root localhost mysql Query 0 --- SHOW PROCESSLIST
杀死 3713763 root localhost 无 Sleep 2 --- ---
杀死 3713764 root localhost 无 Sleep 2 --- ---
自启动以来的内部查询: 118,225,577 文档
ø 每小时: 20,524
ø 每分钟: 342
ø 每秒: 6
说明 查询数量 ø 每小时 %
select 96,653 k 16.8 k 81.75%
set option 7,441 k 1,291.8 6.29%
update 6,285 k 1,091.1 5.32%
change db 3,711 k 644.2 3.14%
show fields 3,144 k 545.8 2.66%
insert 926 k 160.7 0.78%
delete 49,614 8.6 0.04%
delete multi 3,054 0.5 <0.01%
show table status 2,864 0.5 <0.01%
show create table 2,373 0.4 <0.01%
show triggers 2,308 0.4 <0.01%
begin 1,477 0.3 <0.01%
commit 1,477 0.3 <0.01%
show tables 401 0.1 <0.01%
show variables 327 0.1 <0.01%
alter table 251 <0.1 <0.01%
create table 239 <0.1 <0.01%
show databases 173 <0.1 <0.01%
show master status 138 <0.1 <0.01%
show slave status 136 <0.1 <0.01%
show keys 128 <0.1 <0.01%
show binlogs 98 <0.1 <0.01%
replace 49 <0.1 <0.01%
show create db 46 <0.1 <0.01%
rename table 31 <0.1 <0.01%
show grants 23 <0.1 <0.01%
show plugins 16 <0.1 <0.01%
show function status 12 <0.1 <0.01%
show procedure status 12 <0.1 <0.01%
flush 11 <0.1 <0.01%
show warnings 9 <0.1 <0.01%
show status 9 <0.1 <0.01%
show processlist 7 <0.1 <0.01%
create db 7 <0.1 <0.01%
grant 7 <0.1 <0.01%
drop table 6 <0.1 <0.01%
show storage engines 6 <0.1 <0.01%
insert select 4 <0.1 <0.01%
create user 4 <0.1 <0.01%
drop db 3 <0.1 <0.01%
show slave hosts 3 <0.1 <0.01%
show binlog events 2 <0.1 <0.01%
optimize 1 <0.1 <0.01%
kill 1 <0.1 <0.01%
drop user 1 <0.1 <0.01%
alter db 1 <0.1 <0.01%
aa