Any server experts? HELP NEEDED
 

Hi there,


I cannot contact my webhostand it's seriously affecting my sales, among other things. I have access to cPanel, WHM and I can get into the server via that "putty" program as well (SSH?).

The problem is PHP and or MySQL running way too slow. An example: www.buffononline.com (try going to the forum). It is like this across all my sites that use dynamic programming. I had this problem a few days ago, however my host messaged me right back and told me to check now. In about 10 seconds flat the problem that had lasted hours was gone.


Here is my server status (accessed from within cPanel):

apache (1.3.33 (Unix)) up
bind (9.3.0) up
cppop up
cpsrvd up
exim up
exim-26 up
ftpd up
imap up
mysql (4.0.22) up
syslogd up
Server Load 8.37 (1 cpu) <---- Red flashing light
Memory Used 87.39 % <----- Yellow flashing light
Swap 47.00 %
Disk ad0s1a (/) 17 %
Disk ad0s1g (/home) 52 %
Disk ad0s1f (/usr) 94 % <----- Red flashing light
Disk ad0s1e (/var) 68 %
Disk (dev) 17 %



From my above access, is there anyway to solve this issue?

Any assistance would be extremely appreciated.

SSH onto the server. If its unix type: ps -aux : look thru the processes for something using alot of cpu.. Type : killall -9 PROCESSNAME

It may be that simple..

check the active connections on the mysql server... a lot of floods goin around lately causing the connections not to close... =\ that's most likely it.

if you have phpmyadmin installed, just click on process.

restarting mysql however will not fix the problem.

if you have to do it via commandline use,
SHOW PROCESSLIST;

http://dev.mysql.com/doc/mysql/en/show-processlist.html

ICQ: 4930562

I could help you out

you are hitting swap big time, your drives are pushing capacity, paste your error_log out put

i don't think he's hitting swap... the other links work fine and fast. when you click on something db related, its dead.

Getting a little help from Zagi, let's hope I can get something done with him.

Thanks for the replies so far!

