Mmm just had a better look, and some index names start with "xwv_", others with "XWVS_" ... I believe the "XWVS_" are to be removed.
2013/3/13 Jeremie BOUSQUET <[email protected]> > 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
