Hello guys, I'm checking page about database administration [1], as I would like to "sanitize" a bit my indexes before going futher with migration to 4.x. (reason is that clearing problematic data from my stats tables takes forever, and I think it could be improved with the correct indexes). >From that page [1], I get the full list of indexes created for xwiki < 3.2, and the list of indexes that can be created manually, adding to the indexes created automatically by XWiki.
But the info I would like, is the list of indexes that I should expect to be created when on XWiki 3.5. My purpose, is that my "show index" from xwikistatsvisit, for example, displays a number of duplicate indexes, some using lowercase others uppercase (waste of space to the least). Also apart from duplications, I'm now unsure that there are no excessive indexes created to start with (8 indexes on a table seems a bit too much, but I'm no DBA and xwiki schema is particular). I could install another xwiki 3.5 instance, on an empty database, and check the indexes, but if there is a way to find it from the code I'd clearly prefer ;-) So if you have any pointer on the right location, that would be very nice. I'm on MySQL 5.1 by the way. Thanks & regards, Jeremie [1] http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration#HIndexes _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
