Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Runaway process

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Runaway process
# 1  
Old 11-26-2008
Runaway process
Hello all,

My hosting provider has contacted me in order to notify about a runaway process issue. Here it is:

Quote:
This is the 2nd notification regarding issues with the site's scripts. The website is causing server wide load problems for the shared web server it is using.

In order help maintain your web hosting account's server-side system resource stability, our System Administrators have requested that you review the code within the below noted files/server function requests, so that it is more efficient and less resource intensive.

We do not want or like to take sites down, but repeated issues like this cause an entire server to become either slow or unavailable. As this is a shared server, it affects many many customers, and reflects poorly on our company. CPU overuse is a violation of your AUP agreement, and it can lead to the site being shut down.
They have given me a list of those processes but I can neither analyze nor understand what I should do.

Code:
 
DATE
Fri Nov 21 21:32:29 GMT 2008
 
SINFO
hostname: yildizsavaslari.com
ip: 199.238.132.2
server: va1-sg19040
type: S (18)
ctype: NULL
account: yildi2
 
TOP
last pid: 14394; load averages: 1.84, 1.77, 1.57 up 784+19:15:44 21:32:30
270 processes: 12 running, 258 sleeping
 
Mem: 979M Active, 732M Inact, 214M Wired, 83M Cache, 199M Buf, 3008K Free
Swap: 4096M Total, 938M Used, 3158M Free, 22% Inuse
 
 
PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND
59681 yildi2 60 0 55800K 31456K RUN 0 157:09 98.39% 98.39% mysqld
14380 scito1 29 0 3884K 1888K CPU0 0 0:00 7.69% 0.73% ipop3d
456 root 2 0 35756K 31904K select 0 0:28 0.39% 0.39% perl5.8.4
 
 
PROCESS-LIST
yildi2 59681 98.4 1.5 55800 31456 ?? R 26Oct08 157:08.81 /usr/local/mysql/libexec/mysqld --defaults-extra-file=/usr/home/yildi2/var/mysql/my.cnf --basedir=/usr/local/mysql --datadir=/usr/home/yildi2/var/mysql --pid-file=/usr/home/yildi2/var/mysql/yildizsavaslari.com.pid --old-passwords --myisam-recover --bind-address=199.238.132.2
yildi2 14251 0.0 0.2 71116 3376 ?? S 9:32PM 0:00.01 /usr/local/apache/bin/httpd
yildi2 14079 0.0 0.2 71176 3496 ?? S 9:31PM 0:00.02 /usr/local/apache/bin/httpd
yildi2 96498 0.0 0.6 20436 12632 ?? I 8:53PM 0:00.15 php4.cgi (php-cgi-4.4.7)
yildi2 59620 0.0 0.0 656 8 ?? IW - 0:00.00 (sh)
 
