Sponsored Content
Top Forums UNIX for Dummies Questions & Answers mysqld overloading cpu of VPS Post 302528294 by rizwan65 on Monday 6th of June 2011 11:30:08 PM
Old 06-07-2011
mysqld overloading cpu of VPS

Hi bros
I have a VPS 512mb (Burst 2GB) with Kloxo installed and hosting few sites on it with not much traffic

I am facing high cpu load for the last few days and seems mysqld is overloading the cpu

Any suggestion will be appreciated
Regards
Rizwan


Top output is as under

Code:
top - 18:44:04 up 6 days, 12:19,  0 users,  load average: 9.81, 8.44, 5.50
Tasks:  42 total,   2 running,  40 sleeping,   0 stopped,   0 zombie
Cpu(s): 32.0%us, 55.8%sy,  0.0%ni, 12.2%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   2097152k total,   496708k used,  1600444k free,        0k buffers
Swap:        0k total,        0k used,        0k free,        0k cached

PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
25665 mysql     15   0  148m  41m 6904 S 215.2  2.0   29:22:14 mysqld
19929 apache    16   0 60792  30m 5104 S  6.6  1.5   0:07.50 httpd
1458 apache    15   0 59700  28m 4660 S  0.3  1.4   0:03.24 httpd
2044 apache    15   0 50920  19m 4100 S  0.3  0.9   0:01.31 httpd
1 root      15   0  2156  656  568 S  0.0  0.0   0:00.96 init
1987 apache    15   0 50920  19m 4100 S  0.0  0.9   0:00.91 httpd
2043 apache    16   0 50920  19m 4100 S  0.0  0.9   0:01.32 httpd
3155 apache    15   0 51200  19m 4412 S  0.0  1.0   0:00.64 httpd
3156 apache    16   0 50920  19m 4100 S  0.0  0.9   0:01.11 httpd
3646 apache    16   0 59196  28m 4908 S  0.0  1.4   0:03.81 httpd
5218 clamav    16   0 15388 1616 1012 S  0.0  0.1   0:00.31 freshclam
5981 lxpopuse  16   0 36408  31m 2484 S  0.0  1.6   0:03.21 spamd
7697 lxpopuse  15   0 39256  34m 2516 S  0.0  1.7   0:20.55 spamd
9484 apache    15   0 60560  29m 4968 S  0.0  1.5   0:04.14 httpd
13480 named     21   0 91508 4112 2044 S  0.0  0.2   0:13.39 named
17476 root      15   0  7188 1064  660 S  0.0  0.1   0:01.38 sshd
17492 root      15   0  2832  896  724 S  0.0  0.0   0:01.64 xinetd
21733 root      15   0 33856  29m 2416 S  0.0  1.4   0:07.96 spamd
21848 lxlabs    15   0  5580  932  500 S  0.0  0.0   0:00.20 kloxo.httpd
22441 root      15   0 26448  14m 4172 S  0.0  0.7   0:01.01 php
22462 root      15   0 11212  348  224 R  0.0  0.0   0:00.00 vzctl
22466 root      16   0  3708 1460 1236 S  0.0  0.1   0:00.01 bash
23643 root      15   0 49016  20m 7376 S  0.0  1.0   0:02.51 httpd
24010 root      15   0  2288 1016  816 R  0.0  0.0   0:00.00 top


Last edited by pludi; 06-07-2011 at 04:35 AM..
 

10 More Discussions You Might Find Interesting

1. BSD

mysqld

Hello I installed mysql41 this is the end of the installation but when I try to launch the mysqld daemon it write this: note: LodelServoo is a CMS which need mysql I verify that the dir mysql existed under /var/db, but it doesn't so naively I created it and launch again the mysqld... (4 Replies)
Discussion started by: SoulCoder
4 Replies

2. AIX

xlC compilation error when dealing with operator overloading

Hi, I have a piece of C++ code that can be compiled using g++, but reports an error when compiled with xlC: xlC -DHAVE_CONFIG_H -I../SRC -I../include -DNoChange -DSPRNG_MPI -q64 -DLONG64=long -I/usr/lpp/ppe.poe/include -DLONG64=long -c -o libsprng_a-bignum.o bignum.cpp "bignum.cpp",... (1 Reply)
Discussion started by: luop0812
1 Replies

3. Programming

C++ Optr Overloading

Hi All, In C++ one operator can be overloaded, but it can't be overloaded by it's own derieved class Please let me know operator. Thanks, Naga:cool: (1 Reply)
Discussion started by: Nagapandi
1 Replies

4. Programming

Delete operator overloading with multiple arguments.

Hi, I have an requirement to overload the delete operator in C++, but it should also accept the sizeof() the object that is to be deleted. Actually I am trying to built a custom memory allocator and deallocator like a pool, which makes me to overload the delete operator. Small example of the... (1 Reply)
Discussion started by: kapilkumawat
1 Replies

