This group is dedicated to solutions and approaches for high traffic, high performing Drupal sites. As such, it will deal with a lot of information around the rest of a typical Drupal "stack" -- the operating system, web server, database, and PHP tweaks that combine to support the Drupal application.
This is not a support channel or a place to post bug reports.
If you think you have found a bug, use the issue queue for the appropriate project.
If you need support, see http://drupal.org/support for options.
I have been using Drupal for quite some time and recently we went live. The performance scalability has been some issue of late. I have been looking into monitoring my MySQL parameters for quite sometime. Currently I'm using mysql tuner perl script to monitor what variables need change.
Some observations that need help:Read more
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.Read more
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:
So supposing you have several sites on D5 that won't get upgraded to D6 (to take advantage of the syslog support) for several months yet due to workload, what are good ways to optimize InnoDB so that Watchdog can write faster, i.e more concurrent INSERT statements, rather than taking down the site if things get fubar'd? Thanks :)
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:
This uses a /etc/memcached.conf which looks something like this:
Based on info contained within this thread:Read more
We have been engaged by several large Media Companies to assist with them with some serious Drupal initiatives. All of which would make for great case studies for the front page of D.O. So you will be working on fun projects.
We are looking for community members that have extensive Drupal experience to help us out. These projects are not for those just starting out with Drupal, so please reference some of your past work within the community and be prepared to share some code.Read more
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:
I initially posted here in the forums, but catch suggested I should post here: http://drupal.org/node/362511
Duplicate content, but here's the post again:
Just throwing this out there. I have been using the Cache Router module to implement Memcache in Drupal 6.x. It says it "refactored" the Memcache API module to include Memcache support, which seems a bit odd. But it works.Read more
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 hereRead more
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
The server configuration:
Processor: Quadcore 2.66 ghz * 2
Harddisk: 146Gb * 5
set-variable = max_allowed_packet=64M
log-bin = /Drive1/database/mysql-bin.log
Hello everyone , I've been investigating for a CMS framework for 2 weeks ,with the purpose to choose the best CMS platform as our company's next project.
After some work, I find Drupal might be my best choice ,but I am wondering the performance meets our requirement.
As far as I know, The requirement of my company's next project is not so clear , so I am wondering someone maybe have already test the Drupal's performance already , if so , I am very appreciated if you share with me.
Maybe the questions following will help you guys understand my concern :Read more
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.
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
I explsed this thread in the main Drupal forum, but this mone might be more appropriate
I am very concerned by Drupal performance as it directly affects the productivity of people contributing to the content
(It is a Content Management System, isn't it?)
Beside "productivity", ie the time it takes to view, create or updtate content elements, reactivity is a key factor to keep contributor acting. A lazy system will discourge them to collaborate.
So I am mainly - only - interested in improving performance for logged in users. Drupal basic caching does not help.Read more
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:
I have noticed (I think) a strange thing. My cache_get times are excessive compared to rest of queries consistently. E.g on front page for logged in user I am seeing these numbers through devl module
203.92 1 cache_get SELECT data, created, headers, expire FROM main_cache WHERE cid = 'locale:mr'
172.59 1 cache_get SELECT data, created, headers, expire FROM main_cache_menu WHERE cid = '1:mr'
41.89 1 eval SELECT COUNT(uid) AS number FROM main_users WHERE status=1
25.56 1 drupal_lookup_path SELECT dst FROM main_url_alias WHERE src = 'front_page1'
Last night I (finally) updated my (ultra-simple) personal website to 6.0, and while I was at it I decided to try out some caching ideas that had been brewing in the back of my mind for a while.
Though all caching strategies have their pitfalls and drawbacks, the idea I wanted to try -- combining Boost and Memcache -- seems like a real live-wire. However, if it can be made to work, I think it might offer some significant advantages.Read more