Anyone Can Help Optimize My VPS

[lxjtian]

VPS info:


Processor Information
Total processors: 1

Processor #1

Vendor
GenuineIntel

Name
Intel(R) Xeon(R) CPU X3430 @ 2.40GHz

Speed
2394.050 MHz

Cache
8192 KB


Memory Information:


Current Memory Usage

total used free shared buffers cached
Mem: 2097152 642724 1454428 0 0 0
-/+ buffers/cache: 642724 1454428
Swap: 0 0 0
Total: 2097152 642724 1454428


Current Disk Usage

Filesystem Size Used Avail Use% Mounted on
/dev/simfs 350G 35G 315G 10% /
none 1.0G 0 1.0G 0% /dev/shm


========top========

 PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 1895 sun****  18   0 94092  11m 6064 R  2.0  0.5   0:00.06 php
 9548 mysql     15   0  292m  95m 4376 S  0.7  4.7   0:53.06 mysqld
 1807 nobody    15   0 19148 7068 1808 S  0.3  0.3   0:00.01 httpd
14062 nobody    15   0 19824 7820 1876 S  0.3  0.4   0:00.98 httpd
    1 root      15   0  2156  664  572 S  0.0  0.0   0:00.00 init
 1507 root      15   0 10200 2892 2324 R  0.0  0.1   0:00.01 sshd
 1524 nobody    15   0 19148 7148 1852 S  0.0  0.3   0:00.05 httpd
 1560 root      15   0  2544 1340 1104 S  0.0  0.1   0:00.00 bash
 1623 root      15   0  2288 1056  816 R  0.0  0.1   0:00.03 top
 1645 nobody    15   0 19696 7564 1816 S  0.0  0.4   0:00.05 httpd
 1797 nobody    15   0 19148 7056 1796 S  0.0  0.3   0:00.00 httpd
 1814 nobody    15   0 19148 7072 1800 S  0.0  0.3   0:00.00 httpd
 7197 root      15   0 10196 2884 2304 S  0.0  0.1   0:00.02 sshd
 7284 root      15   0  6648 1596 1184 S  0.0  0.1   0:00.02 sftp-server
 8160 root      15   0 10200 2892 2324 S  0.0  0.1   0:00.03 sshd
 9415 root      15   0  2544 1336 1104 S  0.0  0.1   0:00.00 bash
 9471 nobody    16   0 19852 7884 1908 S  0.0  0.4   0:00.94 httpd
 9521 root      25   0  2544 1140  984 S  0.0  0.1   0:00.00 mysqld_safe
 9803 root      15   0  2288 1028  812 S  0.0  0.0   0:00.28 top
16016 root      15   0 10040 2852 2304 S  0.0  0.1   0:00.01 sshd
16291 root      15   0 10200 2892 2324 S  0.0  0.1   0:00.04 sshd
17460 root      15   0  2544 1336 1108 S  0.0  0.1   0:00.00 bash
17641 root      15   0  6648 1536 1184 S  0.0  0.1   0:00.00 sftp-server
18279 root      15   0 22448  564  468 S  0.0  0.0   0:00.04 brcm_iscsiuio
19525 root      15   0  1812  576  480 S  0.0  0.0   0:00.35 syslogd
19528 root      18   0  1760  400  336 S  0.0  0.0   0:00.00 klogd
19560 dbus      18   0  2844  648  488 S  0.0  0.0   0:00.00 dbus-daemon
19585 root      15   0  7200 1072  664 S  0.0  0.1   0:00.00 sshd
19598 root      18   0  2832  864  696 S  0.0  0.0   0:00.00 xinetd
21728 mailnull  15   0 10360 2648 2160 S  0.0  0.1   0:00.01 exim
21757 root      34  18 18480 9204 2128 S  0.0  0.4   0:00.34 cpanellogd
21841 root      15   0 37804  31m 2536 S  0.0  1.5   0:01.85 spamd
21842 root      18   0 15808  13m 1368 S  0.0  0.7   0:04.68 lfd
19598 root      18   0  2832  864  696 S  0.0  0.0   0:00.00 xinetd
21728 mailnull  15   0 10360 2648 2160 S  0.0  0.1   0:00.01 exim
21757 root      34  18 18480 9204 2128 S  0.0  0.4   0:00.34 cpanellogd
21841 root      15   0 37804  31m 2536 S  0.0  1.5   0:01.85 spamd
21880 root      15   0  2152  700  536 S  0.0  0.0   0:00.01 dovecot
21881 root      15   0  2628 1024  828 S  0.0  0.0   0:00.01 dovecot-auth
21909 root      18   0  8004 5264 1836 S  0.0  0.3   0:00.05 leechprotect
21922 dovecot   18   0  5188 1964 1616 S  0.0  0.1   0:00.00 pop3-login
21923 dovecot   20   0  5188 1968 1616 S  0.0  0.1   0:00.00 pop3-login
21924 dovecot   18   0  5200 1976 1628 S  0.0  0.1   0:00.00 imap-login
21925 dovecot   15   0  5320 2020 1648 S  0.0  0.1   0:00.00 imap-login
21937 root      15   0 38164  30m 1892 S  0.0  1.5   0:02.46 spamd
21983 root      15   0 19008 9088 3988 S  0.0  0.4   0:00.39 httpd
22010 root      15   0  7656 1452 1100 S  0.0  0.1   0:00.00 pure-ftpd
22012 root      18   0  5076 1144  900 S  0.0  0.1   0:00.00 pure-authd
22021 root      15   0  3328 1096  564 S  0.0  0.1   0:00.00 crond
22199 root      15   0  4192 2244 1088 S  0.0  0.1   0:00.02 cphulkd
22231 root      15   0  7984 5232 1748 S  0.0  0.2   0:00.05 tailwatchd
22263 root      16   0 15144 9072 1776 S  0.0  0.4   0:00.01 cpdavd
22309 root      18   0  6096 4312 1320 S  0.0  0.2   0:00.02 queueprocd
22337 root      33  18  4184 1868  668 S  0.0  0.1   0:00.00 cpanellogd
22397 root      15   0 14252 7272 1224 S  0.0  0.3   0:00.10 cpsrvd-ssl
23918 named     21   0 39952 4428 2016 S  0.0  0.2   0:00.14 named

