要过节了,把自己的服务器拿出来晒晒太阳,大家说说看法,有没有什么优化的建议~mysql> status
--------------
.................................
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /tmp/mysql.sock
Uptime:                 3 hours 50 min 45 secThreads: 23  Questions: 126204883  Slow queries: 489  Opens: 5470  Flush tables: 1  Open tables: 1500  Queries per second avg: 9115.556
--------------
mysql> show global status like 'Com_update';
+---------------+---------+
| Variable_name | Value   |
+---------------+---------+
| Com_update    | 7490438 | 
+---------------+---------+
mysql> show global status like 'Com_select';
+---------------+---------+
| Variable_name | Value   |
+---------------+---------+
| Com_select    | 6926991 | 
+---------------+---------+
mysql> show global status like 'Com_delete';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Com_delete    | 50010 | 
+---------------+-------+
mysql> show global status like 'Com_insert';
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| Com_insert    | 113266 | 
+---------------+--------+
mysql> show global status like 'Com_commit';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Com_commit    | 13752 | 
+---------------+-------+Cpu(s):  3.6%us,  1.1%sy,  0.0%ni, 95.0%id,  0.0%wa,  0.1%hi,  0.2%si,  0.0%st
Mem:   4035384k total,  4012400k used,    22984k free,    54488k buffers
Swap:  2096472k total,      172k used,  2096300k free,  1683856k cached  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                
 3821 root      21   0 3302m 1.2g  10m S 21.9 31.3  50:14.09 java                                                                   
 3715 mysql     18   0 2774m 781m 5636 S 15.6 19.8  61:02.50 mysqld                                                                 
17790 root      15   0 12872 1236  820 R  0.7  0.0   0:00.07 free -m
             total       used       free     shared    buffers     cached
Mem:          3940       3921         19          0         53       1620
-/+ buffers/cache:       2247       1693
Swap:         2047          0       2047