Site Going Slow, No Solution... Please Help!
Before I start, I have searched this site front and back and must be missing something if the information is included on this site at all. I have looked for possible solutions, and all I have found are varying methods on how to find a solution.
I've downloaded Devel, Backup & Migrate, Admin Menu, etc. In putting these to use, my website has slowed to a crawl. At first, I thought the issue might be watchdog-produce error messages relating to the PM Growl module, but I simply removed that module altogether.
To describe my problem simply, here is what my home page looks like to Devel on loading:
Page execution time was 24749.39 ms.
Memory usage:
Memory used at: devel_init()=1.37 MB, devel_shutdown()=16.66 MB.
My Performance Report: Detailed looks like this (sorry for awful formatting):
# sort icon Date Path Memory (MB) Milliseconds (Total) Anonymous?
316 06/11/2009 - 12:28 ajaxchecklist/update-access 12.00 15458 No
315 06/11/2009 - 12:28 node 18.00 35433 No
314 06/11/2009 - 12:28 ajaxchecklist/update-access 12.00 13806 No
313 06/11/2009 - 12:28 node 18.00 24695 No
312 06/11/2009 - 12:19 node 3.25 1608 No
311 06/11/2009 - 12:18 node 3.25 2100 No
310 06/11/2009 - 12:12 image 16.75 34866 No
309 06/11/2009 - 12:11 admin/build/block 24.25 15701 No
308 06/11/2009 - 12:10 admin/build/block 15.50 3709 No
307 06/11/2009 - 12:10 admin/build/block 24.25 12245 No
306 06/11/2009 - 12:00 modules/system/searchbg.gif 14.75 8189 No
305 06/11/2009 - 12:00 node 18.50 35242 No
304 06/11/2009 - 11:59 modules/system/searchbg.gif 14.75 3993 No
303 06/11/2009 - 11:59 node 18.00 14031 No
302 06/11/2009 - 11:59 node 21.00 8038 No
301 06/11/2009 - 11:57 admin/build/modules 32.25 66608 No
300 06/11/2009 - 11:56 admin/build/modules 32.25 89924 No
299 06/11/2009 - 11:55 admin 21.50 28088 No
I can't figure it out, but every page is taking 2 minutes to load. Here is what I have tried:
- Cleared Cache (several times)
- Set Cache to Disabled / Manual (neither worked)
- Run Cron (I've run Cron several times since)
- Truncated the watchdog table in my database
- Removed heavy modules
- A few other things I might be forgetting...
Using Backup & Migrate, my database seems to be about 130kb. However, when I am in "phpmyadmin" for my database, it shows at around 4-7MB, so I am not sure if this is normal behavior or not...
Any suggestions, guys?
Just wanted to say I imported
Just wanted to say I imported the database backup from before. The site was going great for a minute or two, then it slumped into exactly what it was...
I have no clue what is going on but this is a disaster!
Similar issues, 2nd iteration
I have seen this same problem on two iterations of building a prototype site.
I'm just starting to see some of the symptoms on this 2nd generation prototype that I'm building. The 1st time through I could clearly see evidence of a fugue state between Apache2 and MySQL. It was mitigated when I de-installed bitcache and all of the lovely file/content handling functions that depend on it - but the problem didn't completely go away.
Oh, I should mention - in this 2nd gen prototype I currently have one page of content. I don't think this is related to data volume.
Suggestions about methodology for figuring this out are welcome
regards...
Update 6/15 - determined immediate cause; menu structures got thrashed somehow. Not sure where that came from - lots of duplications in the tables.
One issue that I was
One issue that I was experiencing was that my left sidebar column disappeared. It was causing a great deal of the slowness I was witnessing, and in my Drupal searches, I found that having Devel, Theme Developer, and DHTML Menus all enabled caused this to happen.
After disabling DHTML menus (figured I would while I am using Devel), the site speed increased... But still isn't up to par with what it used to be!
Still working on finding a solution...
=-=
devel uses memory as well, after all of the adjustments have been made, I'd turn devel off to test.
The bottleneck fromw hat I"ve read with regards to optimizing a site in drupal is usually the MySQL server. That said:
How many querries are your pages generating?
Are there duplicate querries being called?
I'll try to answer you
I'll try to answer you questions as best as I can assume you mean. I might be looking in the wrong place:
1. How many querries are your pages generating?
I refreshed my home page 3 times for an answer to this question, assuming it would be the best way to tell how many queries were generated per page. So on average, we get the following:
Page execution time was 25999.58 ms. Executed 198 queries in 2158.44 milliseconds.
Memory usage: Memory used at: devel_init()=1.37 MB, devel_shutdown()=16.36 MB.
Page execution time was 37559.07 ms. Executed 206 queries in 1578.75 milliseconds.
Memory usage: Memory used at: devel_init()=1.37 MB, devel_shutdown()=20.03 MB.
Page execution time was 37846.57 ms. Executed 207 queries in 2501.51 milliseconds.
Memory usage: Memory used at: devel_init()=1.37 MB, devel_shutdown()=20.03 MB.
2. Are there duplicate queries being called?
I wasn't sure how to check this one, exactly. Going to check my tables now.
btw, you often respond to a great majority of my posts and many other posts on this whole board, so I want to say thanks for responding. You've helped me with a vast majority of my issues so far. :)
=-=
you have to inspect your settings for devel. It will give you an actual list of querries that can be viewed for each page. devel documentation can be used also to figure out how to use it to it's potential.
I'm currently undergoing the
I'm currently undergoing the process of turning devel off, because it seems like devel is a real hog for memory... Prior to devel, I wasn't having any issues, but I overlooked that devel could be the problem because it seemed like such a must-have module and it didn't happen right away.
Will see if this works.
With your request to inspect the settings for it on my end, I would love to but no page loads right now. Everything goes to white screen and takes 4 minutes to get there...
I think i've regained
I think i've regained stability.
What Devel setup is recommend? Should I be using APC?
Also, what level of caching is recommended? Disabled or manual?
=-=
your questions depend on your hardware. if on a shared host your options are limited. If on a VPS or dedicated you should certainly look into using 3rd party caching and such. There is an optimization group over at groups.drupal.org that you can join. You can also read through some of Kbahey's blog posts over @ 2bits.com
blank pages are apache errors and apache errors should be posted to help us research for you.
Sounds great, thank you! I
Sounds great, thank you!
I think since I changed the memory limit in my .htaccess file, it just took a little while for it to update. I restored a backup, and retraced my steps. Each time it didn't work, I'd go back and do something a bit differently. Not sure what I did at this point, but it is back to great functionality.
Is Devel something I can only turn on when I need it, or something most people have on all the time? It seems to leave a HUGE footprint on my site...
=-=
I only turn it in when I need it and on a shared host, I don't normally turn it on at all. I'll use my local machine with a duplicated production site in a test environment.