Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-605

Improve updateschema to create the indexes needed for an high performance xwiki

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Duplicate
    • Major
    • None
    • 1.8
    • Storage
    • None
    • Medium

    Description

      The aim of this issue is to help Wiki administrators automatically create MySQL indexes when their wiki starts being heavily used.

      The use case is the following -> after a new wiki install, users start adding new documents and using the wiki. Once a wide number of documents are created, the wiki becomes slow and less responsive. Creating database indexes makes it snappy again. Thus automatically creating indexes for MySQL (which is the most widely used database for XWiki installs) would solve this issue in many cases.

      The suggested interface would be an icon in the administration named database management. It would feature:

      • List of databases that do not have their indexes created
      • Automated index creation (if the DB is MySQL)

      Ludovic was working on this with Raffaello to get the right script to improve an XWiki's indexes. They then need to improve the XWiki updateschema to verify the indexes are created and create them on the fly.

      Attachments

        Issue Links

          Activity

            People

              vmassol Vincent Massol
              ludovic Ludovic Dubost
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: