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.
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 RelatedThe 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 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)
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.
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
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...
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?
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
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
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..
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
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 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?
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 RelatedI've got a VPS which is serving as the main server for a number of sites. Web Server, SSH Server, and Mail Server.
What I've got running:
Apache2, PHP5, MySQL5, Dovecot, Postfix
One of the sites is a growing forum with a MASSIVE photo album. This is the site where I notice the most slowness.
Changing the server software is not an option - Only optimization.
Quote:
Originally Posted by httpd.conf
ServerTokens OS
ServerRoot "/etc/httpd"
PidFile run/httpd.pid
Timeout 300
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
<IfModule prefork.c>
StartServers 8
MinSpareServers 8
MaxSpareServers 13
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 50
</IfModule>
<IfModule worker.c>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
Listen 80
LoadModule auth_basic_module modules/mod_auth_basic.so
LoadModule auth_digest_module modules/mod_auth_digest.so
LoadModule authn_file_module modules/mod_authn_file.so
LoadModule authn_alias_module modules/mod_authn_alias.so
LoadModule authn_anon_module modules/mod_authn_anon.so
LoadModule authn_dbm_module modules/mod_authn_dbm.so
LoadModule authn_default_module modules/mod_authn_default.so
LoadModule authz_host_module modules/mod_authz_host.so
LoadModule authz_user_module modules/mod_authz_user.so
LoadModule authz_owner_module modules/mod_authz_owner.so
LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
LoadModule authz_dbm_module modules/mod_authz_dbm.so
LoadModule authz_default_module modules/mod_authz_default.so
LoadModule ldap_module modules/mod_ldap.so
LoadModule authnz_ldap_module modules/mod_authnz_ldap.so
LoadModule include_module modules/mod_include.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule logio_module modules/mod_logio.so
LoadModule env_module modules/mod_env.so
LoadModule ext_filter_module modules/mod_ext_filter.so
LoadModule mime_magic_module modules/mod_mime_magic.so
LoadModule expires_module modules/mod_expires.so
LoadModule deflate_module modules/mod_deflate.so
LoadModule headers_module modules/mod_headers.so
LoadModule usertrack_module modules/mod_usertrack.so
LoadModule setenvif_module modules/mod_setenvif.so
LoadModule mime_module modules/mod_mime.so
LoadModule dav_module modules/mod_dav.so
LoadModule status_module modules/mod_status.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule info_module modules/mod_info.so
LoadModule dav_fs_module modules/mod_dav_fs.so
LoadModule vhost_alias_module modules/mod_vhost_alias.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule dir_module modules/mod_dir.so
LoadModule actions_module modules/mod_actions.so
LoadModule speling_module modules/mod_speling.so
LoadModule userdir_module modules/mod_userdir.so
LoadModule alias_module modules/mod_alias.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_balancer_module modules/mod_proxy_balancer.so
LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
LoadModule proxy_http_module modules/mod_proxy_http.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so
LoadModule cache_module modules/mod_cache.so
LoadModule suexec_module modules/mod_suexec.so
LoadModule disk_cache_module modules/mod_disk_cache.so
LoadModule file_cache_module modules/mod_file_cache.so
LoadModule mem_cache_module modules/mod_mem_cache.so
LoadModule cgi_module modules/mod_cgi.so
Include conf.d/*.conf
User apache
Group apache
Quote:
Originally Posted by my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
I looked a lot - can not find solution ....
I want to transfer a file from [url]to [url]or [url]Without it will pass my localcomputer (slow upload)
It can be also a script i will install like this one - this is only for images
[url](remote)
I have Plesk 11.5 (service provider mode) on a Windows 2008 server IIS7.Most of my sites are developed in .asp and therefore i use a custom 500-100.asp error page that check s the IP of the visitor then displays either a friendly error, or if its my IP a full error of what has happened (it also emails me the error). This allows me to debug pages easily whilst developing and to keep an eye on anyone trying SQL Injection hacks on my sites (as the error and email also have session variables and IP address).I dont have root access to the server as it is a Webfusion dedicated server.I have following the Plesk documentation -
1) Switch on custom errors for the subscription
2) Look in virtual directories and navigate to error documents
3) Find the error in question (500:100) and change it to point at either a file or URL
FILE - I had the data centre add in the 500-100.asp error page in to the virtual template so that my page is available in the list of virtual files - this didn't work but that maybe because its not a static page??
URL - when i add the path it says its incorrect, if i add a fully qualified address, it accepts it but it doesn't work.give me a specific example of the URL that can be entered relative to the root as the format in the documentation isn't accepted. The last step is to restart IIS which is also an issue as i cant seem to do this from the Plesk panel..It is as if it isn't catching the 500:100 error, and only catching the general 500 error??
I am currently running Google Analytics/Urchin 5 (v5.7.02), on a server, the server has started to act up, (on its last legs etc) and now I am trying to transfer the Urchin Software to a new server, where it would work effectively.
However upon installing the urchin software on the new server and running it (localhost:9999), I am presented with An Action Items Page, and these following choices
Obtain Demo License
Buy License
Activate Pre-Purchased License
I choose ‘Activate Pre-Purchased License’ pop in the Serial number and complete the registration then…
---------------------------------------------------------
Urchin Licensing Center -- Error!
An error has occured during your transaction, please use the back button and correct the problem. The specific error message is:
• Unable to generate a license. Some possible reasons:
Your serial code is currently active <<< How do I disable it and use it on another server?
---------------------------------------------------------
So all I want to do is deactivate the serial and reactivate it on another server.
Does anyone have experience with this or a similar problem or have a solution to this problem. Any help be most appriciated.
Or even a Contact Number so that i can get some one over the phone!
This is the scenario, domain.com are setup on server1, however server2 also has the same profile of domain.com as we use ns3 and ns4 using domain.com. This works fine with the nameserver setup on server2.
However I encounter problems as the emails from server2 won't reach server1 as there are duplicate profile on server2.
My question is how do I setup the DNS in cpanel/whm from server2 so the emails from server2 will reach server1?
Server1 (www.domain.com)
ns1.domain.com
ns2.domain.com
Server2
ns3.domain.com
ns4.domain.com
I just want to use a server for file sharing, it will have nginx and that's it. I'm looking at centos, or freebsd, but I been using centos forever now and I'm not sure how to use freebsd, should I just stay with centos?
Do I tell my hosting provider to just install the OS and give me ssh action and that's it? Don't install any control panels or any other stuff? I want one domain and one subdomain on it though and ftp action.
Remote Spamassassin for Multiple Smartermail Server
I want to setup Remote Spamassassin(On Linux) for Multiple Smartermail servers. I want to the setup the spamassassin on a linux box
How i can setup this with multiple smartermail servers.
what is the fast and best way?
View 4 Replies View Related
