# Why may cause my sites loading very slowly?

**URL:** <https://forums.percona.com/t/why-may-cause-my-sites-loading-very-slowly/2092>\
**Category:** Other MySQL® Questions\
**Created:** [April 24, 2012, 3:54am UTC](https://forums.percona.com/t/why-may-cause-my-sites-loading-very-slowly/2092 "2012-04-24T03:54:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![barkat530](https://avatars.discourse-cdn.com/v4/letter/b/eb9ed0/32.png) [@barkat530](https://forums.percona.com/u/barkat530)\
**Post date:** [April 24, 2012, 3:54am UTC](https://forums.percona.com/t/why-may-cause-my-sites-loading-very-slowly/2092/1 "2012-04-24T03:54:28Z")

</div>

Server details:

RAM: 16GB  
HDD: 1000GB  
OS: Linux 2.6.32-220.7.1.el6.x86\_64  
Processor: 6 Core

Please see the link below for my # top preview:

[URL][http://dl.dropbox.com/u/26967109/%23top-1.jpg[/URL]](http://dl.dropbox.com/u/26967109/%23top-1.jpg%5B/URL%5D)  
 ![]()

my /etc/my.cnf configuration are as below:

bind-address=127.0.0.1  
local-infile=0  
datadir=/var/lib/mysql  
socket=/var/lib/mysql/mysql.sock  
user=mysql

skip-locking  
max\_connections=20000  
table\_cache=40000  
max\_user\_connections=20000  
key\_buffer\_size=1536M  
sort\_buffer\_size=3M  
join\_buffer\_size=3M  
read\_buffer\_size=3M  
read\_rnd\_buffer\_size=4M  
max\_connect\_errors=80  
myisam\_sort\_buffer\_size=512M  
wait\_timeout=300  
interactive\_timeout=800  
connect\_timeout=80  
thread\_cache\_size=1024  
tmp\_table\_size=8M  
thread\_concurrency=12  
concurrent\_insert=2  
query\_cache\_limit=2M  
query\_cache\_size=256M  
query\_cache\_type=1  
transaction\_alloc\_block\_size=8192

[mysqldump]  
quick  
max\_allowed\_packet=512M

[myisamchk]  
key\_buffer\_size=256M  
sort\_buffer\_size=256M  
read\_buffer\_size=64M  
write\_buffer\_size=64M

[mysqlhotcopy]  
interactive-timeout

[mysqld\_safe]  
log-error=/var/log/mysqld.log  
pid-file=/var/run/mysqld/mysqld.pid  
open\_files\_limit=8192

As my server ([1and1.com](http://1and1.com)) httpd conf is set to /etc/httpd/conf.d/swtune.conf and the configuration is as below: at prefork.c:

StartServers 8 MinSpareServers 10 MaxSpareServers 20 ServerLimit 1536 MaxClients 1536 MaxRequestsPerChild 4000

I tried to explain everything that I changed to keep my server okay, but maximum time my server is down. Please help me which parameter can I change to keep my server okay and my sites can load fast. It is taking too much time to load my sites.