displaying admin/build/modules very slow
miiimooo - September 5, 2008 - 16:33
| Project: | Drupal |
| Version: | 6.10 |
| Component: | database system |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
I think I'm going mad! I have jus tenabled anything non-essential as I though oh maybe it's i18n or some other module but still it's the same - I use devel module and it says
Page execution time was 21560.21 ms. Executed 4146 queries in 15434.52 milliseconds.and that's to load admin/build/modules.
Any ideas?
A list of active modules follows below:
- Content Copy
- Fieldgroup
- Link
- Node Reference
- Number
- Option Widgets
- Text
- User Reference
- Contact
- Content translation
- Database logging
- Help
- Menu
- PHP filter
- Search
- Taxonomy
- Tracker
- Update status
- Upload
- .. I realise this will take longer if I copy paste them all - any usual suspects?

#1
I've now created a fresh install on my desktop machine and this is still very very slow. I have only enabled a couple of modules (see listing from drush below) and yet going to http://localhost/admin/build/modules/list comes back with
Page execution time was 6268.49 ms. Executed 2113 queries in 2365.62 milliseconds.Memory usage:
Memory used at: devel_init()=1.06 MB, devel_shutdown()=23.6 MB.
This is the list of installed modules. It's a fresh database - no content.
Drupal Administration Menu 6.x-1.1 6.x-1.1 OKDrupal 6.4 6.4 OK
Content Construction Kit (CCK) 6.x-2.0-rc7 6.x-2.0-rc7 OK
CVS deploy 6.x-1.0 6.x-1.0 OK
Devel 6.x-1.11 6.x-1.11 OK
Drush 6.x-1.1 6.x-1.1 OK
drush_mm unknown ignored:
Internationalization 6.x-1.0-beta3 6.x-1.0-beta3 OK
views unknown ignored:
Has anyone else noticed this? Any ideas what to do? At the moment I make myself a cup of tea whever I want to enable or disable a module...
#2
Which database? I noticed displaying/processing the module list was slow using PostgreSQL on Centos. Assuming I understand you correctly.
#3
MySQL sadly. I wish I could blame PostgreSQL at this point...
#4
Does disabling admin_menu increase the performance?
#5
Since you have devel already installed, couldn't you create a dump of the queries to find out which queries appear unusual often, or at least attach the dump to this issue?
#6
I have been crying about the same issue, and provided the devel log. I beg someone please take a look at this issue.
I saw drupal is generating over a thousand queries when I hit admin/build/modules on a fresh install.
http://drupal.org/node/311626, Please can someone help?
#7
In the spirit of "spread the wealth", I am sharing my solution for my problem, hope it may help you as well.
See #22 in this post http://drupal.org/node/311626
#8
http://drupal.org/node/302638#comment-1101374
From
Page execution time was 22306.34 ms. Executed 3450 queries in 1987.3 milliseconds.
to
Page execution time was 22581.1 ms. Executed 3342 queries in 1938.14 milliseconds.
Reduce number of queries, but the Page execution time is higher?
#9
It's ridiculous, I've fresh Drupal 6.8 installation with no non-core modules enabled and admin/build/modules page is loaded more than 1 minute!
This is a snippet from the report of the devel module:
Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 115559.85 ms.
Memory usage:
Memory used at: devel_init()=1.49 MB, devel_shutdown()=12.28 MB.
Does anyone has an idea what's going wrong?
On the same server/database Drupal 5.6 works perfect.
#10
Hello,
I have gone mad in searching why my admin/build/modules not working after installing CCK,views modules on Drupal6.10. I earnestly request to fix out this. I tried the same thing in Drupal 5.6 .Its working fine there.I want the same to work on Drupal 6.10 as I have developed all my modules in Drupal 6.10 :-(
#11
Hi All,
http://www.tmsnetwork.org/blog/content/2008/08/22/drupal-6-slow-administ... worked for me.
According to that it is due to attempting to get update information. So it instructs how to change a single record in the system table.
record is system.filename = 'modules/update/update.module'
#12
Thanks for posting your solution.
- Arie
#13
@tharaka
Thank you for your solution, it worked for me.
#14
I tried the fix above (disabling update module) but that didn't help.
#15
I'm having this same issue as well, very slow loading times.
#16
Take a look at this handbook page and see if any of that helps.
The modules page *is* a slow page -- probably the slowest -- on any Drupal install because of all the server queries Drupal has to make.
#17
Just an update. We bought a new web server but I start realizing the main cause for this is a slow database server or maybe the number of queries? - latest "benchmarks":
Page execution time was 163872.53 ms. Executed 5902 queries in 159110.87 milliseconds.Which according to my colleague here is 36 queries per second. What do other people get?
#18
#7:
I have myisam as default and it's very slow even on a brand new install.
#19
sounds like there is a solution coming up soon http://drupal.org/node/512962
#20
Subscribing.
#21
Thanks for taking the time to report this issue.
However, marking as duplicate of #193366: execute various rebuilds when modules are submitted.
You can follow up on that issue to track its status instead. If any information from this issue is missing in the other issue, please make sure you provide it over there.
#22
Disabling the admin menu recovered the problem for me.
#23
I am using drupal 6.14 which includes the patch from #193366: execute various rebuilds when modules are submitted and indeed the performance has improved. But I have done quite a few experiments tracking the time it takes for a load/reload/submit of admin/build/modules page and I have cocluded that when update status is enabled many a times the page load times out after execution time has been exceeded
The question is do we need update status to run on admin/build/modules page or everytime ?
Here is my experiment
------------------------
loading page (F5) 16 sec
enabling update status 97 sec
reloading page (F5) 40 sec
reloading page (F5) 40 sec
disabling update status 53 sec
reloading page (F5) 16 sec
------------------------
take a note that enabling the update status makes the page load 2.5x slower
which in many cases might lead to blank screen when enabling lots of modules
at the same time
NOTE:
- time of completion was reported from firefox pluggin
- I am running on localhost thus no server load other than my page requests
modules installed and enabled in modules directory
admin_menu
cck
filefield
filefield_insert
i18n
languageicons
pathauto
token
views
imagecache
imageapi
imagefield
imagefield crop
wysiwyg
jLightbox
thickbox
i know sun above thinks this is a duplicate but I consider the other issue fixed since it was dealing with rebuilds but feel free to include it in any other issue