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.
MySQL optimization - No Innodb support enabled
I just launched my first D7 site. So I'm checking my.cnf settings to make sure they continue to be optimized with the new site. I noticed that there was no Innodb support. I removed the setting to disable innodb but I'm still getting a message when running tuning-primer.sh that no innodb support is enabled. And checking the mysql build it looks like it's there but disabled. What am I doing wrong?
Here is my current my.cnf settings:
[mysqld]
skip-bdb
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
query_cache_type = 1
query_cache_size = 52M
XHProf on Mac OS X with Speed Step: Finally accurate numbers
Hi High-Performance,
I am not sure how many of you tried to use XHProf on Mac OS X, but it was really unusable for me at times, because I would get rather random results due to Speed Stepping technology. Also the profiling time would never match the wait time shown in Chrome Network tab.
I made a patch to use the apple mach timer framework and I finally get accurate numbers each time now and they do also match the wait time shown both externally and internally (devel):
See https://bugs.php.net/bug.php?id=61132 for the patch and a little further explanation of the issue.
Read moreDrupal 7 performance related patches & replacements for core functionally
Last updated by spaghettibolognese on Mon, 2017-03-27 22:12
Core Patches
Big Performance Gains - Low Risk
Second loop in module_implements() being repeated for no reason. ~ 400ms - Included in 7.40
Speed up drupal_parse_info_format() 3x and reduce memory 95% ~ 600ms - Included in 7.40
RFC: Parallel page rendering via ESI fragment caching using HTTPRL non blocking http requests.
The HTTP Parallel Request Library module COULD be used to make Multi process Drupal happen via http://drupal.org/project/esi. I think all that is needed are some minor changes to the ESI module so it will issue non blocking requests to the ESI fragments URLs and we have parallel page rendering.
Questions? What did I miss? Why is this a bad idea? etc..
Read moreUsers and anonymous forms
I'm using varnish and have a couple of exiting modules which do searching. The way that they work is, using forms api, drupal_goto('mysearch/search+terms').
Here's the rub. I have to patch both core and these modules to keep them working with varnish. If I don't I get the notorious "This form is outdated. Reload the page and try again" message. I understand why—the form token is cached in the body of the document, and fails to validate for additional users. I'm a bit at a loss on the best solution for this.
Read moreOptimizing query
Hello
I have a query that is being called by drupal which takes about 18 secs to execute and loads the mysql server with 99%cpu usage.
The query is below:
SELECT DISTINCT c.*
FROM
comment c
INNER JOIN node n ON n.nid = c.nid
INNER JOIN node_access na ON na.nid = n.nid
WHERE (c.status = '1') AND (n.status = '1') AND(( (na.gid = '0') AND (na.realm = 'all') )OR( (na.gid = '1') AND (na.realm = 'forum_access') ))AND (na.grant_view >= '1')
ORDER BY c.created DESC, c.cid DESC
LIMIT 10 OFFSET 0;explain for the above query is below:
getimage vs direct url from apache
Assuming images gets re-sized when uploaded, why drupal uses getimage to include images and thumbs
if it is much faster to access the images directly through apache?
I always notice high cpu utilization when I load a page full of images.
How can I avoid this and include direct url to all my images?
thanks for any comments or suggestions.
Read moreNginx static file cache or Varnish in front?
I have used varnish quite a bit on my LAMP stacks and this deff helps quite a bit out for static files to serve up and keeps the load off of apache.
I hear good things about nginx static file caching so is their a need to put varnish up a head of it?
Read moreApache + Varnish : having both on port 80
Hi,
Turned out I can't replicate the problem defined down there, but I guess it would've been solved thanks to Advagg. I now have an entirely different problem.
I have several virtualhosts on Apache, some of them will not be served with Varnish, but all listen to port 80.
So, the question is, how can I have Apache listening on port 80 for some virtualhosts, and Varnish listening on port 80 for other virtualhosts?
I'm having a weird problem and I can't get to solve it.
Firstly, here is the setup :
<
ul>
Read more