Support Forum

upgrade causing huge server load?

TS tsilvestre
tsilvestre
Member

This morning my hosting service shut my site down due to huge server load which they said is being caused by plugins…the only thing I did different yesterday was to upgrade to v5 and have it create new table locations so everything would be happy. Help? Should I delete these new tables? How do you think I can optimize this situation?frown

17 Answers

New Answer

MP Mr Papa
Mr Papa
Member

not sure what you are saying about the tables…  but 5.0 has across the board made dramatic improvements in server loads… lots of optimizations were made…  no reports of slow down or load issues – just the opposite…

any more details you can provide?

TS tsilvestre
tsilvestre
Member

When I created my site, I changed the default table prefixes (to make it more secure). I noticed that the v5 tables are using the default prefix, so now I have two tables for each item…do you think that could be confusing things? Or causing a slow down of some type?

MP Mr Papa
Mr Papa
Member

not sure how…  we would only access tables using the wp db prefix… the others are but duplicates and could be removed…

MP Mr Papa
Mr Papa
Member

I would think so…  you could export a db backup before hand just to be safe…

TS tsilvestre
tsilvestre
Member

So when the new v5 tables were created, did they copy over the old data?

MP Mr Papa
Mr Papa
Member

what?  any new sp tables would have the same wp db prefix as the existing db tables…   only completely new ones would be added and there would be nothing to copy…    for existing tables, v5 uses the same tables as v4…

TS tsilvestre
tsilvestre
Member

I’d upload a screen capture of my database tables, but I can’t seem to create a small enough file. There are basically two sets of tables for the SP forum…

 

tswp_sfforums 

tswp_sfgroups

tswp_sflinks

tswp_sfmembers  and so on…and then these:

wp_sfforums 

wp_sfgroups 

wp_sflinks

wp_sflog

wp_sfmembers

etc…

MP Mr Papa
Mr Papa
Member

well, the ones we use would have same wp db prefix as the wp site itself…

did you say you changed that?  if so, how? did you change all db tables or just the wp specific ones?

TS tsilvestre
tsilvestre
Member

When I first set up my site, I changed the defaults from wp to tswp. But when I upgraded to v5, the wp tables were added.

MP Mr Papa
Mr Papa
Member

when you changed from wp to tswp, how did you do it?  and did you update the wp-config.php file to tell wp to use the new ones?

TS tsilvestre
tsilvestre
Member

When I first installed WordPress, I changed my db prefix, yes. But when I installed SP, I didn’t do anything. When I upgraded to v5, I clicked YES when asked if I’d like to move my forum tables to new location to be in compliance (I’m paraphrasing). So ultimately, NO, I didn’t change any table prefixes recently. However, it appears that SP has created new tables with a wp prefix, ultimately giving me a second set of tables. frown

MP Mr Papa
Mr Papa
Member

sp uses the wp db prefix defined in your wp-config.php file… 

so how, explain the mechanics, did you change your db prefix?  and when you did it, did you change all the tables in your db, not just the wp tables?

TS tsilvestre
tsilvestre
Member

I redefined the prefix in my wp-config file when I was setting up the site. Then I renamed the standard set of tables to match. Every new table (until now) has been created using my special prefix (tswp_).