on my top process am having this one as shown in the attachement image
its consuming time+ of 746:21:95
on the Process Manager that mysqld process is using the command
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/host.theplanet.host.pid --skip-external-locking
is that process normal? and what is cousing it? should i kill it?
I have 2 identical Fedora8 boxes with Apache 2.2.8, MySQL 5.0.45 and PhP 5.2.4. I use one as the Web+DB server (say box A), and the other (box B) just as the Web server connecting to the DB server on box A. I use this 2 machine configuration to test a LAMP based-Web application. I have a client program on other machines that can emulate a massive web workload to these 2 servers; it can emulate hundreds to thousands of users using the application simultaneously.
Before running the test, the connection to the DB server from both boxes seem fine. Using the mysql client program on either box A or B trying to connect to the DB, the connection goes through instantly. In the /etc/my.cnf file, I have max_connections=4096 and max_user_connections=4096. Note that the web app uses one single db user to connect to the db. To allow remote connection, I inserted one record into the user table of the mysql db whose the host field's value is '%' (allow connection from all remote hosts).
After running the test (which I found out that many requests sent to box B failed), mysql client program on box A is still able to connect to the db instantly; but the one on box B has a problem: it takes extremely long (5 - 10 minutes or even more) to establish the connection, it doesn't time out, just takes that long. I believe that's the cause for the failure of requests to box B.
There is a too many mysql process (because of directadmin) but i don't want to. As i read it is related with compile options.
Is there a way turn off that setting to one mysql process ? OR how can i told to directadmin that i want to one mysql process ?
mysqq has a nice value of 6, is this fine? I read somewhere that it's better at a value of -5.
View 4 Replies View RelatedI have a constant mysql process using 10-20% CPU, its very strange because the process is always present, if I restart apache and mysql and I just open the phpmyadmin or any website connecting to the DB I get this error.
With strace I have seen that the process details are:
futex(0x87326c4, 0x5 /* FUTEX_??? */, 1) = 1
futex(0x8732174, FUTEX_WAKE, 1) = 1
select(15, [13 14], NULL, NULL, NULL) = 1 (in [14])
fcntl64(14, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(14, {sa_family=AF_FILE, path="ӿ"}, [2]) = 25
fcntl64(14, F_SETFL, O_RDWR) = 0
getsockname(25, {sa_family=AF_FILE, path="/var/run/mysql"}, [30]) = 0
fcntl64(25, F_SETFL, O_RDONLY) = 0
fcntl64(25, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(25, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(25, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
The strace show that this piece of code is being repeated everytime that any website or app is using the database.
I have seen that the process call to the path /var/run/mysql in:
getsockname(15, {sa_family=AF_FILE, path="/var/run/mysql "}, [30]) = 0
...but in my system the path doesnt exists, its /var/run/mysqld/ and I cant find a call to "/var/run/mysql" in any file of the server (i have tryed with sudo grep -nr '/var/run/mysql' /)
Server specs:
CENTOS Enterprise 4.6 i686
Linux 2.6.9-67.0.7.ELsmp
Core2Duo E6750
PHP Version 5.2.5
MySQL 5.0.45
How can see wich user have more mysql process?
View 2 Replies View Relatedhow do I stop mysql process for good?
service mysqld stop & killall mysqld don't do anything, mysqld stop and few minutes latter it restart again.
I run httpd with lxadmin.
When i login to the root for the server and go to mysql process list i see a lot of processes that are connected to photo handling and the sate is Locked with over 500 seconds of each one.
I see there is one process that the state says: Copying to tmp table
I read online that if this is taking long it might lock up other queries causing your server to perform slow and only solution is to restart mysql servers.
Right now i have over 100 queries that say Locked and one that says Copying to tmp table....each time i have to restart the mysql services but this happens every 10 minutes as i have enough traffic to cause this problem.
in one of our dedicated servers, when we go to WHM/Service Status / CPU Memory MySQL usage.. http server and MySQL process appears all 3 times...
is that normal?
i attach an email to be more clear.
I have a single mysql process that never stops and running with 10-200% CPU load: URL....
I restart mysql => process coming back
I restart server => process coming back
I kill process => process coming back
I have run:
# mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -i 1 processlist
but there was noting that runs >10min.
Code:
> SHOW FULL PROCESSLIST;
+------+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-------+-----------+------+---------+------+-------+-----------------------+
| 328 | admin | localhost | psa | Sleep | 56 | | NULL |
| 8110 | admin | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST |
+------+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec)
I have strace the PID
Code:
# timeout 1m strace -f -c -p 5873
Process 5873 attached with 30 threads - interrupt to quit
Process 10499 attached (waiting for parent)
Process 10499 resumed (parent 5873 ready)
Process 10502 attached (waiting for parent)
Process 10502 resumed (parent 5873 ready)
Process 10503 attached (waiting for parent)
[code]....
I found with google a hint for high cpu URL....I have deinstalled "health monitor" module, but that was not the reason.I use plesk 12.0.18 Update #38 with CentOS 6.6 (Final).
I have some websites running on my LINUX server now.
Not all of them are running stable commercial scripts or cgi.
In fact, our server had some records down before by some package scripts.
I only know TOP to know the current server status.
But I can not know which PID is making CPU usage high, or which website.
I think if I can check the exact site or cgi causing heavy loading. Perhaps it helps us to make our server up.
Is there a way or LINUX command to find out which PID is causing heavy loading?
For past one week, my wordpress based blog is just dead, becasue of heavy trackback/pingback spamming(500 a minute). I've tried various plugins, but to no avail.
In addition to stop spammers before generating PHP load, I've tried all possible HTACCESS rules, but to no avail. I truly sure, I've done something wrong.
May I request the experts here to advice on how to stop this ongoing spamming?
My website (Large Discussion Forums Site) is under a heavy DDoS attack since 3 weeks. My first host could not handle such an attack so I moved to another who claimed to have a firewall that can handle the attack, but still, the site is down.
Anyone has a good suggestion to get the site up and handle the attack? Any particular hosts that can help me?
(The Forum has its own server and does not use Apache).
I have a Windows Server 2003 Enterprise (32 bits) running IIS 6.0, with ASP.Net 1.1.4322. Basically it's an application and image server, that has a large amount of concurrent accesses.
Around 800 users simultaneous access simulteneously and ASP.NET app, that will request some date from an MS-SQL Server database and point the browser to image file (all at once), every few seconds (it's a live webcast applications). The server is quite robust, with 500 GB in a RAID-5, 4 GB RAM, Dual Opteron Processor.
When the users access it, the machine memory and CPU usage a low. Also it has plenty of bandwidth, since it's directly tied to a Gigabit port on the datacenter. I kept an eye on all paramenters and there is no imporant bottleneck on the hardware side.
Here is my problem: after some "images" are sent, with 800 users, the users start getting a 503 error, and can no longer access the images.
On IIS HTTPErr Logs, I found these errors to be "Timer_ConnectionIdle". I believe it has something to do with the way the Application Pool is handling all those concurrent connections. No references to it are made on Windows Logs.
I've already tried tweaking all those paramenters on the Application Pool, but no results. For example, I tried increasing the Request Queue Limit value, but that doesn't seem to make any difference.
Also, I inserted "MaxUserPort=65534" on TCP configurations on regedit. Rebooted. Also, tried turning off keep-alive and decreasing connection timeout, then a restart of the w3svc (see [url]for the explanation about this). Tried changing each parameter individually and tested. No big difference after each modification.
Has anyone ever seen this? Is there a way to get this solved? Again, this address [url] has a description of what seems to be my problem... but I didn't manage to get this solved.
I'm currently considering to enter the VPS market
I have recently acquired a nice box (2x Dual Core Opteron 275 2.2 GHz, 16 GB RAM, 16x500 GB SATA @ RAID5/6) but I'm unsure if it isn't smarter to buy smaller machines (like X2 5600+, 4 GB RAM, 2x400 GB HDD) and put like 15-20 customers on it.
Yes, I know that the hard drives are more than oversized for VPS hosting
The Opteron server will have a very, very nice I/O performance so that customers are going to have a good feeling while working on it. To refinance the costs it would of course be neccessary to put not less than 125 VPS on one box, so I can imagine that there'll be a bottle neck somewhere (CPU power I'd guess?).
What is your opinion? Big boxes with high performance and loads of customers, or small boxes with not-so-many VPS?
I run a heavy site, and httpd always failing...
I have a server with these specs:
Q6600
8GB RAM
500 GB SATA HD
Cpanel/WHM
I run a filehosting site actually and there are alot of people downloading at the same time which i think the server goes down and then httpd restarts itself and all the people downloading the files, their files get currupted.
How can i make it so it stays stable?
I am running a VB forum using lighttpd and ranomly one of PHP proccess is using about 80 90 % of memory ! and i should kill it manualy
i want to know how to find reason ?
Config :
Centos 4.4 32 Bit
Kernel : 2.6.9-42.0.3.EL
Lighttpd 1.3.14
PHP 4.4.6 FastCGI
xCache 1.2.0
One of my Cpanel servers is showing heavy data transfer this month. In 6 days, it crossed 600 GB data transfer which is equal to what it did last month. Also, all the websites collectively have only consumed around 60 GB data transfer in 6 days. How do I find out what exactly is causing heavy data transfer?
View 14 Replies View RelatedAre there any hosting companies that use an Enterprise strength SPAM solution such as IronPort?
We have 3-4 business websites and spam, especially within the last 6 months, has become a tremendous problem. At least 100 spam emails a day are being delivered.
Spam filters do not solve the problem - they simply put some percentage of spam in a folder, often genuine emails, and we still have to go through it manually.
Do not mind paying a premium for the hosting. Any hosts that offer HEAVY DUTY spam protection?
We are facing a very problematic situation since last several months due to accessive bandwith usage. But we are sure this is only local traffic.
We have 2 Servers with our hosting provider
Server A - this is a VPS
all our webfiles/domains/dns/nameservers reside on this server
Server B - this is a dedicated server
contains only databases
(we are actively running vbulletin based forums on this servers)
Since last several months we are facing huge bandwith increase since we have transferred only our databases to Server B. (earlier database + everything was on Server A) We never ever consumed even 50% of the entire allocated bandwith in past when we were on Server A.
But only after moving the database from Server A to Server B we have found this tremendous increase,
Can we do something about same ? as both the servers belong to same hosting provider.
We are not sure but expect that this is only local network traffic between 2 servers.
We are facing a very problematic situation since last several months due to accessive bandwith usage. But we are sure this is only local traffic.
We have 2 Servers with our hosting provider
Server A - this is a VPS
all our webfiles/domains/dns/nameservers reside on this server
Server B - this is a dedicated server
contains only databases
(we are actively running vbulletin based forums on this servers)
Since last several months we are facing huge bandwith increase since we have transferred only our databases to Server B. (earlier database + everything was on Server A) We never ever consumed even 50% of the entire allocated bandwith in past when we were on Server A.
But only after moving the database from Server A to Server B we have found this tremendous increase,
Can we do something about same ? as both the servers belong to same hosting provider.
We are not sure but expect that this is only local network traffic between 2 servers.
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..
We have many process under nobody user, so our server load is Very high and its not good.
Here is our server log about one of this process:
Code:
Time: Mon Apr 13 11:36:33 2009 +0430
PID: 4415
Account: nobody
Uptime: 25532 seconds
Executable:
/usr/local/lsws/bin/lshttpd.4.0
Command Line (often faked in exploits):
i have always this process in my server ;
Code:
2 root RT 0 0 0 0 S 0 0.0 0:00.02 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.08 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:06.43 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.31 ksoftirqd/1
6 root RT 0 0 0 0 S 0 0.0 0:05.22 migration/2
7 root 34 19 0 0 0 S 0 0.0 0:00.82 ksoftirqd/2
8 root RT 0 0 0 0 S 0 0.0 0:01.41 migration/3
9 root 34 19 0 0 0 S 0 0.0 0:00.08 ksoftirqd/3
what doeas mean , and for wich application are this proccess
How can track and follow a process id.
For example i need to know what is following process:
14764 root 39 15 11712 9.8m 1668 R 20 0.1 0:14.22 perl
I need to know wich/where file used perl with process id 14764
I am noticing that the kacpid process causing high cpu load.
What does kacpid do? Is there a way to fix for this problem?
Quote:
# ps aux|grep kacpid
root 29 59.6 0.2 0 0 ? S< 22:13 42:20 [kacpid]
Quote:
# lsof -p 29
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
kacpid 29 root cwd DIR 8,2 4096 2 /
kacpid 29 root rtd DIR 8,2 4096 2 /
kacpid 29 root txt unknown /proc/29/exe
Quote:
# ls -l /proc/29/exe
/bin/ls: cannot read symbolic link /proc/29/exe: No such file or directory
lrwxrwxrwx 1 root root 0 Oct 30 22:13 /proc/29/exe
Quote:
# uname -r
2.6.18-164.el5PAE
Ive recently installed installed and configured stuff on my new box but after, I realised abnormal memory usage.
Mysql server is taking 256mb, there are somewhere between 6 and 10 apache process taking up at least 40mb each.
Furthermore, when I do: top, I see that the memory usage is increasing by about 120ko each 3 sec.
I am running centos 5.1 and have a load of 0. Basically, there is no one on the server appart from me.
On the server I have at home running debian, I run all thoose thing and it take up 200mb
max.
write me a daemon that will run every 10 seconds.
If <process> has failed or run into issues, restart the process and then email me with details.
After installing LiteSpeed on my server with cPanel, a few processes have been having issues.
<process> = /opt/lsws/bin/lshttpd, pureftpd, named
I'd like to put up here a base question which I hope some will have the goodwill to answer even though it might touch some business secrecies.
We're a gameserver hoster since around ten years, running also vserver products since over two years now. Renting a few Racks in Europe since some time we're a bit in a question mark how rootserver companies deal with the initial hardware costs for every new customer.
Rackspace and today specially power costs are huge cash eaters here in Europe. Dedicated Rootservers are huge space & power consumers per customer ratio. The initial Hw costs for every new rootserver customer might be covered after 4-6 months (if the machine has to be bought newly), adding the bandwidth and power costs it might take up to 8-9 months until a benefit might come in.
Is this the business normality in the rootserver market (waiting 9 months for any benefit, or counting only on the benefit of the 2nd customer using the older Hw), or are the better ways to handle those "initial" costs or keep them affordably low?
I am showing hundreds of running processes for:
/usr/local/apache/bin/httpd -DSSL
In My server i Can see lotz of /usr/local/apache/bin/httpd -k start -DSSL Process also some time it lead to crash of my server,is this caused to improper httpd.con file iam have 200-250 online users here i will give my apachi cofig file
KeepAlive Off
MaxKeepAliveRequests 200
KeepAliveTimeout 15
StartServers 20
MinSpareServers 30
MaxSpareServers 40
MaxClients 600
MaxRequestsPerChild 250
in correct optimization for my apachi also my processer is dual xenon