/
UCD-Database Test Plan

UCD-Database Test Plan

Oct 29, 2007

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/