Re: [xwiki-users] Performance tuning for growing wiki

Thanks for all who replied to my initial request. I've followed the advice and tried MySQL. I have heard about problems with xar export/import and would like to avoid it if naked DB migration is possible. I've googled up what seems a righteous way using MySQL Migration Toolkit (here are 2 links: http://confluence.atlassian.com/display/DOC/Migrating+from+HSQLDB+to+MySQL, http://wiki.alfresco.com/wiki/Migrating_from_HSQL). After some exercises to make jdbc driver work I've got database exported but run into problems with particular columns because of which complete tables are not copied to MySQL. Below is an excerpt from report where for problematic tables evil columns are mentioned: `PUBLIC`.`XWIKICLASSES` Column length too big for column 'XWO_CUSTOM_MAPPING' (max = 21845); use BLOB or TEXT instead `PUBLIC`.`XWIKICLASSESPROP` Column length too big for column 'XWP_CUSTOMDISPLAY' (max = 21845); use BLOB or TEXT instead `PUBLIC`.`XWIKICOMMENTS` Column length too big for column 'XWC_HIGHLIGHT' (max = 21845); use BLOB or TEXT instead `PUBLIC`.`XWIKIDOC` Column length too big for column 'XWD_CONTENT' (max = 21845); use BLOB or TEXT instead `PUBLIC`.`XWIKILARGESTRINGS` Column length too big for column 'XWL_VALUE' (max = 21845); use BLOB or TEXT instead `PUBLIC`.`XWIKIPREFERENCES` Column length too big for column 'XWP_MENU' (max = 21845); use BLOB or TEXT instead Is there a way to cope with this or the only way is export/import with Large Wiki Export extension? Thx, Andrey