[Lxr-general] How to remove a version from the mysql database?

[Michael O. <mic...@fr...>]

Hello,

I guess this question has already been asked, but SourceForge mailing 
list archives are down at the moment.

Is there a clean and simple way to remove a indexed version from the 
MySQL database ? I am using LXR 0.9.5 and since I added a new version 
(Linux 2.6.17), the MySQL server RAM usage grew (no surprise), and since 
my server only has 256 MB of RAM, there wasn't enough RAM left. Because 
of this, my server started swapping like crazy. That's the reason why I 
would like to remove an older Linux kernel sources version to reduce the 
size of my database.

I hope you have a script to do this... Will 'genxref --reindexall' do it 
automatically if I remove the version for the list of indexed versions? 
Anyway, that would be a huge waste of CPU to reindex all versions just 
to purge a given version.

That's an ugly issue for sites indexing many versions at one, especially 
for big projects like the Linux kernel...

Thank you in advance for your feedback,

    Cheers,

    Michael.

-- 
Michael Opdenacker, Free Electrons
Free Embedded Linux Training Materials
on http://free-electrons.com/training
(More than 1000 pages!)