Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-29516 DB layer improvements 2.3 META
  3. MDL-31985

remove text and binary field size from XMLDB - always use big size

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.2
    • Fix Version/s: 2.3
    • Component/s: Database SQL/XMLDB
    • Labels:
    • Testing Instructions:
      Hide

      1/ run all tests for mysql
      2/ run functional DB tests for all database
      3/ try upgrade from 2.2 in mysql
      4/ try install on mysql
      5/ edit some TEXT columns with the XMLDB Editor. Verify that no length is available for them, and XML is saved and later loaded ok.

      Show
      1/ run all tests for mysql 2/ run functional DB tests for all database 3/ try upgrade from 2.2 in mysql 4/ try install on mysql 5/ edit some TEXT columns with the XMLDB Editor. Verify that no length is available for them, and XML is saved and later loaded ok.
    • Affected Branches:
      MOODLE_22_STABLE
    • Fixed Branches:
      MOODLE_23_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      w11_MDL-31985_m23_lobsizes

      Description

      There are constant problems with 64k texts running out of available space in MySQL, the solution is to use only big text fields

      Benefits:

      • no more running out of space in text fields
      • all databases the same behaviour (only MySQL created different sizes)
      • simple upgrade with no extra space requirements

      Potential problems:

      • mysql is painfully slow when modifying tables, it is hard to predict the time necessary because each row may take different amount of space

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                3 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  25/Jun/12