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.
Getting cache tables out of DB (or into different DB)?
Hi All,
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.
Best practices for Drupal sessions in memcached?
Hi All,
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:
http://www.dev411.com/wiki/Memcached_startup_files_for_Red_Hat_(RHEL)
This uses a /etc/memcached.conf which looks something like this:
-u apache
-d
-m 32
-l 127.0.0.1
-p 11211
Based on info contained within this thread:
Read more
Optimizing InnoDB for Watchdog table in D5?
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 :)
Read more
Moving MySQL tmpdir to RAM Disk
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:
Read more
Using a simple, cross-platform static cache to cut server load by 85%
I work on a newspaper site (http://www.gazettenet.com) and have worked out a simple static cache'ing technique outside of Drupal that others might find helpful, assuming similarities in traffic patterns to typical newspaper sites.
Read more
Add Squid on single-server setup?
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
MySQl Performance Monitor using MySQL Tuner Script
Hi All,
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 moredrupal_lookup_path trying a different approach
As most of us on this group are aware, drupal_lookup_path queries DB multiple times and several patches have been tried to fix this. None of it is in core yet. This discussion http://drupal.org/node/106559 has several patches and related links.
I tried to tackle this in a different way with an alias table with 50 records. I changed the engine for url_alias table from MyIsam to MEMORY. My reasoning was making it memory resident will give me almost the same (but not exact) benefit of memory resident array or variable the previous folks have tried. And it won't require any patches etc.
Read more
API like Uniform for Module-2-Module communication
Hi
First, excuse me if theres already some solution for.
I've surfed drupal.org and also the groups but didn't find something...
What I've to do is building a "stack" like Acquia but with advanced functionality.
For this I'll need to grab some already existing Modules and change some of their functions to work "cleaner" with other or mine, too. Because of this it would make updating Core and also Modules a horrobale job I'm looking for a standardize solution to let Modules communicate with each other without bigger modifying.
Read more