archive-com.com » COM » 2 » 2BITS.COM

Total: 372

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Beware of Drupal modules that disable the page cache | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    free alternative to Mollom We ve been pleasantly surprised as we ve had it in place for over 6 months and have had zero complaints of spam from form recipients and also zero complaints of legitimate form submissions being blocked Pablo reply BOTCHA also disables page Submitted by dddave not verified on Thu 2013 02 21 02 47 BOTCHA also disables page cache reply Thank you for the solution to Submitted by Rodney Talley not verified on Tue 2013 11 19 08 10 Thank you for the solution to my problem I was in fact looking for this I was unable to find code when cache is gone reply perect Submitted by Rind not verified on Mon 2014 02 17 19 08 I checked the codes Recommended way of disabling the cache in Drupal 7 x drupal page is cacheable FALSE they are working perfect reply I can t able to enable in cache and block cache on my website Submitted by Muthuraman S not verified on Sun 2016 04 24 04 14 Hi all Thanks everyone for sharing the knowledge on this topic It really helpful Currently I am facing the issue on my website where I cant enable in cache and block cache on performance tab in Drupal 7 I have verified the setting php and contrib and custom modules as well How to check where its enable via SESSION stuff Can someone guide me to resolve this issue Thanks Muthu reply Is your Drupal or WordPress site slow Is it suffering from server resources shortages Is it experiencing outages Contact us for Drupal and WordPress Performance Optimization and Tuning Consulting Contents Services Clients Testimonials News FAQ Payments Site Map Navigation Payment Recent content Do you use any of our Drupal modules Did you find our Drupal WordPress and LAMP performance articles informative Follow us on Twitter 2bits for tips and tricks on Drupal and WordPress Performance Contact us for Drupal and WordPress Performance Optimization and Tuning Consulting In Depth Articles Client Testimonials Developing tracing and debugging Drupal Drupal Performance Tuning and Optimization for large web sites PHP op code caches accelerators Drupal large site case study Abuse Drupal Best Practices at your own peril Poor Performance Admin Menu module Popular yet occasionally problematic Another botnet spamming Drupal web sites causing performance issues Apache 2 and PHP5 on Ubuntu Feisty bloated Apache with fcgid acceptable performance and better resource utilization Avoid excessive disk writes by avoiding PHP errors in your code Benchmarking APC vs eAccelerator using Drupal Benchmarking Drupal 5 x vs 6 x which one is faster Benchmarking Drupal from the shell command line Benchmarking Drupal with PHP op code caches APC eAccelerator and XCache compared Benchmarking PostgreSQL vs MySQL performance using Drupal 5 x Benchmarking Zend Server Community Edition with Drupal Benchmarking strings overrides vs locale module Beware of Drupal modules that disable the page cache Beware when Drupal Pressflow displays messages for anonymous users Botnet hammering web site causing outages Bottleneck Replacing taxonomy term count

    Original URL path: http://2bits.com/articles/beware-drupal-modules-disable-page-cache.html (2016-05-02)
    Open archived version from archive


  • Beware when Drupal/Pressflow displays messages for anonymous users | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    on the net wagering web site for australian gamers which may have slots live roulette and video texas hold em strongly suggested reply Is your Drupal or WordPress site slow Is it suffering from server resources shortages Is it experiencing outages Contact us for Drupal and WordPress Performance Optimization and Tuning Consulting Contents Services Clients Testimonials News FAQ Payments Site Map Navigation Payment Recent content Do you use any of our Drupal modules Did you find our Drupal WordPress and LAMP performance articles informative Follow us on Twitter 2bits for tips and tricks on Drupal and WordPress Performance Contact us for Drupal and WordPress Performance Optimization and Tuning Consulting In Depth Articles Client Testimonials Developing tracing and debugging Drupal Drupal Performance Tuning and Optimization for large web sites PHP op code caches accelerators Drupal large site case study Abuse Drupal Best Practices at your own peril Poor Performance Admin Menu module Popular yet occasionally problematic Another botnet spamming Drupal web sites causing performance issues Apache 2 and PHP5 on Ubuntu Feisty bloated Apache with fcgid acceptable performance and better resource utilization Avoid excessive disk writes by avoiding PHP errors in your code Benchmarking APC vs eAccelerator using Drupal Benchmarking Drupal 5 x vs 6 x which one is faster Benchmarking Drupal from the shell command line Benchmarking Drupal with PHP op code caches APC eAccelerator and XCache compared Benchmarking PostgreSQL vs MySQL performance using Drupal 5 x Benchmarking Zend Server Community Edition with Drupal Benchmarking strings overrides vs locale module Beware of Drupal modules that disable the page cache Beware when Drupal Pressflow displays messages for anonymous users Botnet hammering web site causing outages Bottleneck Replacing taxonomy term count nodes in taxonomy dhtml Bypassing Drupal core Node Access table joins to avoid outage caused by slow queries Can a Drupal web site handle a million page views a day Case study Views Quicktabs and template php Common Issues and Solutions for Dealing with Cloud Computing and VPS performance issues for Drupal Configuring Apache Solr 3 6 for Drupal on Ubuntu 14 04 with password authentication Configuring Apache Solr 4 x for Drupal with password authentication Configuring Drupal with multiple bins for memcached Correct Client IP Address with a Reverse Proxy or Content Delivery Network CDN Do not configure the Service Links module with TinyURL com Drupal 7 x and Pressflow pitfalls can reduce your site s performance Drupal core caching and contributed content caching modules Drupal not saving admin pages with large number of input fields Drupal on a dedicated servers vs Amazon AWS EC2 Drupal performance tuning and optimization userpoints seminar at Open Craft Drupal site excessive memory usage traced to APC and php5 memcached Examples for Drupal custom caching Adding a cache timestamp to cached pages and HTTP headers Fast Parallel MySQL Backups and Imports with Mydumper Free your content of PHP Moving PHP code out of blocks views and nodes Google Crawler hitting your site too aggressively High PHP execution times for Drupal and tuning APC for

    Original URL path: http://2bits.com/articles/beware-when-drupal-pressflow-displays-messages-anonymous-users.html (2016-05-02)
    Open archived version from archive

  • Botnet hammering web site causing outages | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    the first place reply Varnish is good here Submitted by James not verified on Tue 2012 04 24 11 02 I love to use varnish in these sort of situations you can really stop anything touching apache let alone starting to load the drupal stack You can actually cache the redirect as well as well as the final page You can also block that user agent if you want to reply Depends Submitted by Khalid on Tue 2012 04 24 15 01 Varnish just like any other technology is not panacea It is suitable in many situations but in others it is just another layer of complexity and maintainance that interferes with certain things In those cases the solution has to be in the web server layer reply Attack with identical referrer Submitted by Tim Wood not verified on Sun 2012 04 22 15 54 We suffered a distributed attack a few months back which was across too many hosts to block with IPs Fortunately they all had the same referrer some temporary blog setup as a command control center for the botnet We crafted the Apache rewrite rule below which as you mention avoids the overhead of PHP Drupal Since we could identify the attackers by referrer and we just wanted them to go away we set it to respond with a 302 redirect which is a small sized response to a non routable IP and to set a variable so we could log these request to a separate log file RewriteCond HTTP REFERER webhivecol blogspot com NC RewriteRule http 192 168 1 1 R 302 L E ddosnolog 1 CustomLog PATH TO site access log combined env ddosnolog CustomLog PATH TO site ddos access log combined env ddosnolog Thanks for sharing the post Great analysis and helpful ideas Tim reply Similar on a lower scale Submitted by Lawrence not verified on Sun 2012 05 20 22 13 As I m taking a much closer look at logs these days due to our recent issues with Bing bot causing some of our servers to have undue load I ve been spotting a few more of these Currently I m seeing a low level sporadic botnet scan of attack vectors using this browser string Mozilla 4 0 compatible MSIE 6 0b Windows NT 5 0 NET CLR 1 0 2914 As its similar to yours no referrer I don t have logs for any actual real browsers with that string and they re going straight for vulnerabilities all distributed over a number of dissimilar ip s I m going to suggest its a botnet scanning for more zombies to infect Braaaaaaaains Ahem Some examples below from a grep of the logs grepped from multiple logs hence the date time order being a little off 173 173 108 116 20 May 2012 13 34 45 0700 GET index php dsafe mode 3dOff ddisable functions 3dNULL dallow url fopen 3dOn dallow url include 3dOn dauto prepend file 3dhttp 3A 2F 2F81 17 24 82 2Finfo3 txt HTTP 1 1 404 531 Mozilla 4 0 compatible MSIE 6 0b Windows NT 5 0 NET CLR 1 0 2914 107 9 45 97 20 May 2012 18 20 48 0700 GET index php dsafe mode 3dOff ddisable functions 3dNULL dallow url fopen 3dOn dallow url include 3dOn dauto prepend file 3dhttp 3A 2F 2F81 17 24 82 2Finfo3 txt HTTP 1 1 404 531 Mozilla 4 0 compatible MSIE 6 0b Windows NT 5 0 NET CLR 1 0 2914 217 68 35 33 20 May 2012 06 17 21 0700 GET index php dsafe mode 3dOff ddisable functions 3dNULL dallow url fopen 3dOn dallow url include 3dOn dauto prepend file 3dhttp 3A 2F 2F81 17 24 82 2Finfo3 txt HTTP 1 1 404 531 Mozilla 4 0 compatible MSIE 6 0b Windows NT 5 0 NET CLR 1 0 2914 67 2 134 30 20 May 2012 14 10 10 0700 GET index php dsafe mode 3dOff ddisable functions 3dNULL dallow url fopen 3dOn dallow url include 3dOn dauto prepend file 3dhttp 3A 2F 2F81 17 24 82 2Finfo3 txt HTTP 1 1 404 531 Mozilla 4 0 compatible MSIE 6 0b Windows NT 5 0 NET CLR 1 0 2914 108 197 248 20 18 May 2012 09 25 48 0700 GET index php dsafe mode 3dOff ddisable functions 3dNULL dallow url fopen 3dOn dallow url include 3dOn dauto prepend file 3dhttp 3A 2F 2F81 17 24 82 2Finfo3 txt HTTP 1 1 404 531 Mozilla 4 0 compatible MSIE 6 0b Windows NT 5 0 NET CLR 1 0 2914 68 202 104 42 18 May 2012 11 41 15 0700 GET index php dsafe mode 3dOff ddisable functions 3dNULL dallow url fopen 3dOn dallow url include 3dOn dauto prepend file 3dhttp 3A 2F 2F81 17 24 82 2Finfo3 txt HTTP 1 1 301 521 Mozilla 4 0 compatible MSIE 6 0b Windows NT 5 0 NET CLR 1 0 2914 92 3 111 130 18 May 2012 14 41 43 0700 GET dsafe mode 3dOff ddisable functions 3dNULL dallow url fopen 3dOn dallow url include 3dOn dauto prepend file 3dhttp 3A 2F 2F81 17 24 82 2Finfo3 txt HTTP 1 1 200 44505 Mozilla 4 0 compatible MSIE 6 0b Windows NT 5 0 NET CLR 1 0 2914 67 149 101 65 18 May 2012 07 57 37 0700 GET index php dsafe mode 3dOff ddisable functions 3dNULL dallow url fopen 3dOn dallow url include 3dOn dauto prepend file 3dhttp 3A 2F 2F81 17 24 82 2Finfo3 txt HTTP 1 1 404 531 Mozilla 4 0 compatible MSIE 6 0b Windows NT 5 0 NET CLR 1 0 2914 A grep through for more connections from a botnet ip shows only the one connection for that url I have a few hundred more pages more of this in the logs but I think the above is enough to verify If I check the source of the attacks its similar

    Original URL path: http://2bits.com/botnet/botnet-hammering-web-site-causing-outages.html (2016-05-02)
    Open archived version from archive

  • Bottleneck: Replacing taxonomy_term_count_nodes in taxonomy_dhtml | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    Then any need for something in a given vocabulary could be anwered in just one simple query to get the data from cache instead of the myriad heavy queries involved in your case I d bet the gain would be even more substantial reply This looks plain scary CCK Submitted by Visitor not verified on Thu 2007 10 04 23 13 This looks plain scary CCK Select List here I come reply Reported Submitted by Visitor not verified on Mon 2007 09 17 22 20 Reported as an issue here http drupal org node 176518 2bits Drupal consulting reply Why not Submitted by Visitor not verified on Fri 2007 10 05 19 12 Why not simply it even more If all you want is the count of nodes with a term then just do this SELECT count nid FROM term node WHERE tid 28 no joins but it will count unpublished nodes reply start Submitted by Visitor not verified on Fri 2007 12 07 02 51 My tip start with log slow query then go from there works for me every time reply Not in every case Submitted by Visitor not verified on Fri 2007 12 07 09 50 This would work for only one cause of slow downs queries that take a long time to execute It will not help at all with other slow downs caused by other reasons e g lots of fast executing queries lots of modules to load modules that communicate over the net etc 2bits Drupal consulting reply Is your Drupal or WordPress site slow Is it suffering from server resources shortages Is it experiencing outages Contact us for Drupal and WordPress Performance Optimization and Tuning Consulting Contents Services Clients Testimonials News FAQ Payments Site Map Navigation Payment Recent content Do you use any of our Drupal modules Did you find our Drupal WordPress and LAMP performance articles informative Follow us on Twitter 2bits for tips and tricks on Drupal and WordPress Performance Contact us for Drupal and WordPress Performance Optimization and Tuning Consulting In Depth Articles Client Testimonials Developing tracing and debugging Drupal Drupal Performance Tuning and Optimization for large web sites PHP op code caches accelerators Drupal large site case study Abuse Drupal Best Practices at your own peril Poor Performance Admin Menu module Popular yet occasionally problematic Another botnet spamming Drupal web sites causing performance issues Apache 2 and PHP5 on Ubuntu Feisty bloated Apache with fcgid acceptable performance and better resource utilization Avoid excessive disk writes by avoiding PHP errors in your code Benchmarking APC vs eAccelerator using Drupal Benchmarking Drupal 5 x vs 6 x which one is faster Benchmarking Drupal from the shell command line Benchmarking Drupal with PHP op code caches APC eAccelerator and XCache compared Benchmarking PostgreSQL vs MySQL performance using Drupal 5 x Benchmarking Zend Server Community Edition with Drupal Benchmarking strings overrides vs locale module Beware of Drupal modules that disable the page cache Beware when Drupal Pressflow displays messages for anonymous users Botnet

    Original URL path: http://2bits.com/articles/bottleneck-replacing-taxonomy-term-count-nodes-in-taxonomy-dhtml.html (2016-05-02)
    Open archived version from archive

  • Bypassing Drupal core Node Access table joins to avoid outage caused by slow queries | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    CLI installed For that you need to r eplace this line print type t timer read type n With print type timer read type For HTML output in the browser you also need to have the script in the same directory that has Drupal core s index php Analyzing the results Whatever way you run the above script the output will look like this before 1597 86 after 299 9 As you can see there is a significant difference when having node access vs eliminating it from the query The difference above is more than 5X Running it several times and getting slightly different results each time we concluded that at least a 4X improvement is possible with this modification This means that eliminating the node access part from the query was going to improve the site by eliminating slowdowns and outages Quick Solution Hack core The quick solution was to patch the taxnomony module in the function taxonomy select nodes to comment out the two db rewrite sql calls However since the site has some private data we had to protect it in some ways It turned out that for this site the private nodes all belonged to one term 63 and therefore the following patch will bypass the node access join only when the path is taxonomy term zzz and return nothing if the visitor is going to term 63 specifically For other paths normal access control will apply and those authorized to see the private content will continue to be able to do so sql db rewrite sql sql sql count db rewrite sql sql count if in array 63 tids Do not display private nodes return NULL Skip the node access stuff reducing execution time for queries sql db rewrite sql sql sql count db rewrite sql sql count This improved the server performance significantly as you can see in the graphs below MySQL Slow queries reduced significantly The load average is back to a normal number with no spikes CPU usage is also normal with no spikes The drawbacks of the above solution is that it uses a hack to core which has to be maintained in version control for future core upgrades Long Term Solution Separate site The long term solution though is to separate the private stuff to its own site with its own subdomain e g private example com and a separate database The bakery module as a single signon solution Bakery does not synchronize roles across sites though and that has to be managed manually until the feature request in 547524 is implemented Further reading Incidentally this is not the first time that we had to bypass node access to resolve performance bottlenecks caused by slow queries Read How Drupal s node access table can negatively impact site performance for a similar case Tags Drupal Planet Drupal Performance Node Access Slow queries MySQL Contents Articles Bottleneck Replacing taxonomy term count nodes in taxonomy dhtml up Can a Drupal web site handle a million page views a day Add new comment Comments There are also many Submitted by Visitor not verified on Mon 2010 08 16 02 50 There are also many performance problems with views and node access There is a patch commited in the latest 6 x 3 x dev of views which allows to configure to disable db rewrite sql per view reply Extra join Submitted by Visitor not verified on Mon 2010 08 16 11 12 It is an extra join so it will have overhead anywhere it is used With views I saw this patch go in and it is a good option to have for sites that need it But for core there is no such option So we have to hack kittens and all reply But in your particular Submitted by Visitor not verified on Mon 2010 08 16 21 32 But in your particular example you can make Views generate the term pages reply Perhaps later Submitted by Visitor not verified on Mon 2010 08 16 22 03 Yes we can I am not sure if that option is in the latest stable release of views 2 x or not though I can t find the relevant issue right now only ones that were marked as duplicate to a core issue reply Broken Link Submitted by Visitor not verified on Mon 2010 08 16 04 59 Your link in the Further Reading section produces a 404 reply Fixed Submitted by Visitor not verified on Mon 2010 08 16 11 10 Thanks for pointing this out It is now fixed reply Thanks for the analysis Submitted by Visitor not verified on Mon 2010 08 16 10 22 Thanks for the analysis Khalid I ve made similar hacks in the past For one site node access was only used while a node was unpublished for workflow control Once a node was published it was viewable by anyone and only authenticated users be part of the workflow So it was a simple hack to bypass node access if user uid reply Was Page Caching Turned On Submitted by Visitor not verified on Mon 2010 08 16 12 41 You don t really mention it that I saw so I m curious was page caching turned on Since the source of the slowdown sounded like webcrawlers hitting links to these pages wouldn t having the pages cached for anonymous users prevent so much database thrashing Add in a little memcache and they re hitting the database even less reply Caching is enabled with memcache Submitted by Visitor not verified on Mon 2010 08 16 12 51 Yes page caching is enabled and memcache is used too Cache lifetime is set to 15 minutes Because they use tags and have a long list of them combined with the fact that paths like taxonomy term zzz have a pager at the bottom and many of them have many pages Each page is cached independently and crawlers keep hitting the next

    Original URL path: http://2bits.com/drupal-performance/bypassing-drupal-core-node-access-table-joins-avoid-outage-caused-slow-queries.html (2016-05-02)
    Open archived version from archive

  • Can a Drupal web site handle a million page views a day? | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    Thu 2008 03 13 22 42 Yes it is Drupal 5 7 Yes did lots of optimization but not as much as people think is necessary There are a few patches in there and most of them are already in the issue queue on Drupal org The key here is not to go on a module binge I believe that is the most important aspect You can read more on Drupal performance tuning and optimization for large web sites 2bits Drupal consulting reply monitoring Submitted by Visitor not verified on Fri 2008 03 14 15 19 Hi thank you so much for sharing this What software do you use to monitor your server performance What software did you use to produce these graphs Alex reply Munin Submitted by Visitor not verified on Fri 2008 03 14 15 27 It is Munin See more on our article on tools for performance tuning and optimization 2bits Drupal consulting reply over 1 million hits Submitted by Visitor not verified on Wed 2008 06 11 17 16 popsci com has done over 1 2 millions hits in one day req per second peaked about 1210 reply Hits vs Page views Submitted by Visitor not verified on Wed 2008 06 11 17 19 Hits is not the same as page views Each page views incurs multiple hits So a site with 1 2 million hits per day would perhaps have several hundred thousand page views a day only 2bits Drupal consulting reply Thanks for clearing up the Submitted by Visitor not verified on Mon 2008 06 30 15 22 Thanks for clearing up the difference between hits and visits I m still trying to get my head around all this stuff and it s certainly been a steep learning curve However I think I m getting to grips with it eventually reply CPU memory etc Submitted by Visitor not verified on Wed 2008 06 25 13 59 I m curious what the CPU memory etc looked like during these peaks Any chance of seeing those graphs added thanx reply Not much to say Submitted by Visitor not verified on Wed 2008 06 25 15 13 That site regulary breaks the 1 000 000 page view per day barrier now a couple of times per week The highest so far is 1 091 million page views 7 97 million hits However the CPU and memory graph do not show anything out of the ordinary other than the usual daily fluctuation of peak hours CPU has a maximum of 191 usr 129 sys average of 83 usr 17 sys This is out of 800 because Munin sees this as an 8 core system For memory 2 29GB average and 4 09GB maximum out of 8GB total RAM in the box The only time we see noticeable spikes is when the site is on Digg s front page Again this is all anonymous traffic so memcache really helps We see the spike in number of Apache accesses and number of Apache processes up to the MaxClients limit and of course memory to go with them But not much else Heavy tuning has been done on that site but the main ones are a patch for URL alias whitelisting using tracker2 and most importantly memcache with several bins Hope this helps 2bits Drupal consulting reply bravo Submitted by Visitor not verified on Wed 2008 10 01 01 06 thanks for posting and sharing this excellent information reply How do you get these Submitted by Visitor not verified on Tue 2008 12 02 13 48 How do you get these stats Day Date Visits Page Views Hits Bandwidth Mon 25 Feb 2008 53 636 879 777 7 636 793 90 69 GB Tue 26 Feb 2008 53 636 876 492 7 446 068 85 82 GB Wed 27 Feb 2008 52 552 818 191 7 034 696 80 03 GB I d like to get simple text stats like that but all I know how to do is use webalizer awstat and the like reply Awstats Submitted by Visitor not verified on Tue 2008 12 02 13 58 This is from Awstats reply Google Analytics Submitted by Visitor not verified on Mon 2009 01 26 13 26 Can Google Analytics provide such information Day Date Visits Page Views Hits Bandwidth Mon 25 Feb 2008 53 636 879 777 7 636 793 90 69 GB Tue 26 Feb 2008 53 636 876 492 7 446 068 85 82 GB Wed 27 Feb 2008 52 552 818 191 7 034 696 80 03 GB Sat 01 Mar 2008 29 999 324 972 2 781 091 33 05 GB Sun 02 Mar 2008 33 709 431 533 3 518 855 42 37 GB Mon 03 Mar 2008 49 683 865 697 7 429 576 85 27 GB Tue 04 Mar 2008 50 981 831 947 6 990 756 80 63 GB Wed 05 Mar 2008 51 907 831 332 7 162 797 81 47 GB reply No Submitted by Visitor not verified on Mon 2009 01 26 14 12 No Use awstats for that kind of statistics reply Wonderful information Submitted by Visitor not verified on Thu 2009 08 06 10 07 I was wondering how much load my server with same stats as yours can handle You provided invaluable information for me thanks reply Site url Submitted by Visitor not verified on Sat 2009 09 19 11 06 First of all thanks for the great article I m wondering if it is possible to post a complete list of modules used and a site url reply can u give me the URL of the Submitted by Visitor not verified on Wed 2009 11 04 17 02 can u give me the URL of the website that is discuss in this article I just want to see how kind of website it is and hopefully I can learn from it thx reply Is your Drupal or WordPress site slow Is it suffering from

    Original URL path: http://2bits.com/articles/can-a-drupal-web-site-handle-a-million-page-views-a-day.html (2016-05-02)
    Open archived version from archive

  • Case study: Views, Quicktabs and template.php | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    Views 2 x does some weird stuff to query logging for reasons that are not fully clear to us I am not sure exactly how that impacts devel s ability to log and time queries but it looks suspicious and evil This is a snippet from views inc for Drupal 6 x Set up query capturing db query stores the queries that it runs in global queries bit only if dev query is set to true In this case we want to temporarily override that setting if it s not and we can do that without forcing a db rewrite by just manipulating conf This is kind of evil but it works function start query capture global conf queries if empty conf dev query this fix dev query TRUE conf dev query TRUE Add the list of queries run during render to buildinfo see view start query capture function end query capture global conf queries if empty this fix dev query conf dev query FALSE However Views does provide a devel settings in admin build views tools but the display is not as easy to understand as devel s display nor is it integrated in it We noticed that it listed the block name and timing for regular view blocks like so Block block name execute time 346 459150314ms But it does not provide that info for the views that are in quick tabs The Preview button is clearer as long as you are using the same theme that regular users will be using Our patch will also catch slowness due to reasons other than views or the database such as a block containing a widget that contacts another server for example Because Drupal is very powerful and flexible there are no two sites that are exactly alike Every site is a riddle inside a puzzle wrapped in an enigma and at 2bits com we enjoy unraveling them Attachment Size block timing d6 patch 1 13 KB Contents Articles Can a Drupal web site handle a million page views a day up Common Issues and Solutions for Dealing with Cloud Computing and VPS performance issues for Drupal Add new comment Comments User interface patch for Quicktabs Submitted by Visitor not verified on Fri 2009 06 12 23 12 We proposed a patch to Quicktabs user interface to try to explain the performance implications to the user at 490408 reply Views Cacheing Submitted by Visitor not verified on Sat 2009 06 13 03 29 There is now both in views 2 x and in views 3 x a pluggable caching system I think it is worth to look at reply Views 3 x Submitted by Visitor not verified on Sat 2009 06 13 14 43 Views 3 x will have it Not views 2 x as far as I know See my comment above reply It does Submitted by Visitor not verified on Mon 2009 06 15 01 57 Views 2 6 just released this week includes caching capability I ve tested it a bit and it seems stable although I ve not benchmarked it to see what sort of performance difference it makes reply NIce tips where can I Submitted by Visitor not verified on Sat 2009 06 13 00 54 NIce tips where can I download them Block timing patch thanks reply Attached now Submitted by Visitor not verified on Sat 2009 06 13 01 04 Forgot to attach it initially Now it is attached Sorry about that reply views caching Submitted by Visitor not verified on Sat 2009 06 13 08 41 the new v3 version of views will have a caching plugin that is equivalent to does what you did export query and cache it if quicktabs worked with block cache it would be feasible to use the 3 views at once setting reply Not production ready Submitted by Visitor not verified on Sat 2009 06 13 14 42 I saw that Views 3 x have it 468824 earlier this month The site in question is going live in a week so switching to views 3 is not an option for the time being Nice to know that we don t have to do it manually in the future though reply Custom Queries Submitted by Visitor not verified on Sun 2009 06 14 16 42 Another recommendation was to use Views as a Rapid Application Development RAD tool to develop and test the queries then create a module with those queries in them and cache the result This is the best Drupal advice I ve read in months LVX TF reply Agreed Submitted by Visitor not verified on Tue 2009 06 30 20 58 I have been torn between maintainability and speed If I write a custom module I have to maintain a custom module If I use Views I can plan on smooth upgrades and hope that any dumb fool drupal guru could figure out my site if I were to get run over by a truck OK sed s dumb fool genius g thinking of Views2 as RAD is a great idea I just tried to create a view in master detail style but ended up with several JOINS when 2 would do I am going to try this out reply i use drupal intensively on Submitted by Visitor not verified on Thu 2009 07 30 06 21 i use drupal intensively on some high traffic sites and have run in to issues pretty much exactly like what you are describing it is indeed fun to debug issues like this and to optimize queries but not when you ve got a looming deadline in my eyes this is one of the serious shortcomings of drupal with a real good cms or framework this article shouldnt even have to be written reply Contrib Submitted by Visitor not verified on Thu 2009 07 30 10 36 No You miss the point about Drupal s strength Drupal itself core is a customizable and extensible platform with some basic

    Original URL path: http://2bits.com/articles/case-study-views-quicktabs-and-templatephp.html (2016-05-02)
    Open archived version from archive

  • Common Issues and Solutions for Dealing with Cloud Computing and VPS performance issues for Drupal | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    en 0 42 cache get SELECT data created headers expire FROM cache WHERE cid bc 87 redacted 0 36 cache get SELECT data created headers expire FROM cache WHERE cid bc 54 redacted 0 19 cache get SELECT data created headers expire FROM cache WHERE cid filter 3 0b81537031336685af6f2b0e3a0624b0 0 18 cache get SELECT data created headers expire FROM cache WHERE cid bc 88 redacted 0 18 block list SELECT FROM blocks WHERE theme redacted AND status 1 ORDER BY region weight module Then suddenly same site same server and you get Executed 55 queries in 2237 67 milliseconds Page execution time was 2323 59 ms This was a Virtuozzo host and it was a sign of disk contention Since this is a virtual server we could not tell if this is something inside the virutal host or some other tenant on the same physical server flushing the toilet The solution is in the following point Move your VPS to another physical server When you encounter variable performance or poor performance before wasting time on troubleshooting that may not lead anywhere it is worthwhile to contact your host and ask for your VPS to be moved to a different physical server Doing so most likely will solve the issue since you effectively have a different set of housemates Further Reading Drupal on Dedicated vs Amazon AWS EC2 and how we halved the cost of Amazon by going dedicated Hosting Virtualization Virtuozzo OpenVZ vs Xen which is best has real life issues from sites we ve helped When Boost slows down your Drupal site discusses boost cache expiry and how disk contention can be a real issue Tags Drupal Planet Drupal Performance Dedicated Servers Cloud Virtuozzo Xen VPS Contents Articles Case study Views Quicktabs and template php up Configuring Apache Solr 3 6 for Drupal on Ubuntu 14 04 with password authentication Add new comment Comments Always insightful Submitted by Drupleg not verified on Thu 2013 04 18 17 38 I click on every article I see by 2bits com always very insightful real world down and dirty performance information I have a small non profit client on AWS EC2 experiencing these very issues right now intermittently this article is very helpful in helping me understand what is actually happening Thanks reply I have read that on EC2 if Submitted by Visitor not verified on Tue 2013 06 04 20 33 I have read that on EC2 if you simply stop the instance Then restart the instance it comes up on different hardware The advice being that if it starts acting strange just stop and start the instance it might even out again new housemates So I d agree rather than spend days trying to figure out what is wrong with the plumbing just move to a new house I even wrote a batch file to do that very thing My instance restarts in like 5 minutes reply You sure can virtualize Submitted by Marcin not verified on Thu 2013 06 20 09 47 You sure can virtualize storage perhaps not on the hypervisors you mentioned but it s possible on ESXi You can limit each vm instance to certain number of IOPS The problem is not the technology here it s hosting companies One way to overcome disk contention at least in my case was to move Boost cache to memory reply VPS vs Cloud Hosting Submitted by Wes Regen not verified on Thu 2013 09 26 20 16 I would suggest to anyone that you go for VPS It seems to be the more reliable solution I tried a lot of those VPS and cloud solutions and didn t find proper one Eventually found Limy VPS and their free trial offer tested it and decided to subscribe for Advanced Plan It is the best option for my small online business and very glad I found reliable company I would recommend to everyone to visit Limy VPS and sign up for 7 days free trial reply If AWS instance is expensive Submitted by Azaz not verified on Mon 2016 03 28 04 17 If AWS instance is expensive for you then why not try out DigitalOcean for your Drupal website If you find installing Drupal on cloud difficult then try out managed hosting platforms like Cloudways Managed platforms offer 1 click hosting option There is no need to use command line reply Command line Submitted by Khalid on Mon 2016 03 28 08 42 There is no need to use command line Wow Indeed there is no need The newbies prefer clicking and more often than not do not understand the underlying concepts That is fine But most of us experienced sysadmins and devs prefer the command line We do not see it as a hindrance but rather as a powerful toolset that we like using reply Is your Drupal or WordPress site slow Is it suffering from server resources shortages Is it experiencing outages Contact us for Drupal and WordPress Performance Optimization and Tuning Consulting Contents Services Clients Testimonials News FAQ Payments Site Map Navigation Payment Recent content Do you use any of our Drupal modules Did you find our Drupal WordPress and LAMP performance articles informative Follow us on Twitter 2bits for tips and tricks on Drupal and WordPress Performance Contact us for Drupal and WordPress Performance Optimization and Tuning Consulting In Depth Articles Client Testimonials Developing tracing and debugging Drupal Drupal Performance Tuning and Optimization for large web sites PHP op code caches accelerators Drupal large site case study Abuse Drupal Best Practices at your own peril Poor Performance Admin Menu module Popular yet occasionally problematic Another botnet spamming Drupal web sites causing performance issues Apache 2 and PHP5 on Ubuntu Feisty bloated Apache with fcgid acceptable performance and better resource utilization Avoid excessive disk writes by avoiding PHP errors in your code Benchmarking APC vs eAccelerator using Drupal Benchmarking Drupal 5 x vs 6 x which one is faster Benchmarking Drupal from the shell command line

    Original URL path: http://2bits.com/articles/common-issues-and-solutions-dealing-cloud-computing-and-vps-performance-issues-drupal.html (2016-05-02)
    Open archived version from archive



  •