LSOF
lsof: WARNING: access /root/.lsof_va1-sg19040: No such file or directory
lsof: WARNING: created device cache file: /root/.lsof_va1-sg19040
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 59681 yildi2 cwd VDIR 151,4 512 6813162 /usr/home/yildi2/var/mysql
mysqld 59681 yildi2 rtd VDIR 151,0 512 2 /
mysqld 59681 yildi2 txt VREG 151,4 5825516 4407221 /usr/local/mysql-4.1.22/libexec/mysqld
mysqld 59681 yildi2 txt VREG 151,4 85908 1700950 /usr/libexec/ld-elf.so.1
mysqld 59681 yildi2 txt VREG 151,4 52108 43894166 /usr/lib/libz.so.2
mysqld 59681 yildi2 txt VREG 151,4 27524 43894216 /usr/lib/libwrap.so.3
mysqld 59681 yildi2 txt VREG 151,4 950897 43894093 /usr/lib/libssl.so.3
mysqld 59681 yildi2 txt VREG 151,4 1174698 43894073 /usr/lib/libcrypto.so.3
mysqld 59681 yildi2 txt VREG 151,4 28432 43894068 /usr/lib/libcrypt.so.2
mysqld 59681 yildi2 txt VREG 151,4 117024 43894134 /usr/lib/libm.so.2
mysqld 59681 yildi2 txt VREG 151,4 679088 43894051 /usr/lib/libc_r.so.4
mysqld 59681 yildi2 0r VCHR 2,2 0t0 133116 /dev/null
mysqld 59681 yildi2 1w VREG 151,4 14510 6813210 /usr/home/yildi2/var/mysql/yildizsavaslari.com.err
mysqld 59681 yildi2 2w VREG 151,4 14510 6813210 /usr/home/yildi2/var/mysql/yildizsavaslari.com.err
mysqld 59681 yildi2 3u PIPE 0xf3b18980 16384 ->0xf5a966c0
mysqld 59681 yildi2 4u PIPE 0xf5a966c0 16384 ->0xf3b18980
mysqld 59681 yildi2 5u IPv4 0xeeb25980 0t0 TCP yildizsavaslari.com:3306 (LISTEN)
mysqld 59681 yildi2 6u unix 0xedea2f40 0t0 /tmp/mysql.sock
mysqld 59681 yildi2 7u VREG 151,4 10485760 6813211 /usr/home/yildi2/var/mysql/ibdata1
mysqld 59681 yildi2 8u VREG 151,4 0 63942072 /usr (/dev/aacd0e)
mysqld 59681 yildi2 9u VREG 151,4 0 63942073 /usr (/dev/aacd0e)
mysqld 59681 yildi2 10u VREG 151,4 0 63942074 /usr (/dev/aacd0e)
mysqld 59681 yildi2 11u VREG 151,4 5242880 6813212 /usr/home/yildi2/var/mysql/ib_logfile0
mysqld 59681 yildi2 12u VREG 151,4 5242880 6813213 /usr/home/yildi2/var/mysql/ib_logfile1
mysqld 59681 yildi2 13u VREG 151,4 115712 6837894 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_topics_posted.MYI
mysqld 59681 yildi2 14u VREG 151,4 0 63942295 /usr (/dev/aacd0e)
mysqld 59681 yildi2 15u VREG 151,4 2048 6837912 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_zebra.MYI
mysqld 59681 yildi2 16u unix 0xedda81a0 0t0 /tmp/mysql.sock
mysqld 59681 yildi2 17u VREG 151,4 3072 6837595 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_session.MYI
mysqld 59681 yildi2 18u VREG 151,4 11004 6837778 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_forums.MYD
mysqld 59681 yildi2 19u VREG 151,4 19848992 6837856 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_wordmatch.MYD
mysqld 59681 yildi2 20u VREG 151,4 863804 6837904 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_users.MYD
mysqld 59681 yildi2 21u VREG 151,4 9559 6837784 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_forums_track.MYD
mysqld 59681 yildi2 22u VREG 151,4 7168 6837520 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_modules.MYI
mysqld 59681 yildi2 23u VREG 151,4 1024 6837382 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_bbprivmsgs.MYI
mysqld 59681 yildi2 24u VREG 151,4 3072 6837517 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_message.MYI
mysqld 59681 yildi2 25u VREG 151,4 3072 6837801 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_moderator_cache.MYI
mysqld 59681 yildi2 26u VREG 151,4 76176384 6837855 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_wordmatch.MYI
mysqld 59681 yildi2 27u VREG 151,4 516388 6837889 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_topics.MYD
mysqld 59681 yildi2 28u VREG 151,4 24 6837787 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_forums_watch.MYD
mysqld 59681 yildi2 29u VREG 151,4 9216 6837870 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_styles.MYI
mysqld 59681 yildi2 30u VREG 151,4 9123840 6837852 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_wordlist.MYI
mysqld 59681 yildi2 31u VREG 151,4 166912 6837891 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_topics_track.MYI
mysqld 59681 yildi2 32u VREG 151,4 4096 6837433 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_blocks.MYI
mysqld 59681 yildi2 33u VREG 151,4 3072 6837768 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_drafts.MYI
mysqld 59681 yildi2 34u VREG 151,4 7776 6837594 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_session.MYD
mysqld 59681 yildi2 35u VREG 151,4 6840 6837432 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_blocks.MYD
mysqld 59681 yildi2 36u VREG 151,4 8400624 6837853 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_wordlist.MYD
mysqld 59681 yildi2 37u VREG 151,4 19848992 6837856 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_wordmatch.MYD
mysqld 59681 yildi2 38u VREG 151,4 1300 6837769 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_drafts.MYD
mysqld 59681 yildi2 39u VREG 151,4 7168 6837747 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_banlist.MYI
mysqld 59681 yildi2 40u VREG 151,4 2048 6837849 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_results.MYI
mysqld 59681 yildi2 41u VREG 151,4 318464 6837888 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_topics.MYI
mysqld 59681 yildi2 42u VREG 151,4 8192 6837759 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_config.MYI
mysqld 59681 yildi2 43u VREG 151,4 1024 6837613 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_stats_year.MYI
mysqld 59681 yildi2 44u VREG 151,4 19848992 6837856 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_wordmatch.MYD
mysqld 59681 yildi2 45u VREG 151,4 6928 6837760 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_config.MYD
mysqld 59681 yildi2 46u VREG 151,4 1024 6837559 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_poll_data.MYI
mysqld 59681 yildi2 47u VREG 151,4 3072 6837562 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_poll_desc.MYI
mysqld 59681 yildi2 48u VREG 151,4 808 6837850 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_results.MYD
mysqld 59681 yildi2 49u VREG 151,4 19848992 6837856 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_wordmatch.MYD
mysqld 59681 yildi2 50u VREG 151,4 1036 6837802 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_moderator_cache.MYD
mysqld 59681 yildi2 51u VREG 151,4 19848992 6837856 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_wordmatch.MYD
mysqld 59681 yildi2 52u VREG 151,4 35840 6837732 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_acl_groups.MYI
mysqld 59681 yildi2 53u VREG 151,4 19848992 6837856 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_wordmatch.MYD
mysqld 59681 yildi2 54u VREG 151,4 73728 6837900 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_user_group.MYI
mysqld 59681 yildi2 55u VREG 151,4 54604 6837859 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_sessions.MYD
mysqld 59681 yildi2 56u VREG 151,4 4096 6837786 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_forums_watch.MYI
mysqld 59681 yildi2 58u VREG 151,4 12288 6837783 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_forums_track.MYI
mysqld 59681 yildi2 60u VREG 151,4 1024 6837514 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_main.MYI
mysqld 59681 yildi2 61u VREG 151,4 490240 6837615 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_stories.MYD
mysqld 59681 yildi2 62u VREG 151,4 6144 6837873 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_styles_template.MYI
mysqld 59681 yildi2 63u VREG 151,4 44499716 6837814 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_posts.MYD
mysqld 59681 yildi2 64u VREG 151,4 15876 6837733 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_acl_groups.MYD
mysqld 59681 yildi2 65u VREG 151,4 2088 6837519 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_modules.MYD
mysqld 59681 yildi2 66u VREG 151,4 5120 6837631 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_users.MYI
mysqld 59681 yildi2 67u VREG 151,4 1024 6837750 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_bbcodes.MYI
mysqld 59681 yildi2 68u VREG 151,4 3072 6837628 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_topics.MYI
mysqld 59681 yildi2 69u VREG 151,4 2048 6837753 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_bookmarks.MYI
mysqld 59681 yildi2 70u VREG 151,4 1024 6837343 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_banned_ip.MYI
mysqld 59681 yildi2 71u VREG 151,4 6144 6837879 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_styles_theme.MYI
mysqld 59681 yildi2 72u VREG 151,4 44499716 6837814 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_posts.MYD
mysqld 59681 yildi2 73u VREG 151,4 428 6837444 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_counter.MYD
mysqld 59681 yildi2 74u VREG 151,4 0 6837342 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_banned_ip.MYD
mysqld 59681 yildi2 75u VREG 151,4 1024 6837780 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_forums_access.MYI
mysqld 59681 yildi2 76u VREG 151,4 68532 6837880 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_styles_theme.MYD
mysqld 59681 yildi2 77u VREG 151,4 325430 6837606 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_stats_hour.MYD
mysqld 59681 yildi2 78u VREG 151,4 3072 6837762 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_confirm.MYI
mysqld 59681 yildi2 79u VREG 151,4 24219 6837901 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_user_group.MYD
mysqld 59681 yildi2 80u VREG 151,4 18432 6837616 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_stories.MYI
mysqld 59681 yildi2 81u VREG 151,4 107016 6837892 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_topics_track.MYD
mysqld 59681 yildi2 82u VREG 151,4 6144 6837882 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_styles_imageset.MYI
mysqld 59681 yildi2 83u VREG 151,4 3072 6837439 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_config.MYI
mysqld 59681 yildi2 84u VREG 151,4 21 6837754 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_bookmarks.MYD
mysqld 59681 yildi2 85u VREG 151,4 0 6837381 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_bbprivmsgs.MYD
mysqld 59681 yildi2 86u VREG 151,4 2048 6837598 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_sommaire.MYI
mysqld 59681 yildi2 87u VREG 151,4 1024 6837445 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_counter.MYI
mysqld 59681 yildi2 88u VREG 151,4 123904 6837897 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_topics_watch.MYI
mysqld 59681 yildi2 89u VREG 151,4 19848992 6837856 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_wordmatch.MYD
mysqld 59681 yildi2 91u VREG 151,4 6928 6837760 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_config.MYD
mysqld 59681 yildi2 92u VREG 151,4 5967872 6837813 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_posts.MYI
mysqld 59681 yildi2 93u VREG 151,4 2048 6837601 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_sommaire_categories.MYI
mysqld 59681 yildi2 94u VREG 151,4 860 6837438 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_config.MYD
mysqld 59681 yildi2 95u VREG 151,4 3568 6837600 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_sommaire_categories.MYD
mysqld 59681 yildi2 96u VREG 151,4 1044 6837597 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_sommaire.MYD
mysqld 59681 yildi2 97u VREG 151,4 10240 6837741 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_acl_roles_data.MYI
mysqld 59681 yildi2 98u VREG 151,4 1024 6837607 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_stats_hour.MYI
mysqld 59681 yildi2 99u VREG 151,4 1024 6837436 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_comments.MYI
mysqld 59681 yildi2 100u VREG 151,4 344 6837630 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_users.MYD
mysqld 59681 yildi2 101u VREG 151,4 1060 6837561 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_poll_desc.MYD
mysqld 59681 yildi2 102u VREG 151,4 77144 6837895 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_topics_posted.MYD
mysqld 59681 yildi2 103u VREG 151,4 3080 6837742 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_acl_roles_data.MYD
mysqld 59681 yildi2 104u VREG 151,4 4096 6837777 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_forums.MYI
mysqld 59681 yildi2 105u VREG 151,4 116 6837883 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_styles_imageset.MYD
mysqld 59681 yildi2 106u VREG 151,4 1024 6837610 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_stats_month.MYI
mysqld 59681 yildi2 107u VREG 151,4 1024 6837340 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_autonews.MYI
mysqld 59681 yildi2 108u VREG 151,4 19848992 6837856 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_search_wordmatch.MYD
mysqld 59681 yildi2 109u VREG 151,4 41832 6837898 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_topics_watch.MYD
mysqld 59681 yildi2 110u VREG 151,4 1976 6837748 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_banlist.MYD
mysqld 59681 yildi2 111u VREG 151,4 7168 6837885 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_styles_imageset_data.MYI
mysqld 59681 yildi2 112u VREG 151,4 0 6837435 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_comments.MYD
mysqld 59681 yildi2 113u VREG 151,4 33792 6837858 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_sessions.MYI
mysqld 59681 yildi2 114u VREG 151,4 0 6837781 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_forums_access.MYD
mysqld 59681 yildi2 115u VREG 151,4 0 6837339 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_autonews.MYD
mysqld 59681 yildi2 116u VREG 151,4 128 6837874 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_styles_template.MYD
mysqld 59681 yildi2 117u VREG 151,4 10136 6837886 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_styles_imageset_data.MYD
mysqld 59681 yildi2 118u VREG 151,4 6144 6837789 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_groups.MYI
mysqld 59681 yildi2 119u VREG 151,4 588 6837763 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_confirm.MYD
mysqld 59681 yildi2 120u VREG 151,4 324 6837913 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_zebra.MYD
mysqld 59681 yildi2 122u VREG 151,4 44499716 6837814 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_posts.MYD
mysqld 59681 yildi2 123u VREG 151,4 0 6837751 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_bbcodes.MYD
mysqld 59681 yildi2 124u VREG 151,4 44 6837612 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_stats_year.MYD
mysqld 59681 yildi2 126u VREG 151,4 576 6837609 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_stats_month.MYD
mysqld 59681 yildi2 127u VREG 151,4 104 6837871 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_styles.MYD
mysqld 59681 yildi2 128u VREG 151,4 1024 6837604 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_stats_date.MYI
mysqld 59681 yildi2 129u VREG 151,4 78848 6837861 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_sessions_keys.MYI
mysqld 59681 yildi2 130u VREG 151,4 10584 6837558 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_poll_data.MYD
mysqld 59681 yildi2 132u VREG 151,4 159744 6837903 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_users.MYI
mysqld 59681 yildi2 133u VREG 151,4 18993 6837603 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_stats_date.MYD
mysqld 59681 yildi2 134u VREG 151,4 2048 6837516 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_message.MYD
mysqld 59681 yildi2 135u VREG 151,4 60468 6837862 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_sessions_keys.MYD
mysqld 59681 yildi2 139u VREG 151,4 20 6837513 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_main.MYD
mysqld 59681 yildi2 140u VREG 151,4 620 6837627 /usr/home/yildi2/var/mysql/yildizsavaslari/nuke_topics.MYD
mysqld 59681 yildi2 142u VREG 151,4 244 6837790 /usr/home/yildi2/var/mysql/yildizsavaslari/phpbb3_groups.MYD