5. Red Hat

comm: mysqld Not tainted ... Kernel Panic , System totally unresponsive

Hi, I am experiencing frequent system hangs, hard kernel panics, etc almost thrice a day. The system would be totally unresponsive and the only way is to reboot is hard power recycling (plug out the power cable and plug in back after 30 secs). I enabled kdump, but unfortunately the kdump files... (3 Replies)
Discussion started by: massoo
3 Replies

6. Programming

c++ assignment operator overloading

Hello everyone! Suppose that I have something like this A a; a.mem=new int; A b = a; where class A { public: int * mem; A() : mem(NULL) { } ~A() { if (mem!=NULL) delete mem; (1 Reply)
Discussion started by: bashuser2
1 Replies

7. Red Hat

MySQL (mysqld) fails to start!

Hello, I have recently installed MySql and I encourage an error. I am using Fedora 15 and when I am trying to start mysqld service i am getting the following error message: Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details. If I try to start it... (4 Replies)
Discussion started by: dot_pro
4 Replies

8. Programming

PHP exec to restart mysqld

I want to do something very very bad. I want to create a button that restarts mysqld. Why is irrelevant for my issue. Here is my php script ... <?php if(isset($_POST)){ exec("sudo /etc/init.d/mysqld restart"); } ?> <form method="POST"> <input type="submit" name="restart"... (3 Replies)
Discussion started by: noPermissions
3 Replies

9. Homework & Coursework Questions

Mysql missing mysqld.sock (Linux)

I am trying to start a server for a class I am in but... mysql won't start with this error ( ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ) ---------- Post updated at 03:51 PM ---------- Previous update was at 03:50 PM ---------- ... (2 Replies)
Discussion started by: Slayer939
2 Replies

10. Programming

C++ operator overloading error

hi, I defined my own String class and overloaded the output operator with friend ostream& operator<<(ostream& os, const myString& str); //overloads the << operator so it can be used to output values of type myString which works fine. Until I try to execute the following statement: // +... (6 Replies)
Discussion started by: milhan
6 Replies
trafgen(8)							netsniff-ng-toolkit							trafgen(8)

NAME
trafgen - a high-performance zero-copy network packet generator SYNOPSIS
trafgen [-d|--dev <netdev>][-c|--conf <file>][-J|--jumbo-support] [-x|--interactive][-n|--num <uint>][-r|--rand][-t|--gap <usec>] [-S|--ring-size <size>][-k|--kernel-pull <usec>][-b|--bind-cpu <cpu>] [-B|--unbind-cpu <cpu>][-H|--prio-high][-Q|--notouch-irq][-v|--version] [-h|--help] DESCRIPTION
A high-performance network traffic generator that uses the zero-copy TX_RING for network I/O. For instance, on comodity Gigabit hardware up to 1,488,095 pps 64 Byte pps have been achieved with trafgen. OPTIONS
trafgen --dev eth0 --conf trafgen.txf --bind-cpu 0 Use packet configuration trafgen.txf, eth0 as transmission device and CPU0 for binding the process. OPTIONS
-h|--help Print help text and lists all options. -v|--version Print version. -d|--dev <netdev> Device for transmission i.e., eth0. -c|--conf <conf> Path to packet configuration file. -x|--interactive Start trafgen in interactive mode. -J|--jumbo-support Support for 64KB Super Jumbo Frames -n|--num <uint> Number of packets to generate before exiting. 0 means forever until SIGINT. -r|--rand Randomize packet selection process instead of round-robin. -t|--gap <uint> Interpacket gap in microseconds. -S|--ring-size <size> Manually set ring size to <size>: mmap space in KB/MB/GB. -k|--kernel-pull <uint> Kernel pull from user interval in microseconds. Default value is 10 microseconds. -b|--bind-cpu <cpu> Bind to specific CPU (or CPU-range). -B|--unbind-cpu <cpu> Forbid to use specific CPU (or CPU-range). -H|--prio-high Make this high priority process. -Q|--notouch-irq Do not touch IRQ CPU affinity of NIC. EXAMPLES
Generate traffic defined in trafgen.txf on eth0 using CPU 0 trafgen --dev eth0 --conf trafgen.txf --bind-cpu 0 Generate traffic on eth0 using CPU 0, wait 100 us between packets trafgen --dev eth0 --conf trafgen.txf --bind-cpu 0 --gap 100 Generate 100,000 packet on eth0 using CPU 0 trafgen --dev eth0 --conf trafgen.txf --bind-cpu 0 --num 100000 AUTHOR
Written by Daniel Borkmann <daniel@netsniff-ng.org> DOCUMENTATION
Documentation by Emmanuel Roullit <emmanuel@netsniff-ng.org> BUGS
Please report bugs to <bugs@netsniff-ng.org> 2012-06-29 trafgen(8)
All times are GMT -4. The time now is 07:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy