>> However, I'm slightly surprised that >> >> rbh-report --class-info >> >> is quite slow, taking around 30 min for 18 million entries with a total >> size of around 10 TB. > > Hi, > > This report is quite slow but it shouldn't be so long for just 18M > entries. This may be due to an inappropriate DB tuning. I suggest you > look at "http://mysqltuner.pl"; output to check if there is something > wrong with innodb parameters. Another explanation can be if your DB > is under heavy load while you run this command.
There is no particular load on the DB apart from 2 RBH scans, but performing the tweaks suggested by mysqltuner.pl brought the time required from over 30 min down to less than 30 sec. Thanks, Loris -- This signature is currently under construction. ------------------------------------------------------------------------------ _______________________________________________ robinhood-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/robinhood-support
