Some Websites Load Slow + Mysql Timeout
Feb 5, 2007
I'm hosting about 6 private websites on my server, and some have problems.
My biggest website is a vb forum with 30.000 members and 1.5 million posts.
When i browse with firefox i see that vb forum loads fast, but phpads which is integrated on the top and footer loads very slow. When i browse with IE, it takes like 10 seconds before the whole site is loaded and sometimes IE even crashes.
When i try to login on another website / admin panel (oscommerce), i get a mysql gone away error, that means timeout. But why does it show that? I ran mysqlreport and can't find anything why it should display mysql gone away.
# ./mysqlreport
MySQL 5.0.15-standard uptime 3 19:36:47 Mon Feb 5 11:08:10 2007
__ Key _________________________________________________________________
Buffer usage 78.94M of 96.00M %Used: 82.23
Write ratio 0.60
Read ratio 0.00
__ Questions ___________________________________________________________
Total 19.61M 59.47/s
Slow 9 0.00/s %Total: 0.00 %DMS: 0.00
DMS 7.17M 21.74/s 36.56
__ Table Locks _________________________________________________________
Waited 7.57k 0.02/s %Total: 0.05
Immediate 16.50M 50.03/s
__ Tables ______________________________________________________________
Open 1.27k of 1800 %Cache: 70.56
Opened 1.82k 0.01/s
__ Connections _________________________________________________________
Max used 47 of 500 %Max: 9.40
Total 2.62M 7.95/s
__ Created Temp ________________________________________________________
Disk table 6.77k 0.02/s
Table 635.25k 1.93/s
File 50.37k 0.15/s
I can't find any problems on the server which may lead to this strange problem.
The server load is normal, around 1 to 1.5. No weird errors in the apache error log or system log.
This strange behaviour started 2 weeks ago, and appears 2 to 3 time a week.
The system is running:
centos 4.3 64-bit
kernel 2.6.16.17 #1 SMP
directadmin 1.29.0
mysql 5.0.15
php 5.2
apache 2
Zend optimizer 3.2.0
Eaccelerator 1.95
One thing i noticed is that every night when the directadmin cron finished, the server acts normal again.
The directadmin cronjobs are:
* * * * * root /usr/local/directadmin/dataskq
2 0-23/6 * * * root echo 'action=vacation&value=all' >> /usr/local/directadmin/data/task.queue;
#5 5 * * 0 root /sbin/quotaoff -a; /sbin/quotacheck -augm; /sbin/quotaon -a;
20 4 1 * * root echo 'action=reset&value=all' >> /usr/local/directadmin/data/task.queue
0 4 * * * root echo 'action=check&value=license' >> /usr/local/directadmin/data/task.queue
10 0 * * * root /usr/local/directadmin/plugins/awstats/hooks/cgi-bin/awstats_updateall.pl now -awstatsprog=/usr/local/directadmin/plugins/awstats/hooks/cgi-bin/awstats.pl && echo 'action=tally&value=all' >> /usr/local/directadmin/data/task.queue
View 1 Replies
ADVERTISEMENT
Jul 26, 2015
I am running Plesk Version: 12.0.18 on CentOS.Earlier today my service provider had a massive issue and my server was down for several hours. Upon it being back online i've restarted but now I cannot load any of my pages. I have 10 domains setup and if I ping their name servers or the server IP i get packets received now.
One of my installed domains is [URL] ... now if you try and load this url you get a time out but if you try to access admin page URL....None of the subscriptions are able to load their websites when i type in their URL and well it worked before it went down.
View 19 Replies
View Related
Jun 29, 2008
server load is low according to top command / mytop but what I dont understand all websites on the server are loading very slow.
View 10 Replies
View Related
May 13, 2008
all websites on one of my server open very slow..in firefox it just kep saying Waiting.. for at least 10 secs and data is transfered.
contents of my.cnf
[mysqld]
safe-show-database
#old_passwords
back_log = 50
skip-innodb
max_connections = 500
key_buffer_size = 144M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 5000
thread_cache_size = 256
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 6M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_write_lock_count = 16
[mysqld_safe]
nice = -10
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 384M
sort_buffer = 384M
read_buffer = 256M
write_buffer = 256M
httpd.conf
KeepAlive: Off
MaxKeepAliveRequests: 100
KeepAliveTimeout: 1
MinSpareServers: 10
MaxSpareServers: 15
StartServers: 10
MaxClients: 150
MaxRequestsPerChild: 1000
View 11 Replies
View Related
Dec 20, 2007
I've been having trouble with my VPS for a while now. In the QoS alerts page in Virtuozzo it seems to be a problem with numtcpsock and tcprcvbuf, mainly numtcpsock.
Copy these into the browser:
i18.photobucket.com/albums/b106/gnatfish/qosnumtcpsock2.jpg
And when i run cat /proc/user_beancounters:
i18.photobucket.com/albums/b106/gnatfish/beancounters2.jpg
This line is particularly scary:
numtcpsock 164 164 166 166 7321
What do i need to do, to get the website running again? It's only one site on the vps a proxy. So i thought a vps would be able to handle one proxy.
View 1 Replies
View Related
Nov 11, 2008
I've got 25 domains on a Virtuozzo/Plesk8.6/CentOS5 VPS. Each domain has one up-to-date install of WordPress, most have very little traffic (average 200mb per month), maybe 2 domains get 5-7gb traffic per month.
I monitor port 80 connections and rarely see more than 10 at a time.
That should in my opinion be no problem at all for a VPS with 768mb guaranteed ram and 2.4ghz cpu. I've got 30gb hard drive spare too.
But.... about 8 or 10 times a day it grinds to a complete halt: server load at 500-1000%, sites timing out, plesk takes 3mins to load, often I can't even connect with SSH, and the plesk web server, apache
INSERT INTO module_watchdog_sys_stat (time, type, value, service_id) VALUES(FROM_UNIXTIME(1226404705), 'MAINMEM_USAGE', 17472, 11);
80 seconds sounds like a huge amount of time for a MySQL insert to me! Does anyone know if this is likely to be the cause of my trouble? Some problem with Plesk and the database? Or could it be something else?
View 3 Replies
View Related
Mar 26, 2015
My Plesk installation and websites are slow
OVH VPS
8G ram
100 G Harddisk
View 6 Replies
View Related
Jan 12, 2008
We have an issue with websites load very slowly in a new server (centos) and we recieve an email from the server stating the following:
IMPORTANT: Do not ignore this email.
The hostname (ns.domain.com) resolves to . It should resolve to
xx.xxx.xxx.90. Please be sure to correct /etc/hosts as well as the 'A'
entry in zone file for the domain.
Some are all of these problems can be caused by
/etc/resolv.conf being setup incorrectly. Please check this file if
you believe everything else is correct.
You may be able to automaticly correct this problem by using the ' Add an A entry for your hostname ' under ' Dns Functions ' in your Web Host Manager
and when we restart "DNS Server (BIND)" or "named" we get as part of the output the following:
view localhost_resolver: received notify for zone 'domain.com': not authoritative
Please find below the contents of /etc/hosts , /etc/resolv.conf and /etc/sysconfig/network:
/etc/hosts:
::1 localhost6.localdomain6 localhost6
# Do not remove the following line, or various programs
# that require network functionality will fail.
XX.xxx.xxx.90 ns.domain.com ns
127.0.0.1 localhost
/etc/resolv.conf :
#domain domain.com
#search domain.com
#nameserver 127.0.0.1
nameserver xx.xxx.xxx.92
nameserver xx.xxx.xxx.93
/etc/sysconfig/network:
NETWORKING=yes
NETWORKING_IPV6=yes
GATEWAY=xx.xxx.xxx.xx
HOSTNAME=ns.domain.com
DOMAINNAME=domain.com
So what could be wrong with the above settings?
View 5 Replies
View Related
Jul 9, 2014
I am creating new sites in my panel and they are only loading the default page.
The IP is pointed correctly or I would not get the default plesk page.
All the other service seem to work ok. I can ftp in and I can edit files with the online file manager.
If I use the preview feature I can see the changes I make to the files, but that is the only way.
I looked in /var/www/vhosts/system/ and the conf files are present.
What else can I check to see why the sites are not working?
View 8 Replies
View Related
Oct 21, 2009
unfortunately my server crashes a lot recently. What happens is that some application creates a MySQL connection which hangs and then MySQL gets overloaded and takes the whole server down.
My question:
1. How do I configure MySQL to time out even on active connections ? I.e. after 30 seconds kill the process no matter if it is still active or not. Is that possible ?
2. How do I exclude the root user from that?
View 1 Replies
View Related
Nov 6, 2007
I'm having a bit of trouble here with MySQL, I don't know what to do. Centos 4.3, Mysql 4.1
Data is stored in /var/lib/mysql/
I'm looking to move that information to a second hard drive soon, and did a quick test of just copying it to another place on my existing drive. It won't start.
Quote:
[root@localhost ~]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
Error logs
Code:
071106 12:14:33 mysqld started
071106 12:14:33 [Warning] Can't create test file /var/lib/mysqltf/localhost.lower-test
/usr/libexec/mysqld: Can't change dir to '/var/lib/mysqltf/' (Errcode: 13)
071106 12:14:33 [ERROR] Aborting
071106 12:14:33 [Note] /usr/libexec/mysqld: Shutdown complete
071106 12:14:33 mysqld ended
071106 12:17:00 mysqld started
071106 12:17:00 [Warning] Can't create test file /var/lib/mysqltf/localhost.lower-test
/usr/libexec/mysqld: Can't change dir to '/var/lib/mysqltf/' (Errcode: 13)
071106 12:17:00 [ERROR] Aborting
071106 12:17:00 [Note] /usr/libexec/mysqld: Shutdown complete
071106 12:17:00 mysqld ended
I have tried even chmod 777ing the msyqltf folder (my copy) to no avail.
my.cnf
Code:
[mysqld]
datadir=/var/lib/mysqltf/
socket=/var/lib/mysqltf/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
I've tried moving it to different locations. I even tried moving the original folder and renaming it, and still get this problem.
View 14 Replies
View Related
May 14, 2009
I dont know much about what could be cuasing this so i come to you for advice, i am currently at wired tree on their VPS384 package with 348MB of ram and my site is really slow to load [url]sometimes it is so embaressing to show people i just dont bother, i am sure this is deferring visitors from my content how can i speed this up?
I can add more ram but it will push the price and if the price goes too high i might aswell move to a Hybrid with wiredtree.
View 13 Replies
View Related
Apr 24, 2008
My server gets 300 - 600 concurrent connections to http port 80, has a CPU load of 1 - 2%, has practically all RAM of 1 GB used, is running apache 2 and centos 5.
It tends to get slow and when I ban IPs that use many connections to my server (raping it), it becomes fast again. But soon after that new ******* users come which I again ban and the process repeats itself
I'm starting to think that maybe I just don't have enough RAM to handle them because it seems at least some of those users are legit. I don't however have even that much content that needs to be cached so I'm not sure what good RAM would do but perhaps apache just needs more.
View 10 Replies
View Related
Oct 30, 2009
I just installed mySQL server on a brand new dedicated server and am getting Timeout error occurred trying to start MySQL Daemon. I have uninstalled and reinstalled it a few times and am still getting the same error.
View 11 Replies
View Related
May 10, 2007
I am getting the error (as listed in the title) on my server. This is a BRAND NEW FRESH install on a brand new server...
OS: Unix Fedora
Kernel Version: Kernel 2.6.18-1/2798.fc6 on an i686
Hardware Information: Brand new Dell SC1435 Server
Software Version: MySQl 5
Control Panel: Nothing yet
Apache starts ok but when I go to strart MySQL I get the following error...
[root@server112]# /etc/rc.d/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon
Starting MySQL: [FAILED]
Does anyone have any ideas?
I did some pretty extensive searching...
Web Hosting Talk article that basically describes the same error. I followed everything as listed in his suggestion and it didn't change anything.
Also Checked here but this didn't work either.
View 6 Replies
View Related
Apr 12, 2007
My server has a small load (about 30% of it is being used) and it is still running very slow. When I reboot it runs fast for about 5-10 min, and then it is back to slow. I reported this to hivelocity and the responded with
"
The problem was one of your apache process was pegged out. Restarting apache resolved this issue. If you still have issues check top and run lsof on the process ID that is pegged out."
and after it continued
"It will continur to happen until you isolate the source of the issue and stop it.
The load looked fine just now, so I am not seeing an issue.
What you can do is when it pegs out (simply restarting webserver will get it back up but not resolve) run the following command:
ps -aux
Look through the processes to see what is calling it."
Whn I run ps -aux i see a username on my server. i suspended that username but the problem is still happening.
View 7 Replies
View Related
Jul 1, 2007
My machine is pretty good. Here are the specs:
Intel Xeon-Woodcrest 5148-DualCore
3 gigs of ram
250GB Western Digital WD Cavia
I run a forum with a modest amount of traffic along with a content management system handling the other sections of the website. I'm pretty sure the forum isn't the problem though.
The server load for this machine is almost never above a 1. Right now as I type this the load is at 0.17, but it's unbearably slow! Taking up to 16 seconds to load a single page.
What could be causing this? I'm a server n00b. Is there a setting I should be doing to one of my servers configuration files to make it run faster?
My website gets 30-40,000 visitors a day and these problems always occur during peak hours. It would be easier to deal with this though if not for the fact that the server load is always so low. How is it possible for the site to get so slow while the server load is always so low?
View 14 Replies
View Related
Aug 12, 2008
I'm having the oddest issue. For some reason, some of the websites on my server load fine, and some take a really long time to load (2 minutes).
Now, the server load is fine, and the size of the sites aren't the issue either. I've restarted Apache and a couple more services, and still the same sites seem to load very slow.
What could be causing this since it's only effecting certain websites?
View 14 Replies
View Related
Mar 11, 2009
I am currently hosting my website on one server with the specs:
2.8ghz Dual Quad-Core processor + 8 gigs of ram + two 500 hard drives with a 50 mbps unmetered bandwidth package.
My current problem lies in high server loads and very slow server performance throughout the day.
I am considering migrating over to The Planet onto server with the specs:
3.0ghz Dual Quad-Core + 18 gigs of ram + two 50gb hard drives with 2TB of monthly bandwidth transfer.
In an attempt to have great bandwidth pricing and server performance, I plan on downgrading my current server with my current host to a lowe-end server and keeping it only to host my VIDEO and MUSIC files with the 50mbps unmetered package. The Planet will then host my database and all other web related files on their new server.
Is this a good idea as an attempt to save money in bandwidth costs and eliminating my server lag issues?
I was offered a setup of a separate web and database server at my current host but from what I have read, no one touches the performance and reliability The Planet has to offer.
View 6 Replies
View Related
Apr 15, 2007
I recently started hosting a large vBulletin forum (14,014 registered users... 30-60 online at a time) on one of my dedicated servers. When there's a lot of activity on the forums, things start getting really slow. There will be like 50 php-cgi processes running. Some users get blank pages, others get this message:
Notice: Undefined variable: errfile in [path]/forums/includes/functions_log_error.php on line 163
Specs of the server are:
AMD Athlon 64 3000+
160GB SATA HDD
2GB DDR2 RAM
FreeBSD 6.2 (Hosted at AwkNet)
Could there be any Apache modifications I can make to increase performance, or anything else I could try?
View 6 Replies
View Related
Apr 17, 2015
I've been having a few issues with the control panel navigation is running slow even though I have heaps of resources available and free. The server is located locally and have no problems surfing websites attached to the same server.
When I login as admin, it can take 25 seconds to load into the first screen.
CPU GenuineIntel, Intel(R) Xeon(R)CPU E5649 @ 2.53GHz
Version Parallels Plesk v12.0.18_build1200140606.15 os_CentOS 6
OS CentOS 6.6 (Final)
Memory Available 6GB used 2.5-3GB
HDD: 300GB/ approx 130GB Free
I have tried issuing a /etc/init.d/psa restart command and has made no difference.
View 1 Replies
View Related
Jun 12, 2008
Due to LayeredTech price hike, i'm going to cancel my server with LT within two weeks.
Does anyone know an easy way to backup all the domians and mysql database in FreeBSD/DirectAdmin? Is there a built in feature in DirectAdmin that can do that?
View 5 Replies
View Related
Oct 12, 2007
I just added a database server in private network and moved the database for Vbulletin Forum to this server.
But some how, the Forum is loading extremely slow compare to before ( when it was on the localhost). Also, Compare to another website on server (using local database) it is much slower.
One thing good is the load is lower
2 servers are connected via 10mbs private link, both servers are at Softlayer.
webserver: Opteron 170, 2GB RAM, 73GB SCSI 15K
database: Quad Xeon 3220, 2GB RAM, 73GB SCSI 15K.
View 11 Replies
View Related
Dec 10, 2014
Today, without any change on the server side my single running website on my server started running low. After checking the running processes I realised I have these 8 processes running with high cpu load something that didn't had before.
4245 user 20 0 283m 103m 10m R 85.1 0.3 6:44.88 /usr/bin/php-cgi -c /var/www/vhosts/system/domain/etc/php.ini
4243 user 20 0 241m 68m 8736 R 83.8 0.2 6:33.45 /usr/bin/php-cgi -c /var/www/vhosts/system/domain/etc/php.ini
4259 user 20 0 254m 82m 8720 R 83.5 0.3 6:11.00 /usr/bin/php-cgi -c /var/www/vhosts/system/domain/etc/php.ini
4244 user 20 0 282m 103m 10m R 82.1 0.3 6:46.49 /usr/bin/php-cgi -c /var/www/vhosts/system/domain/etc/php.ini
4247 user 20 0 248m 76m 8712 R 78.8 0.2 6:50.31 /usr/bin/php-cgi -c /var/www/vhosts/system/domain/etc/php.ini
4264 user 20 0 258m 85m 8712 R 72.9 0.3 6:49.83 /usr/bin/php-cgi -c /var/www/vhosts/system/domain/etc/php.ini
apache error log doesn't show any warnings, errors.
View 4 Replies
View Related
May 1, 2014
VPS hosting, stats in my sig below. Have poor performance with a drupal and civicrm(drupal based) website and looking to troubleshoot.
Main issue is pages take too long to load, sometimes over 5 seconds and more! Below is my.cnf and MYSQLtuner results.
So my.cnf
Code:
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
[Code] .....
View 2 Replies
View Related
Dec 28, 2008
I'm running a forum system on my server. Loading pages that don't connect to the forum database load normal. Whenever I browse any page that connects to the forum database on my forum, the page either takes ages to load or times out loading. I never exceed using 14% of one of my two cores, I'm using a quarter of my 1.5GB ram. It's only been loading slow like this since I've switched from running Windows to Ubuntu Server 8.10. I enabled logging slow queries on SQL, but nothing's been recorded. I've installed the server packages through Webmin,
when I access the server through its local IP address it's still very slow.
View 13 Replies
View Related
Feb 25, 2007
I added the following to my.cnf and restarted mysql
log_slow_queries=/var/log/mysql/mysql_slow-queries.log
I saw at leat 53 slow queries, however, there is no such file in that folder.
View 9 Replies
View Related
Sep 23, 2008
Mysql server always busy and slow (in my VPS).
How I can know which website/account uses mysql very heavely?
or just any monitoring Idea?
I want to know which user is responsible of that overuse?
View 7 Replies
View Related
Dec 29, 2007
Modernbill v5 is extremely slow. It takes about 2-3 seconds to get to the next page or refresh. It took 5 seconds after clicking 'reports' tab.
In order process, it takes 3-5 seconds just to show the add-ons or update them after hitting "save add-ons". This is unbelievable. I'm using Firefox.
I'm on a cable connection
Server specs:
Dual Xeon 3.4GHz HT
4GB Memory
MySql 5
PHP 5.2.5
Apache 2.2
I applied these optimizations as suggested by an MB tech
Quote:
At the ModernBill level, We have the following custom configurations in our /lib-modernbill/include/config/config.php file:
$CONF["dbType"] = "mysqli";
$CONF["forceCLICurl"] = 0;
$CONF["enableSharedMemoryLocaleCache"] = true;
$CONF["enableSharedMemoryAdminCache"] = true;
$CONF["adminCacheSeconds"] = 300;
$CONF["enableSharedMemoryMBPathCache"] = true;
$CONF["smarty"]["enableCaching"] = true;
$CONF["smarty"]["cacheLifetime"] = 0;
$CONF["smarty"]["enableCompileChecking"] = false;
At the PHP level, we have the following in our php.ini (some of these were recommended in our documentation to start with):
max_execution_time = 300
memory_limit = 128M
error_reporting = 2039
display_errors = Off
register_globals = Off
/etc/my.cnf
[mysqld]
local-infile=0
datadir=/var/lib/mysql
skip-locking
skip-innodb
skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=32M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=500
max_connections=1500
interactive_timeout=10
wait_timeout=28800
connect_timeout=20
thread_cache_size=128
key_buffer=512M ## 128MB for every 1GB of RAM
join_buffer=4M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=4M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci
[mysql.server]
user=mysql
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
View 1 Replies
View Related