Only 1 Mysql And 1 Running In Top
Aug 10, 2007
I just got a new server and updated the OS etc. Since I am use to seeing the old top information I have questions about the new top data. Some of the differances
1. Many less processes (or task as it is now called) then before.
2. Mysql is only shown once with a long time value. Before I had serveral mysql task and time was short
3. In most cases I have only 1 process running but in the onld system it jumped around from 4 to 10
4. The HTTP task below shows a long time and I see very few. Before had at least 10 shown and the time was very short.
Any ideas if maybe I have a setting wrong that is allows less theads or processes to be created?
Apache 2.2
Plesk 8.2
Fedora Code 6
mysql 5
top - 07:56:45 up 28 days, 11:49, 1 user, load average: 0.18, 0.17, 0.17
Tasks: 121 total, 1 running, 120 sleeping, 0 stopped, 0 zombie
Cpu0 : 0.0%us, 0.0%sy, 0.0%ni, 97.0%id, 3.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 1.0%us, 0.3%sy, 0.0%ni, 97.0%id, 1.7%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 5.3%us, 0.7%sy, 0.0%ni, 94.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 3360708k total, 3203700k used, 157008k free, 220304k buffers
Swap: 2031608k total, 4208k used, 2027400k free, 2269484k cached
PID to kill:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1521 mysql 15 0 404m 90m 4576 S 6 2.8 245:28.29 mysqld
13298 apache 15 0 40532 12m 4380 S 0 0.4 0:03.31 httpd
14021 apache 15 0 40616 12m 4416 S 0 0.4 0:02.75 httpd
14462 apache 15 0 41216 13m 4452 S 0 0.4 0:03.05 httpd
16330 apache 15 0 40644 12m 4184 S 0 0.4 0:01.10 httpd
16558 root 15 0 2200 1016 796 R 0 0.0 0:01.68 top
1 root 15 0 2044 604 520 S 0 0.0 0:02.27 init
View 3 Replies
ADVERTISEMENT
Apr 10, 2008
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 Related
Jan 4, 2008
I have a phpBB forum, which uses MySQl database.
For the last two months the forum has been going down every couple of days because the database service has been continuously stoped running on the server with no reason.
What can cause such a frequent database failures?
Can someone attack the forum/database/server in a way that will cause the above problem?
(there is a good reason I consider this possibility very seriously)
How can I prevent futher database failures?
View 2 Replies
View Related
Mar 23, 2015
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).
View 2 Replies
View Related
May 8, 2009
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..
View 4 Replies
View Related
Jan 21, 2007
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?
View 1 Replies
View Related
Jun 16, 2008
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies
View Related
Feb 11, 2008
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
View 2 Replies
View Related
Oct 5, 2009
I want to purchase a dedicated server onwhich I can set up XEN and make few virtual machines.
how to manage backups - get a sepeare machine and configure it as a NAS, use R1Soft backups etc.
View 5 Replies
View Related
Apr 14, 2008
I recently signed up for a VPS server with 512 MB of RAM. I will be hosting two sites on this VPS server. One is not online yet and I just have a Coming soon page up. The other is a Wordpress blog that is running. I don't have any users yet. But my VPS server is currently using ~410 or my 512 MB. This is with essentially nothing running yet. Does anyone else run their websites with only 512 MB or do I need to upgrade to at least 1 GB? I also checked out which processes are taking up the most
(% wise):
5.6 1 /usr/bin/spamd
5.4 2 spamd
3.8 1 /usr/bin/python
3.4 1 /usr/sbin/mysqld
1.7 1 /usr/local/apache/bin/httpd
1.7 1 cpsrvd
1.7 1 cpdavd
1.6 1 /usr/sbin/restorecond
I know I can't disable apache but what about the others? Spam Assasin is disabled in the WHM but the process restarts even after I kill it. Is Python necessary? I am using php apps..
View 12 Replies
View Related
Nov 13, 2007
after compiling rtg, I run this
/usr/local/rtg/bin/rtgpoll -v -t targets.cfg
and see the data is collected already. However, I cannot keep ssh window all the times. So, how to run rtg automatically as daemon?
View 3 Replies
View Related
Jul 20, 2007
let alone with mysql. Have tried to install those both and have tried endless variations of php settings adn moving php.ini around and checked PATH in IIS adn teh extension .php is enabled.
Question:
Should php.ini be copied to Windows or Windows/system32 directory?
I have a test.php file in my virtual directory. I did have it working at one time but then I installed the extensions so I could have teh mysql extension and it hasn't worked since.
I am just a newbie trying to create a testing environment so I can teach myself PHP. I have endless books, have tried the Yanks method but I am not sure it applies to PHP5.
I have PHP at c:/program files/php/ is this a problem? Shoud it just be directly in the c directory? Does that matter?
View 0 Replies
View Related
Jun 17, 2007
I installed csf as my server's firewall with using cpanel besides, I've customized configuration file and everything seems to be right but when i use csf -s it results this error :
iptables: No chain/target/match by that name
LOG tcp opt -- in * out * 0.0.0.0/0 -> 0.0.0.0/0 limit: avg 30/min burst 5 LOG flags 0 level 4 prefix `Firewall: *TCP_IN Blocked* '
Flushing chain `INPUT'
Flushing chain `FORWARD'
Flushing chain `OUTPUT'
Flushing chain `LOGDROPIN'
Flushing chain `LOGDROPOUT'
Flushing chain `acctboth'
Deleting chain `LOGDROPIN'
Deleting chain `LOGDROPOUT'
Deleting chain `acctboth'
Error: iptables command [/sbin/iptables -v -A LOGDROPIN -p tcp -m limit --limit 30/m --limit-burst 5 -j LOG --log-prefix 'Firewall: *TCP_IN Blocked* '] failed, at line 196
View 14 Replies
View Related
Apr 27, 2007
i'm thinking of installing virtualization software on a linux vps machine.
reason... windows vps vost so much and linux are much cheaper.
so within my cheap linux vps, i can install virtual windows using my pre-purchased win2000 license key.
has anyone tried this or is it completely not possible. also what linux-host virtualization software would you recommend?
note my linux vps already has kde with vnc running so i have a graphical interface to my linux vps at home.
View 14 Replies
View Related
Aug 13, 2007
I'm aware of the limitations of using Sun's JVM on a VPS. Are there any good JVMs I can run besides Sun's?
View 14 Replies
View Related
Jan 19, 2008
I have a question that's been bugging me for a few months now (which has gotten worse as traffic increases). I run a site that gets some decent traffic (about 9-10M pageviews per month), and is mostly made up of HTML pages with a lot of images (some pages have about 200k of images, others have maybe 1.5-2MB of them). I have a dedicated server that has 2TB of bandwidth per month, and I'm quickly approaching the 2TB point... what should I do?
Normally, I'd buy more bandwidth... but the host I have charges $400/month for 10mbps unmetered bandwidth -- more than the cost of the server each month! What other options do I have?
View 12 Replies
View Related
Apr 30, 2009
I'm looking into purchasing a VPS, and I saw unmanaged are cheaper.
What would I need to know/learn to do maintain an unmanaged VPS?
View 14 Replies
View Related
Apr 15, 2009
I'm trying to run sshfs on my VPS but it seems to require the fuse module compiled on kernel. I already asked my host but they said that they won't change the kernel.
Is there an alternative to sshfs? I really need something to mount an external server.
View 4 Replies
View Related
Jan 5, 2009
I've written an application that acts as a game server for a simple game I'm creating. From what my friends tell me you can't run an exe on a webhost. They did however tell me that you can run java apps on a host that gives ssh access.
View 8 Replies
View Related
Jul 22, 2007
If I restart VPS (vzctl stop 1002 | vzctl start 1002 ) I can't join from ssh - not working, but remaining services start correctly: ftp, cpanel, etc.
View 9 Replies
View Related
Jan 17, 2008
I currently have one dedicated server and four VPSs all using Plesk and all having their own name servers controlled by Plesk. What I'd like to do is consolidate everything so all my sites use one set of name servers.
I'm a PHP developer (and will be developing my own front end), and only have limited knowledge of administrating a server, so first of all if anyone has done this before and made mistakes in the process, please could you share them with me so I can avoid making them?
Secondly, I would like to use a MySQL database for storing the DNS info - I've found a tutorial at [url]which I'd like to use - could someone who knows what they're talking about have a skim through this and reassure me that everything there is correct and up to date (the article was written in early 2006 - just checking nothing in the world of DNS has changed since)?
I'm using Fedora.
View 0 Replies
View Related
Jun 10, 2008
I keep getting this error when trying to start named, bind 9.3.3 installed through yum (centos 5 x64).
# service named restart
Stopping named: [FAILED]
Starting named: named: already running [FAILED]
# ls /var/run/named
#
# ls /var/lock/subsys | grep named
#
I even uninstalled bind, restarted the system, and reinstalled and it is still giving me the same error.
There aren't any related errors in dmesg/messages and I couldn't find a named related file in /var/log.
View 4 Replies
View Related
Nov 13, 2008
I've a production server running web,smtp, ftp, cpanel...
Now I need to run different solutions on the same server (like PABX, games), of course I can't put all on the same place (to better control security, resource usage etc..)
Is it possible to install xen without affecting my production environment? It would be a good choice doing that?
View 10 Replies
View Related
Jun 20, 2008
We have an OpenVZ VPS, And we have a problem with courier there.
The issue is that when we reboot the VPS, then we see the following error when trying to restart IMAP:
imap has failed, please contact the sysadmin (result was "couriertcpd is not running").
But if we use the following cPanel script, that get resolved until we reboot it (the vps) again:
/scripts/convert2maildir
* We have converted to maildir in the past, but should use that script and choose "3" option to get the issue resolved temporarily.
* I try to start courier with /scripts/courierup --force but that doesnt fix the issue.
* There is some other issues on that VPS which may be related to this one:
- We cannot modify the date on that VPS, I dont know why, It doesnt change ever.
- The results of mkpasswd root command is the same everytime we use it.
Operating System: CentOS 4.6
Control Panel: cPanel 11.23.2
Node Platform: OpenVZ
View 1 Replies
View Related
Aug 13, 2008
I want to start up my web server again. I have Windows XP hosting my web server right now. and, it's slow.
Should i stick with Windows, run IIS and use httpZip from Port80?
I really like microsoft, and don't want to change and adapt to something else.
give me advice
Or, should I run Linux
I would run Linux on it, but I don't know how.
And they have different version of Linux. Example Redhat, Ubuntu etc.
Which one should I go for?
Also, what do I do if I have a netgear ethernet card? Is that Linux? Is it compaitable with Redhat?
And last question, what do I use for security?
I'm a hacker, yeah.. I know what all people can do to websites. How do I stop them?
DoSing, Cross Scripting, XML Attacks, MySql Injection.. Etc.
If a linux fan can respond, that would be nice.
View 4 Replies
View Related
Aug 20, 2008
I'm not sure if this is the best board for this question but I'll try anyway. We recently had an app built and the developer built it using the Zend framework.
Our server is running IIS. Does anyone have a link to information or know any tricks in getting Zend build apps to work on IIS?
We need to stick to IIS because other apps we have were built in asp so switching to apache is not an option.
View 0 Replies
View Related
Jun 25, 2008
may I know which version of apache and mysql are you running on your production server? Will the latest apache or mysql conflict with DA?
View 9 Replies
View Related
Feb 19, 2008
I am showing hundreds of running processes for:
/usr/local/apache/bin/httpd -DSSL
View 3 Replies
View Related
Jul 18, 2008
why not just setup my own server. I have the connection and hardware necessary. So I am wondering why do people pay for web hosting? Why not just run your own website from your own server?
View 15 Replies
View Related
Feb 20, 2008
I have installed postgres over my cpanel account but I am unable to find php_pgsql.so file
I am running Centos 4 Apache 1.3 PHP 4.3 Postgres 7.3
View 4 Replies
View Related