PDA

View Full Version : Eva, need help...


MB
Mon 18th Nov '02, 4:06pm
Voilą, i get the following stats:

10:03pm up 3 days, 4:09, 1 user, load average: 88.41, 51.83, 29.48
365 processes: 267 sleeping, 97 running, 1 zombie, 0 stopped
CPU0 states: 62.24% user, 37.0% system, 0.0% nice, 0.0% idle
CPU1 states: 54.21% user, 45.3% system, 0.0% nice, 0.0% idle
Mem: 1030384K av, 1003172K used, 27212K free, 0K shrd, 7484K buff
Swap: 1052216K av, 19564K used, 1032652K free 591156K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
11980 mysql 20 0 153M 153M 2316 R 7.7 15.2 0:20 mysqld
12539 mysql 19 0 151M 151M 2316 R 7.1 15.0 0:02 mysqld
12615 mysql 19 0 151M 151M 2316 R 7.1 15.0 0:03 mysqld
12034 mysql 23 0 156M 156M 2316 R 5.9 15.5 0:25 mysqld
12121 mysql 21 0 156M 156M 2316 R 5.9 15.5 0:22 mysqld
12536 mysql 23 0 151M 151M 2316 R 5.9 15.0 0:07 mysqld
12119 mysql 19 0 156M 156M 2316 R 4.8 15.5 0:15 mysqld
12122 mysql 20 0 156M 156M 2316 R 4.1 15.5 0:15 mysqld
12507 mysql 25 0 154M 154M 2316 R 4.1 15.3 0:05 mysqld
12508 mysql 25 0 151M 151M 2316 R 4.1 15.0 0:05 mysqld
12509 mysql 25 0 151M 151M 2316 R 4.1 15.0 0:05 mysqld
12510 mysql 25 0 151M 151M 2316 R 4.1 15.0 0:05 mysqld
12513 mysql 25 0 151M 151M 2316 R 4.1 15.0 0:05 mysqld
12048 mysql 15 0 156M 156M 2316 R 4.0 15.5 0:20 mysqld
12512 mysql 22 0 151M 151M 2316 R 4.0 15.0 0:04 mysqld
12969 mysql 20 0 145M 145M 2316 R 3.9 14.4 0:01 mysqld
12780 mysql 20 0 151M 151M 2316 R 3.7 15.0 0:01 mysqld
12798 mysql 19 0 151M 151M 2316 R 3.6 15.0 0:02 mysqld
11990 mysql 25 0 153M 153M 2316 R 3.5 15.2 0:17 mysqld
12067 mysql 25 0 156M 156M 2316 R 3.5 15.5 0:28 mysqld
12114 mysql 25 0 156M 156M 2316 R 3.5 15.5 0:17 mysqld
12115 mysql 24 0 156M 156M 2316 R 3.5 15.5 0:19 mysqld
12444 mysql 24 0 156M 156M 2316 R 3.5 15.5 0:08 mysqld
12631 mysql 25 0 151M 151M 2316 R 3.5 15.0 0:03 mysqld
12966 mysql 19 0 145M 145M 2316 D 3.5 14.4 0:01 mysqld
11988 mysql 23 0 153M 153M 2316 R 3.3 15.2 0:24 mysqld
11989 mysql 25 0 153M 153M 2316 R 2.9 15.2 0:20 mysqld
11995 mysql 25 0 153M 153M 2316 R 2.9 15.2 0:19 mysqld
12010 mysql 25 0 153M 153M 2316 R 2.9 15.2 0:25 mysqld
12045 mysql 23 0 156M 156M 2316 R 2.9 15.5 0:20 mysqld
12068 mysql 16 0 156M 156M 2316 R 2.9 15.5 0:25 mysqld
12113 mysql 25 0 156M 156M 2316 R 2.9 15.5 0:21 mysqld
12445 mysql 25 0 156M 156M 2316 R 2.9 15.5 0:04 mysqld
12619 mysql 25 0 151M 151M 2316 R 2.9 15.0 0:04 mysqld
12641 mysql 19 0 151M 151M 2316 R 2.9 15.0 0:04 mysqld
12832 mysql 19 0 151M 151M 2316 R 2.9 15.0 0:01 mysqld
12018 mysql 25 0 153M 153M 2316 R 2.3 15.2 0:13 mysqld
12033 mysql 25 0 156M 156M 2316 R 2.3 15.5 0:24 mysqld
12044 mysql 25 0 156M 156M 2316 R 2.3 15.5 0:16 mysqld
12945 mysql 20 0 144M 144M 2316 R 2.3 14.3 0:01 mysqld
12947 mysql 20 0 144M 144M 2316 R 2.3 14.3 0:01 mysqld
12964 mysql 20 0 144M 144M 2316 R 2.3 14.3 0:02 mysqld
12528 mysql 25 0 151M 151M 2316 R 2.1 15.0 0:05 mysqld
11996 mysql 25 0 153M 153M 2316 R 1.7 15.2 0:21 mysqld
12032 mysql 25 0 155M 155M 2316 R 1.7 15.4 0:19 mysqld
12614 mysql 20 0 151M 151M 2316 R 1.7 15.0 0:02 mysqld
12640 mysql 24 0 151M 151M 2316 R 1.7 15.0 0:03 mysqld
12867 mysql 19 0 151M 151M 2316 R 1.7 15.0 0:01 mysqld
12637 mysql 25 0 151M 151M 2316 R 1.2 15.0 0:04 mysqld
11993 mysql 25 0 153M 153M 2316 R 1.1 15.2 0:24 mysqld
12047 mysql 25 0 156M 156M 2316 R 1.1 15.5 0:11 mysqld
12050 mysql 25 0 156M 156M 2316 R 1.1 15.5 0:16 mysqld
12053 mysql 25 0 156M 156M 2316 R 1.1 15.5 0:17 mysqld
12516 mysql 25 0 151M 151M 2316 R 1.1 15.0 0:03 mysqld
12531 mysql 25 0 151M 151M 2316 R 1.1 15.0 0:03 mysqld
12632 mysql 25 0 151M 151M 2316 R 1.1 15.0 0:04 mysqld
12760 mysql 25 0 151M 151M 2316 R 1.1 15.0 0:02 mysqld
12761 mysql 25 0 151M 151M 2316 R 1.1 15.0 0:02 mysqld
12762 mysql 25 0 151M 151M 2316 R 1.1 15.0 0:02 mysqld
12763 mysql 25 0 151M 151M 2316 R 1.1 15.0 0:02 mysqld
12778 mysql 25 0 151M 151M 2316 R 1.1 15.0 0:02 mysqld
12788 mysql 25 0 151M 151M 2316 R 1.1 15.0 0:02 mysqld
12796 mysql 22 0 151M 151M 2316 R 1.1 15.0 0:02 mysqld
12837 mysql 19 0 151M 151M 2316 R 1.1 15.0 0:02 mysqld
12870 mysql 21 0 144M 144M 2316 R 1.1 14.3 0:02 mysqld
12961 mysql 15 0 144M 144M 2316 D 0.9 14.3 0:00 mysqld
12104 mysql 25 0 156M 156M 2316 R 0.8 15.5 0:16 mysqld
11966 mysql 25 0 153M 153M 2316 R 0.5 15.2 0:16 mysqld
12116 mysql 20 0 156M 156M 2316 R 0.5 15.5 0:19 mysqld
12124 mysql 25 0 156M 156M 2316 R 0.5 15.5 0:16 mysqld
12511 mysql 20 0 151M 151M 2316 R 0.5 15.0 0:02 mysqld
12633 mysql 25 0 151M 151M 2316 R 0.5 15.0 0:02 mysqld
12634 mysql 25 0 151M 151M 2316 R 0.5 15.0 0:02 mysqld
12636 mysql 21 0 151M 151M 2316 R 0.5 15.0 0:01 mysqld
12638 mysql 21 0 151M 151M 2316 R 0.5 15.0 0:02 mysqld
12642 mysql 25 0 151M 151M 2316 R 0.5 15.0 0:02 mysqld
12643 mysql 20 0 151M 151M 2316 R 0.5 15.0 0:01 mysqld
12644 mysql 25 0 151M 151M 2316 R 0.5 15.0 0:02 mysqld
12646 mysql 19 0 151M 151M 2316 R 0.5 15.0 0:01 mysqld
12765 mysql 21 0 151M 151M 2316 R 0.5 15.0 0:01 mysqld
12791 mysql 20 0 151M 151M 2316 R 0.5 15.0 0:02 mysqld
12824 mysql 20 0 151M 151M 2316 R 0.5 15.0 0:02 mysqld
12942 mysql 20 0 144M 144M 2316 R 0.5 14.3 0:01 mysqld
12962 mysql 20 0 144M 144M 2316 R 0.5 14.3 0:01 mysqld
12784 mysql 20 0 151M 151M 2316 R 0.0 15.0 0:02 mysqld
12789 mysql 19 0 151M 151M 2316 R 0.0 15.0 0:01 mysqld
12797 mysql 19 0 151M 151M 2316 R 0.0 15.0 0:01 mysqld
12831 mysql 20 0 151M 151M 2316 R 0.0 15.0 0:02 mysqld
12835 mysql 20 0 151M 151M 2316 R 0.0 15.0 0:01 mysqld
12836 mysql 20 0 151M 151M 2316 R 0.0 15.0 0:02 mysqld
12948 mysql 15 0 144M 144M 2316 R 0.0 14.3 0:00 mysqld


