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!

If you need a resolution then your best course of action is to start with opening a support ticket with ubb.
You really can't downgrade unless you are absolutely sure that no changes occurred in the tables and or the config file at a minimum.

The only way you can downgrade is if you were to actually reload the 7.1 database backup along with the 7.1 scripts. 7.1 won't work with the 7.5 database structure.

We can go the support ticket route, since there definitely is some type of issue going on.

You can open a ticket HERE
This is for basic support.
Rick will probably let you know if you need advanced support. But you will need to provide him at the least admin access to the control panel . Then possibbly ftp access. And more if needed

Thanks! Did it. Well worth it to have him look into it personally.

THANKS!!!