as default,we may install all the feature on the server,
but i find some shared hosting server provider install web httpd on the front,
and mysql on another one,
could you share your experience about how do you do now?
I am not being able to restart the server, or MySQL or httpd via SSH.
PHP Code:
root@server [~]# /etc/init.d/httpd fullstatusLooking up localhostMaking HTTP connection to localhostAlert!: Unable to connect to remote host.lynx: Can't access startfile http://localhost/server-statusroot@server [~]#
PHP Code:
root@server [~]# /etc/init.d/mysql reload/etc/init.d/mysql: line 244: kill: (3375) - No such processtouch: cannot touch `/var/lib/mysql/server.lubnan.us.pid': Read-only file system
i am using seperate server for sql .But my httpd server failed many time when i checked maximum number of httpd connection then my sql server using too many connection what is the reason of this problem . Is my sql server using as a slave in a ddos attack or sql server need http connection?
View 2 Replies View RelatedI heard of script which checks if httpd , mysql , named etc servies are down and make them up...
it keeps chechking all services after 5 mins
My httpd server continuosly failing i have to set or restart it manually how can i set auto incase if its restart failed.
View 11 Replies View Related24 hours ago something wired happend..
For some reason httpd is causing high serverload.
ATM : 22:44:17 up 22:17, 2 users, load average: 6.23, 6.12, 8.88
U
Will keep gooing up and httpd need to be restartet when serverload comes up to 30.
The traffic on the server is normal, no changes is made on the server.
my server will revert to its old host name and stop working. Old host name was (in) and the new one is (zonto). Then, the server will eventually crash HTTPD. There is enough ram, there is small cpu usage. HTTPD is restarted and then it says it can't connect to local host blah blah. I checked EVERYWHERE, the new host name is set. Is there a host name issue some where else? I change it via the hostname command and changed all of the files.
View 14 Replies View RelatedFor my website I have a server which houses all of my gallery IMAGES of my user profiles. There are over 100,000 images on the server and it's only purpose is to provide those images with http.
However, the http server also has PHP installed, and it's only purpose is for uploading new images. Therefore users eventually get redirected to the images server where they can upload the image.
This all works, but in the future I want to remove the PHP side to the server. I also want to change the whole server program from Apache to Lighthttpd. This is because, lighthttp is a very low overhead web server program, but also provides very little features.
So I was wondering, if I was to do so, and since PHP is not installed, then I would have to make the upload pages on the main http server (which has PHP and Apache). Then I would have to make the main server send the uploaded image to the the lighthttp server via some sort of the scp system call, via PHP. I know that this IS possible, but when it comes down to security holes and so on, would this method really be worth it?
Generally I want to have the lighthttp setup only because it eliminates having to have any dynamic content. Obviously this can also be done with apache (removing dyanmic content), but lighthttp may be more efficient for static content.
As you can see.. there are LOT of connections, checked the network traffic with the NOC, and there is no attack to this server, also, load average is just fine ( fine to handle thos 24000 connections ) :
Code:
top - 16:22:06 up 1 day, 4:10, 1 user, load average: 2.35, 1.92, 1.80
Tasks: 486 total, 3 running, 483 sleeping, 0 stopped, 0 zombie
Cpu(s): 18.1% us, 15.8% sy, 0.0% ni, 57.8% id, 8.0% wa, 0.3% hi, 0.0% si
Mem: 2074864k total, 2057424k used, 17440k free, 28292k buffers
Swap: 2048276k total, 536k used, 2047740k free, 1254496k cached
Code:
[root@server.com~]netstat -an | grep :80 | awk '{ print $5 }' | awk -F: '{ print $1 }' | sort | uniq -c | sort -n
1 165.98.162.70
1 189.131.41.44
1 189.148.21.71
1 189.162.12.79
1 190.40.197.20
1 190.40.221.8
1 190.42.165.10
1 190.56.52.170
1 190.82.40.239
1 190.83.16.78
1 190.86.112.232
1 196.218.61.109
1 200.0.251.141
1 200.107.182.157
1 200.117.132.42
1 200.127.9.187
1 200.127.93.33
1 200.26.154.213
1 200.45.154.172
1 200.45.95.106
1 200.55.33.114
1 200.64.167.167
1 200.65.120.103
1 200.65.224.31
1 200.65.90.116
1 200.81.215.68
1 200.86.145.51
1 200.91.196.101
1 201.13.148.63
1 201.216.210.81
1 201.217.21.18
1 201.221.165.235
1 201.223.163.188
1 201.223.58.53
1 201.225.168.66
1 201.229.227.19
1 201.232.67.214
1 201.252.177.89
1 201.42.47.152
1 201.66.167.80
1 208.35.120.69
1 213.230.57.171
1 213.99.203.36
1 217.15.46.97
1 41.250.35.182
1 62.57.223.4
1 64.12.116.198
1 66.50.4.169
1 70.157.51.76
1 80.103.194.241
1 80.103.244.9
1 80.35.105.72
1 81.167.76.64
1 81.172.59.38
1 81.184.125.159
1 81.42.136.159
1 83.175.216.139
1 83.34.75.215
1 83.40.177.122
1 83.56.243.100
1 83.61.202.162
1 84.172.114.77
1 84.76.47.159
1 84.78.51.134
1 85.59.105.82
1 85.59.44.144
1 85.84.196.176
1 87.217.248.132
1 87.9.3.227
1 88.13.59.80
1 88.14.151.83
1 88.243.44.243
1 88.6.193.57
1 89.52.119.106
1 91.5.25.69
2 148.240.103.239
2 148.240.106.145
2 189.160.98.131
2 189.164.91.133
2 190.24.64.111
2 190.5.196.42
2 195.159.192.94
2 195.160.204.167
2 200.122.26.161
2 200.255.166.196
2 200.58.31.210
2 200.65.200.61
2 200.81.220.213
2 200.82.241.167
2 201.20.119.160
2 201.228.198.9
2 201.228.81.192
2 201.240.236.4
2 201.243.14.219
2 62.83.224.234
2 69.134.194.23
2 80.58.205.32
2 81.36.149.153
2 82.158.193.220
2 83.29.165.39
2 83.33.149.36
2 84.202.151.213
2 85.201.148.63
2 87.19.141.251
3 189.162.4.190
3 190.40.133.222
3 190.6.165.21
3 190.65.7.162
3 200.116.118.133
3 217.216.179.124
3 62.141.241.95
3 83.147.147.5
3 84.18.27.169
3 84.32.123.132
3 84.43.139.236
3 88.226.253.180
3 88.7.73.248
4 189.149.5.151
4 189.158.190.132
4 190.20.81.151
4 200.124.163.127
4 88.244.203.111
5 201.240.15.181
8 212.163.9.11
38 201.143.175.190
46 190.82.179.24
24537
85 % of this apache requests, are in TIME_WAIT state as:
Code:
tcp 0 0 ::ffff:SERVERIP:80 ::ffff:85.48.70.56:49910 TIME_WAIT
tcp 0 0 ::ffff:SERVERIP:80 ::ffff:81.44.96.178:10681 TIME_WAIT
tcp 0 0 ::ffff:SERVERIP:80 ::ffff:200.106.71.33:15028 TIME_WAIT
tcp 0 0 ::ffff:SERVERIP:80 ::ffff:200.106.71.33:15028 TIME_WAIT
tcp 0 0 ::ffff:SERVERIP:80 ::ffff:66.201.171.211:20470 TIME_WAIT
tcp 0 0 ::ffff:SERVERIP:80 ::ffff:81.37.198.134:29218 TIME_WAIT
tcp 0 0 ::ffff:SERVERIP:80 ::ffff:83.52.36.230:28849 TIME_WAIT
Also, dmesg shows this.
Code:
ip_conntrack: table full, dropping packet.
printk: 643 messages suppressed.
ip_conntrack: table full, dropping packet.
printk: 844 messages suppressed.
ip_conntrack: table full, dropping packet.
printk: 665 messages suppressed.
ip_conntrack: table full, dropping packet.
printk: 755 messages suppressed.
ip_conntrack: table full, dropping packet.
printk: 667 messages suppressed.
ip_conntrack: table full, dropping packet.
printk: 735 messages suppressed.
ip_conntrack: table full, dropping packet.
printk: 664 messages suppressed.
ip_conntrack: table full, dropping packet.
printk: 760 messages suppressed.
ip_conntrack: table full, dropping packet.
printk: 666 messages suppressed.
ip_conntrack: table full, dropping packet.
printk: 606 messages suppressed.
ip_conntrack: table full, dropping packet.
printk: 723 messages suppressed.
ip_conntrack: table full, dropping packet.
ip_tables: (C) 2000-2002 Netfilter core team
ip_conntrack version 2.1 (8192 buckets, 65536 max) - 340 bytes per conntrack
printk: 257 messages suppressed.
I already tried to ha handle this using: echo "65535" > /proc/sys/net/ipv4/ip_conntrack_max, but the problem stills.
Im using a plain redhat es 4 server, latest kernel-smp, apache 2.x with mod_evasive.
I have a server that has server load showing at 25-40 (once it was even 53!), running like that for hours. The server has 4 cpus - and yet the sites on the server seem to run fine when I check them. What I'm wondering is, what exactly is load in this context; and how can load run so high like that without the server crashing?
According to top, the load is caused by httpd processes running under user 'nobody', that often take up double digit CPU percentage.
Does Apache always run under 'nobody'?
Is there any way to trace an httpd processes - which account it's for, or which physical script or URL is calling it?
And for top itself, the TIME field on one server of mine is in the format xx:xx (e.g. 3:25), on another it's TIME+ and in the format xx:xx.xx (e.g. 30:02.77). What exactly does this mean? I would asume it's minutes:seconds and minutes:seconds:hundredths, but while watching top it doesn't seem to correlate with that.
a topic long time ago that my server load is frequently high.
I'm talking about something like this
Server Load 158.86
Memory Used 28.2 %
Swap Used 99.57 %
[url]
The only way to solve this problem is to identify the load earlier and kill all httpd process. What I did was
#killall -9 httpd
#killall -9 httpd
#killall -9 httpd
x 30~40 times until no pid process found & the server load is back to normal.
On previous thread, I tried to update mysql & php and it works,
Right now again I am experiencing high server load again...
I'm very sure it's caused by httpd but I am still unable to find out the real cause of the problem and which account user is the culprit for causing this high load.
Can someone assist me by telling me where/how to begin with?
My Dedicated server is being slow - hopefully someone can give a helping hand
Processor: AMD Single CPU Dual Core Athlon 4200
Memory: 2048MB RAM
Primary Hard Drive: 160GB
Operating System : CentOS 4.x X86_64 Bit
Control Panel: CPanel
uplink port: 100
Apache version 1.3.37
php 4.4.4
When i go to my website or any page under the domain it's just white. Blank nothing, nada.
"Failed to receive status information from Apache. Unable to connect to local httpd server."
This error message appears when i click on "apache status".
Is this because of the network issue? Or is it because of something I did myself?
I did a google search and came up on some solution, I did them and nothing.
We have a VPS Server from one of the most reputable VPS Provider. We have 384 Guaranteed RAM and 1GB Burst. We have Dual Core AMD Opteron(tm) Processor 265 - 1795.503 MHz with 1024 KB cached allocated to our VPS.
It is only hosting 2 average forums (10-15 concurrent users in total) and 30 small websites, low traffic websites.
The problem we are having is, almost 3 times a week, the cPanel, named and apache services keeps stopping. I am monitoring our server when this is happen and prior to the event its only using about 300MB RAM and low CPU..
What could be causing this problem? Do I need to upgrade our RAM?
Our server is running; Plesk 11.0.9 and CentOS 5.7 it has a Q8200 CPU @ 2.33GHz and 2GB of RAM. Now there are just two websites on the server plus a couple of redirects/forwarding domains, although lots of domains are still on the server but turned off in Plesk. Both websites are OSCommerce sites and I just need to keep these sites going until the end of the year when we will switch to our new Joomla based website.
We have seen an increasing number of server crashes and after various checks of the logs, fitting a new BIOS battery, check of the hardware by EasySpace who host the server, installation of ClamAV, LMD and RKHunter (which did find some Trojans and Suspect software), I have traced it down to some external Http activity that is taking all of my CPU time and RAM. Here is a screen capture of the Htop listing and when I killed these processes the CPU and RAM went back to normal. The problem is that I usually have to restart the HTTPD service and sometimes things get so bad that the server crashes and I have to request a power cycle.
I trying:
Code:
[root@serwer /]# httpd restart
/usr/sbin/httpd restart: httpd not running, trying to start
/usr/sbin/httpd restart: httpd could not be started
Code:
[root@serwer /]# /etc/rc.d/init.d/httpd configtest
Syntax OK
Help
I keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
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
max_user_connections = 500
[mysqld_safe]
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
[mysqlhotcopy]
interactive-timeout
I have a cPanel server with 4GB RAM
My server hangs time to time, once or twice a day. This is the last status when it happens.
Server Load 75.90 (2 cpus)
Memory Used 92 %
Swap Used 65.78 %
When I was still inside SSH when it happens, the processes I can see inside "top" are a lot of httpd processes.
So I "killall -9 httpd", I had to do it 30~40 times
#killall -9 httpd
#killall -9 httpd
#killall -9 httpd
x 30~40 times until no pid process found & the server load is back to normal.
Before that, I check httpd fullstatus, they look very normal, same goes to what I see inside WHM Apache status & cpu usage status.
At first I thought it was a memory problem after consulting with a server admin, so I replaced all 4GB new ram stick (such a waste)
I have recently upgraded mysql server from 5.0.75 to 5.1.31 on my Ubuntu server 9.04 32 bit. After that when I am running phpmyadmin it is printing a warning :
Your PHP MySQL library version 5.0.75 differs from your MySQL server version 5.1.31.
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
Which server for mysql only?
This is sort of a continuation to this thread here
Based upon the screenshots I provided below. What server would best suit my needs. I need this server to be able to handle the mysql usage and server load.
This server will be only for mysql. The rest of the site (html, videos) will be hosted on a different server.
If you think these servers are not enough for this please let me know any suggestions you have pertaining to server specifications.
Server 1:
Dual Core
Core 2 Duo E4500 2.2Ghz 2MB Cache
500 GB SATA II Hard Drive
2 GB DDR2 SDRAM
Server 2:
Dual Core
Core 2 Duo E8400 3.0Ghz 6MB Cache
500 GB SATA II Hard Drive
4 GB DDR2 SDRAM
Server 3:
Quad Core
Core 2 Quad Q9300 2.5Ghz 6MB Cache
500 GB SATA II Hard Drive
4 GB DDR2 SDRAM
i have install a durpal on my centos server(php5,mysql5,suphp),
for some feature,
i get a lof of error like
---------
Warning: MySQL server has gone away query
---------
i try to google to find some solution,
but the issue is still here,
do you know any problem make this?
I have an older script that works well on the config below. Can anybody know where I find such boxes?
PHP version 4.4.7
MySQL version 4.1.22-standard-log
My site is getting big and my server can barely hold all the mysql processes.
Once I had a similar problem with bandwidth because my media files were eating quite a big chunk of it. So, I just bought a media server and changed some HTML to hotlink all the media from the media server. I would like to do something like that with my MySQL databases, to get some load off my main server.
Should I get my current host to cluster another server for mysql? Or can I use a completely different server (from a different webhost) for mysql?
I have A and B server, i linked a cross cable in both server second ethernet port.
I have A as 10.0.0.1 (eth02) and B as 10.0.0.2 (eth02).
Both can ping to each other.
Now how could i setup 10.0.0.2 mysql to accept connections from 10.0.0.2?
The idea is to setup in A server to be able to backup mysql or write to B server.
I have an issue with one of my scripts,it wont run on mysql 5.x
if its possible to run mysql 4.x and 5.x on the same server?
as you know most of servers use utf8 for mysql charset
1- i use following command to backup as utf8
PHP Code:
mysqldump -u root -p123 --default-character-set=utf8 forum > /db.sql
But it is latin1 as you see following
PHP Code:
CREATE TABLE `access` ( `userid` int(10) unsigned NOT NULL default '0', `forumid` smallint(5) unsigned NOT NULL default '0', `accessmask` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`userid`,`forumid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
why?
How would you offer MySQL 4.1.x and 5 on the same server for your customers?
Would you just change the port of MySQL 5, for instance 3307 so that both versions can coexist?
