high performance

This discussion got me thinking...
http://groups.drupal.org/node/56438#comment-160418

So I decided to create some code that will auto add indexes to your CCK fields where there are none. Works for me (using MySQL), may not work for you. Also at the bottom is code to add indexes elsewhere in Drupal.
<?php
$ret = array();
// Add indexes to CCK fields
$result = db_query("SHOW TABLES LIKE 'content_%'");
while ($table = db_result($result)) {
if ($table == 'content_group') {
db_add_index($ret, 'content_group', 'weight', array('weight'));

Hello, does anyone here currently use the D6 CacheRouter module on their site? If so, could you help test/refactor this patch (http://drupal.org/node/746610) to the CacheRouter module. The goal of the patch is to add a second layer of cache backup if your primary caching tier was unavailable. i.e you could have the Drupal db cache tables as a backup to memcache or apc, instead of defaulting to a "cache miss" scenario which could really hammer the database.

Hey everyone. Mercury 1.0 is almost ready, and we could really use some help testing things out. As Greg posted, Mercury 1.0RC is on Amazon, and the self install instructions have been updated. The more eyes on it before we call it 1.0 official the better, so if you've been waiting to give it a test-drive, now is the time. We're going to be able to deliver fixes via BCFG2 (which is frackin' awesome), but a bug-free initial release state would be ideal.

Report bugs on Launchpad, post comments and responses on this thread here.

Also, if you are already using Mercury, you can help us plan for the future by taking this quick survey. Eight questions only!

Hi

Have found Gear6 www.gear6.com.
They provide hosted memcache with automatic scaling. Sounds interesting.

Does anybody know, how to do it with memcache?

bennos

Hi Everyone.

Very important topics have been discussed in the high performance group in the past and i would like to request all members to help make a list of important factors, which can offer performance boost for Drupal website. I will list a few i know work very nicely. Please do add your suggestions.

1. Use BOOST module to serve static content to users
2. Cache router can also be used for caching.
3. If you are on dedicated hosting, use LiteSpeed Webserver. Even there are some companies offering LiteSpeed hosting in shared environment.

Hi

Today I talked to an Sysadmin in my favorite coffee bar and he gives me tipp. They are trying out in the firm a new PHP Server called HIPHOP.
http://developers.facebook.com/news.php?story=358&blog=1

You seet it in the URL. Facebook has developed it and delivers 90 % of his webtraffic over Hiphop.

I've got a server performing badly at the moment - giving 500 Internal Server error every couple of page refreshes. There are just over 1700 users online at present.

I've checked top, and it's showing me six occurrences of the httpd command using over 10% of the CPU each - with one or two being over 20%, and occasionally over 30%. I've attached a snapshot of the top command in case there's useful information on there I've missed off.

Hi,

I currently operate 1 international D6 site (traffic even from US and EU) with apx 100.000 nodes and 150.000 users. I am having huge load problems and my host does not seem to have the required drupal knowhow to make it work. The site is suffering badly. In one month from now I will be launching a new smaller site for a danish audience on the different subject, but also D6.

Hello,

We are having stability problems on our Drupal site. We have a dedicated server which runs mainly our Drupal site and couple of other small sites. Daily visitor is around 20.000 and around 17.000 is on Drupal and only 200-300 are registered.

We have Gainestown E5520 8 cores(running as 16 cores) CPU with 8 GB ram and fast disk configuration enough. As all can guess hardware infrastructure is well enough to manage whole work. Configuration is simply:

PHP 5.2 cgi mode
Apache 2.2.14
APC installed, MPM_WORKER
Suhosin

Anyone here using Cacherouter Memcached backend (which depends on libmemcached) here ? I don't want to discuss PECL memcached itself, let's just say it's stable enough to be considered on par with memcache.
I'm more interested in Cacherouter Memcached engine code, stability, issues, etc.