MySQL Overload Server, Wich User

Jul 5, 2007

how check which database / user MySQL overload the server?

View 2 Replies


ADVERTISEMENT

Wich User Have More Mysql Process?

May 25, 2009

How can see wich user have more mysql process?

View 2 Replies View Related

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 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

Quad CPU Q9400 @ 2.66GHz & 8 GB Ram - Mysql Overload

Jul 24, 2009

My problem is server overload.I think it's a mysql optimization problem. But i dont change any setting.

Core(TM)2 Quad CPU Q9400 @ 2.66GHz
8 GB Ram

[url]
[url]
[url]
[url]

CENTOS 5.3 i686 standard on server
cPanel 11.24.4-C37008 - WHM 11.24.2 - X 3.9

View 3 Replies View Related

Dedicated Server Wich Allow Torrent Trackers Scripts

May 26, 2008

I`m search for manage dedicated server wich allow torrent trackers scripts.

Can some on tell me wich is best to use?

View 4 Replies View Related

MySQL Replication For User On Shared Server

Nov 6, 2008

I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this.

I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to:

1. execute:
GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa';
[url]

2. Stop mysql server and Add in my.cnf:
[mysqld]
log-bin=mysql-bin
server-id=1
slave-compressed=1
binlog-do-db=user_main
start server[url]

3. execute:
SHOW MASTER STATUS;
we need values of colomns File and Position from output of above command[url]

So my questions are:

Is there any security risk?
Is there significant extra resource usage?
Is this even done on shared environments?

View 5 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

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

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

Which PHP Scripts Lead To Server Overload

May 22, 2008

I have heard a lot of cases when customers used forbidden PHP scripts on shared servers and as a result their accounts were suspended due to the server overload. I am just wondering what scripts it is desirable not to use within shared hosting packages?

View 6 Replies View Related

What PHP Scripts Lead To Server Overload

May 22, 2008

I have heard a lot of cases when customers used forbidden PHP scripts on shared servers and as a result their accounts were suspended due to the server overload. I am just wondering what scripts it is desirable not to use within shared hosting packages?

View 4 Replies View Related

Debian Server Ubnormal CPU & Ram Overload

Oct 30, 2008

Debian Server Ubnormal CPU

View 3 Replies View Related

Server To Hang/overload Once Its Rebooted

Apr 5, 2007

how can i find out what has caused my server to hang/overload once its rebooted?

I know that the SWAP maxed out but i am unsure why.

View 6 Replies View Related

Apache :: Way To Protect Server From Overload?

Feb 19, 2014

Is there a way to protect apache server from overload? For example Nginx has a module called SysGuard when system load or memory use goes too high all subsequent requests will be redirected to the URL specified by the 'action' parameter.

View 1 Replies View Related

Server Overload - Fixed By Extra RAM Or More Powerful CPU

Jul 3, 2008

I have a fairly busy server, and received a High Load warning from my firewall monitoring software. Showing a high 5 minute load average alert of 13.89.

I'm presuming extra memory and a more powerful CPU would be required to sort this out?

Time: Thu Jul 3 12:22:06 2008
1 Min Load Avg: 42.90
5 Min Load Avg: 13.89
15 Min Load Avg: 5.82
Running/Total Processes: 51/359

Output from ps:
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND ...

View 11 Replies View Related

Server Overload :: Don't Ignore This Email ... Cpu Has Been Maxed Out For ...

Sep 29, 2008

I have been receiving these a couple time a day lately and not sure what to do or how to go about checking what might be overloading the server. IF this looks familiar to anyone, I'd appreciate some helpful tips. I'm still a novice, but can muddle my way around the server if given enough guidance. Here is the email I've been getting:

"IMPORTANT: Do not ignore this email.
This is cPanel stats runner on host.myserverhost.com!
While processing the log files for user xxxxxxx, 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
19:20:10 up 2 days, 7:06, 0 users, load average: 15.17, 13.24, 8.00
You should check the server to see why the load is so high and take steps to lower the load. If you want stats to continue to run even with a high load; Edit /var/cpanel/cpanel.config and change extracpus to a number larger then 0 (run /usr/local/cpanel/startup afterwards to pickup the changes)."

I guess my question is, how would I go about determining what is causing the excess load? Seems to happen even when not many folks are on my site.

View 14 Replies View Related

Dedicated Server Overload ... Low Page Views

Jun 9, 2008

I'm on a low-end dedicated server that I run 2 decent sized blogs on. I'm getting several traffic spikes a day where the load goes through the roof and I think I need my server optimized.

My server admin says I need a bigger server and he has never steered me wrong but this is ridiculous:

My blogs use Wordpress as its blogging platform....I know they hog server resources and I've recently installed Super cache so that seems to help.

I average about 5,000 pageviews a day and I would think even a low-end box should handle this but maybe I am wrong.

Here's the server specs:

Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Celeron(R) CPU 2.40GHz
Processor #1 speed: 2394.661 MHz
Processor #1 cache size: 128 KB

Memory: 1033924k/1048016k available (2171k kernel code, 13360k reserved, 723k data, 172k init, 130512k highmem)

hda: ST380011A, ATA DISK drive
hdc: Lite-On LTN486S 48x Max, ATAPI CD/DVD-ROM drive
hda: max request size: 1024KiB
hda: 156250000 sectors (80000 MB) w/2048KiB Cache, CHS=16383/255/63, UDMA(100)
hda: cache flushes supported
hdc: ATAPI 48X CD-ROM drive, 120kB Cache, UDMA(33)

Memory:

total used free shared buffers cached
Mem: 1035148 993356 41792 0 151312 527008
-/+ buffers/cache: 315036 720112
Swap: 2040212 476700 1563512
Total: 3075360 1470056 1605304

View 2 Replies View Related

Wich Command Should I Use To Download From SSH

Nov 18, 2007

download a file to my server with SSH.

i know that the command for a simple download is wget [url]

but i have a link wich needs to enter username and password to download... wich will be the command for that case?

View 4 Replies View Related

Wich Port Used By Hypervm (master/slave)

May 19, 2009

Wich port used by hypervm (master/slave)

I have csf installed on my server and i need to open needed ports.

View 7 Replies View Related

Connect To MySQL DB Only On Certain User

Apr 20, 2009

I am using cPanel 11 (stable release) on a CentOS 5 server and would like to make it so that a certain database can only be connected to from the cPanel user that it is under (ie. user1_db can only be connected to from the user "user1" on the same server).

View 9 Replies View Related

How To Find Which Mysql User Is Using All Cpu

Nov 13, 2008

31015 100 15 0 151m 35m 5156 S 28 0.4 379:34.10 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql

This is my top process, I have quad core server and because of this server load is over 10

I am using cPanel, is it possible to trace which user is using all this cpu?

View 6 Replies View Related

Allow User To Remote Mysql Connection

Aug 15, 2008

how to allow user to remote mysql connection from his localhost ( in linux server with WHM )

my user wants to connect to the mysql from his localhost

View 7 Replies View Related

MySQL Forgetting User Permissions

Jul 5, 2007

Does anyone know what could be the cause of this issue? I located a few others over at cpanel.net that have this problem, but no solution has been found.

[url]

I am running a VPS server with the following:

WHM 10.8.0 cPanel 10.9.1-S14304
RedHat 9 i686 - WHM X v3.1.0
phpMyAdmin - 2.9.0.2
MySQL client version: 4.1.10
mysql version: 5.0.27-standard

I have a database user that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE".

Here's a look at the database permissions from phpMyAdmin.

Code:
User Host Password Global privileges Grant
hello localhost Yes ALL PRIVILEGES Yes
hello_ % No ALL PRIVILEGES Yes
hello_ localhost No ALL PRIVILEGES Yes

The user "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.

View 3 Replies View Related

Mysql/user Is Marked As Crashed

Jan 30, 2007

I am trying to start mysql but i am getting the following error

MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL................................... [FAILED]

I checked my hostname.err file in /var/lib/mysql and this is the error message it shows.

070130 17:59:41 mysqld started
070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 mysqld ended

how I would repair that to get mysql to start again?

View 7 Replies View Related

What Are Common MySQL User Permissions

Jun 29, 2007

I want to use something like PHPBB forums and using one MySQL user and database. Just wondering, what are common user permissions I should set for the user? I want to try to minimize any permissions that can cause big risk to the server security.

Here is a full list of permissions I can grant to the user (via Webmin):

-Select table data
-Insert table data
-Update table data
-Delete table data
-Create tables
-Drop tables
-Grant privileges
-Reference operations
-Manage indexes
-Alter tables
-Create temp tables
-Lock tables

View 3 Replies View Related

Backup Mysql User Privileges

Aug 26, 2007

how do i backup mysql user privileges?

this will only backup the databases:
mysqldump --opt -u root -p --all-databases > data.sql

i would like to backup mysql user privileges too.

View 1 Replies View Related

MySQL Anyway To Log Queries Of Specific User

Jun 5, 2007

I know about the general log but want to just log queries of a specific user. Our database does 400 queries/s on a slow day, so I think it would be a pain to grep though a huge log like that. And, im not sure if it would cause any preformance issues.

View 0 Replies View Related

Default Host For Mysql User

Aug 7, 2007

By default, mysql will create user with host as 'localhost'. Now, if I want the host is '1.2.3.4' by default, how to configure it?

View 3 Replies View Related







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