Optimizing Dedicated Server With MYSQL And Busy Forum
May 11, 2009
Are 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...
View 12 Replies
ADVERTISEMENT
Dec 8, 2008
it'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
View 4 Replies
View Related
Jul 10, 2008
What 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?
View 7 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
May 24, 2007
Are there some simple things that we can do or perhaps request our server management to do to optimize our server? Not sure where to start or what to ask so would like to learn some more before speaking with the server management company. Often times, you need to know the right questions to ask.
View 3 Replies
View Related
Oct 4, 2007
I am having problems with apache going down at least once a day. In Plesk there is a watchdog that monitors the service and then restarts it, but tries 5 times and fails, so apache will still be down and monitoring released. I really don't know what is causing this problem, maybe I could get some help? (Server specs at bottom of post, hope this is all you need)
error_log shows:
Code:
[Thu Oct 04 12:05:43 2007] [notice] caught SIGTERM, shutting down
[Thu Oct 04 12:05:48 2007] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] Init: SSL server IP/port conflict: default-69-64-36-86:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:271) vs. webmail:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:344)
[Thu Oct 04 12:05:48 2007] [warn] Init: SSL server IP/port conflict: default-69-64-37-16:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:111) vs. *****:443 (/var/www/vhosts/*****/conf/httpd.include:12)
[Thu Oct 04 12:05:48 2007] [warn] Init: You should not use name-based virtual hosts in conjunction with SSL!!
[Thu Oct 04 12:05:48 2007] [notice] Digest: generating secret for digest authentication ...
[Thu Oct 04 12:05:48 2007] [notice] Digest: done
[Thu Oct 04 12:05:48 2007] [notice] mod_python: Creating 4 session mutexes based on 512 max processes and 0 max threads.
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:05:48 2007] [warn] Init: SSL server IP/port conflict: default-69-64-36-86:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:271) vs. webmail:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:344)
[Thu Oct 04 12:05:48 2007] [warn] Init: SSL server IP/port conflict: default-69-64-37-16:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:111) vs. *****:443 (/var/www/vhosts/*****/conf/httpd.include:12)
[Thu Oct 04 12:05:48 2007] [warn] Init: You should not use name-based virtual hosts in conjunction with SSL!!
[Thu Oct 04 12:05:48 2007] [notice] Apache configured -- resuming normal operations
[Thu Oct 04 12:06:40 2007] [warn] child process 25195 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25197 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25204 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25207 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25219 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25228 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25232 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25244 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25246 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25257 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25261 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25262 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25265 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25275 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25278 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25281 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25283 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25287 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25351 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25291 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25300 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25302 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25307 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25355 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25365 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25374 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25376 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25377 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25408 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25412 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25423 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25430 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25434 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25437 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25460 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25463 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25474 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25475 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25476 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25565 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25478 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25480 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25481 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25483 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25484 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25485 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25486 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25583 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25489 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25490 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25491 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25493 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25590 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:40 2007] [warn] child process 25591 still did not exit, sending a SIGTERM
[Thu Oct 04 12:06:42 2007] [notice] caught SIGTERM, shutting down
[Thu Oct 04 12:06:46 2007] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Oct 04 12:06:46 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:06:46 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:06:46 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:06:46 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:06:46 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:06:46 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:06:46 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:06:46 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:06:46 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:06:46 2007] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Thu Oct 04 12:06:46 2007] [warn] Init: SSL server IP/port conflict: default-69-64-36-86:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:272) vs. webmail:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:345)
View 6 Replies
View Related
Oct 22, 2009
The my sql seems to take much load in my VPs, configuration file is as follows
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-bdb
set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-bdb
set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
View 0 Replies
View Related
Jul 4, 2008
trying many hosting companies or datacenters.
I have a Vbulletin forum, the expected max visitors number is 3000 (peak time) , i dont allow attachemts at all (links only).
I need a managed dedicated server with server optimization service.
What server specifications would fit my forum and what is the price.
View 14 Replies
View Related
Apr 14, 2009
I am wanting my VPS Optimize to run at it best
I am also wanting MySQL on the VPS to run at it best
Which company do you recommend for VPS and MySQL optimizing?
View 1 Replies
View Related
Aug 12, 2007
i run a popular forum with at least 1000-1200 users online at any given time which reaches 2000-2500 at peak times...
i am using Invision Power Board.
Problem:
Server seems to lose connection with mysql server at peak loads with server load going upto 30.
The server is good enough for these type of loads...
Server Specs:
Code:
Dual AMD Opteron 248
4 GB RAM
CENTOS Enterprise 4.5 i686
Cpanel
The my.cnf file is as follows:
-----------------------------------
Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
long_query_time=4
key_buffer_size = 64M
query_cache_limit=32M
query_cache_size=256M
query_cache_type=1
max_connections=1024
max_user_connections=1024
interactive_timeout=20
wait_timeout=20
connect_timeout=6
thread_cache_size=256
key_buffer_size=64M
log-queries-not-using-indexes
join_buffer=8M
low_priority_updates=1
max_allowed_packet=16M
table_cache=2048
record_buffer=8M
sort_buffer_size=16M
read_buffer_size=4M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M
[mysql.server]
user=mysql
basedir=/var/lib
[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=128M
sort_buffer=128M
read_buffer=32M
write_buffer=32M
[myisamchk]
key_buffer=128M
sort_buffer=128M
read_buffer=32M
write_buffer=32M
[mysqlhotcopy]
interactive-timeout
----------------------------------------------
any changes that would bring down the server load?
Also, some entries from httpd.conf are as follows:
Code:
Timeout 30
KeepAlive Off
MinSpareServers 15
MaxSpareServers 40
StartServers 15
MaxClients 300
MaxRequestsPerChild 1000
View 14 Replies
View Related
Apr 14, 2009
I am wanting my VPS Optimize to run at it best
I am also wanting MySQL on the VPS to run at it best
Which company do you recommend for VPS and MySQL optimizing?
View 1 Replies
View Related
Nov 2, 2009
I optimized a mysql table of 2 million records and about 500MB.. it took about 15 minutes.. However, on the same DB now i have another huge table of 88 million records, it size is 2.2 GB and it has about 30 MB to optimize... my questions..
1.- How can I speed up the optimization process so it can take the less possible time? any tweaks to my.cnf?
2.- Should I repair it using phpmyadmin or just from the shell?
3.- Should I stop http traffic during this optimization?
This is a dedicated db mysql server that handles a large VB forum with 5-8 users online average:
Code:
Intel Xeon 3.2 x4 procs, 32 bits, 4 GB ram
/etc/my.cnf
Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
skip-bdb
query_cache_limit=1M
query_cache_size=48M
query_cache_type=1
max_connections=1200
interactive_timeout=100
wait_timeout=300
connect_timeout=10
thread_cache_size=128
key_buffer=48M
join_buffer=8M
max_allowed_packet=16M
table_cache=2036
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M
# Add
max_heap_table_size = 48M
tmp_table_size = 48M
low_priority_updates=1
concurrent_insert=2
[mysqldump]
quick
max_allowed_packet=16M
[mysql.server]
user=mysql
#basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries=/var/log/slow-queries.log
On the other side, i have the same hardware for the webserver..
View 2 Replies
View Related
Jun 14, 2008
What 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 Related
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?
View 3 Replies
View Related
Aug 29, 2007
Is 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 Related
Apr 27, 2009
I've VPS, I want to cutomize server busy message.
what i should do to cutomize this page?
View 4 Replies
View Related
Apr 20, 2008
Tailed 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
View 4 Replies
View Related
Feb 16, 2008
I have a friend which owns a 2k alexa rank forum using VB
The server hangs and he gets mysql connection error in logs
Quote:
Database error in vBulletin : mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
The server is a dual Pentium D with 4GB RAM
currently 600 users online and 20% RAM used
in rush hours there are 2000 users online and 50% RAM used
We want to optimize mysql - this is the current my.cnf
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 2000
key_buffer = 80M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 3M
table_cache = 2500
thread_cache_size = 384
wait_timeout = 15
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 = 8
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 64M
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
[mysql.server]
user=mysql
basedir=/var/lib
old-passwords = 1
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 64M
write_buffer = 64M
[mysqlhotcopy]
interactive-timeout
View 7 Replies
View Related
Mar 17, 2008
I 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?
View 5 Replies
View Related
Sep 6, 2008
A friend of mine has a VPS server from godaddy, the site he is hosting on this VPS is quite slow and times out a lot.
What would be the best option? Move out of godaddy? Upgrade the plan? or hire someone to optimize the server (apache/mysql).
If you would recommend the third option, it would be great if you can let me know about companies that provide this service.
View 6 Replies
View Related
Oct 25, 2007
i get anew VPS with Control Panel...
when i try to install the VB forum it's show me this warning Messege!
Code:
Error description: mysql_connect() [function.mysql-connect]: Access denied for user 'user_db'@'localhost' (using password:
YES) /home/*****/public_html/includes/class_core.php on line 274
The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.
how can i fix this problem in Mysql USER ?
View 14 Replies
View Related
Mar 21, 2007
i have a Pentium D 820, 2GB Ram at LT where i am hosting a few proxies. Using Centos and Directadmin.
It's realy fast and i am happy with it. The only problem i am facing is that load is jumping up to 60 sometimes but just for a few seconds. Especially when a lot of people are using the proxy and it slows down a bit. That affects only the proxified pages and not a few personal html sites i also host there.
At the moment i am seeing in top that the CPU usage varies from 0,2 to 8, 12, 21 etc but just for a second or two
here is the top output
Quote:
[root@server ~]# top
top - 12:46:18 up 23 days, 2:36, 1 user, load average: 0.36, 0.44, 0.29
Tasks: 353 total, 1 running, 351 sleeping, 0 stopped, 1 zombie
Cpu(s): 1.2% us, 0.5% sy, 0.0% ni, 98.3% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 2066668k total, 1297168k used, 769500k free, 53192k buffers
Swap: 2040244k total, 0k used, 2040244k free, 273108k cached
and another output
Quote:
[root@server ~]# top
top - 12:58:34 up 23 days, 2:48, 1 user, load average: 0.58, 0.39, 0.30
Tasks: 209 total, 4 running, 205 sleeping, 0 stopped, 0 zombie
Cpu(s): 16.9% us, 5.1% sy, 0.0% ni, 77.9% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 2066668k total, 1100760k used, 965908k free, 53196k buffers
Swap: 2040244k total, 0k used, 2040244k free, 276744k cached
and the number of connections on port 80
Quote:
[root@server ~]# netstat -an |grep :80 |wc -l
216
[root@server ~]#
is there any way to tweak or optimize the server so than it can cope better when a lot of people are using the proxy.
View 3 Replies
View Related
Mar 25, 2009
telling me that mysql is hitting loads of 25, which he says is very high and i don't quite know what it means. He is strongly recommending that i shld get another dedicated server for mysql alone.
So can i get some advice on how I can assess the validity of his recommendations? I see that my CPU is load is hitting 125-150% daily. So i suppose there is some truth?
He is recommending that i get a raid-5 which is best. How can i know a suitable configuration of a new server to get? Of course, if i got all the money in the world i shld buy the best. But with constraints on budget, i want to get one (if i really need a new server) that is good for current loads with some projected margins for growth.
View 14 Replies
View Related
Nov 1, 2009
I've a huge site that runs on PHP and MYSQL, I'm going to get a dedicated server and make it for MYSQL so I need to know what server should I get for MYSQL ?
does it need to have lots of ram or should I get high CPU ?
View 7 Replies
View Related
Apr 25, 2009
lets say my web server IP is A, and my dedicated MySQL server is B.
Apache and PHP have been installed on A. MySQL server has been installed and configured on B.
Im just wondering, do I still need to install MySQL client on the web server A?
View 9 Replies
View Related
Mar 11, 2007
I was trying to upgraded MySql on my godaddy V.dedicated server..
And basicly ive screwed it up somehow.
I need to get back up and running and could do with some help on the best way to do that..
Ive visited the MySql website.. ive been playing with the shell (a little too much thats why its screwed up) so i can access the server via that and the server is running
Operating System: Red Hat Fedora Core 2
Can anyone point me first of all to the right download. and maybe point me to a tutorial or give me some advice on installing.. if ive messed up mysql does this also have any impact on the php or anything else?
View 1 Replies
View Related
Jul 31, 2008
i am getting mysql down issues with my current dedicated server. I would like to move my database to a dedicated server where only mysql will be running. Just wondering if this will be faster than the localhost? I have planned to buy dedicated server from another hosting company so definitely there will be a good enough connectivity distance.
View 5 Replies
View Related
Feb 2, 2007
how can i change mysql variables in dedicated server?
WHM 10.8.0 cPanel 10.9.0-R57
CentOS 4.4 i686 - WHM X v3.1.0
View 7 Replies
View Related
Oct 23, 2008
my current servers are part of this mess with Alphared:
[url]
what I'm looking for:
static content main server:
average cpu, average ram
15-20gb data tops, but could use a fast drive
need about 6tb/m of higher quality bandwidth
2 machine cluster for forums
only thing on this will be vBulletin forums.
current database is about 6gb (~7 million posts)
averaging about 800 members active per 15 mins
this isn't for a business, so it all comes out of my pocket. however, after the $#@! with Alphared I do recognize the importance of a good host and I am willing to put money toward that as needed. however, my goal is in the $600-$800/m range for everything.
is that price range doable? if not, what is a reasonable price for what I'm asking? and can anyone recommend reliable hosts (especially one that can correctly setup the cluster for the forums).
View 3 Replies
View Related
