1、top查看开机时间
[root@bogon Desktop]# top
top - 23:07:22 up 1:30, 2 users, load average: 0.07, 0.02, 0.00
Tasks: 138 total, 1 running, 137 sleeping, 0 stopped, 0 zombie
Cpu(s): 7.2%us, 0.3%sy, 0.0%ni, 92.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 1906556k total, 937108k used, 969448k free, 27248k buffers
Swap: 3145720k total, 0k used, 3145720k free, 469308k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2472 root 20 0 196m 36m 8280 S 6.3 1.9 0:11.35 Xorg
2881 root 20 0 310m 14m 9.9m S 2.0 0.8 0:03.27 gnome-terminal
4 root 20 0 0 0 0 S 0.3 0.0 0:00.08 ksoftirqd/0
2783 root 20 0 257m 18m 13m S 0.3 1.0 0:05.78 vmtoolsd
4600 mysql 20 0 966m 116m 4620 S 0.3 6.2 0:02.02 mysqld
1 root 20 0 19356 1544 1232 S 0.0 0.1 0:02.00 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd
3 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
5 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
6 root RT 0 0 0 0 S 0.0 0.0 0:00.01 watchdog/0
7 root 20 0 0 0 0 S 0.0 0.0 0:03.57 events/0
8 root 20 0 0 0 0 S 0.0 0.0 0:00.00 cgroup
9 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khelper
10 root 20 0 0 0 0 S 0.0 0.0 0:00.00 netns
11 root 20 0 0 0 0 S 0.0 0.0 0:00.00 async/mgr
12 root 20 0 0 0 0 S 0.0 0.0 0:00.00 pm
13 root 20 0 0 0 0 S 0.0 0.0 0:00.02 sync_supers
14 root 20 0 0 0 0 S 0.0 0.0 0:00.02 bdi-default
15 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kintegrityd/0
16 root 20 0 0 0 0 S 0.0 0.0 0:00.49 kblockd/0
17 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kacpid
18 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kacpi_notify
19 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kacpi_hotplug
20 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ata_aux
21 root 20 0 0 0 0 S 0.0 0.0 0:01.29 ata_sff/0
22 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ksuspend_usbd
23 root 20 0 0 0 0 S 0.0 0.0 0:00.01 khubd
24 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
25 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md/0
ok,一分半,哈哈
2、df -h查看磁盘空间
[root@bogon Desktop]# df -hl
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 27G 3.0G 23G 12% /
tmpfs 931M 228K 931M 1% /dev/shm
/dev/sda1 291M 39M 238M 14% /boot
很明显剩余空间很大。
3、性能下降sql慢,执行时间长,等待时间长
- 查询语句写的烂
- 索引失效(建了索引但是没用)
- 关联查询太多join(设计缺陷或不得已的需求)
- sql执行顺序
- 手写:
select->from->join->on->where->groub by->having->order by->limit
- 机读:
from->join->on->where->groub by->having->select->order by->limit
- 手写:
- sql执行顺序
- 服务器调优及各个参数设置(缓冲线程数等)