This post is about indexes which have low usage. I am not proposing change.
After reading this post: http://www.databasesoup.com/2014/05/new-finding-unused-indexes-query.html I decided to try it on my Bacula server, and I've put the results here: https://gist.github.com/dlangille/cbd6ee13bab80399aaf7 In short, these indexes are never used: tablename | indexname jobhisto | jobhisto_idx fileset | fileset_name_idx pathhierarchy | pathhierarchy_ppathid These indexes are rarely read, but I suspect they are very useful for restores: file | file_jpfid_idx file | file_pathid_idx file | file_filenameid_idx job | job_name_idx media | media_idx -- Dan Langille - http://langille.org/ ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
