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

Mysql Running Process

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

MySQL Database Service Stops From Running

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

Plesk 12.x / Linux :: MySQL Process Running Unlimited With High CPU?

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

I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working

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

Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql

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

Mysql.sock Gone And Mysql Restart Doesn't Create It

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

How To Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only

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

Running XEN

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

Running Out Of My 512 MB Of RAM With VPS

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

Running Rtg

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

Can't Get PHP 5 Running With IIS

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

Running Csf

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

Running A Vps Within A Vps

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

Running A JVM On A VPS

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

Running Out Of Bandwidth

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

Running Unmanaged VPS

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

Running Sshfs On A VPS

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

SSH And Running Exe (or Any Other Application)

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

OpenVZ - SSH Not Running

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

Running A DNS Server

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

Named Already Running

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

Xen On Running Server

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

Couriertcpd Is Not Running

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

Running Web Server

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

Running Zend On IIS 6.0

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

Those Running DirectAdmin On VPS

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

What Is This Running Process

Feb 19, 2008

I am showing hundreds of running processes for:
/usr/local/apache/bin/httpd -DSSL

View 3 Replies View Related

Running Your Own Server

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

Running Postgres

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







Copyrights 2005-15 www.BigResource.com, All rights reserved