High performance

Quick question -- I run a (smallish) community site on a single dedicated server that is roughly 80% anonymous traffic. I've already installed memcache and apc on my server and tuned mysql etc. so things are running pretty good. In investigating how to make my site run as fast as possible, I've run across mention of squid.

Hello I have a problem with my site when trying to use a RAM Disk to boost temp table create performance. I heard that this optimization was being done on drupal.org but couldn't find any documentation on it. I would appreciate if you could look at my post here and give me any suggestions:

http://drupal.org/node/369204

Hi All,

I'm using memcache module for cache tables.

Now I am interested in doing some testing of using memcache for sessions.

In production we are using RHEL and CentOS in testing so for setup of memcached I'm using the start-memcached and memcached init scripts offered here:

http://www.dev411.com/wiki/Memcached_startup_files_for_Red_Hat_(RHEL)

This uses a /etc/memcached.conf which looks something like this:

-u apache
-d
-m 32
-l 127.0.0.1
-p 11211

Based on info contained within this thread:

Hi All,

What (if any) best practices are there for achieving a configuration where the cache tables aren't writing to the default DB?

My specific concern is related to http://groups.drupal.org/node/12890 (MySQL Binary Logs of Death). Would like to write the cache mutator statements to a different DB so they aren't included in the binary log.

We're running 6.8. Using APC for opcode cache.

It seems like the options are:

• set different DB/tables in place of cache.inc. Specifics?
• use Cache Router. Specifics?
• use Memcache.

Reading the MySQL Performance Blog I've found that they have released a new storage engine that's based on InnoDB with a few performance additions. I thought it could be of interest to some of you.

Here's a few links about it:

<

ul>

I am a big fan of Drupal and have used Drupal on more than 50 websites so far. My team has noticed many issues with performance for a website which was serving high traffic. We used modules like Boost for static file caching.

Some programmers i consulted told me that we should look for database optimization. So, i hired a person for DB optimization. He made a profiling tool to records all the queries our Drupal site makes.

Now, the site serves around 10k visitors in a day. And the number of queries for the last 12 hours are 6.1 million.

Some Facts important to be mentioned here

We are launching a newspaper website in the next couple of days. The site is in Drupal. Can any comments on the ini settings? Does the server conf enough for the load shown.

The site has to serve:
Number of visits 35,720
Pages 205,129
Hits 1929,027

The server configuration:
Processor: Quadcore 2.66 ghz * 2
Ram: 8GB
Harddisk: 146Gb * 5

My.ini configuration:
[mysqld]
datadir=/Drive1/database
socket=/var/lib/mysql/mysql.sock
set-variable = max_allowed_packet=64M
set-variable=max_connections=1000
log-bin = /Drive1/database/mysql-bin.log
binlog-do-db=cab
server-id=1

Here is my initial post about performance tuning our site http://www.divx.com/ This is mainly a place for me to brain dump and spark discussion and hopefully open up issues to track and get some of these fixes into Drupal core.

Servers

4 - Web servers with 8GB Memory each, Apache 2.2.x + PHP 5.2.x
2 - Memcache Servers with 8 GB Memory each. 9 bins per server
2 - Database Servers with 16GB each running MySQL 5.0.x

Traffic

When a page.tpl.php file is generated all of the variables are populated with content. This includes all the regions, the css and javascript, and everything. Some of these are never used in some themes (e.g., $mission) and some are often rebuilt later like $styles and $scripts.

I propose we lazy load the content in these variables when the variables are called the first time which will typically be in the template files. Since lazy loading is a feature of objects it will mean these variables will be attached to objects.

So, in drupal 6 you theme would have:
<?php
print $styles;