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

    • Icon: Sub-task Sub-task
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.3
    • 2.2
    • 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.

      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

            skodak Petr Skoda
            skodak Petr Skoda
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Sam Hemelryk Sam Hemelryk
            Votes:
            3 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.