I'd be glad if you can guide about what should be done. Thanks in advance!
# 2  
Old 11-26-2008
Looks like mysqld is using a boatload of CPU (>98%). If you don't have any sort of custom mysql scripts running, just reply and ask them to help you examine your mysql setup.
# 3  
Old 11-27-2008
This just came in:

Quote:
This email and the last we had sent on this show it is mysql database load in both cases. When I looked into this further I see it that several table names were mentioned

Code:
phpbb3_topics_posted.MYI
phpbb3_zebra.MYI
phpbb3_search_wordmatch
nuke_bbprivmsg

Phpbb is a bulletin board application. It may be possible that at the time perhaps it was being hit heavily. It is possible that it was set up that anyone can browse and post. You might want to look into a way to limit access to such application or think about moving up to a VPS plan if you need to have these things.

Thank You,
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Command to get exact tomcat process I am running ignoring other java process

Team, I have multiple batchjobs running in VM, if I do ps -ef |grep java or tomcat I am getting multiple process list. How do I get my exact tomcat process running and that is unique? via shell script? (4 Replies)
Discussion started by: Ghanshyam Ratho
4 Replies

2. Shell Programming and Scripting

Monitoring processes in parallel and process log file after process exits

I am writing a script to kick off a process to gather logs on multiple nodes in parallel using "&". These processes create individual log files. Which I would like to filter and convert in CSV format after they are complete. I am facing following issues: 1. Monitor all Processes parallelly.... (5 Replies)
Discussion started by: shunya
5 Replies

