Guys: I cannot get a handle on what is causing spikes.
I made backups of all 7.1 tables and files before running the update to 7.53. If I simply reload all the 7.1 files, will the current table structure work? I'll lose a week's worth of posts otherwise. I seem to be unable to figure out what's going on, and I'm online with UBB, server managers, and hosting companies, and nothing seems t be working to ameliorate this stuff.
End result is a current server load of 77.42 and a frozen mysql database. FRICK!
Wed Jul 1 14:10:44 PDT 2009 top - 14:10:45 up 216 days, 6:59, 0 users, load average: 77.42, 25.93, 9.89 Tasks: 1079 total, 7 running, 1072 sleeping, 0 stopped, 0 zombie Cpu(s): 4.6% us, 2.3% sy, 0.5% ni, 90.0% id, 2.6% wa, 0.0% hi, 0.0% si Mem: 4154452k total, 4133768k used, 20684k free, 1236k buffers Swap: 2096472k total, 727000k used, 1369472k free, 1798068k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1827 mysql 15 0 1173m 235m 2584 D 10.9 5.8 7:27.02 mysqld 16090 nobody 16 0 2768 1476 672 R 5.4 0.0 0:00.06 top 14481 nobody 16 0 35156 9504 4924 D 1.8 0.2 0:00.11 httpd 15949 nobody 17 0 35368 10m 5060 R 1.8 0.2 0:00.18 httpd 14261 nobody 16 0 35320 11m 6276 D 0.0 0.3 0:00.40 httpd 14273 nobody 16 0 35312 10m 5564 D 0.0 0.3 0:00.26 httpd 14303 nobody 16 0 35208 10m 5676 D 0.0 0.3 0:00.24 httpd 14307 nobody 16 0 35356 11m 6000 D 0.0 0.3 0:00.42 httpd 14342 nobody 17 0 34616 8500 4240 R 0.0 0.2 0:00.03 httpd 14455 nobody 17 0 34828 7896 3904 D 0.0 0.2 0:00.00 httpd 14810 nobody 16 0 35380 10m 5148 D 0.0 0.2 0:00.19 httpd 14841 nobody 17 0 34372 7164 3208 D 0.0 0.2 0:00.00 httpd 14847 nobody 17 0 35232 9.8m 5352 D 0.0 0.2 0:00.20 httpd 14885 nobody 17 0 34372 7268 3208 R 0.0 0.2 0:00.01 httpd 14932 nobody 17 0 35312 9704 4536 D 0.0 0.2 0:00.16 httpd 15177 nobody 15 0 35308 9852 4656 D 0.0 0.2 0:00.07 httpd 15388 nobody 16 0 34800 8252 3948 R 0.0 0.2 0:00.03 httpd 15407 nobody 18 0 34504 7520 3928 D 0.0 0.2 0:00.15 httpd 15476 nobody 17 0 35104 9448 4880 D 0.0 0.2 0:00.05 httpd 15486 nobody 17 0 34368 7136 3220 D 0.0 0.2 0:00.00 httpd 15547 nobody 17 0 35312 9912 4740 R 0.0 0.2 0:00.29 httpd 15785 nobody 16 0 35304 9696 4632 D 0.0 0.2 0:00.14 httpd 15876 nobody 18 0 34356 8024 3788 D 0.0 0.2 0:00.60 httpd 15881 nobody 17 0 35000 9m 5344 D 0.0 0.2 0:00.43 httpd 15981 nobody 16 0 35292 9m 5060 D 0.0 0.2 0:00.07 httpd Http processes currently running = 999 Mysql processes currently running = 4 Netstat information summary 1 0 FIN_WAIT1 1 0 TIME_WAIT 1 00 CLOSE_WAIT 1 02 CLOSE_WAIT 1 03 CLOSE_WAIT 1 03 LAST_ACK 1 04 CLOSE_WAIT 1 1 ESTABLISHED 1 13 ESTABLISHED 1 14:4533 TIME_WAIT 1 14:4534 TIME_WAIT 1 14:4535 TIME_WAIT 1 14:4536 TIME_WAIT 1 14:4537 TIME_WAIT 1 26 CLOSE_WAIT 1 27 LAST_ACK 1 29 CLOSE_WAIT 1 3 ESTABLISHED 1 3 TIME_WAIT 1 33 CLOSE_WAIT 1 33 LAST_ACK 1 39 CLOSE_WAIT 1 4 LAST_ACK 1 42 CLOSE_WAIT 1 47 CLOSE_WAIT 1 5 ESTABLISHED 1 6 SYN_RECV 1 61 CLOSE_WAIT 1 61 LAST_ACK 1 67 CLOSE_WAIT 1 7 FIN_WAIT1 1 8 ESTABLISHED 1 8 FIN_WAIT1 1 8 LAST_ACK 1 8 TIME_WAIT 1 81 LAST_ACK 1 86 CLOSE_WAIT 1 88 CLOSE_WAIT 1 88 LAST_ACK 1 9 TIME_WAIT 1 91 CLOSE_WAIT 1 94 ESTABLISHED 1 95 CLOSE_WAIT 1 96 ESTABLISHED 1 97 CLOSE_WAIT 1 97 ESTABLISHED 1 99 CLOSE_WAIT 2 0 LAST_ACK 2 01 CLOSE_WAIT 2 05 CLOSE_WAIT 2 2 ESTABLISHED 2 2 LAST_ACK 2 3 CLOSE_WAIT 2 3 LAST_ACK 2 4 ESTABLISHED 2 6 CLOSE_WAIT 3 0 CLOSE_WAIT 3 1 LAST_ACK 3 4 CLOSE_WAIT 3 6 ESTABLISHED 4 9 ESTABLISHED 4 9 LAST_ACK 5 SYN_RECV 5 7 ESTABLISHED 6 0 ESTABLISHED 6 6 LAST_ACK 6 7 LAST_ACK 6 9 CLOSE_WAIT 7 5 LAST_ACK 7 7 CLOSE_WAIT 7 8 CLOSE_WAIT 8 FIN_WAIT1 8 5 CLOSE_WAIT 9 1 CLOSE_WAIT 11 2 CLOSE_WAIT 17 FIN_WAIT2 30 LISTEN 57 TIME_WAIT 109 ESTABLISHED 131 LAST_ACK 308
I need out of 7.53 until I can figure out what's wrong. Can I simply reload the files, are am I in too deep with the database structure?
Is there a fee-based service here I can access. I need help STAT!