On Thu, 27 Jun 2013, [email protected] wrote: > So, the my question should rather be double: (a) how to change id_bibrec > type
Firstly, can you look at your fulltext terms and see whether they are relevant? E.g.: $ echo "SELECT term FROM idxWORD09F LIMIT 100" | dbexec If many of them look bogus, maybe you'd want to plug more aggressive stemming and/or check text extraction procedures. This may be the best solution for the end users. Secondly, since you do not have 16M records in your system, you should not need to alter idxWORD09R.id_bibrec, you only have to alter idxWORD09F.id from MEDIUMINT UNSIGNED to INT UNSIGNED. This would overcome the 16M limit and should fix the troubles. > and (b) how to recreate fulltext index. If you want to do it on the production server and not on replica, then you can launch something like: $ bibindex -u admin -w fulltext -a -i 1000-2000 -P -1 for the concerned record IDs. That is you'd launch a targeted fulltext indexing job only, and with low priority, so that it would be executed only when the system is really idle. Best regards -- Tibor Simko