3. Shell Programming and Scripting

How to solve awk: line 1: runaway string constant error?

Hi All ! I am just trying to print bash variable in awk statement as string here is my script n=1 for file in `ls *.tk |sort -t"-" -k2n,2`; do ak=`(awk 'FNR=='$n'{print $0}' res.dat)` awk '{print "'$ak'",$0}' OFS="\t" $file n=$((n+1)) unset ak doneI am getting following error awk:... (7 Replies)
Discussion started by: Akshay Hegde
7 Replies

4. AIX

Runaway Processes (I think)

Folks I suck a lot of things and performance issue is one of them. After upgrading from 5300-06-03 to 5300-12-04 we started seeing an issue with some runaway processes. It varies as some of these processes have a TTY accociated with them and some do not. If you could give me any idea of what... (4 Replies)
Discussion started by: juredd1
4 Replies

5. Shell Programming and Scripting

Runaway String Problem

Database.txt John:30:40 echo -n "New Title Please :" read NewTitle awk -F":" 'OFS = ":"{ $1 = "'$NewTitle'" ; print $0 } ' Database.txt> Database2.txt mv Database2.txt Database.txt what this does, is that when i input something into $NewTitle, it will update $1 which is "John" into... (3 Replies)
Discussion started by: gregarion
3 Replies

