Monitoring A User's SSH? Also... Mysqld Running At 103%cpu & Stats Overload Emails

May 15, 2007

I have 3 questions.

1.) I have a user that's kinda knows a lot about linux. More than me. He has a lot of stuff on the system which I have no idea what it is. Is there any way I can install a SSH log, so I can monitor what he does in shell?

2.) My server seems REALLY sluggish. I ran a top in shell, and mysqld was taking up from 70% to 110% of the cpu. Is there any way to fix this or find out why? I've restarted the server, and it's fluctuating between 50% and 90% now.

3.) I think this MIGHT be related to the sqld issue, but I've received about 12 emails saying
Quote:

"[statscheck] Stats/Server Overload on my server". "MPORTANT: Do not ignore this email.

This is cPanel stats runner on server1.cewxp.com!

While processing the log files for user cewxp, the cpu has been
maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of this email is 15:49:16 up 5 days, 10:52, 2 users, load average: 27.59, 31.36, 31.83"

and also another email

Quote:

IMPORTANT: Do not ignore this email.

This is cPanel stats runner on server1.cewxp.com!

While processing the log files for user vegapunk, the cpu has been maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of this email is 12:34:26 up 5 days, 7:37, 2 users, load average: 19.90, 17.59, 17.97

View 3 Replies


ADVERTISEMENT

Running Web Applications For Many Users....what To Do

May 30, 2009

I am running an application for which users pay a recurring monthly fee to use.

However, I am not familiar with what kind of hosting and layout i should approach.

Should I just purchase a deicated box from say FDC, and put 5~10 users on it?

Or should I get small vps for each user.

View 4 Replies View Related

Cloud Solutions For Running Web Application For International Users

Nov 6, 2009

I know CDN is only for static files, but is there such cloud host service where users from Asia, Europe and USA will face no serious latency issues?

Is this going overboard, would using Amazon Cloud suffice?

or would purchasing dedicated servers in each region like USA, Europe, and Asia be better?

View 0 Replies View Related

Emails Never Reaching Users (Queued_mail_for_delivery)

Jul 9, 2007

I run a popular community and there are a number of notifications the user can receive.
The notifications are sent via PHP mail() function. For an increasing number of users, emails never get to their mailbox (neither in their junk mail folder).
When I look in qmail's logs, I see a lot of these :

Quote:

@40000000469233dd346d5d24 new msg 331743
@40000000469233dd346d610c info msg 331743: bytes 637 from <myscript@mydomain.com> qp 14664 uid 81
@40000000469233dd34bb8cc4 starting delivery 151: msg 331743 to remote user@hotmail.com
@40000000469233dd34bb90ac status: local 0/10 remote 1/20
@40000000469233df02a4e334 delivery 151: success: 65.54.244.40_accepted_message./Remote_host_said:_250__<20070709131043.14663.qmail@ns22299.ovh.net>_Queued_mail_for_delivery/
@40000000469233df02a4eb04 status: local 0/10 remote 0/20
@40000000469233df02a4eb04 end msg 331743

So I receive a "250" answer, but with this "Queued_mail_for_delivery" message, and the user never gets anything of the email. This exact message is for an hotmail account, but I get other similar ("queued") messages for other accounts.

Is there anything i can do to prevent this from happenning ? A lot of new registrant get these messages with their validation emails and that is lost customers for me.

View 2 Replies View Related

AWSTATS Stats Decreasing While Webalizer Stats Are Increasing

May 23, 2008

I look after a number of sites and monitor their stats. We use both webalizer and AWSTATS so we can have a comparison. Up until recently the stats for both of them where relatively the same, webalizer usually showing higher numbers as it doesn't filter bots but the progression of increase and decrease in stats was proportional. However, over the last few months a curious trend is appearing, the stats in AWSTATS are decreasing every month whereas the stats in Webalizer are increasing, the gap between them now is huge.

View 0 Replies View Related

Can I Delete Mysqld.log

Dec 13, 2008

Can I delete mysqld.log

Can I delete or empty mysqld.log

