Hi Performance
Fast Private File Transfer using X-send file
mod_xsendfile
mod_xsendfile is a small Apache2 module that processes X-SENDFILE headers registered by the original output handler.
If it encounters the presence of such header it will discard all output and send the file specified by that header instead using Apache internals including all optimizations like caching-headers and sendfile or mmap if configured.
It is useful for processing script-output of e.g. php, perl or any cgi.
Referance from http://tn123.ath.cx/mod_xsendfile/
Drupal newspaper site
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
Random ID Generation Write up
So, I've had a few inquiries over the last few months about random node generation as I have implemented it successfully for a client. I have posted a full write up of it on my blog. Feel free to comment on it here or on my blog; I will post a patch when I have a chance and if there is interest.
Article link: http://earnestberry.com/node/13
Boost performance, throughout with opcode cache software
IBM has started a new series of articles that covers OPCODE caching.
Updated
Part 1 - http://www.ibm.com/developerworks/opensource/library/os-php-fastapps1/
Part 2 - http://www.ibm.com/developerworks/opensource/library/os-php-fastapps2/
Part 3 - http://www.ibm.com/developerworks/opensource/library/os-php-fastapps3/
SQL Speed Optimization on Large Datasets
So, you want to speed up your large site? Well, start by cleaning up your SQL if you're accessing large tables. We are running Drupal on top of MS-SQL for a client. We have one table that has 7.5 millinon rows in it. Now, I had mentioned what I am about to talk about in another post before, but I know have some hard numbers to base it off of.
So anyway, this table had 7.5+ million rows, and the page was loading mighty slow. Running it 10 times, Devel query showed where I was bleeding...more like gushing time:
<
ol>
Tuning drupal for hi-traffic
<
blockquote>
Hi, I recently switched from phpbb to drupal. (http://drupal.org/node/44368)
Here is my configuration
- web server: Dual Xeon 3.0Ghz (32bit), 2G RAM, SATA HDD
- db server: same as web server (physically different server)
- software: apache 1.3.34, php 5.1.2, mysql 5.0.18
- total number of nodes: 70,000+
- total number of comments: 330,000+
- total number of users: 25,000+
- Usually there are 150+ anonymous users and 50+ registered users (by checking Who's online block)
- Modules: most core modules (4.7) except archive, book, drupal, legacy, ping with contributed modules (adsense, codefilter, favorite_nodes, google_analytics, logintobaggan, nmoderation, subscription, taxomony_access, urlfilter, votingapi, comment_upload, tagadelic)