6. Shell Programming and Scripting

Shell Script to Kill Process(number of process) Unix/Solaris

Hi Experts, we do have a shell script for Unix Solaris, which will kill all the process manullay, it used to work in my previous env, but now it is throwing this error.. could some one please help me to resolve it This is how we execute the script (and this is the requirement) ... (2 Replies)
Discussion started by: jonnyvic
2 Replies

7. Shell Programming and Scripting

script to monitor process running on server and posting a mail if any process is dead

Hello all, I would be happy if any one could help me with a shell script that would determine all the processes running on a Unix server and post a mail if any of the process is not running or aborted. Thanks in advance Regards, pradeep kulkarni. :mad: (13 Replies)
Discussion started by: pradeepmacha
13 Replies

8. Programming

Runaway SIGALRM signal handler

I have written a program to demonstrate a problem I have encountered when using BSD style asynchronous input using the O_ASYNC flag in conjunction with a real time interval timer sending regular SIGALRM signals to the program. The SIGIO handler obeys all safe practices, using only an atomic update... (8 Replies)
Discussion started by: stewartw
8 Replies

9. UNIX for Dummies Questions & Answers

Runaway processes killed (Really need help)

I got about more than 300 emails from root with the subject "Runaway processes killed" saying that "13146 12737 97.7 6 bash" . So what should I do? Any help would be appreciate (2 Replies)
Discussion started by: Micz
2 Replies

10. UNIX for Advanced & Expert Users

Runaway process. Opinions needed

not too long ago, i wrote a very short script that will bring up 4 customized xterms. The script went completely abnormal simply because of an error I had made in a while loop. This script took control of the system and rendered everything useless. The system admin team which i was part of... (4 Replies)
Discussion started by: TRUEST
4 Replies
Login or Register to Ask a Question