Search

_{Search through our group's posts (events, discussions, jobs, etc.) and their comments here. Results are displayed in order of post date. Use the pager below to browse results.}

Excessive cache_get time

Posted by ajayg on January 4, 2009 at 3:29am

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

 
92 1 cache_get SELECT data, created, headers, expire FROM main_cache WHERE cid = 'locale:mr' 
59 1 cache_get SELECT data, created, headers, expire FROM main_cache_menu WHERE cid = '1:mr' 
89 1 eval SELECT COUNT(uid) AS number FROM main_users WHERE status=1 
56 1 drupal_lookup_path SELECT dst FROM main_url_alias WHERE src = 'front_page1' 
.....

Lazy Loading Theme Variables

Posted by mfer on January 4, 2009 at 5:23am

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;

Concerned about performances / Benchmark on 3 different hosting.

Posted by jvieille on January 12, 2009 at 10:45pm

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.

Tuning a high traffic Drupal 6 site

Posted by slantview on January 13, 2009 at 6:43am

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

How is the performance of Drupal, Need some detailed information

Posted by liyangmin on January 14, 2009 at 8:55am

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 :

Drupal newspaper site

Posted by shyamala on January 17, 2009 at 5:08pm

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

Multisite split database performance impact

Posted by tisho-1 on January 19, 2009 at 10:26am

Hi guys,

Has anyone noticed a performance impact when the Drupal 5.x database is split for a multisite setup?

Drupal Makes insane number of Queries, Can it be considered Good ?

Posted by gdtechindia on January 21, 2009 at 6:25am

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

Memcache options for Drupal 6.x - your opinions please

Posted by greg.harvey on January 22, 2009 at 1:57pm

Hi all,

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.

Anyone tried Percona XtraDB Storage Engine for MySQL?

Posted by markus_petrux on January 25, 2009 at 9:40am

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>

Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB (2008/12/16)

Subscribe with RSS