Its currently 850MB

If I can do I have to stop MYSQL first;?

View 6 Replies View Related

Mysqld Restart

Nov 15, 2008

I just bought new DS 3 days ago : Intel Core2Duo 2.33 GHz, 2GB DDR2 RAM , 250 GB.

Today mysql automatic stop and not auto restart :|

I checked cron job: has no cron job there. I have just only one site on this server.

I check Check mysql error log:

081115 10:47:52 [Note] /usr/sbin/mysqld: Normal shutdown
081115 10:47:52 InnoDB: Starting shutdown...
081115 10:47:54 InnoDB: Shutdown completed; log sequence number 0 72782
081115 10:47:54 [Note] /usr/sbin/mysqld: Shutdown complete
081115 10:47:54 mysqld ended
081115 10:47:55 mysqld started
/usr/sbin/mysqld: File '/var/log/mysql-slow-queries.log' not found (Errcode: 13)
081115 10:47:55 [ERROR] Could not use /var/log/mysql-slow-queries.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
081115 10:47:55 InnoDB: Started; log sequence number 0 72782
081115 10:47:56 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

my.cnf file ....

View 8 Replies View Related

Mysqld Using 100 Percent Of Cpu

Apr 10, 2007

I've got a strange situation here. We have some software which we run on multiple servers. As of today the software is using 100 percent (sometimes more) of the cpus.

Here is the result from top. It's usually far worse using 100 percent of both cpu's almost all of the time. I just restarted, but the server load is climbing to 20+. Any idea how I can figure out what is going on? The same software on two other identically configured servers runs fine. This server has had no problems for over 6 months, but suddenly this started today. The server is a dual opteron with 4GB of ram. The databases are innodb thus the high memory usage for mysql (innodb buffer pool size)

top - 13:52:54 up 3:14, 2 users, load average: 3.39, 4.42, 6.86
Tasks: 121 total, 4 running, 108 sleeping, 9 stopped, 0 zombie
Cpu(s): 66.1% us, 1.7% sy, 32.2% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 4090568k total, 3077004k used, 1013564k free, 52748k buffers
Swap: 2096440k total, 56k used, 2096384k free, 1796632k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11871 mysql 15 0 2581m 1.0g 3844 S 96 26.2 13:05.73 mysqld
7569 root 39 19 8048 2024 1304 R 65 0.0 32:27.49 http
11984 apache 15 0 152m 14m 5860 S 12 0.4 0:24.27 httpd
11990 apache 15 0 152m 17m 8376 S 9 0.4 0:14.31 httpd
12002 apache 16 0 153m 15m 5408 R 6 0.4 0:08.60 httpd
12040 apache 15 0 152m 17m 8524 S 5 0.4 0:03.86 httpd
11966 apache 15 0 153m 17m 8280 S 3 0.4 0:22.99 httpd

View 14 Replies View Related

OS X 10.5 - Mysqld: Command Not Found

Apr 28, 2009

I'm setting a local server on my network. Leopard 10.5.6

I went to mysql.com and installed the intel 32-bit version of mysql (package).

After install, i try to run mysqladmin command, but it returns command not found.
I search the location using
which mysql
nothing returns.

I find the install here:
/usr/local/mysql-5.1.34-osx10.5-x86/bin

even when i check the file and its there, running the command returns
mysqladmin: command not found

View 1 Replies View Related

Mysqld Unable To Start

Aug 23, 2007

My server was having a high load so I stop httpd and mysqld. I tried to restart both service but only httpd is starting and mysqld failed. It keeps timing out.

service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]

It was working and I only trying to restart it.

The load on my server now is 0 because the website is down.

View 8 Replies View Related

After Rotation Mysql Don't Write Mysqld.log

Nov 6, 2009

we have set logrotate for rotate mysqld.log daily

file is compress, deleted and created from logrotate but mysql not write anything

Any idea about why?

View 1 Replies View Related

Starting Mysqld With The --skip-name-resolve

Apr 19, 2007

How can we start mysqld with --skip-name-resolve? Syntax Or Command?

