Extremely slow LXR indexing with mysql after last update
Don't see any errors but indexing a fairly large set of LXR versions of various programs with genxref program now taking extreme time. Previously only took a few minutes to zip though lots of projects/versions (i.e., was fast last time I ran this about a week ago).
See alternating 100% cpu on cores and what looks like constant disk usage and processing now just crawls. Previously (about a week ago and earlier) this indexing activitiy took only 10-15 minutes but now it takes 3-4 hours (and I reduced the number of versions indexed by by about 2/3rd).
Top and system monitor don't show extreme processing on mysqld or genxref or any other process (except cores usages rotates and remains 100%). However, top indicates a big percentage on "waiting for IO" which correlates with the disk LED being on almost contantly on but very audible disk activity heard.
Recent f16 update included mysqld I think, so my guess is something has changed or broken with it. LXR is a perl script the builds the mysql database for seeing source code, with links and searching, in the browser. It is not part of Fedora.
No errors reported in /var/log/messages or /var/log/mysql.log.
Don't see speed problems with other apps or servers.