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========
========SAR========
========/usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl========
========my.cnf========
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 <[email protected]>
>> 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