View 7 Replies View Related

Plesk 11.x / Windows :: Panel Don't Show Users Database In Tab Users

Sep 6, 2013

The upgrade has an error when manage the users database.

PRODUCT, VERSION, VERSION OF MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
OS Microsoft Windows Server 2008 R2 Service Pack 1 x64
Panel version 11.5.30 Update #13, last updated at Sept 1, 2013 03:30 PM

PROBLEM DESCRIPTION
In a costumer panel have a one database MSSQL, and assign to this DB 3 users, but the tab option "Users" don't work fot his costumer and show this error:

Error Javascript:
TypeError: template is null
this.template = template.toString(); in protototype.js 8472831 (línea 807)

ACTUAL RESULT
Error Javascript:
TypeError: template is null
this.template = template.toString(); in protototype.js 8472831 (línea 807)

EXPECTED RESULT
Show users in the tab users for database.

View 2 Replies View Related

Preventing Users From Connecting To Other Users Database

Mar 25, 2009

On my server, users can connect to any database as long as they have the database user and password. This makes it easier to hack any database on the server.
What I want to do is to make the users can only connect to their own databases and not other's.

I tried changing the localhost ip address but it didn't work ( I assume I didn't do it the right way)

View 7 Replies View Related

Vps Is OverLoad

Jul 18, 2007

i have vps 512 MB ram From HostForWeb working Fine! in 160 websites! Hosted
But! in swvps.com with 2 gig ram! Low Working! OverLoad and CPU Usage is Red Alert
But HostForWeb VPS with 512 MB Ram good Working I Dont Know Why SWvps.com Is Low with 2 gig ram for me?

View 14 Replies View Related

Overload Of Traffic

Jul 2, 2009

I am not sure if my dedicated server is being attacked or if it is legitimate traffic. I need help figuring out the difference and if it is an attack, how to prevent it, and if it is legitimate traffic, how to configure the server to handle the load.

My server information is below:

