UCD-Database Test Plan

Owned by Thomas Amsler
Last updated: Oct 29, 2007 by Mike WenkVersion comment

Testing ucd-database (sakai_external) bug-fixes and improvements

Overall Results Grid

Test 1 (Results)

  • Deploy https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/tags/sakai_2-4-x-test-001 on bricker-test (sakai_external)
  • DB Configuration:
    • Set optimizer_index_cost_adj to 100
    • Set _KEEP_REMOTE_COLUMN_SIZE to FALSE
    • Using MViews and Views
  • Load Test:
    • Application Server: sakai-test (isaac)
    • Database: bricker-test (for sakai and sakai_external)
    • Load Test Definition:
      • Script: Smartsite MJW Learn.bdf
      • Parameters: bDoChat is true, bDoForums is false, bDoWiki is false
      • Workload Configuration:
        • Starting Users: 10
        • Increment Users by: 5
        • Increment time: 15s
        • Max/Total Users: 100
      • Time: 1 hour 15 minutes
      • Running against: https://isaac.ucdavis.edu:8443
      • Site ID: ea6a32ea-4e46-43c6-80cf-4eacba3c91b8
      • Site Name: HDE 012 - 001 FQ 2007
  • Source Code:
    • sakai_2-4-x-HEAD-prod-003 
      • - Applying SAK-1064
  svn merge -r 3038:3039 https://mware.ucdavis.edu/svn/ucd-sakai/ucd-form-based-distauth/branches/sakai_2-4-x-HEAD/ ucd-form-based-distauth/

- Applying SAK-1111
  patch -p0 < ../../patches-sakai_2-4-x-HEAD/SAK-1111.patch

- Set the protection level to 1 in login/.../web.xml

Test 2 (Results)

  • Deploy https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/tags/SAK-1202-test-001/ on bricker-test (sakai_external)
  • DB Configuration:
    • Set optimizer_index_cost_adj to 10
  • Load Test:
    • Application Server: sakai-test (isaac)
    • Database: bricker-test (for sakai and sakai_external)
    • Load Test Definition:
      • Script: Smartsite MJW Learn.bdf
      • Parameters: bDoChat is true, bDoForums is false, bDoWiki is false
      • Workload Configuration:
        • Starting Users: 10
        • Increment Users by: 5
        • Increment time: 15s
        • Max/Total Users: 100
      • Time: 1 hour 15 minutes
      • Running against: https://isaac.ucdavis.edu:8443
      • Site ID: ea6a32ea-4e46-43c6-80cf-4eacba3c91b8
      • Site Name: HDE 012 - 001 FQ 2007
  • Source Code:
    • sakai_2-4-x-HEAD-prod-003 
      • - Applying SAK-1064
  svn merge -r 3038:3039 https://mware.ucdavis.edu/svn/ucd-sakai/ucd-form-based-distauth/branches/sakai_2-4-x-HEAD/ ucd-form-based-distauth/

Test 2a (Results)

  • Deploy https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/tags/SAK-1202-test-001/ on bricker-test (sakai_external)
  • DB Configuration:
    • Set optimizer_index_cost_adj to 10
    • Run stats on tables
  • Load Test:
    • Application Server: sakai-test (isaac)
    • Database: bricker-test (for sakai and sakai_external)
    • Load Test Definition:
      • Script: Smartsite MJW Learn.bdf
      • Parameters: bDoChat is true, bDoForums is false, bDoWiki is false
      • Workload Configuration:
        • Starting Users: 10
        • Increment Users by: 5
        • Increment time: 15s
        • Max/Total Users: 100
      • Time: 0 hour 30 minutes
      • Running against: https://isaac.ucdavis.edu:8443
      • Site ID: ea6a32ea-4e46-43c6-80cf-4eacba3c91b8
      • Site Name: HDE 012 - 001 FQ 2007
  • Source Code:
    • sakai_2-4-x-HEAD-prod-003 
      • - Applying SAK-1064
  svn merge -r 3038:3039 https://mware.ucdavis.edu/svn/ucd-sakai/ucd-form-based-distauth/branches/sakai_2-4-x-HEAD/ ucd-form-based-distauth/

