要过节了,把自己的服务器拿出来晒晒太阳,大家说说看法,有没有什么优化的建议~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
--------------
.................................
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
你的table cache可以在设的有些小