Search through our group's posts (events, discussions, jobs, etc.) and their comments here. Results are displayed in order of post date. Use the pager below to browse results.
How to decrease load on mysql (CAPTCHA,node counter, and xmlsitemap)?
I have read Dries Buytaert post http://buytaert.net/playing-with-new-relic-on-acquia-hosting about most time consuming operations on mysql.
I have analyzed my mysql.bin log after 2 weeks load on web-site and get the following:
- CAPTCHA - 36% of queries
Count: 696.77k (12.12%)
Query: UPDATE captcha_sessions SET token='S' WHERE csid=N
Count: 696.11k (12.11%)
Query: UPDATE captcha_sessions SET timestamp=N, solution='S' WHERE csid=N
Count: 695.75k (12.10%)
Improve the load of 404 pages, page not found
When a 404 page is launched by Drupal, it needs to load all Drupal's stack.
In web sites with a lot of modules, like is my case, it means that php need load 60M ram for launch a page not found!
That is a problem if for example you have some kind of software testing your site with random urls like mcaffe.
So we made a little hack for index.php so we check previously if a page exists before load all drupal stack.
Here is the code. Someone knows a clean way for fix this problem?
/**
* @file
* The PHP page that serves all page requests on a Drupal installation.
*
Serious performane issue because of mini-panels and multiple content types
We are working on a site whose pages are taking 17 seconds to load when it is not cached. What you see here is CCK content types like Book, Video, etc. in Block Views, which are then used in Mini Panels. These Mini Panels are joined together to create widgets. We are showing three nodes at a time for each content type - Still loading 12 different content types requires a large number of SQL queries.
Read moreMySQL performance issue with heavy traffic - help!
Hi there,
I'm running a site with about 13,000 nodes, and we currently have 3 clones of the same websites (with slightly different content) for different regions.
This is our current server:
Dual Nehalem Quad Core Xeon 5520 (8 x 2.26GHz + hyper-threading CPU)
2 x 500GB HDD
12GB RAM
Monitoring and managing production Drupal environments using New Relic
I work for New Relic. As Dries pointed out last week on his blog, http://buytaert.net/playing-with-new-relic-on-acquia-hosting we now have a Drupal performance management service available. You can use it to see where Drupal is slow... and you can track the problem down using real production data. We are currently looking for people willing to try out our latest agent in High Performance Drupal environments. check us out http://newrelic.com/php-app-performance.html - we want feedback from the community about our instrumentation.
Read more
Seeking part-time developer to help finish site
You are a talented and dedicated software developer proficient with Drupal (not a firm), and competent with mySQL databases, and willing to learn a bit about Ubercart. You are also available to work on a part-time basis.
We are a small company about to roll out a website with over 19 million business listings that allows homeowners to search for local businesses and service providers.
Read morewebair CDN and access control
Hi,
I am considering all my media content to webair CDN
http://www.webair.com/pdf/WebairCDN_SecureURLs.pdf
Will I be able to maintain access control to media for members/non-members with http://drupal.org/project/cdn and is there anyone out there that can set this up for me ?
Regards Allan
Read moreManaging content as nodes in a separate database
I am managing a site with over 19 million business listings. Cloning a database this size is daunting and time-consuming. Most of this data is static, but there are some definite advantages to managing it as nodes. In a perfect world, I'd like to be able to move these 19M nodes to a separate database so that I could easily clone the rest of it for development and testing, but I can't think of any way to do that that will allow me to keep working with the data through the Drupal Node Module with its incumbent advantages.
Read moreMemcached tuning: "object too large for cache"
We have a Pressflow 6 app with Cache Router routing to multiple memcache bins. The bins have plenty of memory allocated, but other than that are running with default options.
In local testing, I've found that some basic cache-setting fails because of object size. Examples:
<20 set cache_views-views_data%3Aen 1 0 2721377
>20 SERVER_ERROR object too large for cache
<20 set cache_menu-links%3Aadmin_menu%3Atree-data%3A788912d6fd7adf98c8c86af7c57d00fe 1 0 1670355
>20 SERVER_ERROR object too large for cache
imageinfo_cache module
Looked at cachegrind output and image_get_info was taking a lot of time; called from theme_imagecache. My files dir is a S3 mount thus its a little bit slower. I did some local testing and if the file is local a cache_get is slower. But if the file is not local then cache_get is way faster.
http://drupal.org/node/1017820
I've attached a simple module that works; anyone find this useful? It works by overriding theme_imagecache.
Read more