MySQL Overload Server, Wich User
Jul 5, 2007how check which database / user MySQL overload the server?
View 2 Replies
ADVERTISEMENT
Wich User Have More Mysql Process?
May 25, 2009How can see wich user have more mysql process?
View 2 Replies View RelatedMonitoring A User's SSH? Also... Mysqld Running At 103%cpu & Stats Overload Emails
May 15, 2007I 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
Overload- MySQL
Apr 25, 2007My 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 RelatedQuad CPU Q9400 @ 2.66GHz & 8 GB Ram - Mysql Overload
Jul 24, 2009My 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
Dedicated Server Wich Allow Torrent Trackers Scripts
May 26, 2008I`m search for manage dedicated server wich allow torrent trackers scripts.
Can some on tell me wich is best to use?
MySQL Replication For User On Shared Server
Nov 6, 2008I 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?
My Server Overload
Oct 23, 2007currently 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?
Vmware Overload Server
Jul 8, 2009Im 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
Server Overload Solution
Oct 26, 2009i 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 RelatedPrevention From Server Overload
Oct 27, 2008Today 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 RelatedWhich PHP Scripts Lead To Server Overload
May 22, 2008I 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 RelatedWhat PHP Scripts Lead To Server Overload
May 22, 2008I 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 RelatedDebian Server Ubnormal CPU & Ram Overload
Oct 30, 2008Debian Server Ubnormal CPU
View 3 Replies View RelatedServer To Hang/overload Once Its Rebooted
Apr 5, 2007how 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.
Apache :: Way To Protect Server From Overload?
Feb 19, 2014Is 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 RelatedServer Overload - Fixed By Extra RAM Or More Powerful CPU
Jul 3, 2008I 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 ...
Server Overload :: Don't Ignore This Email ... Cpu Has Been Maxed Out For ...
Sep 29, 2008I 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.
Dedicated Server Overload ... Low Page Views
Jun 9, 2008I'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
Wich Command Should I Use To Download From SSH
Nov 18, 2007download 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?
Wich Port Used By Hypervm (master/slave)
May 19, 2009Wich port used by hypervm (master/slave)
I have csf installed on my server and i need to open needed ports.
Connect To MySQL DB Only On Certain User
Apr 20, 2009I 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 RelatedHow To Find Which Mysql User Is Using All Cpu
Nov 13, 200831015 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?
Allow User To Remote Mysql Connection
Aug 15, 2008how 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
MySQL Forgetting User Permissions
Jul 5, 2007Does 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.
Mysql/user Is Marked As Crashed
Jan 30, 2007I 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?
What Are Common MySQL User Permissions
Jun 29, 2007I 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
Backup Mysql User Privileges
Aug 26, 2007how 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.
MySQL Anyway To Log Queries Of Specific User
Jun 5, 2007I 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 RelatedDefault Host For Mysql User
Aug 7, 2007By 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