Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 06-10-2005 13:30:12

thekiko
Member
Registered: 07-11-2002
Posts: 126

Mysql Being A Hog

Just the past couple of days the store has been chunky.  Anyone seen these kind of numbers?

14:20:53  up 1 day, 10:50,  1 user,  load average: 14.12, 10.48, 11.89
143 processes: 126 sleeping, 17 running, 0 zombie, 0 stopped
CPU states:  cpu    user    nice  system    irq  softirq  iowait    idle
           total   97.4%    0.0%    2.5%   0.0%     0.0%    0.0%    0.0%
Mem:  1027440k av,  801040k used,  226400k free,       0k shrd,   92040k buff
                    303840k actv,  289436k in_d,   13536k in_c
Swap: 2040244k av,   72936k used, 1967308k free                  450332k cached

  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME CPU COMMAND
4932 mysql     25   0 20212  19M  1492 R     7.9  1.9   0:29   0 mysqld
4941 mysql     25   0 20212  19M  1492 R     7.9  1.9   0:25   0 mysqld
4945 mysql     25   0 20212  19M  1492 R     7.9  1.9   0:24   0 mysqld
4951 mysql     25   0 20212  19M  1492 R     7.9  1.9   0:18   0 mysqld
4963 mysql     25   0 20212  19M  1492 R     7.9  1.9   0:17   0 mysqld
5004 mysql     25   0 20212  19M  1492 R     7.9  1.9   0:09   0 mysqld
5035 mysql     23   0 20212  19M  1492 R     7.5  1.9   0:02   0 mysqld
5005 mysql     25   0 20212  19M  1492 R     6.5  1.9   0:09   0 mysqld
4929 mysql     25   0 20212  19M  1492 R     5.9  1.9   0:29   0 mysqld
4931 mysql     25   0 20212  19M  1492 R     5.9  1.9   0:29   0 mysqld
4961 mysql     25   0 20212  19M  1492 R     5.9  1.9   0:17   0 mysqld
5003 mysql     25   0 20212  19M  1492 R     5.9  1.9   0:09   0 mysqld
5006 mysql     25   0 20212  19M  1492 R     5.9  1.9   0:09   0 mysqld
5034 mysql     23   0 20212  19M  1492 R     5.9  1.9   0:02   0 mysqld
3226 apache    15   0  9988 9528  6188 S     0.5  0.9   0:02   0 httpd
30422 apache    15   0 10440 9984  6368 S     0.1  0.9   0:11   0 httpd
30423 apache    15   0 10400 9940  6320 S     0.1  0.9   0:05   0 httpd
  576 apache    16   0 10804  10M  6508 S     0.1  1.0   0:06   0 httpd
4896 root      15   0  1180 1180   896 R     0.1  0.1   0:00   0 top
    1 root      15   0   500  464   440 S     0.0  0.0   0:38   0 init
    2 root      15   0     0    0     0 SW    0.0  0.0   0:00   0 keventd
    3 root      34  19     0    0     0 SWN   0.0  0.0   0:00   0 ksoftirqd/0

I am little bit lost as to what to do next.

Thanks in advance.


TheKiko

Offline

 

#2 06-10-2005 15:22:45

TerryA
Member
From: Sanford, Fl
Registered: 07-14-2003
Posts: 1322
Website

Re: Mysql Being A Hog

I would check your database with PHPMyAdmin if you have it to see if a table has gotten corrupted.

Offline

 

#3 06-10-2005 15:46:13

thekiko
Member
Registered: 07-11-2002
Posts: 126

Re: Mysql Being A Hog

Hi Terry,

Thank you for your help.  What exactly should I be looking for in PHPmyadmin to find a corrupt table?

Thanks again,


TheKiko

Offline

 

#4 06-10-2005 15:48:22

thekiko
Member
Registered: 07-11-2002
Posts: 126

Re: Mysql Being A Hog

Oops.. figured it out smile.


TheKiko

Offline

 

#5 06-10-2005 16:02:40

thekiko
Member
Registered: 07-11-2002
Posts: 126

Re: Mysql Being A Hog

Hmm... no dice on the corrupted mySQL tables.  Are there any other recommendations?

Thanks,


TheKiko

Offline

 

#6 06-10-2005 21:14:25

TerryA
Member
From: Sanford, Fl
Registered: 07-14-2003
Posts: 1322
Website

Re: Mysql Being A Hog

Take a look at your logs and see if there is a robot from MSN or some other search engine that is hitting you hard.  Try your site access log first and look for multiple entries with the same IP.  If you have that, block those IPs in your firewall for a few days or until they go away.

Offline

 

Board footer