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…