HardwareIntel Xeon 3220-Quad Core [2.4GHz
8GB DDR2
SATAII 500GB

SoftwareCentOS 5.3-32
Apache2
MySQL 5
PHP 5
When I do ps aux|grep httpd|wc -l I get the count of current connected clients of 259 which is always maxing out my MaxClients of 256. I had increased it to 512, and it maxed out, I had increased it to 1024 and it maxed out, and lastly I had setup to 2048 and it works, but slows the entire server down.

View 7 Replies View Related

Overload Logs

Mar 25, 2008

I think my apache is killing my servers with crazy overload with logs... how do I turn this off?

View 2 Replies View Related

My Server Overload

Oct 23, 2007

currently i purchase a reseller. when i click in server status, i found out that the detail is as below:

cpsrvd up [green]
Server Load 5.41 (1 cpu) [red]
Memory Used 46.7 % [green]
Swap Used 9.51 % [green]
Disk /dev/sda1 (/boot) 13 % [green]
Disk /dev/sdb (/mount) 57 % [green]
Disk /dev/sda3 (/) 88 % [yellow]

i found that the server load is in red color, and the last item Disk/dev/sda3 is in yellow color. may i know what is the problem?

View 5 Replies View Related

Memory Overload

Oct 9, 2007

My server is out of memory....how do I find which script or domain is causing for memory abuse on server?

Its Plesk server 3.0Ghz + 1GB Ram

View 3 Replies View Related

Apache- And Overload

Apr 23, 2007

the server is overloaded some times during a day.

There is one process of httpd witch use 80-90% of memory. Load increases to 90 or 200 :/

I installed strace and when the process appeared I run on that process and there is:

mmap(NULL, 364544, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2b25e60000

There is a lot of that entries.

View 5 Replies View Related

AP7901 Overload.

Feb 8, 2007

I am using a AP7901, and at 12AMP I am getting a red led status overload. At 11AMP the led is green status, which is perfect.

Is this a problem? Shouldn't I be able to use 16AMP? Is it safe/ok to use more AMP?

View 3 Replies View Related

Overload- MySQL

Apr 25, 2007

My webserver keeps on overloading, causing pages to lag and mysql connections to get clogged. Each time it overloads, it's because of there being too many MySQL connections, and I really just don't know why there are so many. I am not sure whether someone is sabotaging my server or whether there is a hole in my php scripts that causes an abundance of connections, or some very slow query.

View 2 Replies View Related

Vmware Overload Server

Jul 8, 2009

Im using Vmware on dedicated server:

each 2 Intel(R) Xeon(TM) CPU 3.00GHz

1- in vmware show:

2 CPUs x 2 Cores

but i check in SSH we have 7 core !

Code:
# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 6
model name : Intel(R) Xeon(TM) CPU 3.00GHz
stepping : 4
cpu MHz : 7680.000
cache size : 2048 KB
physical id : 0
siblings : 4
core id : 0
cpu cores : 2
apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 6
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est cid cx16 xtpr lahf_lm
bogomips : 6012.44
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 6
model name : Intel(R) Xeon(TM) CPU 3.00GHz
stepping : 4
cpu MHz : 5120.000
cache size : 2048 KB
physical id : 1
siblings : 4
core id : 0
cpu cores : 2
apicid : 4
fpu : yes
fpu_exception : yes
cpuid level : 6
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est cid cx16 xtpr lahf_lm
bogomips : 5984.27
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual

View 2 Replies View Related

Server Overload Solution

Oct 26, 2009

i want to kill apache/http and restart it again automatically. i need this because sometime we are not in front of the server to fix an overload issue immediately, which can affect a server very badly. i believe many of us already face this kind of situation and hope there is some kind of script or way to do this.

View 5 Replies View Related

Suspicious Overload And Spammers

Jul 24, 2009

I have a small VPS, with few websites each one with very low visitors in average less than100 visits per day

CentOS 2.6.9
Plesk
PHP 5.1.6
Apache/2.2.3

Few days ago some Forum spammers signed up to one of the forums. One of them: stopforumspam.com/ipcheck/212.178.2.3

Today I was away for few 5 hours after I came back I recived a notice from my script that "SMF could not connect to the database"

I checked and I noticed almost all of my sites are not responding. MySql was working. A script on remote server which uses mysql from my server loaded but with dealy

------------------Next step-------------------
log to SSH
# uptime
# 12:XX:XX up XXX days, 5:06, X users, load average: 10.58, 8.86, 5.86

my normal load is less than 0.9

-----------------check open ports ---------------------------
netstat -nap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:995 0.0.0.0:* LISTEN 1936/couriertcpd
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 32447/mysqld
tcp 0 0 0.0.0.0:106 0.0.0.0:* LISTEN 14307/xinetd
tcp 0 0 0.0.0.0:139 0.0.0.0:* LISTEN 9943/smbd
tcp 0 0 0.0.0.0:110 0.0.0.0:* LISTEN 1916/couriertcpd
tcp 0 0 0.0.0.0:143 0.0.0.0:* LISTEN 1840/couriertcpd
tcp 0 0 0.0.0.0:8880 0.0.0.0:* LISTEN 9626/httpsd
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 7645/httpd
tcp 0 0 0.0.0.0:465 0.0.0.0:* LISTEN 14307/xinetd
tcp 0 0 0.0.0.0:21 0.0.0.0:* LISTEN 14307/xinetd
tcp 0 0 [MyServerIP]:53 0.0.0.0:* LISTEN 13619/named
tcp 0 0 [MyServerIP]:53 0.0.0.0:* LISTEN 13619/named
tcp 0 0 [MyServerIP]:53 0.0.0.0:* LISTEN 13619/named
tcp 0 0 127.0.0.1:53 0.0.0.0:* LISTEN 13619/named
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 13820/sshd
tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN 14307/xinetd
tcp 0 0 127.0.0.1:953 0.0.0.0:* LISTEN

View 2 Replies View Related

Prevention From Server Overload

Oct 27, 2008

Today my server was down cause it was overloaded and when i restart my server its running how to stop such problem in the future

View 10 Replies View Related







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