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

    • Sub-task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.2
    • 2.3
    • Database SQL/XMLDB
    • MOODLE_22_STABLE
    • MOODLE_23_STABLE
    • w11_MDL-31985_m23_lobsizes
    • 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.

    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

              skodak Petr Skoda
              skodak Petr Skoda
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Sam Hemelryk Sam Hemelryk
              David Woloszyn, Huong Nguyen, Jake Dallimore, Michael Hawkins, Stevani Andolo
              Votes:
              3 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                25/Jun/12