admin/site building/modules page very slow!

Joined: 09/04/2008
User offline. Last seen 38 weeks 2 days ago.

Hey guys, been awhile since I posted on here. I've literally searched all day on the drupal.org forums about this issue... all I really got was links to related threads that didn't solve the issue. I saw patches and such, but wasn't sure how to add those patches if they'd even work. I got to the point where I trashed all the modules and started with the core ones. the modules page still loads slow and I'm at least able to activate modules. But when I had all my modules and I tried to activate the CCK modules the system would get a fatal error and time out.

I installed the devel module and it shows a bunch of _menu_router_build inquieries. Quite a few have a MS count of around 246.48. Someone on the drupal.org forums mentioned to change the mySQL tables to a different format and it worked for them, but I haven't dug that deep to do anything to mySQL tables.

The server is not my server space. My server is a shared host and runs smooth and fast. His I'm not sure if it's shared or not, I would assume it is.

Thanks for any help guys.

Joined: 11/28/2008
User offline. Last seen 38 weeks 3 days ago.
Do you know what the fatal

Do you know what the fatal error was when you tried to activate CCK? Even if your web server is running smoothly, I wonder how much load is on the database server - does MySQL reside on the same machine as the website server?

What version of Drupal is this? 5.x? 6.x? 7.x? More details would be helpful - I'm certainly not a guru when it comes to Drupal (yet, although I've learned a lot, and am learning a lot more, very fast), but anything you can give us will help the rest of us try to help you.

It sounds like you uninstalled all of your unnecessary modules. Was there a point where Drupal was NOT running slow on your website? Have you tried reinstalling the whole system? (delete everything, don't just upgrade or something). If you were able to get rid of all your modules, it sounds like it wouldn't be that big of a deal to start over.

Good luck,
David

Joined: 09/04/2008
User offline. Last seen 38 weeks 2 days ago.
sorry about that....

Yeah sorry I should have put more info up.

I'm Drupal 6.12 latest version. The fatal error was: Fatal error:
Maximum execution time of 120 seconds exceeded in D:\wwwsites\truevine1611com\www\includes\file.inc on line 891

I don't know if the database server is on the same machine as the website server. I think I'm going to ask my client if I can contact their hosting server.

Also at the time this happened everything on the drupal admin page ran smoothly. The only hang up I would get is clicking on the modules menu and trying to active modules.

Below was my Devel Module information:
Executed 1387 queries in 16027.31 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 19396.39 ms.

And now I don't know what I did... I thought maybe reinstalling the modules, delete and then recreate the data base with same info, then reinstall Drupal would do something. Now I can run the install.php, but it won't go pass the selecting of the english language... below is the error I got.

FastCGI Error
The FastCGI Handler was unable to process the request.

Error Details:

* The FastCGI process exceeded configured request timeout
* Error Number: 258 (0x80070102).
* Error Description: The wait operation timed out.

HTTP Error 500 - Server Error.
Internet Information Services (IIS)

I'm also thinking it could be the mySQL they are using.... it's phpMyAdmin 2.9.2 ..... aren't they up to version 5 now?

The link is www.truevine1611.com if that helps any also... but like I said now that I deleted and recreated the database I can't get past languages on the install... sigh.

PS: the site comes up blank now.

Joined: 09/04/2008
User offline. Last seen 38 weeks 2 days ago.
Update...

Sorry about these updates... I'm assuming it's a module that's doing something. I trashed all the modules and now it got past the languages... I guess I'll have to download each module to make sure they are up to date. Cause I use the same modules on other sites and had no problems... unless a module is conflicting with something.

Joined: 10/18/2008
User offline. Last seen 4 weeks 3 days ago.
Try disabling the "Update

Try disabling the "Update Status" module. It seems to have some issues. When you press "Submit" on the modules page, it clears out the Update Status cache. Then while you're on any admin page it will either check for updates or use the cache.

/ * Begin Signature */
It's a strange thing about determined seekers-after-wisdom that, no matter where they happen to be, they'll always seek that wisdom which is a long way off. Wisdom is one of the few things that looks bigger the further away it is.

Joined: 09/04/2008
User offline. Last seen 38 weeks 2 days ago.
Have done that.

Thanks Bishop, that's one of the first things I did due to my drupal.org forum search. They suggested doing that. It does speed up the overall admin pages. But it didn't solve my problem with the module page though. I know it can take time to load due to the modules and such. Hopefully making sure the models are updated will help.

G&G Podcast Host
Matt Farina's picture
Joined: 06/01/2006
User offline. Last seen 3 weeks 2 days ago.
How many modules?

How many modules do you have on the site (not just the installed ones)?

Matt Farina
Geeks and God Former Co-Host
www.mattfarina.com

Joined: 09/04/2008
User offline. Last seen 38 weeks 2 days ago.
how many modules...

Hey Matt,

I have about 20 modules maybe. Just basic ones like CCK, audio, wysiwyg, etc. Everything seems to be working okay now after I made sure all modules were updated. So I guess maybe an out of date module brought it to a stop? The module page is still kinda slow, but nothing patients can't handle... and I assume shouldn't be as fast as the other admin pages.

G&G Podcast Host
Matt Farina's picture
Joined: 06/01/2006
User offline. Last seen 3 weeks 2 days ago.
slowest page

The modules page might be the slowest page in drupal. It doesn't just deal with the installed modules but every possible module you would want to turn on for your site so it's a bit of a performance drag.

Matt Farina
Geeks and God Former Co-Host
www.mattfarina.com