Test 3 (Results)

  • Deploy https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/tags/SAK-1202-test-001/ on bricker-test (sakai_external)
  • DB Configuration:
    • Set optimizer_index_cost_adj to 10
    • Running under EXTERNAL_TS tablespace with segment management set to manual.
    • Stats on tables
    • Library cache flushed
    • Using MViews and Views
  • Load Test:
    • Application Server: sakai-test (isaac)
    • Database: bricker-test (for sakai and sakai_external)
    • Load Test Definition:
      • Script: Smartsite MJW Learn.bdf
      • Parameters: bDoChat is true, bDoForums is false, bDoWiki is false
      • Workload Configuration:
        • Starting Users: 10
        • Increment Users by: 5
        • Increment time: 15s
        • Max/Total Users: 100
      • Time: 1 hour 15 minutes
      • Running against: https://isaac.ucdavis.edu:8443
      • Site ID: ea6a32ea-4e46-43c6-80cf-4eacba3c91b8
      • Site Name: HDE 012 - 001 FQ 2007
  • Source Code:
    • sakai_2-4-x-HEAD-prod-003 
      • - Applying SAK-1064
  svn merge -r 3038:3039 https://mware.ucdavis.edu/svn/ucd-sakai/ucd-form-based-distauth/branches/sakai_2-4-x-HEAD/ ucd-form-based-distauth/

Test 4 (Results)

  • Deploy https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/tags/SAK-1202-test-001/ on bricker-test (sakai_external)
  • DB Configuration:
    • Set optimizer_index_cost_adj to 10
    • Running under EXTERNAL_TS tablespace with segment management set to manual.
    • Stats on tables
    • Library cache flushed
    • Using MViews and Views
  • Load Test:
    • Application Server: sakai-test (isaac)
    • Database: bricker-test (for sakai antrue,d sakai_external)
    • Load Test Definition:
      • Script: Smartsite MJW Learn.bdf with modifications to eliminate chat visibility
      • Parameters: bDoChat is false, bDoForums is false, bDoWiki is false
      • Workload Configuration:
        • Starting Users: 10
        • Increment Users by: 5
        • Increment time: 15s
        • Max/Total Users: 100
      • Time: 1 hour 15 minutes
      • Running against: https://isaac.ucdavis.edu:8443
      • Site ID: ea6a32ea-4e46-43c6-80cf-4eacba3c91b8
      • Site Name: HDE 012 - 001 FQ 2007
  • Source Code:
    • sakai_2-4-x-HEAD-prod-003 
      • - Applying SAK-1064
  svn merge -r 3038:3039 https://mware.ucdavis.edu/svn/ucd-sakai/ucd-form-based-distauth/branches/sakai_2-4-x-HEAD/ ucd-form-based-distauth/

Test 5 (Results) (TBD to run this)

  • Deploy https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/tags/SAK-1202-test-001/ on bricker-test (sakai_external)
  • DB Configuration:
    • Set optimizer_index_cost_adj to 10
    • Set _KEEP_REMOTE_COLUMN_SIZE to TRUE
    • Using MViews and Views
  • Load Test:
    • Application Server: sakai-test (isaac)
    • Database: bricker-test (for sakai and sakai_external)
    • Load Test Definition:
      • Script: Smartsite MJW Learn.bdf
      • Parameters: bDoChat is true, bDoForums is false, bDoWiki is false
      • Workload Configuration:
        • Starting Users: 10
        • Increment Users by: 5
        • Increment time: 15s
        • Max/Total Users: 100
      • Time: 1 hour 15 minutes
      • Running against: https://isaac.ucdavis.edu:8443
      • Site ID: ea6a32ea-4e46-43c6-80cf-4eacba3c91b8
      • Site Name: HDE 012 - 001 FQ 2007
  • Source Code:
    • sakai_2-4-x-HEAD-prod-003 
      • - Applying SAK-1064
  svn merge -r 3038:3039 https://mware.ucdavis.edu/svn/ucd-sakai/ucd-form-based-distauth/branches/sakai_2-4-x-HEAD/ ucd-form-based-distauth/