November 2007 - Development - lists.drupal.org

Re: [development] drupal on postgresql benchmark
by Khalid Baheyeldin 26 Nov '07

26 Nov '07

On Nov 26, 2007 2:48 PM, Bill Moran <wmoran(a)potentialtech.com> wrote: > In response to "Khalid Baheyeldin" <kb(a)2bits.com>: > > > On Nov 26, 2007 1:52 PM, Bill Moran <wmoran(a)potentialtech.com> wrote: > > > > > My point is: > > > a) Let me send you a tweaked postgresql.conf file and well find > > > out whether the performance difference is simply a matter of > > > untuned configuration and ... > > > > I will post them for all to see, maybe someone will point out something > > else. > > > > These are the non comment lines in postgresql.conf > > > > hba_file = '/etc/postgresql/8.2/main/pg_hba.conf' > > ident_file = '/etc/postgresql/8.2/main/pg_ident.conf' > > external_pid_file = '/var/run/postgresql/8.2-main.pid' > > listen_addresses = 'localhost' > > port = 5432 > > max_connections = 100 > > unix_socket_directory = '/var/run/postgresql' > > shared_buffers = 24MB > > max_fsm_pages = 153600 > > log_line_prefix = '%t ' > > stats_row_level = on > > autovacuum = on > > datestyle = 'iso, dmy' > > lc_messages = 'en_CA.UTF-8' > > lc_monetary = 'en_CA.UTF-8' > > lc_numeric = 'en_CA.UTF-8' > > lc_time = 'en_CA.UTF-8' > > Oh yeah ... there's lots of room for improvement here. > > How much RAM does this system have, and how much of it is "free" > memory during the test? > 2GB of RAM. Here is the output from free: total used free shared buffers cached Mem: 2060032 1813748 246284 0 576896 439828 -/+ buffers/cache: 797024 1263008 Swap: 3903712 260 3903452 And here is /proc/meminfo MemTotal: 2060032 kB MemFree: 245736 kB Buffers: 577000 kB Cached: 439912 kB SwapCached: 16 kB Active: 777476 kB Inactive: 550212 kB SwapTotal: 3903712 kB SwapFree: 3903452 kB Dirty: 96 kB Writeback: 0 kB AnonPages: 310812 kB Mapped: 32764 kB Slab: 457012 kB SReclaimable: 425856 kB SUnreclaim: 31156 kB PageTables: 9352 kB NFS_Unstable: 0 kB Bounce: 0 kB CommitLimit: 4933728 kB Committed_AS: 526896 kB VmallocTotal: 34359738367 kB VmallocUsed: 2724 kB VmallocChunk: 34359735611 kB We can carve off some memory from cache and buffers (1016 MB combined). > Khalid ... are you willing to work with me to investigate this? > If not, I'll try to get my own test rig set up, but it probably > won't happen until the new year. > I am willing to, time permitting of course. > Off the top of my head, I'd start out with 2 things: > *) Bump shared_buffers to 1/4 the total memory on the system > *) "vacuum analyze" the database after the load but before > the perf test. > What do you mean after the load? You mean after loading data into the database but before running ab? > > I'll look this over a bit and send you a recommended config file > later this evening. > > Will look forward to it. I guess we can take this conversation off the list too, so as not to spam others. -- Khalid M. Baheyeldin 2bits.com http://2bits.com Drupal optimization, development, customization and consulting.

1 0

Simpletest: embrace and utilize
by Robert Douglass 26 Nov '07

26 Nov '07

Hi everyone, in very recent history I was faced with a set of programming problems that I was having a seriously difficult time handling. The architecture of my upcoming Solr module had gotten away from me, and every effort I made to reel it in and bring it under control was leading to dead ends and broken code. The way that I finally got out of the mess was by installing the Simpletest module and writing test cases for the functionality I needed. The act of codifying the expected behavior of every unit of the module helped me get over the hump and write code that works. Furthermore, the more test cases I produced, the faster the development proceeded. Code began to write itself (almost). So I've now written an article on unit testing and Simpletest: http://www.lullabot.com/articles/introduction-unit-testing I want to thank Moshe, Rok, and all the others who have worked on this code for so long, with so little praise. I hope that now the mass of Drupal developers will start to wake up to the potential of writing test cases and dig in. http://drupal.org/project/simpletest -Robert

2 1

need doxygen for group "forms"
by Peter Wolanin 26 Nov '07

26 Nov '07

Can someone who is familiar with the API module and doxygen and look at: http://drupal.org/node/195283 Many of the core form building functions are now tagged with "@ingroup forms" but there is no such group defined for the API module to find. -Peter

1 0

CCK Flashcard module seeks maintainer
by Robert Douglass 25 Nov '07

25 Nov '07