========SAR========

Linux 2.6.18-194.26.1.el5.028stab081.1 (server9.verygoodns.com)         07/24/11

00:00:01          CPU     %user     %nice   %system   %iowait    %steal     %idle
00:10:01          all     37.53      1.08     13.94     24.25      0.00     23.20
00:20:01          all     36.13      0.03     12.95     13.09      0.00     37.81
00:30:02          all     42.47      0.02     15.47      9.03      0.00     33.00
00:40:02          all     39.65      0.02     14.87     16.53      0.00     28.92
00:50:01          all     46.42      0.04     19.62     22.04      0.00     11.88
01:00:02          all     43.44      0.02     16.51     10.35      0.00     29.69
01:10:01          all     47.35      0.02     15.72     14.48      0.00     22.43
01:20:03          all     46.49      0.02     15.96      8.82      0.00     28.71
01:30:02          all     47.74      0.02     16.73      8.78      0.00     26.73
01:40:01          all     49.79      0.04     17.10     13.31      0.00     19.77
01:50:01          all     45.30      0.02     14.88     10.88      0.00     28.91
02:00:01          all     39.52      0.29     15.48      7.68      0.00     37.03
02:10:01          all     37.25      1.05     15.12     16.58      0.00     30.00
02:20:01          all     36.75      0.04     15.00      9.82      0.00     38.39
02:30:01          all     37.85      0.04     14.68      5.47      0.00     41.96
02:40:01          all     31.56      6.52     12.32      9.26      0.00     40.33
02:50:01          all     40.07      0.05     13.90     11.73      0.00     34.24
03:00:01          all     46.53      0.02     17.00      5.77      0.00     30.68
03:10:01          all     41.34      0.02     16.37     18.13      0.00     24.14
03:20:02          all     45.85      0.02     17.44     10.42      0.00     26.26
03:30:02          all     39.93      0.05     16.75      9.75      0.00     33.52
03:40:01          all     41.72      0.02     16.33      7.99      0.00     33.95
03:50:01          all     39.90      0.03     15.55      6.80      0.00     37.73
04:00:01          all     40.46      0.04     16.10      7.47      0.00     35.94
04:10:03          all     38.43      1.04     16.11     14.44      0.00     29.97
04:20:02          all     34.28      0.02     14.77     25.47      0.00     25.46
Average:          all     41.30      0.41     15.64     12.24      0.00     30.41

04:29:15          LINUX RESTART

