The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Anyone Can Help Optimize My VPS

Discussion in 'Workarounds and Optimization' started by lxjtian, Jul 24, 2011.

  1. lxjtian

    lxjtian Member

    Joined:
    Apr 5, 2011
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    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========
    Code:
     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========

    Code:
    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========
    Code:
     >>  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========
    Code:
    [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
    
    
     
  2. lxjtian

    lxjtian Member

    Joined:
    Apr 5, 2011
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    noone reply? very sad
     
  3. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,450
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    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:


    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. ;)
     
Loading...

Share This Page