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.}

Module "Black-Hole" revival

Posted by Souvent22 on April 17, 2007 at 8:55pm

There are a "LOT" of contrib modules out there. Even more so, there are a great deal of good modules that have been neglected. Lets be honest, a developers time is precious, and we all get spread thin and a bit scattered sometimes, and we leave our children (modules) to the way side for other things (like "bill-paying" modules/development so we can eat from time to time :) ).

Random ID Generation Write up

Posted by Souvent22 on April 24, 2007 at 2:58am

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

Performance review of object translation required

Posted by gábor hojtsy on May 8, 2007 at 11:25am

We have posted a patch to support object translation of certain Drupal objects (content types, user profile fields and categories, site settings, and so on) to multiple human languages. While we have clear concepts and very good ideas for the user interface (which we though before that would not be easy), performance-wise we are at crossroads. We would welcome beginner as well as expert reviewers to come and share their performance ideas about Drupal object translation, so Drupal 6 can include a mature translation infrastructure, advancing ahead of the competition. ;) We need your input!

"Introduce dynamic object translation API (optimize this!)" http://drupal.org/node/141461

Search bugs that need addressing

Posted by robertdouglass on May 11, 2007 at 5:53am

I'd like to draw your attention to two significant (and possibly related) search module bugs that are leading to widespread corruption of our search indexes:

Missing nodes in search index:
http://drupal.org/node/139537

The problem is missing content. You can't find a node with the search index if it doesn't get indexed for some reason.

Duplicate entries:
http://drupal.org/node/143160

The problem is duplicated entries in the search index which bloats the index and makes potential upcoming query optimizations impossible.

Understanding enormous numbers in SQL status report

Posted by TheHoaryHound on May 20, 2007 at 2:08am

Can one of you experts out there help me with this?

In a brand-new, <10 node Drupal 5.1 site running with MySQL 4.1.21 and PHP 5.0.5, on Appache at www.siteground.com

When looking at admin->logs->status->MySQL (4.1.21)

I'm getting some HUGE numbers, where zeros are expected. Can someone provide some guidance or words of wisdom?

Some of the report is listed below. PS--I can't figure out where to get help, no one answers posts at Drupal.org or at siteground.com, and I feel like there's no one out here!!

Memcache beta 1 released

Posted by robertdouglass on May 22, 2007 at 9:19am

The Drupal Memcache API and Integration module has reached beta 1 and is ready for testing. This module provides all the tools you need to use memcache as the cache backend for Drupal. It features the ability to cluster memcache servers so that your cache's memory pool can grow indefinitely, and allows you to assign bins to these clusters so that session information can go to one cluster, page cache to another, and views or cck cache to yet another. This gives you total control over your network layout. There is also a new admin module which will eventually allow you to reset your cache, configure bins/clusters and servers, and view usage statistics. Right now it only provides the statistics. You need the memcache PECL extension to run this module.

Advcache: call for benchmarks

Posted by robertdouglass on May 31, 2007 at 8:54pm

Hi all. I've been working on a new project called Advcache (Advanced Cache) which is a package of caching patches (and a controller module) for Drupal 5. It allows you to cache many things which don't get cached normally, and is intended to increase the performance of Drupal sites, especially for authenticated users. Current caching targets include nodes, comments, taxonomy (trees, terms, vocabularies and node-term bindings), paths, search queries, and forums.

Read from slave database patch to help Drupal.org

Posted by Amazon on June 12, 2007 at 5:34pm

Provide support for database replciation

This is something we would like to see available for Drupal.org.

Cheers,
Kieran

MySQL slow query log analyzer orders by total time spent on queries

Posted by Amazon on June 18, 2007 at 4:02am

Hi, if you want to tune your database, a good place to start is finding out what the slowest queries are by total time spent.

Here's a nice tool from the MySQL performance blog.

Add this line to your my.cnf and restart your database server:

log-slow-queries = /var/log/mysql/mysql-slow.log

Add execute permissions to mysql_slow_log_parser, it's a perl script.

Here's an example:

Starting...

2818 Queries

Total time: 2821, Average time: 1.00106458481192

Which query takes 63 hours of cummulative wait time to process on Drupal.org?

Posted by Amazon on July 21, 2007 at 3:08am

7348 Queries

Taking 16 to 46 seconds to complete

SELECT n.nid, n.title, l.comment_count FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid WHERE n.type = 'XXX' AND n.status = XXX ORDER BY n.nid DESC LIMIT XXX, XXX;

63 hours total, assuming an average time of 31 seconds.

3574 Queries

Taking 16 to 67 seconds to complete

41 hours total, assuming an average of 41.5 seconds

Subscribe with RSS