I have a server facing to 150+ requests/sec. Using apache 1.3.39. The current config here
Timeout 15
KeepAlive Off
MaxKeepAliveRequests 10
KeepAliveTimeout 5
MinSpareServers 15
MaxSpareServers 20
StartServers 15
MaxClients 400
MaxRequestsPerChild 100000
I wonder if I can change anything to make site is faster? Currently, it's very slow. It's one core2duo box with 2GB RAM
drupal based flash archade website in that more 5000 visitors per day. I like to optimize the Apache & MySQL in best.
4GB RAM
Apache : 2.0.52
PHP : PHP 5.2.5
MySQL : 5.0.51
httpd.conf
KeepAlive Off
MaxKeepAliveRequests 50
KeepAliveTimeout 10
StartServers 16
MinSpareServers 8
MaxSpareServers 64
ServerLimit 1000
MaxClients 500
MaxRequestsPerChild 5000
ServerSignature On
my.cnf (Seprate box with 2GB RAM)
log-slow-queries = /var/log/mysql/mysql-slow.log
skip-external-locking
skip-locking
skip-innodb
skip-bdb
skip-name-resolve
max_connections = 800
max_user_connections = 800
key_buffer = 36M
key_buffer_size = 64M
myisam_sort_buffer_size = 64M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 3M
thread_stack = 128K
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 999999
query_cache_limit = 8M
query_cache_size = 64M
query_cache_type = 1
tmp_table_size = 16M
old_passwords=1
user=mysql
quick
quote-names
max_allowed_packet = 16M
[isamchk]
key_buffer = 16M
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)
We'd like to use this tool from Google on our Plesk server: [URL]
is it useful getting these tools going on server, and are they worth it?
I have a 512mb cPanel VPS and would like to try and save a bit more ram, I have made the below changes to the httpd.conf and have also turned spamd, entropychat, melange, mailman, the only webstats I have is AWStats
Code:
MinSpareServers 2
MaxSpareServers 5
StartServers 3
Can anyone recommend any other changes to save some more ram ?
For anyone wanting to know, the VPS is being used to serve my websites
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?
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.
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
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?
I remember seeing a website/forum where you couldn't post your server stats and httpd.conf settings and experts would give advice on settings you should use.
Does anyone know the url to this site, or site similar to it
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 RelatedI 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..
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
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.
I have four servers with a quad xeon, 4gb ram, and 2x300GB SAS 15K RAID0 harddrives, pushing a total of 1.6gbits. It serves a lot of zip files with an average flesize of 180mb. My question is, how can I optimize lighttpd 1.4.19 to push its max with very low IO-wait. I've looked up some stuff and only found options that deal with lighttpd 1.5 and use Linux-AIO for the backend network. Currently I use writev with 16 workers and an read/write idle timeout of 10s. Logging is off, too.
View 14 Replies View RelatedI am running a SQL test server here that is piping HUGE amounts of data for a test project I am running.
Approximately 30 queries a second - constantly. That's over 2.5M queries a day -- so we are talking big (I think?)
I am currently running this test on a
AMD Phenom 9300, 4GB RAM - SATA 500GB HDD and I am running MySQL 5.0.51a i386 on CentOS
I have programmed a process control for our applications purpose - basically it controls the launching of our SQL intense applications, and stops launching when the Load is greater than 2.5
I have plans to optimize the number of queries (I will build in a cache to some of the applications - and run INSERT statements all together) however I am looking for SQL tweaks that will improve performance. Would running the 64bit version work better?
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
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 RelatedAre 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...
Server Version: Apache/2.2.22 (Unix)
On our production service, we've been getting numerous malformed POST requests to some of our CGI scripts that are showing up as 500 errors in our logs. They are malformed in the sense that the actual content length doesn't match the Content-Length specified in the request.
Here's the most trivial example I can come up with that reproduces the problem for us:
POST /some_valid_alias HTTP/1.1
Host: example.org
User-Agent: Arbitrary/1.0
Content-Type: multipart/form-data; boundary=---------------------------41184676334
Content-Length: 769
-----------------------------41184676334
In addition to the 500 error in the access log, we see the corresponding error in the error log:
(70014)End of file found: Error reading request entity data
Based on the nature of the POST request and the error response, it does appear that Apache is doing the right thing here.
The POST never actually makes it as far as the script being targeted (/some_valid_alias in the above example); in other words, Apache returns 500 to the client, writes the error to the error log and never executes the script.
Is there a way to capture/avoid internal Apache errors like 70014, and return some other HTTP status besides 500 (like 403)? It's particularly annoying in our case, because our server sends us an email for all 500 errors.
So far, our best "defense" against these 500 errors is to disallow POST for these aliases, which normally just ignore the POST data anyway (when the request is not malformed):
RewriteCond %{REQUEST_METHOD} ^POST$
RewriteRule ^/(some_valid_alias)(.*)$ $1$2 [R]
But this won't work for all our scripts, because in some cases we do want to permit POST.
I've had this problem a long time now with my hosting network and decided to ask here hoping I get some good solutions, or if someone is willing to looking at this (I'll pay if they want).
Here's what I mean:
[url]
Problem is as you can see apache processes constantly rise infinitely, at least until I restart apache (/etc/init.d/httpd restart). The point of restart is shown in red lines.
And after restart, it goes down again for X amount of hours then eventually rises again infinitely until it's restarted again.
But the fact that after restart it remains down, it means it had the potential to be down all along.
So my question is: what could be causing this and does anyone have solution to keep them low at all times (as per graphs)?
The Linux Server got down when the MaxClients 256 is reached.
Error Log:
"server reached MaxClients setting, consider raising the MaxClients setting"
So that I have tried to increased the MaxClients Value to 500, after changed the value in httpd.conf and restart I get following error message.
" [notice] SIGHUP received. Attempting to restart
WARNING: MaxClients of 500 exceeds ServerLimit value of 256 servers,
lowering MaxClients to 256. To increase, please see the ServerLimit
directive."
So that I tried changed the Server limit in /usr/local/apache/include/httpd.h header file. but it seems like there is no entry.
Apache Version : 2.2.8
So I have added the ServerLimit 500 entry in httpd.conf file and restart the httpd service. But still shows the same warning mesg. Please help me regarding this.
We have the Dedicated server for Flash Game Server with following configuration.
RHEL4 OS
2GB RAM
Intel(R) Xeon(R) X3210 @ 2.13GHz
Cpanel Installed.
Apache 2.2.8
PHP 5.2.4
MySQL 4.1.2 (MySQL Server is working in differend server)
I have the following Apache redirect code in .htaccess:
RewriteRule ^sap-latest-news/([0-9]*)/([A-Za-z0-9_-.]*).htm$ /domain.com/app/modules/content/latestNews.php?id=$1 [L]
This redirect works fine on Apache 2.2.8, but doesn't work on Apache 1.3.41
The following is the entry from error_log:
RewriteRule: cannot compile regular expression '^sap-latest-news/([0-9]*)/([A-Za-z0-9_-.]*).htm$'
A simple Rewrite is working fine in Apache 1.3, but the above regualar expression doesn't seem to be working on Apache 1.3. Does anyone know whether Apache 1.3 doesn't support it?
I am having an issue where I have a server that Directadmin is installed on. I go to the a url that is on the server and all i see is the default page of apache saying congrats, it is installed. Although there is no file like that in the public_html any longer and I can see my files in the public_html folder of that specific site.
View 6 Replies View RelatedI've been searching around with google regarding how to downgrade the Apache 2.2 which comes with CentOS 5 to Apache 1.3.39.
View 2 Replies View RelatedI'm building a new server for a predominantly php5/mysql5 website and was wondering which version of apache to put on. I know there are some issues with PHP and Apache in MPM, but what's the performance comparison between Apache 1.3 and Apache 2 Prefork?
View 4 Replies View RelatedI am trying to install dedicated web server on my Slackware 12.0.0 machine. I am a novice in Linux, but succeeded in MySQL & proFTPd installation. The problem now in httpd compiling.
I downloaded the latest Apache 2.2.9, but it needs Apache Portable Runtime 1.3.2 installed. I downloaded 1.3.2 version and run ./configure
1. checking size of size_t... 4
2. checking which format to use for apr_size_t... %u
3. checking size of off_t... 4
4. checking for mmap64... yes
5. checking for sendfile64... yes
6. checking for sendfilev64... no
7. checking for mkstemp64... yes
8. checking for readdir64_r... yes
9. checking which type to use for apr_off_t... off64_t
10. checking whether ino_t and unsigned long are the same... yes
11. configure: using unsigned long for ino_t
12. checking size of pid_t... 4
13. checking whether byte ordering is bigendian... no
14. checking size of struct iovec... 8
15. checking for strnicmp... no
16. checking for strncasecmp... yes
17. checking for stricmp... no
18. checking for strcasecmp... yes
19. checking for strdup... yes
20. checking for strstr... yes
21. checking for memchr... yes
22. checking for strtoll... yes
23.
24. Checking for DSO...
25. checking for dlopen... no
26. checking for dlopen in -ldl... yes
27. adding "-ldl" to LIBS
28. checking for dlsym... yes
29.
30. Checking for Processes...
31. checking for waitpid... yes
32. checking for Variable Length Arrays... yes
33. checking struct rlimit... yes
34.
35. Checking for Locking...
36. checking for semget... yes
37. checking for semctl... yes
38. checking for flock... yes
39. checking for semaphore.h... (cached) yes
40. checking OS.h usability... no
41. checking OS.h presence... no
42. checking for OS.h... no
43. checking for library containing sem_open... none required
44. checking for sem_close... yes
45. checking for sem_unlink... yes
46. checking for sem_post... yes
47. checking for sem_wait... yes
48. checking for create_sem... no
49. checking for working sem_open... yes
50. checking for union semun in sys/sem.h... no
51. checking for LOCK_EX in sys/file.h... yes
52. checking for F_SETLK in fcntl.h... yes
53. checking for SEM_UNDO in sys/sem.h... yes
54. checking for POLLIN in poll.h sys/poll.h... yes
55. checking for PTHREAD_PROCESS_SHARED in pthread.h... yes
56. checking for pthread_mutexattr_setpshared... yes
57. checking for working PROCESS_SHARED locks... yes
58. checking for robust cross-process mutex support... yes
59. decision on apr_lock implementation method... SysV IPC semget()
60. checking if all interprocess locks affect threads... no
61. checking if POSIX sems affect threads in the same process... no
62. checking if SysV sems affect threads in the same process... no
63. checking if fcntl locks affect threads in the same process... no
64. checking if flock locks affect threads in the same process... no
65. checking for entropy source... /dev/urandom
66.
67. Checking for File Info Support...
68. checking for struct stat.st_blocks... yes
69. checking for struct stat.st_atimensec... no
70. checking for struct stat.st_ctimensec... no
71. checking for struct stat.st_mtimensec... no
72. checking for struct stat.st_atim.tv_nsec... yes
73. checking for struct stat.st_ctim.tv_nsec... yes
74. checking for struct stat.st_mtim.tv_nsec... yes
75. checking for struct stat.st_atime_n... no
76. checking for struct stat.st_ctime_n... no
77. checking for struct stat.st_mtime_n... no
78. checking for inode member of struct dirent... d_fileno
79. checking for file type member of struct dirent... d_type
80.
81. Checking for OS UUID Support...
82. checking uuid.h usability... no
83. checking uuid.h presence... no
84. checking for uuid.h... no
85. checking uuid/uuid.h usability... yes
86. checking uuid/uuid.h presence... yes
87. checking for uuid/uuid.h... yes
88. checking for library containing uuid_create... no
89. checking for library containing uuid_generate... -luuid
90. checking for uuid_create... no
91. checking for uuid_generate... yes
92. checking for os uuid usability... yes
93.
94. Checking for Time Support...
95. checking for struct tm.tm_gmtoff... yes
96. checking for struct tm.__tm_gmtoff... no
97.
98. Checking for Networking support...
99. checking for type in_addr... yes
100. checking if fd == socket on this platform... yes
101. checking style of gethostbyname_r routine... glibc2
102. checking 3rd argument to the gethostbyname_r routines... char
103. checking style of getservbyname_r routine... glibc2
104. checking if TCP_NODELAY setting is inherited from listening sockets... yes
105. checking if O_NONBLOCK setting is inherited from listening sockets... no
106. checking whether TCP_NODELAY and TCP_CORK can both be enabled... yes
107. checking for TCP_CORK in netinet/tcp.h... yes
108. checking for TCP_NOPUSH in netinet/tcp.h... no
109. checking for SO_ACCEPTFILTER in sys/socket.h... no
110. checking whether SCTP is supported... no
111. checking for struct ip_mreq... yes
112. checking for set_h_errno... no
113.
114. Checking for IPv6 Networking support...
115. checking for library containing getaddrinfo... none required
116. checking for library containing gai_strerror... none required
117. checking for library containing getnameinfo... none required
118. checking for gai_strerror... yes
119. checking for working getaddrinfo... yes
120. checking for negative error codes for getaddrinfo... yes
121. checking for working getnameinfo... yes
122. checking for sockaddr_in6... yes
123. checking for sockaddr_storage... yes
124. checking for working AI_ADDRCONFIG... yes
125. checking if APR supports IPv6... yes
126. checking langinfo.h usability... yes
127. checking langinfo.h presence... yes
128. checking for langinfo.h... yes
129. checking for nl_langinfo... yes
130.
131. Restore user-defined environment settings...
132. restoring CPPFLAGS to ""
133. setting EXTRA_CPPFLAGS to "-DLINUX=2 -D_REENTRANT -D_GNU_SOURCE -D_LARGEFILE64_SOURCE"
134. restoring CFLAGS to ""
135. setting EXTRA_CFLAGS to "-g -O2 -pthread"
136. restoring LDFLAGS to ""
137. setting EXTRA_LDFLAGS to ""
138. restoring LIBS to ""
139. setting EXTRA_LIBS to "-luuid -lrt -lcrypt -lpthread -ldl"
140. restoring INCLUDES to ""
141. setting EXTRA_INCLUDES to ""
142. configure: creating ./config.status
143. config.status: creating Makefile
144. config.status: creating include/apr.h
145. config.status: creating build/apr_rules.mk
146. config.status: creating build/pkg/pkginfo
147. config.status: creating apr--config
148. config.status: WARNING: 'apr-config.in' seems to ignore the --datarootdir setting
149. config.status: creating apr.pc
150. config.status: creating test/Makefile
151. config.status: creating test/internal/Makefile
152. config.status: creating include/arch/unix/apr_private.h
153. config.status: executing default commands
154. config.status: include/apr.h is unchanged
155. config.status: include/arch/unix/apr_private.h is unchanged
After that I am trying make and have error at the end:
make[1]: Entering directory `/root/build/apr-1.3.2'
/bin/sh /root/build/apr-1.3.2/libtool --silent --mode=link gcc -g -O2 -pthread -DHAVE_CONFIG_H -DLINUX=2 -D_REENTRANT -D_GNU_SOURCE -.....
In the middle of recompiling apache (via whm) after upgrading postgresql to 8.3, apache went down and remains down even after restart. Recompile is still in progress (about 15 minutes in)
tail -f /usr/local/apache/logs/error_log
[Wed Nov 12 15:24:44 2008] [warn] No JkShmFile defined in httpd.conf. Using default /usr/local/apache/logs/jk-runtime-status
[Wed Nov 12 15:24:44 2008] [notice] ModSecurity for Apache/2.5.7 (http://www.modsecurity.org/) configured.
[Wed Nov 12 15:24:46 2008] [warn] No JkShmFile defined in httpd.conf. Using default /usr/local/apache/logs/jk-runtime-status
[Wed Nov 12 15:24:46 2008] [alert] getpwuid: couldn't determine user name from uid 4294967295, you probably need to modify the User directive
[Wed Nov 12 15:24:46 2008] [alert] getpwuid: couldn't determine user name from uid 4294967295, you probably need to modify the User directive
[Wed Nov 12 15:24:46 2008] [alert] getpwuid: couldn't determine user name from uid 4294967295, you probably need to modify the User directive
[Wed Nov 12 15:24:46 2008] [alert] getpwuid: couldn't determine user name from uid 4294967295, you probably need to modify the User directive
[Wed Nov 12 15:24:46 2008] [alert] getpwuid: couldn't determine user name from uid 4294967295, you probably need to modify the User directive
[Wed Nov 12 15:24:46 2008] [notice] Apache/2.2.10 (Unix) mod_ssl/2.2.10 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_jk/1.2.25 PHP/5.2.6 configured -- resuming normal operations
[Wed Nov 12 15:24:46 2008] [alert] Child 22588 returned a Fatal error... Apache is exiting!
httpd configtest
Syntax OK
ps -ef | grep ^httpd (no result)
Cpanel/Centos
I have apache 1.3 and PHP 4.4 installed on my CentOS 4.4
Can I install apache 2.2 and PHP 5.x on the same server? I want to test my scripts for compatibility and also to check the performance.
I dont want to break my current setup because it's a production server.
if you were to be presented with a choice to run Apache 1 or Apache 2 given you'd have more or less the same support requests etc, and the same underlying user requirements to implement either one or the other, which one would you choose and why?
I noticed that Hsphere Parallels control panel 3.2 release as may well other control panels, offers such possibility. Personally I've been educated from senior members of previous organizations to appreciate Apache 1 as the defacto version of the web hosting industry (choice here being apache 1 and 2, not IIS or any other web servers)
Could you kindly simply attempt to enlighten me given, indeed support for both will/might remain the same in the future?
I am facing while upgrading the current Apache version 2.2.11 to Apache 2.4.4. IIS 7.5 on Windows Web Server 2008 R2 is not redirecting requests to the Apache 2.4.4 which is on Windows Server 2003 R2. I checked the access and error logs of Apache 2.4.4 and there is no entry. The existing 2.2.11 is working completely fine with IIS 7.5. IIS is working as a load balancer in my environment, takes the https requests and forwards that to Apache, then it goes to the App servers. Here, self signed certificate is used between the Load balancer and the Web server.
I have followed exact same configuration as it was used in Apache 2.2.11 but installed it with a different port (444), later changed it to 443 before running Apache 2.4.4 as a service, turning off the Apache 2.2.11 service. And also, my Apache 2.4.4 is working completely fine when I access it through the Web Server level URL (through the server machine name). But it throws me an error 502 when I hit the Load Balancer level URL. Here is the complete error:
"502 - Web server received an invalid response while acting as a gateway or proxy server. There is a problem with the page you are looking for, and it cannot be displayed. When the Web server (while acting as a gateway or proxy)contacted the upstream content server, it received an invalid response from the content server."
how I can solve the issue? I am stuck with this portion for about 2 weeks now, it's really urgent to get it solved!
My observation that came through lots of trial and error, I believe that this has something to do with Windows registry!! I came to this conclusion as I uninstalled the existing Apache 2.2.11 and installed it back again, it throws me the same error that I am getting for Apache 2.4.4. Then, I matched it with the other web server, found out some differences in the registry created for 2.2.11 and changed in this one accordingly- now 2.2.11 worked fine in this web server.