Development Log

Please list most recent changes at the top.

  • I am now using my blog for this.
  • 2007-04-14 Need to setup or revitalize CVS for our template and custom modules.
  • 2007-04-14 Updated staging.ourmedia.org with data from production server. Here are some useful commands:

On production server...

  1. cd /SOMEWHERE
  2. mkdir backup
  3. mysqldump -u SQLUSERNAME -pSQLPASSWORD -h 10.0.0.3 ourmedia TABLENAME | bzip2 -c > backup/TABLENAME.sql.bz2
  4. scp backup/*.bz2 OSUSERNAME@staging.ourmedia.org:/opt/wwwvhost/production/WHATEVER (enter password, when prompted)

On staging server (someone know who to do issue these commands remotely from production server?)...

  1. cd /opt/wwwvhost/production/WHATEVER
  2. mysql production < TABLENAME.sql.bz2
  3. rm TABLENAME.sql.bz2

Cleaning up on production server...

  1. cd /SOMEWHERE
  2. rm -f backup/*
  3. rmdir backup
  • 2007-04-13 Added index to "files" table on both production and staging databases. This provides a significant improvement in query time for a typical page. With current blog settings, there are three "SELECT * FROM files where nid = %d" queries associated with any page that references a node (e.g., just about any page). These were taking 200-300 milliseconds each, whereas the entire set of queries associated with the homepage, profiles and media pages was approximately 800 milliseconds. After adding an index to the "files" table based on the "nid" column, these query times dropped to about 1.25 milliseconds each for the three queries against the "files" table. Thus we might hope to see a 75% reduction in database query times. A brief glance at the table indexes indicates that there are other queries that might run faster with some additional indexes, but the improvements may be small. Addressing the number of queries may be more fruitful and addressing efficient caching of both queries and pages is likely to offer far greater gains in performance and scalability. I have been moving several items from blocks to the page templates (mainly page.tpl.php) in cases where they are fairly static in nature.
  • 2007-04-13 Added "Nice Titles" javascript tool tips from http://www.kryogenix.org/code/browser/nicetitle/
  • 2007-04-13 Modified homepage login fields as per http://alistapart.com/articles/makingcompactformsmoreaccessible
Links:

Comments and discussion: