On 2011-03-02, Eric Bollengier <eric.bolleng...@baculasystems.com> wrote: > Le mardi 01 mars 2011 14:58:04, Phil Stracchino a écrit : >> I was looking into what Bacula was doing in the DB this morning, with a >> MySQL catalog, to see why last night's backup jobs stalled. As a result >> of my investigations, I have two questions: >> >> 1. >> If dbcheck finds that either of the two indices it needs are missing, >> why does it only offer to create temporary indices, instead of offering >> to create the indices once and have done with it? > > Because these indexes slow down files and attributes insertion, and speed up > dbcheck. So, as you insert files more often than you run dbcheck, we decided > to create/delete these indexes on the fly. But, feel free to add them > permanently.
Or better don't. One of the indexes created by dbcheck is known to create *extreme* slowdowns (at least in mysql 5.0 and 5.1, do to bad index choosing algo in them, it seems). See bug http://bugs.bacula.org/view.php?id=1472 for details, and http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog -- Opinions above are GNU-copylefted. ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
