Apache Won't Start And MYSQL Optimization Server Experts
Jun 18, 2009
Can anyone recommend a Apached and MYSQL optimization expert? I just some optimization done on mysql and apache upgraded... but pache wouldn't restart with the following entries:
MinSpareThreads 25
MaxSpareThreads 35
ThreadsPerChild 25
if i remove above then it starts... but my CPU spikes and I am getting a ton of errors emailed to me:
Invalid SQL:
SELECT COUNT(DISTINCT(userid)) AS count FROM vb_session WHERE vb_session.userid>0 AND vb_session.lastactivity>1245294346;
MySQL Error : Out of memory (Needed 8388580 bytes)
Error Number : 5
Request Date : Wednesday, June 17th 2009 @ 09:39:06 PM
Error Date : Wednesday, June 17th 2009 @ 09:39:06 PM
Its constantly complaining about this same query and i thought i removed all of the vbulletin options...
i am pulling my hair out... cuz my server isn't swapping, ther are 0ver 8GBs in cache.... but my CPU goes up
Here is original problem thread...
[url]
2nd post has recommended config... and my subsequent probs
View 6 Replies
ADVERTISEMENT
Apr 6, 2008
[root@server1 ~]# service httpd start
no listening sockets available, shutting down
Unable to open logs
CENTOS Enterprise 4.6 i686 on standard - WHM X v3.1.0
apache 2.2
httpd.conf file was empty... I'm recompiling right now.
View 3 Replies
View Related
Jun 24, 2008
I have a fairly high end server in which I have installed SIM. SIM is restarting Apache up to 10 times a day, presumably due to high load causing un-availability.
On restart, Apache / MYSQL is stable until the load / mem usage begins to climb then it is restarted again. Here are my 'load' stats for today:
Load for today
High (2:18am): 4.63
Low (3:30am): 1.20
Mean: 1.84
Latest: 1.61
Mem usage for today
High (1:36am): 9,192.9 MB
Low (1:48am): 7,995.7 MB
Mean: 8,683.1 MB
Latest: 8,781.7 MB
I have seen it using 20GB RAM before.
I have tried to follow various optimisation guides but these seem tailored to less powerful servers.
The web application I run on this server is almost entirely MYSQL based, with thousands of DB calls a day. Across the entire system I probably get 200,000 bot hits per day or even more. At peak times search engine bots are literally hammering the server.
My server specs are:
# Processor: Quad-Core Xeon Processor * 8
# CPU Speed: 3Ghz
# RAM: 32 GB DDR2
# HDD: 36 GB 15k Raptor X2 + 1TB Sata
# OS: 32Bit CentOS
Changes / optimisation of the actual application is not possible.
My configuration files are:
My.cnf ....
View 11 Replies
View Related
Jun 2, 2008
I'm having issues after changing my system time and rebooting for whatever reason it didn't take effect but now my VMWare servers wont boot. I get this error when trying to run a vmware-cmd
[root@plexus ~]# /usr/bin/vmware-cmd -l
/usr/bin/vmware-cmd: Could not connect to vmware-authd
(VMControl error -14: Unexpected response from vmware-authd: 511 Error connecting to /usr/sbin/vmware-serverd process.)
[root@plexus ~]#
also when i try logging into the web interface same error.
View 5 Replies
View Related
Jan 27, 2007
I just switched to a new server - I went from a Dual Opteron 248 with 3GB of RAM to a Dual Clovertown with 4GB of RAM. Yet, despite having mild traffic right now, my load is rather high and my memory usage is like 80% (which is ridiculous, since that would mean I would be maxing out on the old box).
For some reason, my servers usually lose access when I get around 400 people on TEXT-BASED, non-MySQL pages? How is that possible? I have really solid servers, yet people running basic Pentiums with 1 or 2GB never run into this issue.
Is there any good, cheap site that would be able to properly optimize mySQL and Apache to lower the load and figure out why the memory usage is so high? Platinum Server Management never really got this done, so even though they're great for other support issues, please don't recommend them.
View 0 Replies
View Related
Jun 27, 2009
I've got a small box running as a fileserver with CentOS 5. Sometimes life is a little easier using a GUI for jobs rather than SSH.
As this is not accessible externally, I've got it to autologin to a non-privilaged user, and as part of that logon a VNC session is opened using the inbuilt remote desktop tool.
This was working perfectly, until I realised if I cold boot the server without a monitor attached, X11 wont start at all unless I attach a monitor to it.
I know I can start a VNC session from using vncserver, but this way allows me to logon to the server as if I was sat infront of it, rather than running an extra session.
Presumabley I can add something into /etc/X11/xorg.conf so X11 will start without a monitor hooked up?
View 1 Replies
View Related
Jul 2, 2008
My server is running a AMD Athlon(tm) XP 2000+ (1662 MHz)CPU
I only host one site, a vb forum on my server and its killing the CPU with only 80-100 people online.
The load averages are:
23.73 (1 mins) , 20.39 (5 mins) , 10.88 (15 mins)
and these are the processes that are making it slow:
Code:
ID Owner CPU Command
8003 mysql 34.1 % /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-f ...
7777 apache 2.1 % /usr/sbin/httpd
7911 apache 2.1 % /usr/sbin/httpd
8382 apache 2.1 % /usr/sbin/httpd
7857 apache 1.9 % /usr/sbin/httpd
7776 apache 1.8 % /usr/sbin/httpd
8384 apache 1.7 % /usr/sbin/httpd
7849 apache 1.6 % /usr/sbin/httpd
9159 root 1.6 % /usr/libexec/webmin/proc/index_cpu.cgi
7852 apache 1.5 % /usr/sbin/httpd
8790 apache 1.4 % /usr/sbin/httpd
8724 apache 1.2 % /usr/sbin/httpd
8775 apache 1.2 % /usr/sbin/httpd
8779 apache 1.1 % /usr/sbin/httpd
8841 apache 1.1 % /usr/sbin/httpd
155 root 1.0 % [kswapd0]
8752 apache 1.0 % /usr/sbin/httpd
8881 root 1.0 % /usr/bin/perl /usr/libexec/webmin/virtual-server/collectinfo.pl
8961 apache 1.0 % /usr/sbin/httpd
8759 apache 0.9 % /usr/sbin/httpd
8777 apache 0.9 % /usr/sbin/httpd
8956 apache 0.9 % /usr/sbin/httpd
8962 apache 0.9 % /usr/sbin/httpd ..
View 6 Replies
View Related
Oct 30, 2007
i run a fedora server with plesk 8 on it i was wondering if some one can help me to find the best way to optimize the databases on the server at once my servers contains many clients with unicode data in the database.
View 0 Replies
View Related
Mar 20, 2007
I currently have a server for proxy websites only.
I have disabled MySQL, is that ok?
Will my statistics software still work (awstats)?
What else can i disable or do to optimize the server for proxy websites.
I'm using the phproxy scripts.
View 0 Replies
View Related
Apr 21, 2008
So the site got featured on [url]and now the server is drowning...
The Coppermine Gallery usually hovers around 30~50 users daily and now, 1800, and im at a lost as how I should configure mysql to take on such a load. right now it takes about 10 secs or more to load a page and sometimes it would time out. Because it si coppermine, all pages are dynamic and can't be cached -_-"
Here's the my.cnf right now after i played around with the numbers
server spec
Opteron 170 (2ghz)
2gb ram
250 7200rpm
[mysqld]
set-variable=local-infile=0
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
#skip-networking
back_log = 75
key_buffer = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 7200
max_connections = 600
connect_timeout = 100
wait_timeout = 12000
tmp_table_size = 100M
max_heap_table_size = 64M
max_allowed_packet = 15M
max_connect_errors = 9999999
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 40M
query_cache_size = 150M
query_cache_type = 1
query_prealloc_size = 65536
tmp_table_size = 64M
query_alloc_block_size = 131072
default-storage-engine = MyISAM
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/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 = 16M
write_buffer = 16M
httpd.conf
Timeout 20
#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive Off
#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100
#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 15
##
## Server-Pool Size Regulation (MPM specific)
##
# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# ServerLimit: maximum value for MaxClients for the lifetime of the server
# MaxClients: maximum number of server processes allowed to start
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule prefork.c>
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 200
MaxClients 200
MaxRequestsPerChild 1500
</IfModule>
# worker MPM
# StartServers: initial number of server processes to start
# MaxClients: maximum number of simultaneous client connections
# MinSpareThreads: minimum number of worker threads which are kept spare
# MaxSpareThreads: maximum number of worker threads which are kept spare
# ThreadsPerChild: constant number of worker threads in each server process
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule worker.c>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
View 11 Replies
View Related
Jul 8, 2007
I have one bare server and installed everything myself. however, I found apache, mysqld can not automatically start after reboot, may I know how to enable them to automatically start after reboot?
View 5 Replies
View Related
Jan 25, 2008
I keep trying to restart Apache but it wont restart... I run a command line to restart it, but nothing happens. Here is what I have tried:
Quote:
-bash-3.1# chroot /home/fatehost.net/runtime_layeredpanel/
fatehost:/# /etc/
bash: /etc/: is a directory
fatehost:/# /etc/init.d
bash: /etc/init.d: is a directory
fatehost:/# /etc/init.d/httpd-users
Usage: /etc/init.d/apache2 start|stop|restart|reload|force-reload
fatehost:/# /etc/init.d/httpd-users start
Starting web server: Apache2(98)Address already in use: make_sock: could not bind to address 205.209.135.132:80
no listening sockets available, shutting down
Unable to open logs
fatehost:/# /etc/init.d/httpd-users restart
Forcing reload of web server: Apache2httpd (pid 5955) already running
.
fatehost:/# /etc/init.d/httpd-users force-reload
Forcing reload of web server: Apache2.
fatehost:/# /etc/init.d/httpd force-reload
Forcing reload of web server: Apache2.
fatehost:/# /etc/init.d/httpd-users restart
Forcing reload of web server: Apache2httpd (pid 13475) already running
.
fatehost:/#
fatehost:/# /etc/init.d/httpd-users start
Starting web server: Apache2(98)Address already in use: make_sock: could not bind to address 205.209.135.132:80
no listening sockets available, shutting down
Unable to open logs
fatehost:/# /etc/init.d/httpd-users stop
Stopping web server: Apache2.
fatehost:/#
fatehost:/# /etc/init.d/httpd-users start
Starting web server: Apache2(98)Address already in use: make_sock: could not bind to address 205.209.135.132:80
no listening sockets available, shutting down
Unable to open logs
fatehost:/#
fatehost:/# sudo /etc/init.d/httpd-users stop
bash: sudo: command not found
fatehost:/# su root /etc/init.d/httpd-users restart
Forcing reload of web server: Apache2httpd (pid 20391) already running
.
fatehost:/# /etc/init.d/httpd-users reboot
Usage: /etc/init.d/apache2 start|stop|restart|reload|force-reload
fatehost:/# reboot
WARNING: could not determine runlevel - doing soft reboot
(it's better to use shutdown instead of reboot from the command line)
shutdown: timeout opening/writing control channel /dev/initctl
init: timeout opening/writing control channel /dev/initctl
fatehost:/# WARNING: could not determine runlevel - doing soft reboot
bash: WARNING:: command not found
fatehost:/# (it's better to use shutdown instead of reboot from the command line)
> shutdown: timeout opening/writing control channel /dev/initctl
> init: timeout opening/writing control channel /dev/initctl
>
fatehost:/# /home/fatehost.net/runtime_layeredpanel
bash: /home/fatehost.net/runtime_layeredpanel: No such file or directory
fatehost:/#
View 6 Replies
View Related
Aug 29, 2013
After an unexpected server shutdown. We cant start mysql anymore.
Error: Could not complete the operation: defpackagemng failed: The process terminated unexpectedly. (Error code 1067) at Start service MySQL
View 4 Replies
View Related
Jan 13, 2013
Server easily install but it could not be start ,,,it says that Server Root must be a directory..
View 1 Replies
View Related
Dec 11, 2007
just got a new server and got my site up and running on it perfectly but ive noticed its a bit slower than my old server and i think this is down to my incorrctly optimized mysql setup. ive used the my.cnf off my old server with some minor edits but im wondering what people can suggest i change for the following server spec
AMD Athlon 64 X2 4200+
2GB DDR2
120gb Sata hd
currently my my.cnf is as follows
Quote:
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
old-passwords
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
max_connections=1000
key_buffer = 1M
long_query_time = 5
query_cache_size = 64M
query_cache_limit = 64M
max_allowed_packet = 5M
table_cache = 2000
max_heap_table_size=32M
tmp_table_size=30M
thread_cache_size = 256
sort_buffer_size = 32M
net_buffer_length = 8K
read_buffer_size = 6M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 32M
join_buffer_size = 3M
open_files_limit = 50000
#log-queries-not-using-indexes
low_priority_updates = 1
#loonsies
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
according to mysql tuning primer it reports the following
Quote:
-- MYSQL PERFORMANCE TUNING PRIMER --
- By: Matthew Montgomery -
MySQL Version 4.1.20-log x86_64
Uptime = 0 days 17 hrs 52 min 44 sec
Avg. qps = 15
Total Questions = 1028682
Threads Connected = 1
Warning: Server has not been running for at least 48hrs.
It may not be safe to use these recommendations
To find out more information on how each of these
runtime variables effects performance visit:
[url]
Visit [url]
for info about MySQL's Enterprise Monitoring and Advisory Service
SLOW QUERIES
Current long_query_time = 5 sec.
You have 0 out of 1028694 that take longer than 5 sec. to complete
The slow query log is NOT enabled.
Your long_query_time seems to be fine
WORKER THREADS
Current thread_cache_size = 256
Current threads_cached = 3
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine
MAX CONNECTIONS
Current max_connections = 1000
Current threads_connected = 1
Historic max_used_connections = 4
The number of used connections is 0% of the configured maximum.
You are using less than 10% of your configured max_connections.
Lowering max_connections could help to avoid an over-allocation of memory
See "MEMORY USAGE" section to make sure you are not over-allocating
MEMORY USAGE
Max Memory Ever Allocated : 243 M
Configured Max Per-thread Buffers : 41 G
Configured Max Global Buffers : 75 M
Configured Max Memory Limit : 41 G
Physical Memory : 1.90 G
Max memory limit exceeds 90% of physical memory
KEY BUFFER
Current MyISAM index space = 12 M
Current key_buffer_size = 1 M
Key cache miss rate is 1 : 14581
Key buffer fill ratio = 44.00 %
Your key_buffer_size seems to be too high.
Perhaps you can use these resources elsewhere
QUERY CACHE
Query cache is enabled
Current query_cache_size = 64 M
Current query_cache_used = 5 M
Current query_cache_limit = 64 M
Current Query cache Memory fill ratio = 8.42 %
Current query_cache_min_res_unit = 4 K
Query Cache is 15 % fragmented
Run "FLUSH QUERY CACHE" periodically to defragment the query cache memory
If you have many small queries lower 'query_cache_min_res_unit' to reduce fragmentation.
Your query_cache_size seems to be too high.
Perhaps you can use these resources elsewhere
MySQL won't cache query results that are larger than query_cache_limit in size
SORT OPERATIONS
Current sort_buffer_size = 32 M
Current record/read_rnd_buffer_size = 1020 K
Sort buffer seems to be fine
JOINS
Current join_buffer_size = 3.00 M
You have had 378 queries where a join could not use an index properly
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
If you are unable to optimize your queries you may want to increase your
join_buffer_size to accommodate larger joins in one pass.
Note! This script will still suggest raising the join_buffer_size when
ANY joins not using indexes are found.
OPEN FILES LIMIT
Current open_files_limit = 50000 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine
TABLE CACHE
Current table_cache value = 2000 tables
You have a total of 908 tables
You have 102 open tables.
The table_cache value seems to be fine
TEMP TABLES
Current max_heap_table_size = 31 M
Current tmp_table_size = 30 M
Of 3666 temp tables, 0% were created on disk
Created disk tmp tables ratio seems fine
TABLE SCANS
Current read_buffer_size = 5 M
Current table scan ratio = 1544 : 1
read_buffer_size seems to be fine
TABLE LOCKING
Current Lock Wait ratio = 1 : 4664
You may benefit from selective use of InnoDB.
View 11 Replies
View Related
Mar 13, 2007
PIV 2.8Ghz, 1GB Ram, MySQL 3.23, RHL E3.0
The servers load is vey bad, most of the time 7-8+ and the IO WAIT more than 60% which is decreasing server performace. Please help me to optimzie the MySQL specially. If you have the good my.cnf config please give me the complete config file.
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = connect_timeout=10
set-variable = interactive_timeout=100
set-variable = join_buffer_size=1M
set-variable = key_buffer=128M
set-variable = max_allowed_packet=16M
set-variable = max_connections=250
set-variable = max_connect_errors=10
set-variable = myisam_sort_buffer_size=16M
set-variable = table_cache=256
set-variable = thread_cache_size=32
set-variable = thread_concurrency=2
set-variable = wait_timeout=15
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries = /var/log/mysql-slow.log
long_query_time = 5
View 7 Replies
View Related
Nov 16, 2008
Server down after start apache! Too many connection!
When im start apache on server, its crashed.
I am see following error, in access log:
Where is issue and how can fix it?
-bash-3.1# tail -f /var/log/httpd/access_log
::1 - - [16/Nov/2008:20:54:23 +0330] "GET / HTTP/1.0" 403 5043 "-" "Apache/2.2.3 (CentOS) (internal dummy connection)"
::1 - - [16/Nov/2008:20:54:24 +0330] "GET / HTTP/1.0" 403 5043 "-" "Apache/2.2.3 (CentOS) (internal dummy connection)" ....
View 4 Replies
View Related
Jun 7, 2013
I am using Wamp server 2.2.
I recently made some changes to the Apache configuration to allow me to make a virtual host for the Zendframework. the change i made were as follows:
<VirtualHost 127.0.0.1>
ServerName zendy
DocumentRoot "C:workspacezendypublic"
SetEnv APPLICATION_ENV "development"
<Directory "C:workspacezendypublic">
DirectoryIndex index.php
AllowOverride All
Order Deny,Allow
Allow from all
</Directory>
</VirtualHost>
Since these changes were made, my wamp server will not start up. the wamp bar remain red.
What I have to do to find out/trace where the fault is?
View 3 Replies
View Related
Apr 9, 2009
someone to look at my DB and optimize it as it is running ridiculously high loads of 25. It is vbulletin. I'm only looking for professional companies for this job.
View 1 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
Nov 14, 2012
I'm running Apache 2.2 on Windows 7. I'm a casual user of the Apache server, and the server I'm running is only used to develop a Silverlight application on the local machine, nothing more. The following problem is apparently a non-systematic error (sometimes the server can startup, sometimes it cannot. If it cannot, it sometimes can after a reboot (a service startup race condition?))
I get error when starting the server: "The requested operation has failed!"
When I run "http.exe" from a command prompt I get:
Quote:
httpd.exe: Could not reliably determine the server's fully qualified domain name, using 10.0.0.100 for ServerName
(OS 10048)Only one usage of each socket address (protocol/network address/port) is normally permitted. :
make_sock: could not bind to address 0.0.0.0:80
No listening sockets available, shutting down
Unable to open logs
It does not write anything in the "error.log". It cannot? why? rights? but it could yesterday! anything changed from yesterday, no nothing!
I have tried to start the server many times today, and it has not written anything in error.log. Looking in the log there are many entries from yesterday, when the server probably worked!?
Okay there most be something using port 80 then!
Output from "netstat -o -n -a | findstr :80" is nothing! netstat says there is nothing listening on port 80.
I'm running SQL Server 2008 Express, and "Reporting Service" would be a prime candidate for listening on port 80, but netstat says it is not!
I'm using the ZoneAlarm firewall (the Apache server has been given full trust and permissions), and it has worked previously, I belive it cannot be the problem.
I'm using Avast anti-virus, but everything is disabled in it, and I'm only using it to run a virus check from time to time.
(I don't think it has anything to do with the "fully qualified domain name", because the setting it is complaining about has always been the same, also when the server is actually working, from time to time)
View 2 Replies
View Related
Jul 8, 2007
On one of my servers (Intel P4 2.8Ghz, 1GB RAM, cPanel), I've been tweaking some of the MySQL values in my.cnf and using the MySQL Tuning Primer shell script to evaluate the results.
This is my current my.cnf. I'm running MySQL 5.0.27.
Code:
[mysqld]
set-variable = max_connections=500
safe-show-database
skip-innodb
long_query_time=5
log-slow-queries=/var/log/mysql/log-slow-queries.log
query_cache_type=1
query_cache_size=16M
query_cache_limit=1M
table_cache=512
key_buffer=150M
thread_concurrency=2
thread_cache_size=80
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=768K
The tuning primer script is telling me the following.
PHP Code:
Current max_heap_table_size = 16 MCurrent tmp_table_size = 32 MOf 3875 temp tables, 52% were created on diskEffective in-memory tmp_table_size is limited to max_heap_table_size.Perhaps you should increase your tmp_table_size and/or max_heap_table_sizeto reduce the number of disk-based temporary tables
What values should I increase (if at all) max_heap_table_size and tmp_table_size to?
View 3 Replies
View Related
Feb 16, 2007
Code:
mysql> SHOW STATUS;
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 510 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 441269798 |
| Bytes_sent | 2031527307 |
| Com_admin_commands | 27428 |
| Com_alter_db | 0 |
| Com_alter_table | 4 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 27481 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 16883 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 5515 |
| Com_insert_select | 379 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 1 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 154467 |
| Com_set_option | 132 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 7 |
| Com_show_charsets | 33 |
| Com_show_collations | 33 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 6 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 17 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 2 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 38 |
| Com_show_variables | 79 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 38964 |
| Com_update_multi | 0 |
| Connections | 306 |
| Created_tmp_disk_tables | 6302 |
| Created_tmp_files | 3 |
| Created_tmp_tables | 26220 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 7984 |
| Handler_discover | 0 |
| Handler_read_first | 10826 |
| Handler_read_key | 80354286 |
| Handler_read_next | 921590052 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 2852179 |
| Handler_read_rnd_next | 358019891 |
| Handler_rollback | 0 |
| Handler_update | 34804652 |
| Handler_write | 3299547 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 350900 |
| Key_blocks_used | 136652 |
| Key_read_requests | 177777142 |
| Key_reads | 234783 |
| Key_write_requests | 192997 |
| Key_writes | 70499 |
| Max_used_connections | 18 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 126 |
| Open_streams | 0 |
| Open_tables | 89 |
| Opened_tables | 124 |
| Qcache_free_blocks | 1493 |
| Qcache_free_memory | 101831304 |
| Qcache_hits | 247556 |
| Qcache_inserts | 154232 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 170 |
| Qcache_queries_in_cache | 2670 |
| Qcache_total_blocks | 6866 |
| Questions | 491633 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 15228 |
| Select_range_check | 0 |
| Select_scan | 42652 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 29 |
| Sort_merge_passes | 0 |
| Sort_range | 26186 |
| Sort_rows | 92603755 |
| Sort_scan | 28212 |
| Table_locks_immediate | 427295 |
| Table_locks_waited | 239 |
| Threads_cached | 1 |
| Threads_connected | 17 |
| Threads_created | 18 |
| Threads_running | 2 |
| Uptime | 9400 |
+----------------------------+------------+
163 rows in set (0.00 sec)
this is what SHOW STATUS; commands give me can anyone provide me any helpful tips on what I can adjust in my.cnf to lower my server load which is above 10 during peak hours and mysql is the only thing eating this serve up I have lots og 3gb ram and a 64bit AMD 2800 server
View 6 Replies
View Related
Apr 23, 2013
I've installed apache, php5 and php handler but couldn't able to the start the server and my error log is below.
stalling the Apache2 service
The Apache2 service is successfully installed.
Starting the Apache2 service
The Apache2 service is running.
ce] Apache/2.0.64 (Win32) configured -- resuming normal operations
[Mon Apr 22 21:16:59 2013] [notice] Server built: Oct 18 2010 01:36:23
[Mon Apr 22 21:16:59 2013] [notice] Parent: Created child process 1060
[Mon Apr 22 21:16:59 2013] [notice] Child 1060: Child process is running
[Mon Apr 22 21:16:59 2013] [notice] Child 1060: Acquired the start mutex.
[Mon Apr 22 21:16:59 2013] [notice] Child 1060: Starting 250 worker threads.
[code]....
View 7 Replies
View Related
May 2, 2014
I'm facing problem with latest Apache 2.4.9. Previously we used Apache 2.4.7 ​version which supports DER SSL certificates. But Latest Apache(2.4.9) is not working with DER SSL certificates. I have to convert DER certificate to PEM format to start the Apache server. Am i missing anything ? Is DER certificate not supported in Apache 2.4.9 ?
View 6 Replies
View Related
Jan 20, 2014
Problem detected!
19:58:32 [Apache] Port 80 in use by "Unable to open process" with PID 4!
19:58:32 [Apache] Apache WILL NOT start without the configured ports free!
19:58:32 [Apache] You need to uninstall/disable/reconfigure the blocking application
19:58:32 [Apache] or reconfigure Apache and the Control Panel to listen on a different port
19:58:32 [Apache] Attempting to start Apache app...
19:58:32 [Apache] Status change detected: running
19:58:33 [Apache] Status change detected: stopped
19:58:33 [Apache] Error: Apache shutdown unexpectedly.
19:58:33 [Apache] This may be due to a blocked port, missing dependencies,
19:58:33 [Apache] improper privileges, a crash, or a shutdown by another method.
19:58:33 [Apache] Press the Logs button to view error logs and check
19:58:33 [Apache] the Windows Event Viewer for more clues
19:58:33 [Apache] copy and post this
19:58:33 [Apache] entire log window on the forums
that is my error message I have changed skype's port from using port 80 and also uninstalled IIS from microsoft I have only installed xampp on its own without wamp server so that they dont conflict.
View 3 Replies
View Related
Jul 27, 2009
I'm trying to optimize a server (Intel E8300) with 8Gb of RAM and WHM/cPanel administration panel.
Now the server has only 46 accounts in WHM, and about 10.000 unique visitors / day
As mysql is always on top for CPU ussage I have edited 2 values in my.cnf, but this was done in 10 minutes and not to much research, any more help will be appreciated. On this server as I see it's been using MyISAM for storage engine and maybe just a few tabels with InnoDB ....
View 13 Replies
View Related
Jul 10, 2014
I'm testing on Windows 7 x64 SP1.
I have downloaded httpd-2.4.9-win32.zip from VC10 Win32 link which includes IPv6 Crypto apr-1.5.0 apr-util-1.5.3 apr-iconv-1.2.1 openssl-1.0.1h zlib-1.2.8 pcre-8.34 libxml2-2.9.1 lua-5.1.5 expat-2.1.0.
I unzipped and installed on my system. Configured SSL. I installed in directory C:Apache24
View 10 Replies
View Related
Oct 13, 2009
I am facing problem regarding my site. I have dedicated server with WHM/cPanel, i have integrated tomcat with apache , the apache processes are too high aroung 1200-1400, So please guide me howto optimize my apache for better performance.
root@trick [/]# ps aux | grep -c httpd
1403
root@trick [/]# ps aux | grep -c mysql
3
root@trick [/l]# free -m
total used free shared buffers cached
Mem: 4053 3408 645 0 220 1890
-/+ buffers/cache: 1297 2756
Swap: 4094 0 4094
---------------------------------------------
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
<IfModule prefork.c>
StartServers 10
MinSpareServers 10
MaxSpareServers 20
ServerLimit 1000
MaxClients 600
MaxRequestsPerChild 0
</IfModule>
View 7 Replies
View Related
May 25, 2009
I'm looking to get some tips to optimize my Apache webservers. Now i have 2 apache servers with load balancer. If someone can guide me and bring some tips for this purpose is highly appreciated.
Also, i would like to know about disadvantages of enabling KeepAlive. Recently i have enabled it and found my site load much better. But the disadvantage (that i experienced personally) is after stop browsing for a while (about 40-60 minutes) i need to keep triggering the URL of site several times to get enter the website. If not i can't get into it and it likes the site giving no response at all.
View 4 Replies
View Related
