Hi Performance

heshanmw's picture

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/

Login to post comments · Read more · 2 attachments
Shyamala's picture

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

8 comments · Read more

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

3 comments

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>

4 comments · Read more

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)
Login to post comments · Read more
Syndicate content