Http processes currently running = 153
Mysql processes currently running = 159

Netstat information summary
1 CLOSE_WAIT
3 FIN_WAIT2
6 LISTEN
9 FIN_WAIT1
39 SYN_RECV
107 ESTABLISHED
337 TIME_WAIT

Any suggestions?

MB
Mon 18th Nov '02, 4:10pm
Many of this "# Query_time: 422 Lock_time: 0 Rows_sent: 1 Rows_examined: 1357644
SELECT count(*) AS posts FROM post WHERE dateline > '1037652187';
# Time: 021118 22:06:01" in the logs...

I guess, i need a firewall..

MB
Mon 18th Nov '02, 4:45pm
Originally posted by MB
Many of this "# Query_time: 422 Lock_time: 0 Rows_sent: 1 Rows_examined: 1357644
SELECT count(*) AS posts FROM post WHERE dateline > '1037652187';
# Time: 021118 22:06:01" in the logs...

I guess, i need a firewall..

Lol.. i get it.. (and it took only 3 hours to find out..)

"action=getnew"

Kill this function or you can get flooded easily.. Load times now around 1-2 and an ultra fast start site...

And now i`m going to check which nice user used "search.php?action=getdaily" and have a nice talk with this isp.

walter
Mon 18th Nov '02, 4:48pm
BTW, "Eva"s name actually is George :)

Steve Machol
Mon 18th Nov '02, 4:49pm
MB, to get vB support on these forums please follow the instructions in my sig to register for Priority Forum Support. If you are not the license holder then you'll need to ask the owner to enter your email address in that form. :)

eva2000
Mon 18th Nov '02, 11:10pm
MB, as steve asked, please enter your vBulletin.com forum username on the form on this page to receive support for this issue: http://www.vbulletin.com/members/forums.php
- you will need your vB license customer number and password to access this form.