04:30:02          CPU     %user     %nice   %system   %iowait    %steal     %idle
04:40:02          all     37.43      0.04     14.43     21.79      0.00     26.30
04:50:01          all     43.11      0.04     16.67     15.22      0.00     24.97
05:00:01          all     49.79      0.02     18.78     13.98      0.00     17.42
05:10:01          all     41.48      0.05     15.83     41.18      0.00      1.46
05:20:01          all     41.78      0.00     16.28     17.34      0.00     24.60
05:30:02          all     34.20      0.00     12.05     29.60      0.00     24.15
05:40:01          all     32.74      0.13     11.93     14.59      0.00     40.60
05:50:01          all     31.78      0.02     11.67     14.91      0.00     41.62
06:00:01          all     31.35      0.81     11.25     12.23      0.00     44.35
06:10:02          all     33.83      0.29     11.64     11.23      0.00     43.01
06:20:01          all     35.72      0.49     12.47     14.37      0.00     36.96
Average:          all     37.56      0.17     13.91     18.77      0.00     29.59

========/usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl========

 >>  MySQLTuner 1.1.2 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.92-community-log
[OK] Operating on 32-bit architecture with less than 2GB RAM

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 182M (Tables: 6217)
[--] Data in InnoDB tables: 16M (Tables: 922)
[--] Data in MEMORY tables: 0B (Tables: 51)
[!!] Total fragmented tables: 227

-------- Performance Metrics -------------------------------------------------
[--] Up for: 48m 53s (768K q [262.065 qps], 5K conn, TX: 412M, RX: 158M)
[--] Reads / Writes: 91% / 9%
[--] Total buffers: 308.0M global + 12.4M per thread (150 max threads)
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
[!!] Maximum possible memory usage: 2.1G (106% of installed RAM)
[OK] Slow queries: 0% (1/768K)
[OK] Highest usage of available connections: 5% (8/150)
[OK] Key buffer size / total MyISAM indexes: 128.0M/58.0M
[OK] Key buffer hit rate: 99.5% (2M cached / 13K reads)
[OK] Query cache efficiency: 82.5% (605K cached / 734K selects)
[!!] Query cache prunes per day: 1979658
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 9K sorts)
[!!] Joins performed without indexes: 1753
[!!] Temporary tables created on disk: 42% (5K on disk / 13K total)
[OK] Thread cache hit rate: 99% (28 created / 5K connections)
[!!] Table cache hit rate: 0% (300 open / 31K opened)
[OK] Open file limit used: 11% (115/1K)
[OK] Table locks acquired immediately: 100% (178K immediate / 178K locks)
[OK] InnoDB data size / buffer pool: 16.5M/18.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Adjust your join queries to always utilize indexes
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    query_cache_size (> 32M)
    join_buffer_size (> 8.0M, or always use indexes with joins)
    tmp_table_size (> 256M)
    max_heap_table_size (> 128M)
    table_cache (> 300)

========my.cnf========

[mysqld]
local-infile=0
log-slow-queries=/var/lib/mysql/slow.log
datadir=/var/lib/mysql
skip-locking
long_query_time=5
max_connections=150
max_connect_errors=10
max_allowed_packet=32M
interactive_timeout=30
wait_timeout=100
query_cache_size=32M
query_cache_limit=64M
connect_timeout=10
table_cache=300
thread_cache_size=4
tmp_table_size=256M
max_heap_table_size=128M
join_buffer_size=8M
sort_buffer_size=2M
read_buffer_size=2M
key_buffer_size=128M
thread_concurrency=3
innodb_buffer_pool_size=18M

[mysqld_safe]
open_files_limit=5000

[mysql.server]
user=mysql

[mysqldump]
quick
max_allowed_packet=96M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=32M
write_buffer=32M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=32M
write_buffer=32M

[lxjtian]

noone reply? very sad

[Infopro]

Whats so sad? It's Sunday, everyone is offline enjoying the weekend and you've only posted a little over 9 hours ago, late on a Saturday night.

If you're in a rush, have a closer look at other similar threads asking the same question for tips on how you can tweak your system on your own.

Here's a tip to get you going in the right direction, you should make sure MySQL has been up for at least 24 hours before assuming MySQLTuner is giving you accurate details.

From your post above, a snip that says yours has been up 48 minutes at time of paste:

-------- Performance Metrics -------------------------------------------------
[--] Up for: 48m 53s (768K q [262.065 qps], 5K conn, TX: 412M, RX: 158M)

Optimizing your server is not necessarily a cPanel thing, it's about your server and its hardware. Those kinds of details and tips can be found in a much larger scale outside these forums via your favorite search engine.

cPanelTristan and others who assist in explaining the output of MySQLTuner and ways to tweak your system on this forum, do it to be helpful.

It's not a requirement on these forums that anyone answers your posts, even more so on a weekend.