Changes between Version 31 and Version 32 of Ticket #590


Ignore:
Timestamp:
09/09/13 13:59:24 (3 years ago)
Author:
jim
Comment:

Proposal L added: (underway already) Review slow query log, explain queries, tweak as necessary/flag poorly behaving modules. and raised #591 for Chris to examine if we can move the mysql disk hitting temp tables into memory.

Also adding some nice links to the excellent 2bits.com...

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #590

    • Property Add Hours to Ticket changed from 0.75 to 0.25
    • Property Total Hours changed from 12.45 to 12.7
  • Ticket #590 – Description

    v31 v32  
    55I also note that many of these cleanup operations will also help make the move to D7 smoother and better. 
    66 
    7 = Summary of fixes and status = 
     7= Summary of actions and status = 
     8=== Ongoing === 
     9L) '''Review slow query log, explain queries, tweak as necessary/flag poorly behaving modules.''' 2-4 hours, high reward, low risk... Keep looking at the slow query log and adjust Drupal or find patches as necessary. ALSO related [http://2bits.com/articles/reduce-your-servers-resource-usage-moving-mysql-temporary-directory-ram-disk.html Reduce your server's resource usage by moving MySQL temporary directory to tmpfs]... Have opened ticket for this: #591 for Chris. 
     10 
    811 
    912=== To do: depeding on spare time (JK to monitor, EM to confirm) === 
     
    1417 
    1518=== New, to run past Ed === 
    16 '''J) Convert inline PHP into module code and features''' -- various parts (1-2 hours for block code; 4-6 hours to make Features be used across site), high reward, low risk -- {{{Eval()}}}uated code is much slower than PHP in files, especially since it can't be accelerated by APC or Zend Opcode cache... We have a few blocks and many views that are loaded from the database and evaluated. Ideally the blocks would be moved to the 'Transition Extras' module, and the views would be pushed into features. This work is good to do for maintainability and D7 upgrades, too. 
     19'''J) Convert inline PHP into module code and features''' -- various parts (1-2 hours for block code; 4-6 hours to make Features be used across site), high reward, low risk -- {{{Eval()}}}uated code is much slower than PHP in files, especially since it can't be accelerated by APC or Zend Opcode cache... We have a few blocks and many views that are loaded from the database and evaluated. Ideally the blocks would be moved to the 'Transition Extras' module, and the views would be pushed into features. This work is good to do for maintainability and D7 upgrades, too. See: http://2bits.com/api/abuse-drupal-best-practices-your-own-peril-poor-performance.html and http://2bits.com/articles/free-your-content-php-moving-php-code-out-blocks-views-and-nodes.html 
    1720 
    1821