bash$ ps -aux
USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
nobody 71740 44.2 0.0 39160 332 ?? R Tue12PM 774:51.01 /usr/local/apac
nobody 73243 43.3 0.0 39348 332 ?? R Tue12PM 773:15.39 /usr/local/apac
nobody 43589 0.0 0.0 696 268 ?? S 8:10PM 0:00.00 /usr/local/libe
nobody 43588 0.0 0.0 632 240 ?? S 8:10PM 0:00.00 sh -c /usr/loca
nobody 43587 0.0 0.1 2260 1360 ?? S 8:10PM 0:00.00 /usr/bin/nrpe -
nobody 43586 0.0 0.1 2260 1340 ?? Ss 8:10PM 0:00.02 /usr/bin/nrpe -
mysql 43584 0.0 2.0 70108 20260 ?? RN 8:10PM 0:00.00 /usr/local/libe
mysql 43583 0.0 2.0 70108 20260 ?? SN 8:10PM 0:00.00 /usr/local/libe
mysql 43578 0.0 2.0 70108 20260 ?? SN 8:10PM 0:00.00 /usr/local/libe
buffon 43577 0.0 0.1 804 652 p0 Ss 8:10PM 0:00.01 -bash (bash)
buffon 43576 0.0 0.2 5344 1676 ?? S 8:10PM 0:00.00 sshd: buffon@tt
root 43572 0.0 0.2 5344 1588 ?? S 8:10PM 0:00.03 sshd: buffon [p
mysql 43571 0.0 2.0 70108 20260 ?? SN 8:10PM 0:00.00 /usr/local/libe
nobody 43527 0.0 1.2 44888 11988 ?? S 8:09PM 0:00.07 /usr/local/apac
nobody 43526 0.0 1.1 44788 11264 ?? S 8:09PM 0:00.04 /usr/local/apac
nobody 43525 0.0 1.1 44792 11280 ?? S 8:09PM 0:00.06 /usr/local/apac
mysql 43523 0.0 2.0 70108 20260 ?? IN 8:09PM 0:00.00 /usr/local/libe
mysql 43497 0.0 2.0 70108 20260 ?? IN 8:09PM 0:00.00 /usr/local/libe
digital 43496 0.0 0.2 2612 1820 ?? I 8:09PM 0:00.01 proftpd: digita
ifiancee 43477 0.0 0.2 2612 1852 ?? S 8:08PM 0:00.01 proftpd: ocauto
mysql 43422 0.0 2.0 70108 20260 ?? IN 8:07PM 0:00.00 /usr/local/libe
mysql 43389 0.0 2.0 70108 20260 ?? IN 8:06PM 0:00.00 /usr/local/libe
mysql 43370 0.0 2.0 70108 20260 ?? IN 8:06PM 0:00.00 /usr/local/libe
mysql 43350 0.0 2.0 70108 20260 ?? IN 8:05PM 0:00.00 /usr/local/libe
mysql 43335 0.0 2.0 70108 20260 ?? IN 8:05PM 0:00.00 /usr/local/libe
mysql 43277 0.0 2.0 70108 20260 ?? IN 8:04PM 0:00.00 /usr/local/libe
mysql 43256 0.0 2.0 70108 20260 ?? IN 8:04PM 0:00.00 /usr/local/libe
mysql 43217 0.0 2.0 70108 20260 ?? IN 8:03PM 0:00.00 /usr/local/libe
mysql 43097 0.0 2.0 70108 20260 ?? IN 8:00PM 0:00.00 /usr/local/libe
mysql 43096 0.0 2.0 70108 20260 ?? IN 8:00PM 0:00.00 /usr/local/libe
mysql 43064 0.0 2.0 70108 20260 ?? IN 8:00PM 0:00.00 /usr/local/libe
mysql 43008 0.0 2.0 70108 20260 ?? IN 8:00PM 0:00.00 /usr/local/libe
mysql 42940 0.0 2.0 70108 20260 ?? IN 7:58PM 0:00.00 /usr/local/libe
mysql 42716 0.0 2.0 70108 20260 ?? IN 7:54PM 0:00.00 /usr/local/libe
mysql 42579 0.0 2.0 70108 20260 ?? IN 7:51PM 0:00.00 /usr/local/libe
mysql 42346 0.0 2.0 70108 20260 ?? IN 7:48PM 0:00.00 /usr/local/libe
mysql 42345 0.0 2.0 70108 20260 ?? IN 7:48PM 0:00.00 /usr/local/libe
mysql 42344 0.0 2.0 70108 20260 ?? IN 7:48PM 0:00.00 /usr/local/libe
mysql 42343 0.0 2.0 70108 20260 ?? SN 7:48PM 0:00.21 /usr/local/libe
mysql 42342 0.0 2.0 70108 20260 ?? SN 7:48PM 0:00.31 /usr/local/libe
mysql 42331 0.0 2.0 70108 20260 ?? IN 7:47PM 0:00.00 /usr/local/libe
mysql 42330 0.0 2.0 70108 20260 ?? IN 7:47PM 0:00.00 /usr/local/libe
mysql 42329 0.0 2.0 70108 20260 ?? IN 7:47PM 0:00.00 /usr/local/libe
mysql 42328 0.0 2.0 70108 20260 ?? IN 7:47PM 0:00.00 /usr/local/libe
mysql 42327 0.0 2.0 70108 20260 ?? SN 7:47PM 0:00.04 /usr/local/libe
mysql 42273 0.0 2.0 70108 20260 ?? SN 7:47PM 0:00.11 /usr/local/libe
root 42251 0.0 0.0 652 252 ?? I 7:47PM 0:00.01 /bin/sh /usr/lo
freeplay 73744 0.0 0.1 7984 824 ?? RN 2:22AM 0:00.00 cpaneld - servi
freeplay 73743 0.0 0.1 8020 832 ?? RNs 2:22AM 0:00.03 cpaneld - servi
freeplay 73692 0.0 0.1 8024 820 ?? RN 2:21AM 0:00.00 cpaneld - servi
root 71528 0.0 0.1 4008 540 ?? RN 1:47AM 0:00.03 dcpumon - killp
root 71527 0.0 0.1 3488 1444 ?? I 1:47AM 0:01.10 chkservd (perl)
mailnull 57133 0.0 0.1 5212 924 ?? Is 1:42AM 0:00.01 /usr/sbin/sendm
root 57113 0.0 0.0 3468 0 ?? IW - 0:00.00 /usr/bin/perl /
root 57111 0.0 0.0 632 0 ?? IWs - 0:00.00 /bin/sh -c /scr
root 57109 0.0 0.0 1116 368 ?? I 1:42AM 0:00.05 cron: running j
root 54701 0.0 0.1 5044 1296 ?? RN 1:00AM 0:00.00 /usr/bin/perl /
root 54671 0.0 0.1 5044 1296 ?? IN 1:00AM 0:00.13 /usr/bin/perl /
root 54664 0.0 0.0 632 0 ?? IWs - 0:00.00 /bin/sh -c /scr
root 54656 0.0 0.0 1040 324 ?? I 1:00AM 0:00.00 cron: running j
nobody 34776 0.0 1.2 57040 12672 ?? S Tue08PM 1:30.59 /usr/local/apac
nobody 34765 0.0 1.4 57348 14652 ?? S Tue08PM 1:39.43 /usr/local/apac
nobody 34764 0.0 2.4 57304 24824 ?? S Tue08PM 1:35.70 /usr/local/apac
nobody 34763 0.0 1.6 57340 16460 ?? S Tue08PM 1:34.29 /usr/local/apac
nobody 34754 0.0 1.2 57596 12500 ?? S Tue08PM 1:31.99 /usr/local/apac
nobody 34693 0.0 1.2 58476 12712 ?? S Tue08PM 1:33.45 /usr/local/apac
nobody 34575 0.0 1.3 57308 13772 ?? S Tue08PM 1:31.78 /usr/local/apac
nobody 34095 0.0 1.7 57412 17344 ?? S Tue07PM 1:36.91 /usr/local/apac
nobody 34092 0.0 1.5 57448 15480 ?? S Tue07PM 1:36.81 /usr/local/apac
nobody 34073 0.0 1.5 56700 15536 ?? S Tue07PM 1:31.31 /usr/local/apac
nobody 34007 0.0 1.3 57176 13244 ?? S Tue07PM 1:30.81 /usr/local/apac
nobody 33877 0.0 1.4 57436 14200 ?? S Tue07PM 1:31.17 /usr/local/apac
nobody 33876 0.0 1.4 57220 14616 ?? S Tue07PM 1:35.86 /usr/local/apac
nobody 33873 0.0 1.5 56896 15732 ?? S Tue07PM 1:34.90 /usr/local/apac
nobody 33871 0.0 1.2 57280 12452 ?? S Tue07PM 1:35.40 /usr/local/apac
nobody 33869 0.0 1.4 57008 14580 ?? S Tue07PM 1:33.08 /usr/local/apac
nobody 33868 0.0 1.3 57220 13056 ?? S Tue07PM 1:30.47 /usr/local/apac
nobody 33867 0.0 1.4 57196 14944 ?? S Tue07PM 1:38.58 /usr/local/apac
nobody 33866 0.0 1.1 57180 11380 ?? S Tue07PM 1:34.81 /usr/local/apac
nobody 33865 0.0 2.3 57264 23808 ?? S Tue07PM 1:31.84 /usr/local/apac
nobody 33864 0.0 1.6 57592 16716 ?? S Tue07PM 1:35.59 /usr/local/apac
nobody 33863 0.0 2.2 57516 22664 ?? S Tue07PM 1:37.16 /usr/local/apac
nobody 33862 0.0 1.5 57348 15756 ?? S Tue07PM 1:35.23 /usr/local/apac
nobody 33861 0.0 1.6 57448 16804 ?? S Tue07PM 1:35.71 /usr/local/apac
nobody 33860 0.0 1.6 57248 16200 ?? S Tue07PM 1:34.44 /usr/local/apac
nobody 33859 0.0 1.3 57136 13596 ?? S Tue07PM 1:34.02 /usr/local/apac
nobody 33858 0.0 1.3 57236 13000 ?? S Tue07PM 1:31.24 /usr/local/apac
nobody 33857 0.0 1.3 57036 13564 ?? S Tue07PM 1:32.19 /usr/local/apac
nobody 33856 0.0 1.6 56684 16252 ?? S Tue07PM 1:30.37 /usr/local/apac
nobody 33855 0.0 1.5 57416 15652 ?? S Tue07PM 1:38.15 /usr/local/apac
nobody 33854 0.0 2.1 57108 21784 ?? S Tue07PM 1:35.46 /usr/local/apac
nobody 33853 0.0 1.6 57380 16520 ?? S Tue07PM 1:37.27 /usr/local/apac
nobody 33852 0.0 2.2 57440 22500 ?? S Tue07PM 1:34.74 /usr/local/apac
nobody 33851 0.0 1.5 57152 15400 ?? S Tue07PM 1:34.49 /usr/local/apac
nobody 33850 0.0 1.5 54612 15880 ?? S Tue07PM 1:34.80 /usr/local/apac
nobody 33849 0.0 1.1 57204 11588 ?? S Tue07PM 1:35.33 /usr/local/apac
nobody 33848 0.0 2.4 57472 24888 ?? S Tue07PM 1:38.40 /usr/local/apac
nobody 33847 0.0 1.5 56836 15288 ?? S Tue07PM 1:30.62 /usr/local/apac
nobody 33846 0.0 1.4 57460 14272 ?? S Tue07PM 1:33.17 /usr/local/apac
nobody 33845 0.0 1.5 57308 15796 ?? S Tue07PM 1:38.32 /usr/local/apac
nobody 33844 0.0 1.5 57068 15316 ?? S Tue07PM 1:33.09 /usr/local/apac
nobody 33843 0.0 1.4 57280 14700 ?? S Tue07PM 1:35.98 /usr/local/apac
nobody 33842 0.0 1.3 57312 13968 ?? S Tue07PM 1:33.85 /usr/local/apac
nobody 33841 0.0 1.3 57252 13448 ?? S Tue07PM 1:37.67 /usr/local/apac
nobody 33840 0.0 1.3 57356 13204 ?? S Tue07PM 1:32.62 /usr/local/apac
nobody 33839 0.0 1.6 57040 16328 ?? S Tue07PM 1:37.35 /usr/local/apac
nobody 33838 0.0 1.2 54424 12864 ?? S Tue07PM 1:31.73 /usr/local/apac
nobody 33837 0.0 1.4 57324 14996 ?? S Tue07PM 1:33.03 /usr/local/apac
nobody 33836 0.0 1.3 57316 13532 ?? S Tue07PM 1:36.40 /usr/local/apac
nobody 33835 0.0 1.2 57356 12388 ?? R Tue07PM 1:32.55 /usr/local/apac
nobody 33834 0.0 1.6 57204 16724 ?? S Tue07PM 1:36.48 /usr/local/apac
nobody 33833 0.0 1.4 57512 14668 ?? S Tue07PM 1:35.45 /usr/local/apac
nobody 33832 0.0 1.6 57464 16824 ?? S Tue07PM 1:34.50 /usr/local/apac
nobody 33831 0.0 1.5 56764 15076 ?? S Tue07PM 1:32.99 /usr/local/apac
nobody 33830 0.0 2.2 57132 22912 ?? S Tue07PM 1:32.65 /usr/local/apac
nobody 33829 0.0 1.5 57524 15296 ?? S Tue07PM 1:31.09 /usr/local/apac

...
nobody 33828 0.0 1.6 57520 16644 ?? S Tue07PM 1:33.83 /usr/local/apac
nobody 33827 0.0 1.3 56928 13972 ?? S Tue07PM 1:34.63 /usr/local/apac
nobody 33826 0.0 1.3 57324 13888 ?? S Tue07PM 1:32.21 /usr/local/apac
nobody 33825 0.0 1.4 56480 14500 ?? S Tue07PM 1:32.45 /usr/local/apac
nobody 33824 0.0 1.6 57416 17004 ?? S Tue07PM 1:39.37 /usr/local/apac
nobody 33823 0.0 1.6 60104 16072 ?? S Tue07PM 1:32.29 /usr/local/apac
nobody 33822 0.0 1.3 57388 13516 ?? S Tue07PM 1:35.71 /usr/local/apac
nobody 33821 0.0 1.3 57240 13292 ?? S Tue07PM 1:33.75 /usr/local/apac
nobody 33820 0.0 1.3 57432 13892 ?? S Tue07PM 1:31.89 /usr/local/apac
nobody 33819 0.0 1.3 57896 13900 ?? S Tue07PM 1:32.01 /usr/local/apac
nobody 33818 0.0 2.3 57340 23744 ?? S Tue07PM 1:31.67 /usr/local/apac
nobody 33817 0.0 1.3 57292 13332 ?? S Tue07PM 1:30.29 /usr/local/apac
nobody 33816 0.0 1.3 57032 12960 ?? S Tue07PM 1:32.99 /usr/local/apac
nobody 33815 0.0 1.2 57364 12380 ?? S Tue07PM 1:34.85 /usr/local/apac
nobody 33814 0.0 2.2 57104 23300 ?? S Tue07PM 1:35.61 /usr/local/apac
nobody 33813 0.0 1.3 57332 13556 ?? S Tue07PM 1:33.41 /usr/local/apac
nobody 33812 0.0 1.4 54692 14820 ?? S Tue07PM 1:33.23 /usr/local/apac
nobody 33811 0.0 1.3 57128 13540 ?? S Tue07PM 1:35.31 /usr/local/apac
nobody 33810 0.0 1.4 57424 14784 ?? S Tue07PM 1:31.77 /usr/local/apac
nobody 33809 0.0 2.3 57136 24056 ?? S Tue07PM 1:34.69 /usr/local/apac
nobody 33808 0.0 1.4 49336 14724 ?? S Tue07PM 1:31.91 /usr/local/apac
nobody 33805 0.0 1.2 57464 12936 ?? S Tue07PM 1:33.97 /usr/local/apac
nobody 33804 0.0 1.4 57100 14888 ?? S Tue07PM 1:32.59 /usr/local/apac
nobody 33798 0.0 1.3 56828 13332 ?? S Tue07PM 1:36.49 /usr/local/apac
nobody 33797 0.0 1.2 57460 11936 ?? S Tue07PM 1:36.30 /usr/local/apac
nobody 33796 0.0 1.3 56932 13620 ?? S Tue07PM 1:36.49 /usr/local/apac
nobody 33795 0.0 1.4 57256 14296 ?? S Tue07PM 1:29.84 /usr/local/apac
nobody 33794 0.0 1.6 57252 16432 ?? S Tue07PM 1:33.08 /usr/local/apac
nobody 33793 0.0 1.4 56976 14076 ?? S Tue07PM 1:36.51 /usr/local/apac
nobody 33792 0.0 1.5 57360 15484 ?? S Tue07PM 1:34.25 /usr/local/apac
nobody 33783 0.0 1.5 56972 15332 ?? S Tue07PM 1:31.58 /usr/local/apac
nobody 33782 0.0 1.3 57364 13428 ?? S Tue07PM 1:34.78 /usr/local/apac
nobody 33781 0.0 1.4 57112 14596 ?? S Tue07PM 1:34.02 /usr/local/apac
nobody 33780 0.0 1.3 56948 13476 ?? S Tue07PM 1:30.41 /usr/local/apac
nobody 33779 0.0 1.3 57140 13424 ?? S Tue07PM 1:33.32 /usr/local/apac
nobody 33778 0.0 1.3 56940 13684 ?? S Tue07PM 1:31.57 /usr/local/apac
nobody 33777 0.0 2.3 57292 23856 ?? S Tue07PM 1:34.00 /usr/local/apac
nobody 33776 0.0 1.3 57244 13516 ?? S Tue07PM 1:33.69 /usr/local/apac
nobody 33771 0.0 1.1 57120 11744 ?? S Tue07PM 1:34.52 /usr/local/apac
nobody 33769 0.0 1.2 57088 12752 ?? S Tue07PM 1:33.95 /usr/local/apac
bind 3388 0.0 0.4 6492 3684 ?? Ss Tue01AM 5:00.57 /usr/sbin/named
root 68340 0.0 0.1 23768 1364 ?? S Mon07PM 5:56.97 /usr/local/sbin
root 47042 0.0 0.1 7048 1096 ?? S 9Feb05 0:17.40 cppop - accepti
root 46890 0.0 0.1 2292 696 ?? S 9Feb05 0:59.43 antirelayd (per
mailnull 46879 0.0 0.0 5196 348 ?? Is 9Feb05 0:00.50 /usr/local/sbin
mailnull 46877 0.0 0.0 5196 0 ?? Is 9Feb05 0:00.01 /usr/local/sbin
mailnull 46874 0.0 0.0 5196 392 ?? Ss 9Feb05 0:09.53 /usr/local/sbin
root 68751 0.0 0.1 7884 1116 ?? I 3Feb05 0:30.75 cpsrvd - waitin
mailman 68672 0.0 0.1 7400 752 ?? I 3Feb05 0:01.97 /usr/bin/python
mailman 68671 0.0 0.1 7400 760 ?? S 3Feb05 3:07.36 /usr/bin/python
mailman 68670 0.0 0.1 7448 792 ?? S 3Feb05 3:22.93 /usr/bin/python
mailman 68669 0.0 0.1 7412 744 ?? S 3Feb05 3:05.97 /usr/bin/python
mailman 68668 0.0 0.1 7400 752 ?? S 3Feb05 3:06.11 /usr/bin/python
mailman 68667 0.0 0.1 7400 740 ?? S 3Feb05 3:05.86 /usr/bin/python
mailman 68666 0.0 0.1 7404 784 ?? S 3Feb05 3:20.12 /usr/bin/python
mailman 68665 0.0 0.1 7400 768 ?? S 3Feb05 3:06.98 /usr/bin/python
mailman 68661 0.0 0.0 7428 0 ?? Is 3Feb05 0:00.13 /usr/bin/python
root 94544 0.0 1.0 44724 10232 ?? Ss 30Jan05 12:20.98 /usr/local/apac
root 847 0.0 0.0 968 0 v7 IWs+ - 0:00.00 /usr/libexec/ge
root 846 0.0 0.0 968 0 v6 IWs+ - 0:00.00 /usr/libexec/ge
root 845 0.0 0.0 968 0 v5 IWs+ - 0:00.00 /usr/libexec/ge
root 844 0.0 0.0 968 0 v4 IWs+ - 0:00.00 /usr/libexec/ge
root 843 0.0 0.0 968 0 v3 IWs+ - 0:00.00 /usr/libexec/ge
root 842 0.0 0.0 968 0 v2 IWs+ - 0:00.00 /usr/libexec/ge
root 841 0.0 0.0 968 0 v1 IWs+ - 0:00.00 /usr/libexec/ge
root 840 0.0 0.0 968 0 v0 IWs+ - 0:00.00 /usr/libexec/ge
root 836 0.0 0.0 5328 452 ?? Ss 25Jan05 0:30.41 /usr/local/sbin
root 517 0.0 0.0 2252 0 ?? IWs - 0:00.00 /usr/local/sbin
cpanel 426 0.0 0.0 3224 136 ?? Ss 25Jan05 0:46.16 /usr/bin/stunne
mailman 270 0.0 0.1 6820 748 ?? I 25Jan05 0:02.92 /usr/bin/python
nobody 190 0.0 0.1 2612 964 ?? Is 25Jan05 1:01.99 proftpd: (accep
root 124 0.0 0.0 940 124 ?? Is 25Jan05 0:01.72 /usr/sbin/usbd
root 122 0.0 0.1 2644 592 ?? Ss 25Jan05 1:44.84 /usr/sbin/sshd
root 120 0.0 0.0 1040 228 ?? Is 25Jan05 0:09.63 /usr/sbin/cron
root 118 0.0 0.0 1116 212 ?? Ss 25Jan05 0:49.03 /usr/sbin/inetd
root 110 0.0 0.0 1000 304 ?? Ss 25Jan05 0:28.85 /usr/sbin/syslo
root 28 0.0 0.0 212 0 ?? IWs - 0:00.00 adjkerntz -i
root 11 0.0 0.0 0 0 ?? DL 25Jan05 0:11.45 (vnlru)
root 10 0.0 0.0 0 0 ?? DL 25Jan05 66:23.25 (syncer)
root 9 0.0 0.0 0 0 ?? DL 25Jan05 0:31.69 (bufdaemon)
root 8 0.0 0.0 0 0 ?? DL 25Jan05 28:12.68 (vmdaemon)
root 7 0.0 0.0 0 0 ?? DL 25Jan05 82:42.80 (pagedaemon)
root 6 0.0 0.0 0 0 ?? DL 25Jan05 0:00.14 (usb2)
root 5 0.0 0.0 0 0 ?? DL 25Jan05 0:00.15 (usb1)
root 4 0.0 0.0 0 0 ?? DL 25Jan05 0:00.00 (usbtask)
root 3 0.0 0.0 0 0 ?? DL 25Jan05 0:00.21 (usb0)
root 2 0.0 0.0 0 0 ?? DL 25Jan05 0:00.00 (taskqueue)
root 1 0.0 0.0 556 76 ?? ILs 25Jan05 0:04.59 /sbin/init --
buffon 43593 0.0 0.0 628 228 p0 R+ 8:10PM 0:00.00 ps -aux
root 0 0.0 0.0 0 0 ?? DLs 25Jan05 0:05.14 (swapper)
mysql 43590 0.0 2.0 70108 20260 ?? RN 8:10PM 0:00.00 /usr/local/libe
bash$

that's alot of running processes lol

did u do what i said yet?

I don't know how to get on phpmyadmin for the entire server, just individual accounts.

When I go in via SSH here is what I get:


bash$ SHOW PROCESSLIST;
bash: SHOW: command not found
bash$

hehe, you have to be connected to mysql to use that command

if you know your mysql username and pass do this

mysql -h localhost -u user -p

enter pass, then do that command.

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW PROCESSLIST;
+-----+--------+-----------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+--------+-----------+------+---------+------+-------+------------------+
| 237 | buffon | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST |
+-----+--------+-----------+------+---------+------+-------+------------------+
1 row in set (0.02 sec)

mysql>



I think it's just giving the same thing as if I go thru phpmyadmin..

It's only for the one account I logged in through.

In "ps aux" if the kernel is not modifed/trimmed, you will see all proceses of the server including other users' processes. To see only your processes, do "ps x" command.

The problem is not php nor mysql in your end. Lots of mysql data conections are being made on the server and couldn't deal with your end properly (this happens all the time with default mysql settings). If you require or use such a huge amount of mysql data connections like right now, you must either have a seperate mysql server (coz as it seems you're on a shared one) or request to adjust mysql settings to allow more connections than the usual.

If it gets any more slower, mysql will die instantly.

ps x - show process for current user
ps aux - show all running processes
who - who is currently on the terminal
finger username - know extended information on the user if set
gfy roks - yes.

There's your problem..

Looks like Apache is going nuts on you..

This could be caused by many things..

Try turning apache off for 2 minutes, then restarting Apache...

Thanks for that.

My host told me it's a dedicated and I am paying for a dedicated server, yet a few people seem to think it's shared... Which is a little distrurbing in itself.

In regards to ps aux; if you look at the long list I posted above (two posts) you will see what I got when typing "ps aux".

ping buffononline.com
PING buffononline.com (205.138.198.14): 56 data bytes
64 bytes from 205.138.198.14: icmp_seq=0 ttl=55 time=7.761 ms


ping foundrynap.com
PING foundrynap.com (205.138.198.14): 56 data bytes
64 bytes from 205.138.198.14: icmp_seq=0 ttl=55 time=7.587 ms

Find a real host get off foundrynap.com

Host I reccomend in no particular order:

Mojohost.com
Phatservers.com
Techiemedia.com
Isprime.com
Webair.com
Oxeo.com


Whats the matter can't find support right now?

Hmmm thats the going trend with these loosers. The above list is of hosts that I know are solid and I'm an ex employee of a few of them and still recommend them.

Looks like a very busy server to me. You certain its a dedicated machine?

It is shared they are serving their own webpage off the same ip.


( Insert owned pic here )

This below:
Are not accesses. They are status' of your server. Red Flashing light is critical while yellow is almost critical. If this server is your own dedicated server, you are eating alot of it.

If it says up it means you're in good shape.
f Disk ad0s1f (/usr) 94 % <----- Red flashing light is already full, I am expecting that you're on a shared server and that's caused by mysql data connections.
Disk ad0s1g (/home) 52 % is where all sites are in, specifically /home/username.
Server Load 8.37 (1 cpu) <---- Red flashing light Means you have a very busy server, good business.
Memory Used 87.39 % <----- Yellow flashing light You can still accomodate another daemon to make your server fail. This is not good.
Disk (dev) 17 % Has all the compilers and thunderstorm generators how you can be able to have cPanel installed etc..

What you can do is grab a dedicated mysql server if mysql is failing you. Once the memory flops, everything will fail you.

EDIT: Get a dedicated mysql server. A server for mysql purposes only, nothing more. It will be handy for the next 3 to 4 months until you get to expand more. Based on your stats, you're on a shared server. Yes cPanel gets bugs like the rest. If you're on a dedicated server, your stats is not working properly.

Well, considing I was told and paying for a DEDICATED SERVER, it's all quite frusterating.

Right now without support or root (wonder why? heh?) - is there anything I can do to get the sites running? I mean it's pretty hard to get any sales when pages take this long to load.

Thank you guys os much for your help btw, I am just having a hard time with this when I can't get support.

Holy hell that is gey. Telling you you have a dedicated server and they are hosting their stuff (and who knows who elses) on that IP? Shitty m8.

Damn man, you should really get in touch with the guy who sold that as a dedicated server to you. Get your money back or something. That's ridiculous. Why would a host do that? Especially one advertising all over the place? What nasty publicity.

answer my ICQ steen

If you do not have root, the server is not yours. If the server is not yours, you are sharing it. If you are sharing it, you're on a dedicated server shared between other users. You are not on a dedicated server, you're on a shared server. If you're on a virtual dedicated server (also known as VDS), you are technically sharing the server.

Yes it is fraustrating coz the server is the backbone of your sites. Your sites can be jacked anytime and still remain standing. Your server gets jacked, you are considered to be a disabled.

Get a managed server or have someone manage the server for you. Lots of good hosts here. Honestly, you can't do everything alone. Design is for design as for content is for content and server management is for server management. If you mix any of those in any one man, you're on a 50/50 scale.

Multi-tasking is good yes, it doesn't mean it's 100% effective.

EDIT: English is my 3rd language.

Considering Steen2 needs to move on a new host, this is a bump. Spam servers? Hehehe :)
http://66.195.126.15/x/xp.jpg
Only a few survived.

Sorry, I was just leaving when you ICQed me and had to rush out the door and computer shut down. Could you ICQ me again please?

Agreed. 150 domains on the IP when I do a reverse lookup.

Included I see "p3rsian" incase he's wondering as well.

get off foundrynap as soon as you resolve this, they are a sinking ship

That is almost funny (in a twisted way).........foundrynap are scammers......hahahaha :1orglaugh

Unless Steen2 owns all of those domains, it's Steen2's dedicated server and Steen2's doing a good job. :thumbsup

Wow appears the one man wonder reseller has taken a shit.

Is it possible to move servers while all this is going down?

Of course its possible. The new host you choose will gladly help you transfer everything over for you. Or should. It's what we'd do.

Create backups of your db's and everything else FIRST before you get into heated discussions with the host, or before you send the cancelation

Backup everything, get a new server elsewhere, upload everything, change DNS and THEN cancel