Load averages are ok ,but site loading is slow

rioabraham

Registered
Nov 16, 2011
3
0
51
Pathanamthitta, India
cPanel Access Level
Website Owner
Load averages are ok ,but site loading is slow

My server load averages( 2.86 2.10 1.75) look normal after i added some optimizations recommended on this forum ,but site loading is slow.I have run optimise tables from admincp-vbulletin and also done it from ssh .I dont know linux to start with ,i've done most ssh cmds which i saw in this forum.

Specs
Processor: Intel® Dual 2.8Ghz Xeon
Bandwidth: 1,000GB
Memory: 4GB Ram
Hard Drive: 2 x 320GB HDD
RAID: RAID 1
Operating System: CentOS 5.7 Final -32 bit
Arch-i686
Forum : Vbulletin 4.1.5
Vbseo 3.6.0
I've checked my monthly bandwidth usage it almost doubled from last 2 months .Nah there is no increase in visitors as alexa rank has gone down from 39K to 50K ,if i say.I have heard that slow loading websites can get low ranks in google,may be that is the cause for alexa rank drop.


Here are some configurations i have done.
vi /etc/my.cnf
Code:
[mysqld]
local-infile=0
max_connections=200
key_buffer_size=256M
myisam_sort_buffer_size=64M
open_files_limit=50000
long_query_time=4
read_buffer_size=4M
sort_buffer_size=4M
join_buffer_size=1M
read_rnd_buffer_size=8M
table_cache=10K
thread_cache_size=8
max_allowed_packet=1M
max_connect_errors=10
query_cache_limit=16M
query_cache_size=128M
tmp_table_size=64M
max_heap_table_size=64M
skip-innodb
skip-federated
log-bin=mysql-bin
server-id=1
skip-name-resolve
skip-locking
tmpdir=/mysqltmp
log-slow-queries= /var/lib/mysql/slow.log


[mysqld_safe]
open_files_limit=8192

[mysqldump]
max_allowed_packet=16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size=256M
sort_buffer_size=256M
read_buffer_size=2M
write_buffer_size=2M

[isamchk]
key_buffer_size=256M
sort_buffer_size=256M
read_buffer_size=2M
write_buffer_size=2M

[mysqlhotcopy]
interactive-timeout
After running
./Mysqltuner.pl
Code:
 >>  MySQLTuner 1.2.0 - 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.1.56-log
[!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 2G (Tables: 547)
[--] Data in MEMORY tables: 7M (Tables: 50)
[!!] Total fragmented tables: 12

-------- Security Recommendations  -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 1d 1h 8m 49s (3M q [41.887 qps], 244K conn, TX: 168B, RX: 1B)
[--] Reads / Writes: 76% / 24%
[--] Total buffers: 448.0M global + 17.2M per thread (200 max threads)
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
[!!] Maximum possible memory usage: 3.8G (95% of installed RAM)
[OK] Slow queries: 0% (2K/3M)
[OK] Highest usage of available connections: 18% (37/200)
[OK] Key buffer size / total MyISAM indexes: 256.0M/565.0M
[OK] Key buffer hit rate: 100.0% (665M cached / 152K reads)
[OK] Query cache efficiency: 56.1% (1M cached / 2M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (49 temp sorts / 225K sorts)
[OK] Temporary tables created on disk: 8% (4K on disk / 60K total)
[OK] Thread cache hit rate: 98% (3K created / 244K connections)
[OK] Table cache hit rate: 67% (896 open / 1K opened)
[OK] Open file limit used: 6% (1K/20K)
[OK] Table locks acquired immediately: 99% (3M immediate / 3M locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance


Daily Processes log


Disk Usage


Process manager
 

Attachments

Last edited:

minosjl

Well-Known Member
Jun 4, 2011
168
0
66
India
cPanel Access Level
Root Administrator
Hi brother,


Basically defunct processes is also known as a "zombie". It means that it's finished but still depends on a "parent" which is still alive .You can kill those processes .What's the php handler you are using,Please recompile your easyapche with correct handler and incase of the vbulletin , i think it may occured due to the zend optimiser + ironcube conflict issues on apache .If both of them are currently enabled , please uninstall one of them as recommended by Vbulletin .

Please verify these things :)
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
You might also want to check loading times on the site itself via a browser to see how long each component takes to load. That could be a good indicator of what might be slowing it down:

Pingdom Tools

This is a tool that can be used to tell you how long each element on your site takes to load for a set page.