The CCK Flashcard module is "A CCK field that offers textfields or textareas for "Front" and "Back" (like the sides of a flashcard). Upon display the front and back can be toggled. Useful for testing your memory on things." It needs a new maintainer. Please contact me if you are interested. http://drupal.org/project/cck_flashcard

1 0

Re: [development] Early Drupal 6 review from Chris Messina
by Hans Salvisberg 25 Nov '07

25 Nov '07

Khalid Baheyeldin wrote: > > vocabulary -> category group > > Two words would be confusing, especially if category is used for term. > > How about just "category" here. > > > term -> category or tag > > > We can keep it as a term. The issue is the "vocab", not so much "term". Tag > is more specific to free tagging, and may be overloading the term. <sigh> The problem is that everyone intuitively knows what a category is. If you have a term "dog" and you tag a post with "dog", then that post goes in to the category "dog". That's the common sense non-technical meaning of "category". You can even stretch that to include terms like "Gamer's Forum" -- a post in the Gamer's Forum goes into the category "Gamer's Forum". That's what classification is all about, putting things into categories. Using "category" for anything else but for terms will just not work for normal people without re-educating them about what that common word means. IOW, it will not work. Now, what's that thing in between -- the "animals" and the "forums" -- in plain English? Go ask the man in the street: If you have categories like "dog", "bird", and "elephant", then what would you call that group of categories? Answer: "animals" Oops, answered my own question, the real one... Hans

4 4

Please do not use postponed (now) for core
by Karoly Negyesi 25 Nov '07

25 Nov '07

Hi, We have 7.x to mark issues belonging there -- most issues marked as postponed are really 7.x, CNW. I can imagine postponed meaning "let's wait for patch Y" but these are rare/nonexistent during the freeze. Thanks, NK

2 1

Drupal and MySQL Clustering
by Zohar Stolar 25 Nov '07

25 Nov '07

Hello all, I'm looking for information about Drupal and MySQL/PGSQL clustering. Is it possible? Does it have anything to do with Drupal, or is it server level only? Any pointers would be appreciated. Thanks, Zohar -- Zohar Stolar | זהר סטולר z.stolar(a)gmail.com <mailto:z.stolar@gmail.com>

1 0

Menu, theme and all registries rebuild
by Karoly Negyesi 23 Nov '07

23 Nov '07

Hi, Given how much you visit admin/build/modules during daily administration (never) and given the bug at http://drupal.org/node/193366 we have moved the rebuild functions from the submit to the form itself. Aside from fixing the bug, this have a very nice side effect of this bugfix which is going to be rather important when you develop for the Dexterous Drupal with Drag and Drop and Drilldown without Delay (aka D6): you can visit admin/build/modules and your menu gets rebuilt and your theme functions get recognized (schema and node type changes, too). Regards, NK

1 0

Drupal 6, beta 4, usability exceptions
by Dries Buytaert 23 Nov '07

23 Nov '07

Hello world, as promised, here is a list of non-critical bugs that can still make it into Drupal 6 (assuming they hit CVS HEAD *before* November 30th): 1. http://drupal.org/node/193333 - Add drag and drop to taxonomy module 2. http://drupal.org/node/192736 - Add drag and drop to book module That's it. Other than that, there are plenty of critical bugs to fix. :) -- Dries Buytaert :: http://www.buytaert.net/

1 0

Re: [development] How many modules is too many?
by Michelle Cox 23 Nov '07

23 Nov '07

I have nearly 100 projects, many with multiple modules, and am not done adding, yet. It does really eat up memory like crazy but I haven't heard a solution to it. The fact is that some sites, especially social networking ones, use a lot of modules. Most of them are fairly small but needed. Would combining the smaller modules into one big one help any? Or would that still use the same amount of memory? Michelle On 11/21/2007 12:29:46 PM, Khalid Baheyeldin (kb(a)2bits.com) wrote: > (Changing the subject) > > I regularly see 80+ to 110+, and that causes Apache to eat 100MB per > process, which is really not good ... > > This is the open buffet binge syndrome detailed here: > > http://2bits.com/articles/server-indigestion-the-drupal-contributed- > modules-open-buffet-binge-syndrome.html > > On Nov 21, 2007 12:50 PM, Jim Li <jimmydami(a)gmail.com> wrote: > > > Cool, thanks! > > > It'd be interesting to have a poll on how many modules people use on a > > social network site. I heard someone uses 160 modules at his dev site, > > it may go down a bit later, but it probably will still in the 100+ > > ragnge :) > > > > On Nov 20, 2007 6:31 PM, Earl Miles <merlin(a)logrus.com> wrote: > > > On the other hand, having 150+ modules load *is* going to eat a whole > > > lot of memory; so actually activating all these modules is a really > > > bad > > > idea. > > > > > > And yes, the modules page under 4.7 is going to choke like [insert > > > really bad sports team metaphor here]. > > > > > > > > > Sean Robertson wrote: > > > > As I understand it, Drupal 5+ no longer does that. That's > what the >

10 11