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.
Planning out Memory Usage
I'm getting ready to deploy a 1 server Drupal site with a Dual Xeon 2.8 and 4GB of memory. I've been reading a lot on tuning and I'm finding it's often recommended you make some configurations based on a percentage of memory you have allocated to either Apache or MySQL.
With a 4GB system, how much memory should I allocate to Apache and MySQL? or is there another way to look at this?
The server will also be running Cent5, PHP 5.2, Apache 2.2, MySQL5, Memcached 1.2
Read moreMemcache API or Cache Router?
Drupal 6 - Core Source Evaluation
I whipped up a quick source code line counting bash script to evaluate work that I have previously done. However that being said I ran it against Drupal 6 core without any contrib, and its interesting to see where the numbers are at. Currently it does not parse or report on comments or markup however I will add that in there soon.
module 24442
inc 38890
php 4670
install 6139
js 3621
css 5164
total 82926 Will be interesting to compare with D7 if/when (already?) hook_hooks and others are implemented allowing us to slim our .module files even more.
Read moreInterested in a Multiple Drupal site Sprint: Drupal 7 Core improvements for running dozens to hundreds of Drupal sites
There's an increasing number of organizations which are standardizing dozens if not hundreds of websites on Drupal. There is a lot of great innovation going on inhouse, but we have not had a lot of get back into core. Should the next big Drupal sprint be a Multiple site sprint?
Are people willing to travel for 2-3 days to attend a sprint?
Are there organizations dedicating resources to multiple site management who are willing to sponsor getting more of this innovation into Drupal core?
Are organizations willing to provide a sprint location for 8 to 12 sprinters?
Boost configured in apache vs .htaccess
Is anyone using Boost with the rewrite conditions in an Apache conf vs. .htaccess? Boost works fine by default, but when I move the rerwite rules into apache, it does not.
I made the logical changes that I had to make from to the normal drupal rewrite by adding a slash before 'cache' on each rewrite rule.
Here's what I got.. If you have any suggestions, or could post your rewrite rules that work, I'd appreciate it.
RewriteCond %{REQUEST_METHOD} ^GET$
RewriteCond %{REQUEST_URI} ^/$
RewriteCond %{QUERY_STRING} ^$
RewriteCond %{HTTP_COOKIE} !DRUPAL_UID
Multiple Refresh Crashes Site
We are running RHEL5.1, Apache2, MySql5, PHP5 and have run into an issue. Our site runs find with normal usage, but if you hold the refresh (F5) key, then the site will crash. We have gotten it to the point that it will not crash the server, but it will take a while before the page responds (for any user). I know that this does not happen on other sites, so we are most likely missing a configuration setting somewhere. Here is what we have:
Apache
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 2
StartServers 8
MinSpareServers 5
MaxSpareServers 20
PHP Accelerators
PHP Accelerators do not have any additional benefit! Are we doing something wrong? Any special configuration we need for enabling them? What kind of performance benefits can we expect?
Read moreMillions of nodes
A partial investigation of running a Drupal (6) site containing millions of nodes
The (three) problems that I've run into so far are all in search.module -- the "more" core modules seem to do okay.
Read moreYSlow analysis and your thoughts
I am releasing a site next week that has (in the past) gotten up to 1200 simultaneous users. My worry is that the performance of the site will not be good enough to handle that kind of traffic. I used YSlow, but there are probably better testing plugins somewhere. Here is the case:
Server:
4x 3.0GHz Cores
4GB RAM
Dedicated/Co-Located
Linux (Cent OS)
Apache
MySQL
PHP 5
Drupal 5
YSlow Analysis Score: 72 (C)
A 1. Make fewer HTTP requests
F 2. Use a CDN
A 3. Add an Expires header
F 4. Gzip components
A 5. Put CSS at the top
C 6. Put JS at the bottom
Temp Tables in my .cnf
I've been tweaking a my.cnf file for the last couple weeks, using the tuning primer sh script as a guide. You know the routine, I make my change, restart mysqld, then run the script in a day or two to check improvements.
I'm understanding all of it except for Temp Tables. I always get something like this.
Of 20971 temp tables, 60% were created on disk
Perhaps you should increase your tmp_table_size and/or max_heap_table_size
to reduce the number of disk-based temporary tables

