Managing WP sites thru phpmyadmin

Grindstone

Sofa King Re: Tar Dead
May 13, 2008
5,147
112
0
North Idaho
Long story short, I've got a 9k page site running multiple custom plugins, that while amazing, weren't coded in the best manner and now I can't get any page in the admin panel that uses a page drop down menu to load, it just times out after 60 seconds (after getting the vps provider to bump it from 15 to 30 and finally 60). PHP memory is pushed thru the roof, site is only using like 5% of server resources but certain php queries (anything involving a page/post from the backend) cause cpu useage to push to 100% for the duration of the timeout.

Anyway, enough of the backstory, so now I've been managing it thru phpmyadmin, which I really like but I recently had it redesigned and while the theme works awesome on a demo site, when I throw it up on my beast it breaks. No header, no sidebar, no footer, just the main content section with no content.

The theme coder, who is a kickass coder on here (no idea of username, he was a referral off wickedfire) thinks it's in the general settings of my wp blog, the reading subsection specifically, the one where you can set pages or post, a sticky page or whatever.

Anybody know what table/field in the wp database that info would reside and what settings default would be?

Thanks for any good info, and to send some back out there, WP doesn't play nice with high volume pages (posts are ok, but pages, even tho they get dropped in the same database table, causes serious issues with WP's sloppy php embedded coding), especially if you use pages and subpages. And if you still want to build a mega site on WP, take the SEO hit and throw a unique identifier in there for every post, even if it's not pretty.

Cheers!
 


You tried using WP Super Cache before? Works a treat on high traffic sites.
 
The theme coder, who is a kickass coder on here (no idea of username, he was a referral off wickedfire) thinks it's in the general settings of my wp blog, the reading subsection specifically, the one where you can set pages or post, a sticky page or whatever.

Anybody know what table/field in the wp database that info would reside and what settings default would be?

coder = css_designer (if you're talking about what I think you're talking about)

Re your problem, I'll take a look at it later today and see if I can figure it out. Should be around after I get caught up on a few things.
 
You tried using WP Super Cache before? Works a treat on high traffic sites.

Been down all those roads. To paraphrase Starbury, "this is another level, then another level, then like 5 more levels beyond that".

@Nate, he is who you thought he was.
 
If you think you can fix the problem if you could see the link to the right page -- look at another blog and then paste in that link on the broken one.
 
Too busy cutting firewood to pay attention to us.....

paul-bunyan.jpg