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".
  • Monitoring MySQL queries using PROCESSLIST along with system resource utilization | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    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 include once performance High Performance Drupal with Apache MPM Worker Threaded Server and PHP FPM High server load because of repeating queries too many times Hosting Virtualization Virtuozzo OpenVZ vs Xen which is best How Drupal s node access table can negatively impact site performance How Google and Bing crawlers were confused by quicktabs How relying on connections to third party servers can be detrimental to performance How to reduce page load times by sending emails via cron rather on page submission Identifying aggressive crawlers using Go Access Improve Your Drupal Site Performance While Reducing Your Hosting Costs Improving the performance of Drupal s cron by using the Elysia cron module Increasing Drupal s speed via the Squid caching reverse proxy Installing PHP APC on GNU Linux Centos 5 Installing PHP APC on GNU Linux Ubuntu Gutsy Gibbon 7 10 and Debian Installing Varnish 3 x on Ubuntu Server 12 04 LTS and using Munin to monitor it Installing and Configuring Redis for Drupal 7 and other Memcached Alternatives Installing eAccelerator 0 9 5 1 on Ubuntu Feisty 7 04 Installing memcached 1 2 5 and memcache pecl 2 2 3 on Ubuntu server Large web site scalability The Slashdot infrastructure hardware and software Less is more Keeping down the number of modules by extending existing ones Measuring memory consumption by Drupal bootstrap and modules Memory usage revisited when the Open Buffet is not to blame rather Views Microsoft WebDAV MiniRedir Drupal singlesignon An aggressive crawler MongoDB as a caching solution for Drupal 7 Monitoring MySQL queries using PROCESSLIST along with system resource utilization MySQL InnoDB performance gains as well as some

    Original URL path: http://2bits.com/articles/monitoring-mysql-queries-using-processlist-along-with-system-resource-utilization.html (2016-05-02)
    Open archived version from archive


  • MySQL InnoDB: performance gains as well as some pitfalls | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    not create such an abstraction layer instead of modifying core current abstraction layer Sure you may then need to modify the install file of the modules you are using to ensure they are setup properly for the new InnoDB abstraction layer but that would be quite trivial considering they are likely already set up for MySQL reply Sounds like a module to Submitted by Visitor not verified on Tue 2008 11 18 12 50 Sounds like a module to query alter all SELECT COUNT statements with SQL CALC FOUND ROWS is in order reply InnoDB count limitation Submitted by Visitor not verified on Tue 2007 05 29 09 47 On InnoDB this info is not stored in an index and even the index and the data are kept in the same file So doing the same query on a table can incur a significant performance penalty I don t think having the index and data in separate files has much to do with the limitation InnoDB keeps multiple versions of each record at any one time in order to boost concurrency 1 Since in any given transaction the number of rows in some table is going to be different it s harder to maintain this sort of information Some applications can get around the SELECT count FROM table issue by replacing it with a SELECT MAX primary key FROM table This is only going to be correct if your table has a primary key that increments one value at a time and there are no deleted records 1 http en wikipedia org wiki Multi Version Concurrency Control reply We converted our site to Submitted by Visitor not verified on Mon 2010 02 08 17 58 We converted our site to innodb because of the locking issues but I think we are having problems with the accesslog from the statistics module Sadly we need to have it enabled to generate some content tipical most viewed content and such I found some references to putting the table on memcache and then committing it to database every X minutes What do you think about that wouldn t that be a problem when the accumulated queries hit the db server We need to keep the statistics on but we definitely need new ideas on how to fight them 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

    Original URL path: http://2bits.com/articles/mysql-innodb-performance-gains-as-well-as-some-pitfalls.html (2016-05-02)
    Open archived version from archive

  • MySQL my.cnf configuration for a large Drupal site | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    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 include once performance High Performance Drupal with Apache MPM Worker Threaded Server and PHP FPM High server load because of repeating queries too many times Hosting Virtualization Virtuozzo OpenVZ vs Xen which is best How Drupal s node access table can negatively impact site performance How Google and Bing crawlers were confused by quicktabs How relying on connections to third party servers can be detrimental to performance How to reduce page load times by sending emails via cron rather on page submission Identifying aggressive crawlers using Go Access Improve Your Drupal Site Performance While Reducing Your Hosting Costs Improving the performance of Drupal s cron by using the Elysia cron module Increasing Drupal s speed via the Squid caching reverse proxy Installing PHP APC on GNU Linux Centos 5 Installing PHP APC on GNU Linux Ubuntu Gutsy Gibbon 7 10 and Debian Installing Varnish 3 x on Ubuntu Server 12 04 LTS and using Munin to monitor it Installing and Configuring Redis for Drupal 7 and other Memcached Alternatives Installing eAccelerator 0 9 5 1 on Ubuntu Feisty 7 04 Installing memcached 1 2 5 and memcache pecl 2 2 3 on Ubuntu server Large web site scalability The Slashdot infrastructure hardware and software Less is more Keeping down the number of modules by extending existing ones Measuring memory consumption by Drupal bootstrap and modules Memory usage revisited when the Open Buffet is not to blame rather Views Microsoft WebDAV MiniRedir Drupal singlesignon An aggressive crawler MongoDB as a caching solution for Drupal 7 Monitoring MySQL queries using PROCESSLIST along with system resource utilization MySQL InnoDB performance gains

    Original URL path: http://2bits.com/articles/mysql-my-cnf-configuration-for-a-large-drupal-site.html (2016-05-02)
    Open archived version from archive

  • Native PHP compilers: Roadsend | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    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 include once performance High Performance Drupal with Apache MPM Worker Threaded Server and PHP FPM High server load because of repeating queries too many times Hosting Virtualization Virtuozzo OpenVZ vs Xen which is best How Drupal s node access table can negatively impact site performance How Google and Bing crawlers were confused by quicktabs How relying on connections to third party servers can be detrimental to performance How to reduce page load times by sending emails via cron rather on page submission Identifying aggressive crawlers using Go Access Improve Your Drupal Site Performance While Reducing Your Hosting Costs Improving the performance of Drupal s cron by using the Elysia cron module Increasing Drupal s speed via the Squid caching reverse proxy Installing PHP APC on GNU Linux Centos 5 Installing PHP APC on GNU Linux Ubuntu Gutsy Gibbon 7 10 and Debian Installing Varnish 3 x on Ubuntu Server 12 04 LTS and using Munin to monitor it Installing and Configuring Redis for Drupal 7 and other Memcached Alternatives Installing eAccelerator 0 9 5 1 on Ubuntu Feisty 7 04 Installing memcached 1 2 5 and memcache pecl 2 2 3 on Ubuntu server Large web site scalability The Slashdot infrastructure hardware and software Less is more Keeping down the number of modules by extending existing ones Measuring memory consumption by Drupal bootstrap and modules Memory usage revisited when the Open Buffet is not to blame rather Views Microsoft WebDAV MiniRedir Drupal singlesignon An aggressive crawler MongoDB as a caching solution for Drupal 7 Monitoring MySQL queries using PROCESSLIST along with system resource utilization MySQL InnoDB performance gains as well as some pitfalls MySQL my cnf configuration for a large Drupal site Native PHP compilers

    Original URL path: http://2bits.com/articles/native-php-compilers-roadsend.html (2016-05-02)
    Open archived version from archive

  • Node creation and editing slow in Internet Explorer? Here is a solution ... | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    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 include once performance High Performance Drupal with Apache MPM Worker Threaded Server and PHP FPM High server load because of repeating queries too many times Hosting Virtualization Virtuozzo OpenVZ vs Xen which is best How Drupal s node access table can negatively impact site performance How Google and Bing crawlers were confused by quicktabs How relying on connections to third party servers can be detrimental to performance How to reduce page load times by sending emails via cron rather on page submission Identifying aggressive crawlers using Go Access Improve Your Drupal Site Performance While Reducing Your Hosting Costs Improving the performance of Drupal s cron by using the Elysia cron module Increasing Drupal s speed via the Squid caching reverse proxy Installing PHP APC on GNU Linux Centos 5 Installing PHP APC on GNU Linux Ubuntu Gutsy Gibbon 7 10 and Debian Installing Varnish 3 x on Ubuntu Server 12 04 LTS and using Munin to monitor it Installing and Configuring Redis for Drupal 7 and other Memcached Alternatives Installing eAccelerator 0 9 5 1 on Ubuntu Feisty 7 04 Installing memcached 1 2 5 and memcache pecl 2 2 3 on Ubuntu server Large web site scalability The Slashdot infrastructure hardware and software Less is more Keeping down the number of modules by extending existing ones Measuring memory consumption by Drupal bootstrap and modules Memory usage revisited when the Open Buffet is not to blame rather Views Microsoft WebDAV MiniRedir Drupal singlesignon An aggressive crawler MongoDB as a caching solution for Drupal 7 Monitoring MySQL queries using PROCESSLIST along with

    Original URL path: http://2bits.com/articles/node-creation-and-editing-slow-internet-explorer-with-solution.html (2016-05-02)
    Open archived version from archive

  • Overcoming long Views rendering time on Drupal sites | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    per each user role Now as I said you should choose the more general as possible If you choose global you end up with just one block of cached information that is very light per page you will have one cached set of information for each page where that block view shows up so do the math If you choose per role you will have as many sets of information as roles you have usually just a few this tends to be good Per user you will have as many as your users accessing that information this could be good or not depending on how many users you have accessing that And per user per page or per role per page well do the math here multiply number of users roles agains the number of pages where the information is shown this should be your last option So analyze well the use of the information what changes inside that information and related to what and you will have the answer to which cache to use Nestor reply What is view render time Submitted by Visitor not verified on Sun 2013 06 09 15 25 I have the exact website installed on a cloud vps and on a development shared server In views whenever I click the update preview button on the vps the Query execute time is low but the View render time is always higher than on the shared hosting server For example VPS Query build time 2 27 ms Query execute time 0 57 ms View render time 352 36 ms Shared Query build time 2 45 ms Query execute time 1 11 ms View render time 338 7 ms Most of the time the view render time on the vps is far higher than shown above What is view render time and why is it taking longer on the vps Thank you reply Insignificant Submitted by Khalid on Sun 2013 06 09 15 30 Such small difference of a few tens of milliseconds or less is insignificant If you run the queries several times you will get different numbers all the time Do not build any conclusion on such small differences 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

    Original URL path: http://2bits.com/caching/overcoming-long-views-rendering-time-drupal-sites.html (2016-05-02)
    Open archived version from archive

  • Performance Case Study: Scaling of a Drupal intranet for a large multinational corporation | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    on the same server as the application This eased off the load for retrieving the variable menu and other caches that are done for every page view In addition the custom cache set cache get mentioned above would be stored in memcache as well and not the database Conclusion We were now able to get a response time of 0 6 seconds with the system handling 200 concurrently logged in users easily Although the above graph says MyISAM vs InnoDB the graph is the cumulative result of all the changes mentioned above You can see what a difference it is in response time for each URL visited by each of the 200 users Moreover CPU utilization memory utilization and disk contention were within acceptable levels showing that there is room to grow and that the above configuration can handle more transactions and more users if we need it to Contents Articles Overcoming long Views rendering time on Drupal sites up Performance Case Study slow database queries from web to database server Add new comment Comments You are great Submitted by Visitor not verified on Wed 2009 03 18 05 12 Great Great Great I always read your article with more and more attention and I always write some notes on my book fo notes Tnx again for all of yours articles And sorry for my bad English M ziodrupal net sviluppo siti CMS Drupal reply Thanks Submitted by Visitor not verified on Sun 2010 02 21 04 38 I ve found the same problems on one o my site with 2 300 visitors lock on myisam tables and high number of tmp tables in some module Thanks for the hints and thans to ZioDrupal that let me found your article 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

    Original URL path: http://2bits.com/articles/performance-case-study-scaling-drupal-intranet-large-multinational-corporation.html (2016-05-02)
    Open archived version from archive

  • Performance Case Study: slow database queries from web to database server | 2bits.com, Inc. - Drupal Performance Tuning and Optimization, Managed Hosting and Consulting
    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 include once performance High Performance Drupal with Apache MPM Worker Threaded Server and PHP FPM High server load because of repeating queries too many times Hosting Virtualization Virtuozzo OpenVZ vs Xen which is best How Drupal s node access table can negatively impact site performance How Google and Bing crawlers were confused by quicktabs How relying on connections to third party servers can be detrimental to performance How to reduce page load times by sending emails via cron rather on page submission Identifying aggressive crawlers using Go Access Improve Your Drupal Site Performance While Reducing Your Hosting Costs Improving

    Original URL path: http://2bits.com/articles/performance-case-study-slow-database-queries-web-database-server.html (2016-05-02)
    Open archived version from archive



  •