Mysql Server Busy And Slow
Sep 23, 2008Mysql 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?
ADVERTISEMENT
Optimizing MySQL On A Busy Server (4 Gigs Of Ram)
Dec 8, 2008it's getting to the point where I need to optimize MySQL to better handle a busy server.
These days it seems MySQL is using 30% - 60% CPU almost constantly. But, the good news is that I've got 4 gigs of ram on this box and their seems to be an access of 600mb free constantly throughout the day.
Is it possible to tweak MySQL to a little more RAM dependent and take some of the load off the CPU? It seems MySQL wont go over 300mb of ram at any given time.. I'm already working on optimizing the SQL Querys on the web page itself.
my.cnf (4.1.22-standard):
# 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
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
safe-show-database
old_passwords
back_log = 75
max_connections = 600
table_cache = 128
thread_cache = 32
wait_timeout = 60
interactive_timeout = 80
connect_timeout = 60
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 64M
query_cache_limit = 8M
query_cache_size = 100M
query_cache_type = 1
default-storage-engine = MyISAM
local-infile=0
thread_concurrency = 4
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
Optimizing Dedicated Server With MYSQL And Busy Forum
May 11, 2009Are there any services where an ADMIN can monitor DB usage on system and make some recommendations or even find SQL that is poorly written ...
I have a DUAL harpertown, 10GB RAM, and RAID
I have a typical, gallery, busy VB forum, and video script...
THe site traffic has not increased much but my Memory keeps getting chewed up... i already did some tuning that VBULLLETIN suggested... but the memory still goes... i need a tool or someone to just monitor the server for a day and grab as much diagnostic info as possible..
I suspect that its a single query giving problems cuz i have some custom coded pages...
I don't want to split the DB and HTTP request on diff servers cuz the traffic that i get shouldn't warrant it... for now...
VPS Incredibly Slow, Huge Numbers Of Slow MySQL Queries For Plesk/Watchdog
Nov 11, 2008I'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?
Server Seems Busy
Jun 28, 2007../logs/error_log
[info] server seems busy, (you may need to increase StartServers, or Min/MaxSpareServers), spawning 8 children, there are 6 idle, and 37 total children
../httpd.conf
StartServers 7
MinSpareServers 8
MaxSpareServers 13
I think it's already high values, Is it safe to increase it?
How To Track Busy Web On Server
Aug 29, 2007Is there a way I can track the HTTP traffic to which domain is running with high traffic. Due to traffic load I/O wait is increasing. I want to suspend the domain that have the large traffic to avoid down time.
View 4 Replies View RelatedHow To Customize Server Busy Message
Apr 27, 2009I've VPS, I want to cutomize server busy message.
what i should do to cutomize this page?
Apache Errors / Down Server Seems Busy
Apr 20, 2008Tailed apache logs and found this:
[Sun Apr 20 08:29:34 2008] [debug] proxy_util.c(1778): proxy: initialized single connection worker 0 in child 10308 for (*)
[Sun Apr 20 08:29:34 2008] [debug] proxy_util.c(1670): proxy: grabbed scoreboard slot 0 in child 10309 for worker proxy:reverse
[Sun Apr 20 08:29:34 2008] [debug] proxy_util.c(1670): proxy: grabbed scoreboard slot 0 in child 10310 for worker proxy:reverse
[Sun Apr 20 08:29:34 2008] [debug] proxy_util.c(1689): proxy: worker proxy:reverse already initialized
[Sun Apr 20 08:29:34 2008] [debug] proxy_util.c(1689): proxy: worker proxy:reverse already initialized
[Sun Apr 20 08:29:34 2008] [debug] proxy_util.c(1778): proxy: initialized single connection worker 0 in child 10309 for (*)
[Sun Apr 20 08:29:34 2008] [debug] proxy_util.c(1778): proxy: initialized single connection worker 0 in child 10310 for (*)
[Sun Apr 20 08:29:35 2008] [info] server seems busy, (you may need to increase StartServers, or Min/MaxSpareServers), spawning 8 children, there are 2 idle, and 45 total children
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1670): proxy: grabbed scoreboard slot 0 in child 10311 for worker proxy:reverse
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1689): proxy: worker proxy:reverse already initialized
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1778): proxy: initialized single connection worker 0 in child 10311 for (*)
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1670): proxy: grabbed scoreboard slot 0 in child 10312 for worker proxy:reverse
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1689): proxy: worker proxy:reverse already initialized
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1778): proxy: initialized single connection worker 0 in child 10312 for (*)
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1670): proxy: grabbed scoreboard slot 0 in child 10313 for worker proxy:reverse
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1689): proxy: worker proxy:reverse already initialized
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1778): proxy: initialized single connection worker 0 in child 10313 for (*)
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1670): proxy: grabbed scoreboard slot 0 in child 10314 for worker proxy:reverse
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1689): proxy: worker proxy:reverse already initialized
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1778): proxy: initialized single connection worker 0 in child 10314 for (*)
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1670): proxy: grabbed scoreboard slot 0 in child 10315 for worker proxy:reverse
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1689): proxy: worker proxy:reverse already initialized
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1778): proxy: initialized single connection worker 0 in child 10315 for (*)
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1670): proxy: grabbed scoreboard slot 0 in child 10316 for worker proxy:reverse
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1689): proxy: worker proxy:reverse already initialized
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1778): proxy: initialized single connection worker 0 in child 10316 for (*)
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1670): proxy: grabbed scoreboard slot 0 in child 10317 for worker proxy:reverse
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1689): proxy: worker proxy:reverse already initialized
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1778): proxy: initialized single connection worker 0 in child 10317 for (*)
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1670): proxy: grabbed scoreboard slot 0 in child 10318 for worker proxy:reverse
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1689): proxy: worker proxy:reverse already initialized
[Sun Apr 20 08:29:35 2008] [debug] proxy_util.c(1778): proxy: initialized single connection worker 0 in child 10318 for (*)
What on earth is all these proxy_util.c errors?
Also, I could not find any details in the httpd.conf file regarding StartServers, or Min/MaxSpareServers.
I'm using Centos 4 / Apache 2.2 / PHP 5 / Cpanel
Server Seems Busy, (you May Need To Increase StartServers, Or Min/MaxSpareServers)
Mar 17, 2008I have a pages with high load - load avg is about 10-20.
and in the error_log of the apache message:
[Mon Mar 17 18:10:19 2008] [info] server seems busy, (you may need to increase StartServers, or Min/MaxSpareServers), spawning 8 children, there are 6 idle, and 32 total children
I have in apache:
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeOut 1
StartServers 15
MinSpareServers 15
MaxSpareServers 20
MaxClients 256
MaxRequestsPerChild 500
What values should be of these parameters for the such high traffic pages?
Mysql Loading Very Slow
Dec 28, 2008I'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.
Mysql Slow Queries
Feb 25, 2007I 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.
Modernbill Is Really Slow / Mysql Optimizations
Dec 29, 2007Modernbill 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
Very Slow Query Time After Upgrade To Mysql 5
Apr 8, 2009We have a dedicated server and we host 4 news portals based on e107 and joomla.
My partner on Sunday has upgraded mysql from version 4 to 5. Now the server experiences very high CPU usage and query time on portals has been increased very much.
We used to have query times lower than 1 sec for the main page of [url](which is a site that receives about 2000 visits/day) and now query times are 5-15sec !
Does anybody know if this is makes sense ?
Below is the server Status from WHM :
-------------------------------------
cpdavd up
cpsrvd up
exim (exim-4.69-15.1_cpanel_maildir) up
ftpd up
httpd (2.2.11 (Unix)) up
imap up
interval up
mysql (5.0.67-community-log) up
named (9.3.4) up
pop up
rsyslogd up
spamd up
syslogd up
Server Load 6.97 (1 cpu)
Memory Used 49.4 %
Swap Used 0.23 %
Disk /dev/hda3 (/tmp) DMA+ 70 %
Disk /dev/hda5 (/) DMA+ 22 %
Disk /dev/hda1 (/boot) DMA+ 14 %
Below is the Server Information from WHM :
------------------------------------------
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz
Processor #1 speed: 2394.068 MHz
Processor #1 cache size: 2048 KB
Memory Information
Memory: 2064420k/2087424k available (2091k kernel code, 21752k reserved, 846k data, 236k init, 1169920k highmem)
System Information
Linux server.aktoweb.biz 2.6.20-1.2319.fc5 #1 Mon May 21 19:52:13 EDT 2007 i686 i686 i386 GNU/Linux
Physical Disks
hda: WDC WD3200AAJB-00TYA0, ATA DISK drive
hda: hw_config=600d
hda: hw_config=600d
hda: max request size: 512KiB
hda: 625142448 sectors (320072 MB) w/8192KiB Cache, CHS=38913/255/63<6>hda: hw_config=600d
hda: cache flushes supported
Current Memory Usage
total used free shared buffers cached
Mem: 2066428 1756324 310104 0 339576 486636
-/+ buffers/cache: 930112 1136316
Swap: 1052248 2428 1049820
Total: 3118676 1758752 1359924
Current Disk Usage
Filesystem Size Used Avail Use% Mounted on
/dev/hda5 288G 60G 213G 22% /
/dev/hda1 99M 13M 82M 14% /boot
tmpfs 1009M 0 1009M 0% /dev/shm
/dev/hda3 494M 215M 254M 46% /tmp
Below is the CPU/Memmory/Mysql Usage from WHM :
-------------------------------------------------
mysql42.707.300.0
Top Process%CPU 42.7/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
Top Process%CPU 42.6/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
giaprakigiapraki.com2.7012.111.7
Top Process%CPU 1.3httpd [urll] [/e107_plugins/pm/pm.php?inbox]
Top Process%CPU 1.1httpd [url] [/e107_plugins/forum/forum_viewforum.php?87]
Top Process%CPU 1.0httpd [url] [/e107_plugins/chatbox_menu/chatbox_iframe.php]
adsnetadsnet.gr1.177.900.7
Top Process%CPU 0.5httpd [adsnet.gr] [/www/delivery/lg.php?bannerid16&campaignid4&zoneid5&chan]
Top Process%CPU 0.4httpd [adsnet.gr] [/www/delivery/lg.php?bannerid50&campaignid6&zoneid15&cha]
Top Process%CPU 0.3httpd [adsnet.gr] [/www/delivery/lg.php?bannerid183&campaignid77&zoneid1&ch]
r40r40.gr1.073.340.0
Top Process%CPU 1.1httpd [r40.gr] [/index.php?optioncom_fireboard&Itemid188&funcshowcat&cat]
Top Process%CPU 0.5httpd [r40.gr] [/images/fbfiles/avatars/s_64.png]
Top Process%CPU 0.3httpd [r40.gr] [/index2.php?optioncom_jim&taskxml&no_html1]
root0.278.532.0
Top Process%CPU 0.2[kjournald]
alex123alexandroupoli.net0.030.270.0
Top Process%CPU 0.1httpd [alexandroupoli.net] [/e107_images/banners/banner468x60-alexandroupolinet.gif]
galfasgalfas.gr0.030.270.0
Top Process%CPU 0.1httpd [galfas.gr] [/racing/images/galfas_R40_banner.jpg]
eximstats0.000.000.3
nobody0.001.100.0
mailnull0.000.000.0
unauthenticated0.000.000.0
named0.000.10
Optimizing These Particular MySQL Slow Queries In WordPress
Jun 14, 2008What I did here was create /var/log/mysqld.slow.log for queries that are taking one second or longer. After around 36 hours, here is what I came up with. Since the file size of /var/log/mysqld.slow.log was 219KB, posting it in its entirety it not practical. Therefore, I used a program, the perl script known as mysql_slow_log_parser found on www.retards.org, to parse the mysqld.slow.log to make it easier to interpret and read. The result was that the original filesize of 219KB was converted to the smaller size of 14KB....
View 7 Replies View RelatedSome Websites Load Slow + Mysql Timeout
Feb 5, 2007I'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
How To Enable Slow-query Logging In MySQL
Apr 23, 2007how to enable slow-query logging in MySQL ? Im using mysql version 4.1.20
well i just added following line in my.cnf can you please tell me is it correct way or not?
Code:
log-slow-queries=/tmp/slow_queries.log
log-update = /var/lib/mysql/updates.log
Plesk 12.x / Windows :: PHP Connecting Over Localhost To MySQL Very Slow
Jan 27, 2015I have windows server 2012 and Plesk v12.0.18 #30 - I noticed speed problem.
When I try to connect to mySQL with:
$conn = new mysqli('localhost', 'joomla_***', '*****', 'joomla_test');
Connection takes 1 second!!!When I try to connect with '127.0.0.1' instead of 'localhost' connection takes 0,009 seconds.
1. I tried solution to add line '127.0.0.1 localhost' to c:windowssystem32driversetshosts - but no luck.
2. I tried to edit C:Program Files (x86)ParallelsPleskMySQLDatamy.ini - adding lines
bind-address=127.0.0.1
skip-name-resolve
then restarted mySql but 1 second lag time on connection was still there.
3. I even tried to disable IPv6 but still no luck
I guess all users windows windows server 2012 has the same problem??!?!...
Apache Seems To Be Busy But Load Is 0.00
Feb 12, 2007i'm hosting a forum (~80 simultalinous users online) In a VDS 512 MB RAM, Linux Debian with apache 1.3 and mysql 4.1 , php4.
Apache seems to be busy, pages don't even load, this can be resolved by restating apache. and after a couple of time (about 4 hours) it does the same thing again, and i do have to restart it again and looping ...
Here is my httpd.conf file :
Code:
Timeout 200
KeepAlive On
MaxKeepAliveRequests 200
KeepAliveTimeout 3
MinSpareServers 5
MaxSpareServers 15
StartServers 5
MaxClients 20
HostnameLookups Off
MaxRequestsPerChild 2000
Hostmonster - Site Shutdown Because Its Busy
Jun 3, 2009Wanted to share a bit (read vent a bit if you're cynical ).
Just got the following e-mail from hostmonster.
-----------
Dear Dale:
Your web hosting account for ibycus.com has been deactivated (reason: site causing performance problems).
Although your web site has been disabled, your data may still be available for up to 15 days, after which it will be deleted.
If you feel this deactivation is in error, please contact customer support as soon as possible.
Thank you,
Support
For support go to
Toll-Free: (866) 573-4678
-------------
Apparently, there are two files on my website that are being hit quite a bit, and causing the server to slow down. (I admit, its a busy site, and the files are very big).
The files aren't new there, and neither is the traffic, but the plug was pulled with no warning what so ever, and no offer of remediation on their part beyond refunding the remaining portion of my contract (I would hope so too!).
I can understand that they may not be able to continue to host my site due to the volume of traffic it generates, but they really could have handled this much better.
Inexpensive VPS For Busy PHPBB Forum
Jul 10, 2008What minimum VPS specs should I be looking for to support a PHPBB3 forum that uses 100GB/mth bandwidth and has 50 concurrent users at peak times (measured by PHPBB, so not real-time concurrent)?
And are there any suggestions for inexpensive ($30 or less) options that would be worth trying? Have never used a VPS before.
If not, are there any shared hosting providers that specialize in hosting message boards like PHPBB?
French Web Hosting To Handle Busy Site
Jun 8, 2009Can anybody suggest a large hosting company based in France?
I'm looking for hosting that can handle a high bandwith, high profile, busy website. We will require excellent customer support and a professional attitude.
Apache :: Busy Servers Reaches Maxclients
Jun 18, 2015I am using apache 2.2 webserver and tomcat 6 as app server.
I have two unix boxes (let say A and B) where apache is installed for load balancing purpose.
The issue is now and then I see that on both the server reaches to 250 busy servers which makes my site very slow and after some time the site is unaccessible.
When I see this I restart apache on both unix boxes and also restart my app server.
But that does not work. As soon as I start apache the httpd process ramps up to 12 (ps -ef | grep httpd) within a minute and the busy servers still remains at 250.
The only I have to do is wait and watch till the busy servers goes down to 250 and then site is back to normal.
Some times it takes hours for busy servers to go down below 250.
I dont understand that why even restarting apache and tomcat doesn't work. why the busy servers are still at 250. even after I restart.
This is what I have in httpd.conf
<IfModule worker.c>
ServerLimit 80
StartServers 2
MaxClients 250
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
I tried to increase MaxClients to 300, which also didn't work and apache or httpd process shuts down by itself.
Server Too Slow
Apr 9, 2007this is my server and i host only one site as upload image but it is too slow and usully apache down
how i can optimize this server please
Processor Information
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) 4 CPU 2.26GHz
Processor #1 speed: 2262.422 MHz
Processor #1 cache size: 512 KB
Memory Information
Memory: 1002104k/1015744k available (2150k kernel code, 12844k reserved, 716k data, 164k init, 98240k highmem)
System Information
Linux 2.6.9-42.0.3.EL #1 Fri Oct 6 05:59:54 CDT 2006 i686 i686 i386 GNU/Linux
Physcial Disks
Current Memory Usage
total used free shared buffers cached
Mem: 1003164 976220 26944 0 102932 471740
-/+ buffers/cache: 401548 601616
Swap: 1052216 171412 880804
Total: 2055380 1147632 907748
Slow Server ...
Jan 6, 2008frends now iam haveing dedicated server with pentium-4 and RAM is 2GB,my site online members is more than 100 members,now i feel slow in server,what i have add extra RAM or any chage in server
View 5 Replies View RelatedServer Is Slow
Jun 19, 2007Why is my hosting server usually slow and down?
CPU Usage : 100%
Main : >3GB (total physical memory: 3GB)
i dont know Do user access to website that are hosted on my server too crowded make server slow while bandwidth only have 4MB.
Slow Server
Sep 7, 2007Server is dead slow. Its 3.0 1GB Ram Plesk Lniux Red Hat E4 machine. The top -c result is as below.
197 total, 6 running, 191 sleeping, 0 stopped, 0 zombie
Cpu(s): 4.0% us, 1.7% sy, 0.3% ni, 0.0% id, 94.0% wa, 0.0% hi, 0.0% si
Mem: 1027556k total, 953880k used, 73676k free, 23604k buffers
Swap: 2040244k total, 102308k used, 1937936k free, 87872k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3167 mysql 15 0 288m 67m 4336 S 0.8 6.8 40:37.97 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --
3247 apache 18 0 125m 75m 4344 D 0.7 7.5 0:00.34 /usr/sbin/httpd
3039 root 26 10 13628 5808 2656 S 0.3 0.6 0:00.69 mytop
3250 apache 16 0 121m 71m 4520 R 0.3 7.1 0:00.35 /usr/sbin/httpd
4671 apache 15 0 141m 89m 6512 S 0.2 9.0 0:57.54 /usr/sbin/httpd
1882 popuser 15 0 4176 700 564 S 0.2 0.1 0:00.17 /usr/bin/pop3d Maildir
2111 popuser 15 0 4036 712 564 S 0.2 0.1 0:00.47 /usr/bin/pop3d Maildir
3327 apache 17 0 124m 73m 5556 R 0.2 7.3 0:00.50 /usr/sbin/httpd
1 root 16 0 3580 484 456 S 0.0 0.0 0:02.11 init [3]
2 root 34 19 0 0 0 S 0.0 0.0 0:14.01 [ksoftirqd/0]
3 root 5 -10 0 0 0 S 0.0 0.0 0:00.56 [events/0]
4 root 9 -10 0 0 0 S 0.0 0.0 0:00.00 [khelper]
5 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 [kacpid]
19 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 [kblockd/0]
40 root 10 -10 0 0 0 S 0.0 0.0 0:00.00 [aio/0]
20 root 15 0 0 0 0 S 0.0 0.0 0:00.00 [khubd]
39 root 15 0 0 0 0 S 0.0 0.0 4:09.01 [kswapd0]
186 root 25 0 0 0 0 S 0.0 0.0 0:00.00 [kseriod]
295 root 15 0 0 0 0 D 0.0 0.0 2:29.80 [kjournald]
1373 root 6 -10 2272 376 372 S 0.0 0.0 0:00.02 udevd
1606 root 6 -10 0 0 0 S 0.0 0.0 0:00.00 [kauditd]
1648 root 6 -10 0 0 0 S 0.0 0.0 0:00.00 [kmirrord]
1672 root 15 0 0 0 0 S 0.0 0.0 0:00.00 [kjournald]
1673 root 19 0 0 0 0 S 0.0 0.0 0:00.00 [kjournald]
2443 root 15 0 1608 528 456 D 0.0 0.1 2:14.13 syslogd -m 0
2447 root 16 0 2696 368 316 S 0.0 0.0 0:00.00 klogd -x
2474 rpc 15 0 3304 404 400 S 0.0 0.0 0:00.00 portmap
2493 rpcuser 18 0 2648 528 524 S 0.0 0.1 0:00.00 rpc.statd
2519 root 16 0 4672 188 152 S 0.0 0.0 0:00.10 rpc.idmapd
2590 root 15 0 1952 436 284 S 0.0 0.0 0:00.07 /usr/sbin/smartd
2599 root 19 0 1940 356 352 S 0.0 0.0 0:00.00 /usr/sbin/acpid
2659 named 16 0 43736 7664 1884 S 0.0 0.7 12:22.15 /usr/sbin/named -u named -c /etc/named.conf -u named -t /var/name
2702 root 16 0 4956 912 792 S 0.0 0.1 0:03.86 /usr/sbin/sshd
2715 root 16 0 3104 712 620 S 0.0 0.1 1:02.87 xinetd -stayalive -pidfile /var/run/xinetd.pid
2869 postgres 16 0 19772 1440 1332 S 0.0 0.1 0:00.08 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data
2873 postgres 18 0 10572 216 176 S 0.0 0.0 0:00.00 postgres: stats buffer
Server Is So Slow
Mar 5, 2007My server is so slow I don’t know where the problem is
Server Load from 2 to 8 Monthly bandwidth 1300 GB Unique visitor 4000 - 5000 daily Page loads 13.000 – 20.000
This is current server features
Intel Pentium 4 2.8Ghz 1024MB RAM Bandwidth: 1500GB
Server Slow To Load
May 14, 2009I 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.
Server Network Very Slow
Jun 22, 2009problem with my server running CentOS 5.3.
I noticed that there are huge pings to my server from time to time, example:
------------------
64 bytes from HOSTNAME (server-IP): icmp_seq=0 ttl=60 time=2.93 ms
64 bytes from HOSTNAME (server-IP): icmp_seq=1 ttl=60 time=2.70 ms
64 bytes from HOSTNAME (server-IP): icmp_seq=2 ttl=60 time=1901 ms
64 bytes from HOSTNAME (server-IP): icmp_seq=3 ttl=60 time=899 ms
64 bytes from HOSTNAME (server-IP): icmp_seq=5 ttl=60 time=2.69 ms
64 bytes from HOSTNAME (server-IP): icmp_seq=6 ttl=60 time=2.62 ms
64 bytes from HOSTNAME (server-IP): icmp_seq=4 ttl=60 time=2132 ms
64 bytes from HOSTNAME (server-IP): icmp_seq=8 ttl=60 time=2.57 ms
64 bytes from HOSTNAME (server-IP): icmp_seq=7 ttl=60 time=1190 ms
64 bytes from HOSTNAME (server-IP): icmp_seq=10 ttl=60 time=2.65 ms
64 bytes from HOSTNAME (server-IP): icmp_seq=9 ttl=60 time=1048 ms
64 bytes from HOSTNAME (server-IP): icmp_seq=12 ttl=60 time=2.74 ms
64 bytes from HOSTNAME (server-IP): icmp_seq=11 ttl=60 time=1205 ms
------------------
First I thought that it is network related, but most strange for me was that I did not have any packets lose.
Then I tried to ping from my server to other hosts - situation was the same - some ping were good and some were huge (700ms, 800ms, even 2000ms)
I checked:
cat /proc/sys/net/ipv4/netfilter/ip_conntrack_max
and it was 65536
Then I checked:
cat /proc/sys/net/ipv4/netfilter/ip_conntrack_count
and it was ~1600 so normal.
dmesg was showing such errors:
conntrack_ftp: partial 227 3331059707+13
Then I checked ifconfig, here is the output:
------------------
eth0 Link encap:Ethernet HWaddr 00:24:21:57:2B:6F
inet addr:MAIN=IP Bcast:BCAST=IP Mask:255.255.255.192
inet6 addr: fe80::224:21ff:fe57:2b6f/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:170557113 errors:0 dropped:2421127049 overruns:0 frame:0
TX packets:182047660 errors:0 dropped:46 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:2756835074 (2.5 GiB) TX bytes:79640621 (75.9 MiB)
Interrupt:82 Base address:0xe000
------------------
Strange for me was:
RX packets [...] dropped:2421127049
TX packets [...] dropped:46
I did not have such dropped information on all my other servers. Dropped counter for RX was constatnly increasing.
So I decided to restart all services on the server. After restarting network and ipaliases - problem disappeared. RX dropped counter is still rising, but I do not have any slowdowns on the server and pings are normal.
My question is - does anyone could have any idea what can casue my problem and how can I prevent this in the future?
Server Running Very Slow
Nov 6, 2009i have a strange problem at my server ,
i hosted 1 wesite ( forum script with no plugins )
when my traffic consuption reache to 25mbs the server running very slow for hours although the load avarage is very normal 1-2 Iowait 3% ram consumption 8-10Gb
my uplink port 1Gb and of course my DC said the connection is normal with no limitation
the server specs are good
Quad procs 7200 ,16Gb ram ,15K SCSI speed
connections reache to 2000-2500 per seconds